1998. To remove the content of selected cells you must issue ______ command A. Delete B. Clear Contents C. Clear All D. Clear Delete ✅ The correct answer is option B.
2000. Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook? A. Work sheet B. Chart sheet C. Macro sheet D. Data sheet ✅ The correct answer is option D.
2002. Ctrl + D shortcut key in Excel will A. Open the font dialog box B. Apply double underline for the active cell C. Fill down in the selection D. None of above ✅ The correct answer is option C.
2004. Which of the following is not the correct method of editing the cell content? A. Press the Alt key B. Press the F2 key C. Click the formula bar D. Double click the cell ✅ The correct answer is option A.
2006. Which of the following series type is not valid for Fill Series dialog box? A. Linear B. Growth C. Autofill D. Time ✅ The correct answer is option D.
1968. While Finding and Replacing some data in Excel, which of the following statement is valid? A. You can Find and Replace within the sheet or workbook B. Excel does not have option to match case for find C. Both are valid D. None are valid ✅ The correct answer is option A.
1971. Which of the following action removes a sheet from workbook? A. Select the sheet, then choose Edit > Delete Sheet B. Select the sheet then choose Format > Sheet > Hide C. Both of above D. None of above ✅ The correct answer is option A.
1974. Which of the following option is not available in Paste Special dialog box? A. Add B. Subtract C. Divide D. SQRT ✅ The correct answer is option D.
1977. Which of the following is invalid statement? A. Sheet tabs can be colored B. Some picture can be applied as a background of a sheet C. You can set the column width automatically fit the amount of text D. The width of a row and be specified manually or fit automatically ✅ The correct answer is option D.
1980. How do you display current date and time in MS Excel? A. Date () B. Today () C. Now () D. Time () ✅ The correct answer is option C.