MCQ Bank

The Function Library in Microsoft Excel is located under the Formulas tab. It provides access to built-in functions organized into categories for calculations and data analysis.

CS001 Final Term AI Solved

Q21

The Pivot table option can be found under ___________ tab

A) Data
B) Home
C) Review
D) Insert

AI Explanation

The PivotTable option is available under the Insert tab in Microsoft Excel. It is used to summarize and analyze large amounts of data quickly.

CS001 Final Term AI Solved

Q22

Which one is not a relational operator in the given options?

A) <=
B) =
C) <>
D) ()

AI Explanation

Relational operators compare values, such as =, <>, and <=. Parentheses () are used for grouping calculations and are not relational operators.

CS001 Final Term AI Solved

Q23

Relative reference is useful when we need to apply _______ type of calculations.

A) Same
B) Complex
C) Simple
D) Mathematical

AI Explanation

Relative references are useful when applying the same type of calculation to multiple cells. The references automatically adjust when the formula is copied to different locations.

CS001 Final Term AI Solved

Q24

Which of following bar shows the content of cell of MS Excel sheet?

A) Content bar
B) Name bar
C) Formula bar
D) Menu bar

AI Explanation

The Formula bar displays the content or formula of the currently selected cell in an Excel worksheet. It allows users to view and edit cell entries.

CS001 Final Term AI Solved

Q25

How many worksheets an MS excel document contains by default?

A) 1 worksheet
B) 10 worksheet
C) 3 worksheet
D) 2 worksheet

AI Explanation

In modern versions of MS Excel, a new workbook contains one worksheet by default. Additional worksheets can be added whenever required.

CS001 Final Term AI Solved

Q26

To remove the contents of several cells at once, you can _____.

A) select the cells and choose Edit | Clear... | Contents
B) Press Esc button
C) select the cells and drag the fill handle back up over them
D) select the cells and press DELETE.

AI Explanation

The Clear Contents command removes the data from selected cells while leaving the cell formatting unchanged. It can be applied to multiple selected cells at once.

CS001 Final Term AI Solved

Q27

Rows of MS Excel are represented by

A) Names
B) Alphabets
C) Numbers
D) Marks

AI Explanation

Rows in MS Excel are identified by numbers such as 1, 2, 3, and so on. Columns are identified using alphabets.

CS001 Final Term AI Solved

Q28

In MS Excel data can be sorted as following

A) Select the date, you need to sort. Go to Data < sort
B) Select the data, you need to sort. Go to Edit < sort
C) Select the data, you need to sort. Go to File < sort
D) None of Given

AI Explanation

In Excel, sorting is performed by selecting the data range and using the Sort option under the Data tab. This allows data to be arranged in ascending or descending order.

CS001 Final Term AI Solved

Q29

_______ displays the Help task pane in MS Excel.

A) F4
B) F3
C) F1
D) F2

AI Explanation

The F1 key opens the Help task pane in MS Excel. It provides access to help resources and guidance about Excel features.

CS001 Final Term AI Solved

Q30

Columns of MS Excel are represented by

A) Alphabets
B) Marks
C) Names
D) Numbers

AI Explanation

Columns in MS Excel are represented by alphabets such as A, B, C, and so on. Rows are represented by numbers.

CS001 Final Term AI Solved

Q31

By default there are ...... sheet(s) in MS Excel

A) 4
B) 3
C) 2
D) 1

AI Explanation

In current versions of MS Excel, a workbook contains one worksheet by default when created. Users can add more worksheets as needed.

CS001 Final Term AI Solved

Q32

You can enter different types of data in spreadsheet like

A) Numeric Data
B) Symbols
C) All of Given
D) Letters

AI Explanation

A spreadsheet can contain different types of data, including numeric data, symbols, and letters. These values can be entered and processed in worksheet cells.

CS001 Final Term AI Solved

Q33

Rows of MS Excel are represented by

A) Alphabets
B) Marks
C) Names
D) Numbers

AI Explanation

Rows in MS Excel are identified by numbers such as 1, 2, and 3. Columns are identified by alphabetic labels.

CS001 Final Term AI Solved

Q34

Worksheet of MS Excel is divided into

A) Facts and figures
B) Objects
C) Rows and columns
D) Figure

AI Explanation

An MS Excel worksheet is divided into rows and columns that form a grid of cells. Each cell is the intersection of a row and a column where data can be entered.

CS001 Final Term AI Solved

Q35

In complex formulas, the ______ is very important.

A) Order of operations
B) Percentage %
C) Formula
D) Math

AI Explanation

In complex formulas, the order of operations determines which calculations are performed first. Following the correct sequence ensures the formula produces the intended result.

CS001 Final Term AI Solved

Q36

The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is ________.

A) B1:G10
B) B1.G10
C) B1;G10
D) B1-G10

AI Explanation

A range in Excel is written using the starting cell reference, followed by a colon, and then the ending cell reference. B1:G10 represents all cells from B1 through G10.

CS001 Final Term AI Solved

Q37

Relative reference is useful when we need to apply _______ type of calculations.

A) Simple
B) Complex
C) Mathematical
D) Same

AI Explanation

Relative references are useful when the same type of calculation needs to be applied across multiple cells. The cell references automatically adjust when the formula is copied.

CS001 Final Term AI Solved

Q38

It is possible to ___________ the worksheets in a workbook.

A) Only rename
B) Rename, copy, move, delete
C) Only move
D) Only copy

AI Explanation

Excel worksheets can be managed in several ways, including renaming, copying, moving, and deleting. These options help users organize workbook content effectively.

CS001 Final Term AI Solved

Q39

In MS Excel data can be sorted as following

A) Select the data, you need to sort. Go to File < sort
B) Select the data, you need to sort. Go to Edit < sort
C) Select the date, you need to sort. Go to Data < sort
D) None of Given

AI Explanation

In MS Excel, sorting is performed by selecting the data range and using the Sort option under the Data tab. This allows the selected information to be arranged in the desired order.