All Free Computer Science and IT MCQs with Answers

521. Maximum zoom percentage in Excel is _________?

• A. 100%
• B. 300%
• C. 400%
• D. 500%

Explanation: Excel permits worksheet zoom from 10% up to a maximum of 400%. The 100% setting is normal size, not the maximum.

522. Default file name in MS Excel is?

• A. Document 1
• B. Workbook 1
• C. Book1
• D. Worksheet

Explanation: A new Excel workbook is traditionally given the default name Book1, with a file extension added when it is saved. Document1 is the usual default name associated with Word.

523. To insert chart in MS Excel, which shortcut key used?

• A. Alt+F1
• B. F2
• C. F3
• D. F4

Explanation: Alt+F1 creates an embedded chart from the selected Excel data on the current worksheet. Other function keys listed do not perform this chart-insertion shortcut.

524. What is a shortcut key of "Change the font' in MS Word?

• A. Ctrl + Shift + F
• B. Alt + shift + F
• C. Alt + F
• D. None of These

Explanation: Ctrl+Shift+F opens the font-selection control in Word, allowing the font type to be changed. Ctrl+F alone is used for finding text, so it is not the shortcut described.

525. What is the function of the VLOOKUP function in Excel?

• A. To perform a vertical lookup and return a value based on a specified criteria
• B. To perform a horizontal lookup and return a value based on a specified criteria
• C. To add up a range of cells
• D. To find the average of a range of cells

Explanation: VLOOKUP searches vertically down the first column of a table and returns a related value from a specified column in the same row. HLOOKUP performs the corresponding horizontal search.

526. What is the function of the IF function in Excel?

• A. To perform a logical test and return a value based on the result
• B. To add up a range of cells
• C. To find the average of a range of cells
• D. To count the number of cells in a range

Explanation: IF evaluates a logical condition and returns one result when the condition is true and another when it is false. SUM, AVERAGE, and COUNT perform the other listed calculation types.

527. What is the function of the SUM function in Excel?

• A. To add up a range of cells
• B. To find the average of a range of cells
• C. To count the number of cells in a range
• D. To find the maximum value in a range of cells

Explanation: SUM adds the numeric values in a selected range of cells. AVERAGE, COUNT, and MAX respectively calculate the mean, number of entries, and largest value.

528. What is the intersection of a column and row called in Excel?

• A. A cell
• B. A range
• C. A column header
• D. A row header

Explanation: The point where a row and a column meet is called a cell, identified by a reference such as B4. A range is a group of cells, while headers label rows or columns.

529. Title bar in MS-Excel displays name of the __________ ?

• A. Worksheet
• B. Workbook
• C. Formula
• D. Location

Explanation: The Excel title bar displays the name of the active workbook, such as Book1 or Budget.xlsx. A worksheet is an individual sheet inside that workbook.

530. in MS-Excel__________ short cut key is used for hiding rows.

• A. Ctrl+H
• B. Ctrl+7
• C. Ctrl+9
• D. None of the above

Explanation: Ctrl+9 hides the selected rows in Excel, while Ctrl+0 hides columns. Ctrl+H opens Find and Replace rather than hiding rows.