CSS - PMS - CCE - PCS - Basic Computing MCQs

Correct Answer: B. B2 Fact Check: Select B2, then use View → Freeze Panes. Excel freezes rows above and columns to the left. A. A1 is not correct because it does not match the verified fact: Select B2, then use View → Freeze Panes. Excel freezes rows above and columns to the left. B. Correct — B2 is right because Select B2, then use View → Freeze Panes. Excel freezes rows above and columns to the left. C. C3 is not correct because it does not match the verified fact: Select B2, then use View → Freeze Panes. Excel freezes rows above and columns to the left. D. A2 is not correct because it does not match the verified fact: Select B2, then use View → Freeze Panes. Excel freezes rows above and columns to the left.

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.

Correct Answer: B. Top of page Fact Check: A header appears at the top of a page. A footer appears at the bottom. A. Bottom of page is not correct because it does not match the verified fact: A header appears at the top of a page. A footer appears at the bottom. B. Correct — Top of page is right because A header appears at the top of a page. A footer appears at the bottom. C. Middle only is not correct because it does not match the verified fact: A header appears at the top of a page. A footer appears at the bottom. D. Left margin only is not correct because it does not match the verified fact: A header appears at the top of a page. A footer appears at the bottom.

Correct Answer: A. Multiple personalized documents Fact Check: Mail Merge is used to create letters, labels, or envelopes for many recipients using one template. A. Correct — Multiple personalized documents is right because Mail Merge is used to create letters, labels, or envelopes for many recipients using one template. B. Charts only is not correct because it does not match the verified fact: Mail Merge is used to create letters, labels, or envelopes for many recipients using one template. C. Videos only is not correct because it does not match the verified fact: Mail Merge is used to create letters, labels, or envelopes for many recipients using one template. D. Antivirus files is not correct because it does not match the verified fact: Mail Merge is used to create letters, labels, or envelopes for many recipients using one template.

Correct Answer: B. Spell Check Fact Check: Spell Check helps identify and correct spelling errors in a document. A. Mail Merge is not correct because it does not match the verified fact: Spell Check helps identify and correct spelling errors in a document. B. Correct — Spell Check is right because Spell Check helps identify and correct spelling errors in a document. C. WordArt is not correct because it does not match the verified fact: Spell Check helps identify and correct spelling errors in a document. D. Page Color is not correct because it does not match the verified fact: Spell Check helps identify and correct spelling errors in a document.

Correct Answer: A. Ctrl + S Fact Check: Ctrl + S saves the current file. A. Correct — Ctrl + S is right because Ctrl + S saves the current file. B. Ctrl + P is not correct because it does not match the verified fact: Ctrl + S saves the current file. C. Ctrl + F is not correct because it does not match the verified fact: Ctrl + S saves the current file. D. Ctrl + H is not correct because it does not match the verified fact: Ctrl + S saves the current file.

Correct Answer: B. Ctrl + Z Fact Check: Ctrl + Z is used to undo the last action. A. Ctrl + Y is not correct because it does not match the verified fact: Ctrl + Z is used to undo the last action. B. Correct — Ctrl + Z is right because Ctrl + Z is used to undo the last action. C. Ctrl + U is not correct because it does not match the verified fact: Ctrl + Z is used to undo the last action. D. Ctrl + B is not correct because it does not match the verified fact: Ctrl + Z is used to undo the last action.

Correct Answer: A. Ctrl + X Fact Check: Ctrl + X cuts selected text or object and moves it to clipboard. A. Correct — Ctrl + X is right because Ctrl + X cuts selected text or object and moves it to clipboard. B. Ctrl + C is not correct because it does not match the verified fact: Ctrl + X cuts selected text or object and moves it to clipboard. C. Ctrl + S is not correct because it does not match the verified fact: Ctrl + X cuts selected text or object and moves it to clipboard. D. Ctrl + N is not correct because it does not match the verified fact: Ctrl + X cuts selected text or object and moves it to clipboard.