MS Excel MCQs

Correct Answer: B. Keep rows/columns visible while scrolling Fact Check: Freeze Panes keeps selected rows or columns visible when you scroll in Excel. A. Delete sheet is not correct because it does not match the verified fact: Freeze Panes keeps selected rows or columns visible when you scroll in Excel. B. Correct — Keep rows/columns visible while scrolling is right because Freeze Panes keeps selected rows or columns visible when you scroll in Excel. C. Add password is not correct because it does not match the verified fact: Freeze Panes keeps selected rows or columns visible when you scroll in Excel. D. Print only is not correct because it does not match the verified fact: Freeze Panes keeps selected rows or columns visible when you scroll in Excel.

Correct Answer: C. $A$1 Fact Check: $A$1 is an absolute reference. It remains fixed when copied to another cell. A. A1 is not correct because it does not match the verified fact: $A$1 is an absolute reference. It remains fixed when copied to another cell. B. A$1 is not correct because it does not match the verified fact: $A$1 is an absolute reference. It remains fixed when copied to another cell. C. Correct — $A$1 is right because $A$1 is an absolute reference. It remains fixed when copied to another cell. D. 1A is not correct because it does not match the verified fact: $A$1 is an absolute reference. It remains fixed when copied to another cell.

Correct Answer: B. MIN Fact Check: MIN returns the smallest value from selected cells. A. MAX is not correct because it does not match the verified fact: MIN returns the smallest value from selected cells. B. Correct — MIN is right because MIN returns the smallest value from selected cells. C. SUM is not correct because it does not match the verified fact: MIN returns the smallest value from selected cells. D. AVERAGE is not correct because it does not match the verified fact: MIN returns the smallest value from selected cells.

Correct Answer: B. MAX Fact Check: MAX returns the largest value from selected cells. A. MIN is not correct because it does not match the verified fact: MAX returns the largest value from selected cells. B. Correct — MAX is right because MAX returns the largest value from selected cells. C. SUM is not correct because it does not match the verified fact: MAX returns the largest value from selected cells. D. IF is not correct because it does not match the verified fact: MAX returns the largest value from selected cells.

Correct Answer: A. COUNT Fact Check: COUNT counts cells containing numbers only. A. Correct — COUNT is right because COUNT counts cells containing numbers only. B. COUNTA is not correct because it does not match the verified fact: COUNT counts cells containing numbers only. C. MAX is not correct because it does not match the verified fact: COUNT counts cells containing numbers only. D. IF is not correct because it does not match the verified fact: COUNT counts cells containing numbers only.

Correct Answer: C. AVERAGE Fact Check: AVERAGE calculates the arithmetic mean of selected numbers. A. SUM is not correct because it does not match the verified fact: AVERAGE calculates the arithmetic mean of selected numbers. B. COUNT is not correct because it does not match the verified fact: AVERAGE calculates the arithmetic mean of selected numbers. C. Correct — AVERAGE is right because AVERAGE calculates the arithmetic mean of selected numbers. D. MIN is not correct because it does not match the verified fact: AVERAGE calculates the arithmetic mean of selected numbers.

Correct Answer: B. SUM Fact Check: SUM is used to add numbers in Excel. A. AVERAGE is not correct because it does not match the verified fact: SUM is used to add numbers in Excel. B. Correct — SUM is right because SUM is used to add numbers in Excel. C. COUNT is not correct because it does not match the verified fact: SUM is used to add numbers in Excel. D. MAX is not correct because it does not match the verified fact: SUM is used to add numbers in Excel.

Correct Answer: B. = Fact Check: Excel formulas start with an equal sign (=), for example =SUM(A1:A5). A. + is not correct because it does not match the verified fact: Excel formulas start with an equal sign (=), for example =SUM(A1:A5). B. Correct — = is right because Excel formulas start with an equal sign (=), for example =SUM(A1:A5). C. # is not correct because it does not match the verified fact: Excel formulas start with an equal sign (=), for example =SUM(A1:A5). D. @ is not correct because it does not match the verified fact: Excel formulas start with an equal sign (=), for example =SUM(A1:A5).

Correct Answer: A. Cell Fact Check: A cell is formed where a row and column meet, such as A1 or B2. A. Correct — Cell is right because A cell is formed where a row and column meet, such as A1 or B2. B. Table is not correct because it does not match the verified fact: A cell is formed where a row and column meet, such as A1 or B2. C. Slide is not correct because it does not match the verified fact: A cell is formed where a row and column meet, such as A1 or B2. D. Field is not correct because it does not match the verified fact: A cell is formed where a row and column meet, such as A1 or B2.

Correct Answer: B. Worksheet Fact Check: A worksheet is a sheet inside an Excel workbook. A. Slide is not correct because it does not match the verified fact: A worksheet is a sheet inside an Excel workbook. B. Correct — Worksheet is right because A worksheet is a sheet inside an Excel workbook. C. Record is not correct because it does not match the verified fact: A worksheet is a sheet inside an Excel workbook. D. Query is not correct because it does not match the verified fact: A worksheet is a sheet inside an Excel workbook.

Correct Answer: C. Workbook Fact Check: An Excel file is called a workbook, and it contains worksheets. A. Document is not correct because it does not match the verified fact: An Excel file is called a workbook, and it contains worksheets. B. Presentation is not correct because it does not match the verified fact: An Excel file is called a workbook, and it contains worksheets. C. Correct — Workbook is right because An Excel file is called a workbook, and it contains worksheets. D. Database only is not correct because it does not match the verified fact: An Excel file is called a workbook, and it contains worksheets.

Correct Answer: B. .xlsx Fact Check: Modern Excel workbooks are saved with .xlsx extension. A. .docx is not correct because it does not match the verified fact: Modern Excel workbooks are saved with .xlsx extension. B. Correct — .xlsx is right because Modern Excel workbooks are saved with .xlsx extension. C. .pptx is not correct because it does not match the verified fact: Modern Excel workbooks are saved with .xlsx extension. D. .pdf is not correct because it does not match the verified fact: Modern Excel workbooks are saved with .xlsx extension.

Correct Answer: A. Spreadsheet work Fact Check: MS Excel is spreadsheet software used for calculations, tables, formulas, charts, and data analysis. A. Correct — Spreadsheet work is right because MS Excel is spreadsheet software used for calculations, tables, formulas, charts, and data analysis. B. Video editing is not correct because it does not match the verified fact: MS Excel is spreadsheet software used for calculations, tables, formulas, charts, and data analysis. C. Painting is not correct because it does not match the verified fact: MS Excel is spreadsheet software used for calculations, tables, formulas, charts, and data analysis. D. Email only is not correct because it does not match the verified fact: MS Excel is spreadsheet software used for calculations, tables, formulas, charts, and data analysis.