MS Excel Mastery Quiz (Chapter-6): 110 MCQs to Test Your Spreadsheet Skills! Computer AwarenessTest 1Test 2Test 3Test 4Test 50% Report a question What's wrong with this question?You cannot submit an empty report. Please add some details. MS Excel- Spreadsheet Mock Test-420 MCQs20 Marks10 Minutes 1 / 20What is the function of the "Sort" option in MS Excel? To perform calculations on selected cells To rearrange the rows or columns in ascending or descending order based on selected criteria To format the content of selected cells To fill cells with color or pattern 2 / 20How can you use the "Print Comments" option to print comments inserted in the worksheet in MS Excel? Type "/printcomments" at the end of the document Press the "Ctrl + C" shortcut key Click the "Print Comments" button on the toolbar Go to "Page Layout" > "Print Comments" 3 / 20What is the correct syntax for the SUM function in MS Excel? =SUM(A1-A2) =SUM(A1, A2) =SUM(A1 + A2) =SUM(A1: A2) 4 / 20In MS Excel, which symbol is used to start a formula? $ = @ * 5 / 20Which function can be used to find the highest value in a range of cells in MS Excel? =TOP(A1: A10) =HIGHEST(A1:A10) =LARGEST(A1:A10) =MAX(A1:A10) 6 / 20What is the correct syntax for the CONCATENATE function in MS Excel? =JOIN(A1, A2) =COMBINE(A1, A2) =CONCATENATE(A1, A2) =CONCAT(A1, A2) 7 / 20How can you use the IF function in MS Excel to check if a value in cell A1 is greater than 10? =IF(A1 > 10, "Yes", "No") =IF(A1 < 10, "Yes", "No") =IF(A1 >= 10, "Yes", "No") =IF(A1 = 10, "Yes", "No") 8 / 20How can you use the "Print Gridlines" option to print gridlines on the worksheet in MS Excel? Type "/printgridlines" at the end of the document Press the "Ctrl + G" shortcut key Click the "Print Gridlines" button on the toolbar Go to "Page Layout" > "Print Gridlines" 9 / 20What is the purpose of using the "Print Titles" option in MS Excel? To insert a new row in the worksheet To print the worksheet directly without any preview To adjust the font size before printing To repeat specific rows or columns on every printed page 10 / 20Which function can be used to calculate the average of a range of cells in MS Excel? =MIDDLE(A1: A10) =AVERAGE(A1:A10) =MEAN(A1:A10) =AVG(A1:A10) 11 / 20What is the function of the "Print Comments" option in MS Excel? To print the worksheet directly without any preview To print comments inserted in the worksheet To insert a new row in the worksheet To adjust the font size before printing 12 / 20What is the purpose of using absolute cell references in a formula in MS Excel? To apply formatting to the formula To refer to a cell that will change when the formula is copied to other cells To refer to a cell that will not change when the formula is copied to other cells To hide the formula from view 13 / 20How can you use the "Print in Black and White" option to print the worksheet in black and white in MS Excel? Click the "Print in Black and White" button on the toolbar Type "/printblackandwhite" at the end of the document Press the "Ctrl + B" shortcut key Go to "Page Layout" > "Print in Black and White" 14 / 20How can you use the "Print Titles" option to repeat specific rows or columns on every printed page in MS Excel? Type "/printtitles" followed by the row or column reference Go to "Page Layout" > "Print Titles" > "Rows to Repeat at Top" or "Columns to Repeat at Left" Click the "Print Titles" button on the toolbar and choose "Rows to Repeat at Top" or "Columns to Repeat at Left" Press the "Ctrl + R" shortcut key 15 / 20What is the purpose of using cell references in formulas? To display the content of the cell in the formula To hide the formula from view To refer to a specific cell or range of cells in the formula To apply formatting to the formula 16 / 20How can you use the COUNT function in MS Excel to count the number of non-empty cells in a range? =COUNT(A1:A10) =COUNTIF(A1:A10, "<>") =COUNTA(A1:A10) =NONEMPTY(A1: A10) 17 / 20How can you use the "Clear All" option to delete the contents and formatting of selected cells in MS Excel? Press the "Ctrl + Shift + K" shortcut key Type "/clearall" at the end of the document Click the "Clear All" button on the toolbar Go to "Home" > "Clear" and select "Clear All" 18 / 20What is the purpose of using the "Print in Black and White" option in MS Excel? To insert a new row in the worksheet To print the worksheet directly without any preview To print the worksheet in black and white instead of color To adjust the font size before printing 19 / 20Which formula can be used to add the values in cells A1 and A2 in MS Excel? =ADD(A1, A2) =A1 + A2 =SUM(A1, A2) =TOTAL(A1, A2) 20 / 20What is the function of the "Print Gridlines" option in MS Excel? To insert a new row in the worksheet To adjust the font size before printing To print the worksheet directly without any preview To print gridlines on the worksheet Previous 1 2 3 4 5 6NextRelated Posts Computer Hardware & Software Questions & Answers (Chapter-3): Quiz of 100+ MCQs Today’s Computer Awareness Mock (MCQs) Exam: Test your Competitive Exam Preparations! Computer Literacy in Banking (Chapter-14): Comprehensive 120 MCQs for Competitive Exam Preparation in IndiaLeave a Reply Cancel Reply Save my name, email, and website in this browser for the next time I comment. I have read and accepted the Privacy Policy * Δ
Computer Literacy in Banking (Chapter-14): Comprehensive 120 MCQs for Competitive Exam Preparation in India
Acadizy 
