MCQ Bank

In spreadsheet programs, the Ctrl key is used to select multiple non-adjacent worksheets and create a worksheet group. Holding Ctrl while clicking sheet tabs allows multiple sheets to be selected together.

CS001 Final Term AI Solved

To arrange rows in alphabetical order based on column A, you need to use the command _____.

A) Edit | Data | Sort
B) Tools | Sort
C) None of Given
D) Data | Sort

AI Explanation

The Sort command is typically found under the Data menu in spreadsheet applications. It allows rows to be arranged alphabetically or numerically based on a selected column.

CS001 Final Term AI Solved

When cell addresses are not changed in copying a formula it is called ........... like = $ A $ 2 + $ B $ 2.

A) absolute cell referencing
B) mix cell reference
C) single cell reference
D) none of given

AI Explanation

Absolute cell references use dollar signs ($) to lock both the column and row, preventing changes when a formula is copied. For example, $A$2 and $B$2 remain fixed during copying.

CS001 Final Term AI Solved

It is possible to ___________ the worksheets in a workbook.

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

AI Explanation

Worksheets in a workbook can be managed in several ways, including renaming, copying, moving, and deleting. These options help organize and modify workbook structure.

CS001 Final Term AI Solved

We can use the vertical scroll horizontal and bars to ______________.

A) View different worksheets
B) View different rows and columns.
C) Edit the contents of a cell
D) Split a worksheet into two panes

AI Explanation

Scroll bars are used to navigate through a worksheet by moving vertically through rows and horizontally through columns. They allow users to view different parts of the worksheet without changing its content.

CS001 Final Term AI Solved

The comment can be attached using the New comment option in ________ tab

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

AI Explanation

In MS Excel, comments are added using the New Comment option located in the Review tab. This tab contains tools for reviewing, annotating, and tracking changes in worksheets.

CS001 Final Term AI Solved

The spelling can be verified using the Spelling option in ______ tab.

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

AI Explanation

The Spelling option in Excel is found under the Review tab. It is used to check and correct spelling errors in worksheet content.

CS001 Final Term AI Solved

If you press __________, the cell accepts your typing as its contents.

A) Back-Space
B) Tab
C) Esc
D) Enter

AI Explanation

Pressing Enter confirms the typed data and stores it as the content of the selected cell. Other keys either cancel, move, or edit the input differently.

CS001 Final Term AI Solved

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

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

AI Explanation

In modern versions of MS Excel, a new workbook opens with one worksheet by default. Additional sheets can be added as needed.

CS001 Final Term AI Solved

_________ function calculates the largest value in a set of numbers.

A) Max
B) Average
C) Min
D) Count

AI Explanation

The MAX function returns the largest value from a specified set of numbers. It is commonly used in spreadsheets to find the highest value in a range.

CS001 Final Term AI Solved

Q10

In complex formulas, the ______ is very important.

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

AI Explanation

In complex formulas, the order of operations determines the sequence in which calculations are performed. Following rules such as parentheses, exponents, multiplication/division, and addition/subtraction ensures accurate results.

CS001 Final Term AI Solved

Q11

When cell addresses are changed in copying a formula it is called .......... like = sum ( A1 , B1 ).

A) absolute cell referencing
B) relative cell referencing
C) none of given
D) duplicate cell referencing

AI Explanation

Relative cell references change automatically when a formula is copied to another location. For example, A1 and B1 will adjust based on the new position of the copied formula.

CS001 Final Term AI Solved

Q12

If more than one operator involved in any formula so which one has the highest priority.

A) - and +
B) * and /
C) ()
D) ^

AI Explanation

Parentheses have the highest priority in mathematical formulas because calculations inside them are performed first. They are used to control the order in which operations are carried out.

CS001 Final Term AI Solved

Q13

You can enter different types of data in spreadsheet like

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

AI Explanation

Spreadsheets can store different types of data, including symbols, letters, and numeric values. These data types can be entered and manipulated within spreadsheet cells.

CS001 Final Term AI Solved

Q14

In MS Excel, what menu we should select to create chart?

A) Go to Insert <Choose Any Chart
B) Go to Data < Choose Any Chart
C) Go to File < Choose Any Chart
D) Go to Home < Choose Any Chart

AI Explanation

In MS Excel, charts are created from the Insert tab, where users can choose from various chart types. The selected data is then represented visually using the chosen chart.

CS001 Final Term AI Solved

Q15

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 of cells in Excel is represented by the reference of the first cell followed by a colon and the reference of the last cell. B1:G10 correctly identifies all cells from column B row 1 through column G row 10.

CS001 Final Term AI Solved

Q16

Worksheet of MS Excel is divided into

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

AI Explanation

An Excel worksheet is organized as a grid made up of rows and columns. The intersection of a row and column forms a cell where data is entered.

CS001 Final Term AI Solved

Q17

Columns of MS Excel are represented by

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

AI Explanation

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

CS001 Final Term AI Solved

Q18

To copy data in MS Excel

A) press Ctrl+D
B) press Ctrl+Y
C) press Alt+C
D) press Ctrl+C

AI Explanation

The Ctrl+C keyboard shortcut is used to copy selected data in MS Excel. Ctrl+D fills data downward, while Ctrl+C is the standard copy command.

CS001 Final Term AI Solved

Q19

To edit existing data in a cell without having to retype it all, you should _____.

A) double-click the cell
B) hold SHIFT down while clicking the cell
C) click in the menu bar
D) click in the task bar

AI Explanation

Double-clicking a cell allows the user to edit the existing contents directly without retyping the entire entry. It opens the cell for modification within the worksheet.