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-320 MCQs20 Marks10 Minutes 1 / 20How can you use the "Fill" option to apply a background color to selected cells in MS Excel? Press the "Ctrl + F" shortcut key Go to "Home" > "Fill" and choose the desired color Click the "Fill Color" dropdown on the toolbar and choose the color Type "/fillcolor" followed by the color code 2 / 20How can you use the "Copy" option to duplicate selected cells in MS Excel? Type "/copy" at the end of the document Go to "Home" > "Copy" Press the "Ctrl + C" shortcut key Click the "Copy" button on the toolbar 3 / 20What is the function of the "Undo" option in MS Excel? To redo the last action performed To cancel the last action performed and revert to the previous state To save the current worksheet To copy the selected cells to the clipboard 4 / 20What is the purpose of using the "Clear" option in MS Excel? To change the font style of selected cells To cut the worksheet into multiple sections To undo the last action performed To delete the selected cells' contents without moving them to the clipboard 5 / 20What is the purpose of using the "Clear All" option in MS Excel? To undo the last action performed To change the font style of selected cells To cut the worksheet into multiple sections To delete the selected cells' contents and formatting without moving them to the clipboard 6 / 20How can you use the "Cut" option to remove and move selected cells in MS Excel? Click the "Cut" button on the toolbar Go to "Home" > "Cut" Press the "Ctrl + X" shortcut key Type "/cut" at the end of the document 7 / 20How can you use the "Paste" option to paste copied cells in MS Excel? Click the "Paste" button on the toolbar Type "/paste" at the end of the document Go to "Home" > "Paste" Press the "Ctrl + V" shortcut key 8 / 20What is the function of the "Header/Footer" option in MS Excel? To adjust the font size before printing To print the worksheet directly without any preview To insert a new row in the worksheet To add headers and footers to the printed page 9 / 20What is the purpose of using the "Fill" option in MS Excel? To change the font size of selected cells To perform mathematical calculations on selected cells To format the content of selected cells To fill cells with color or pattern 10 / 20How can you access the "Header/Footer" option to add headers and footers to the printed page in MS Excel? Type "/headerfooter" at the end of the document Press the "Ctrl + H" shortcut key Go to "Insert" > "Header & Footer" Click the "Header & Footer" button on the toolbar 11 / 20What is the purpose of using the "Find and Replace" feature in MS Excel? To replace text in cells with a specific value To find and highlight cells that meet a certain criteria To search for specific text within the worksheet To search and replace formulas in cells 12 / 20How can you insert a new row in MS Excel? Type "/insertrow" at the end of the document Click the "Insert Row" button on the toolbar Press the "Ctrl + I" shortcut key Right-click on the row header and select "Insert Row" 13 / 20How can you use the "Find and Replace" feature in MS Excel to replace "apple" with "orange" in the entire worksheet? Press the "Ctrl + F" shortcut key and enter "apple" in "Find What" and "orange" in "Replace With" Go to "Home" > "Find and Replace" and enter "apple" in "Find What" and "orange" in "Replace With" Click the "Find and Replace" button on the toolbar and enter "apple" and "orange" respectively Type "/findreplace apple orange" at the end of the document 14 / 20How can you use the "Undo" option to cancel the last action in MS Excel? Click the "Undo" button on the toolbar Press the "Ctrl + Z" shortcut key Go to "Edit" > "Undo" Type "/undo" at the end of the document 15 / 20How can you use the "Clear" option to delete the contents of selected cells in MS Excel? Press the "Ctrl + K" shortcut key Click the "Clear Contents" button on the toolbar Go to "Home" > "Clear" and select "Contents" Type "/clear" at the end of the document 16 / 20How can you use the "Format Painter" option to copy cell formatting in MS Excel? Type "/formatpainter" at the end of the document Click the "Format Painter" button on the toolbar and select the destination cell Go to "Home" > "Format Painter" and click on the source cell, then click on the destination cell Press the "Ctrl + P" shortcut key 17 / 20What is the purpose of using the "Cut" option in MS Excel? To cut the worksheet into multiple sections To remove the selected cells and move them to the clipboard To copy the selected cells and move them to the clipboard To change the font style of selected cells 18 / 20What is the function of the "Paste" option in MS Excel? To change the font style of pasted cells To remove the selected cells from the clipboard and paste them into the worksheet To paste the worksheet into a different workbook To copy the selected cells from the clipboard and paste them into the worksheet 19 / 20What is the purpose of using the "Copy" option in MS Excel? To remove the selected cells and move them to the clipboard To cut the worksheet into multiple sections To copy the selected cells and move them to the clipboard To change the font style of selected cells 20 / 20What is the function of the "Format Painter" option in MS Excel? To apply borders to selected cells To change the font style of selected cells To perform calculations on selected cells To copy the formatting of selected cells and apply it to other cells Previous 1 2 3 4 5 6NextRelated Posts MS PowerPoint Mock Test (Chapter-7): 100 Challenging Questions (MCQs ) for Competitive Exams Knowing Computer GK Quiz (Chapter-1): Basics [150+ MCQs] Today’s Computer Awareness Mock (MCQs) Exam: Test your Competitive Exam Preparations!Leave 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 
