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-220 MCQs20 Marks10 Minutes 1 / 20What is the purpose of using the "Margins" option in MS Excel? To set the page margins for the printed page To insert a new row in the worksheet To adjust the font size before printing To change the page layout and print settings of the worksheet 2 / 20What is the name of the individual spreadsheet within a workbook in MS Excel? Subsheet Worksheet Data Sheet Data Tab 3 / 20What term is used for a formula that refers to its own cell in MS Excel? Circular Formula Self-Link Self-Loop Self-Reference 4 / 20What feature allows you to copy the formatting of selected cells and apply it to other cells? Copy Format Format Painter Duplicate Style Style Applier 5 / 20Which option in MS Excel allows you to insert new cells, rows, or columns? Add Update Create Insert 6 / 20How can you access the "Page Setup" option in MS Excel? Type "/pagesetup" at the end of the document Press the "Ctrl + S" shortcut key Click the "Page Setup" button on the toolbar Go to "File" > "Page Setup" 7 / 20What is the purpose of using the "Print Area" option in MS Excel? To print only selected cells within a specified range To adjust the margins of the printed page To insert a new row in the worksheet To change the page orientation before printing 8 / 20What is the function of the "Page Setup" option in MS Excel? To change the page layout and print settings of the worksheet To adjust the font size before printing To print the worksheet directly without any preview To format the content of selected cells 9 / 20How can you use the "Scale to Fit" option to fit the worksheet content to a specific number of pages in MS Excel? Press the "Ctrl + F" shortcut key Type "/scaletofit" followed by the number of pages Click the "Scale to Fit" button on the toolbar and choose "Fit to Pages Wide/Height" Go to "Page Layout" > "Scale to Fit" > "Fit to Pages Wide/Height" 10 / 20How can you access the "Margins" option to set the page margins in MS Excel? Click the "Margins" button on the toolbar and select the desired margin size Type "/margins" followed by the margin size Press the "Ctrl + M" shortcut key Go to "Page Layout" > "Margins" and choose the desired margin size 11 / 20What is the function of the "Scale to Fit" option in MS Excel? To change the page layout and print settings of the worksheet To fit the content of the worksheet to a specified number of pages when printing To print the worksheet directly without any preview To adjust the font size before printing 12 / 20In MS Excel, which menu option allows you to create new worksheets within a workbook? Add Worksheet Insert Worksheet Worksheet Manager New Worksheet 13 / 20In MS Excel, what symbol is used to start a formula? = != =! == 14 / 20Which keyboard shortcut is used to paste the copied content from the clipboard in MS Excel? Ctrl + C Ctrl + V Ctrl + X Ctrl + P 15 / 20Which feature allows you to add labels or notes to cells in MS Excel? Comment Cell Label Data Note Cell Note 16 / 20How can you access the "Print Preview" feature in MS Excel? Type "/printpreview" at the end of the document Go to "File" > "Print Preview" Press the "Ctrl + P" shortcut key Click the "Print Preview" button on the toolbar 17 / 20What is the name of the sheet at the bottom of the MS Excel window that contains the data? Worksheet Sheet Tab Tab Sheet Data Sheet 18 / 20How can you set a specific "Print Area" in MS Excel? Type "/printarea" followed by the range of cells Press the "Ctrl + A" shortcut key Click the "Set Print Area" button on the toolbar Go to "Page Layout" > "Print Area" > "Set Print Area" 19 / 20What data type is used to represent text or alphanumeric values in MS Excel? String Numeric Text Character 20 / 20What is the purpose of the "Print Preview" feature in MS Excel? To change the page layout of the worksheet To adjust the font size before printing To view how the worksheet will appear when printed To print the worksheet directly without any preview Previous 1 2 3 4 5 6NextRelated Posts Information & Network Security Quiz (Chapter-10): 110 MCQs for Competitive Exams Computer Hardware & Software Questions & Answers (Chapter-3): Quiz of 100+ MCQs Basics of Operating Systems (Chapter-4): 130 Essential MCQs for BeginnersLeave 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 * Δ
Acadizy 
