Excel Questions March 14, 2023 | No Comments 0 votes, 0 avg 51 123456789101112131415 Excel Questions 1 / 15 1. ____ appear at the bottom of the Excel window. A. Title bar B. Formula bar C. Work sheet tabs D. Name box 2 / 15 2. Which option is used to quickly convert a range of cells to a table with its own style converted in MS Excel? A. Table Styles B. Stylish Cells C. Format as Table D. Cells as Table 3 / 15 3. An array is a systematic arrangement of similar objects, usually in rows and columns. A. true B. false 4 / 15 4. Steps for protecting a sheet by password in MS Excel? A. Under the Review Tab, Click on Protect Current Sheet B. Under Insert Tab, Click on Protect Sheet C. Under Data Tab, Click on Protect Sheet D. Under the Review Tab, Click on Protect Sheet 5 / 15 5. The intersection of a column and a row in a worksheet is called ____. A. Box B. Cell C. Range D. Page Break 6 / 15 6. Excel is a program that is used to prepare a A. Slide presentation B. Spreadsheet C. Text document D. Database 7 / 15 7. What is the keyboard shortcut to switch between open Excel windows? A. CTRL + TAB B. ALT + TAB C. CTRL + ALT + TAB D. None of the above 8 / 15 8. The total number of columns in a worksheet? A. 26 B. 256 C. 12,834 D. 16,384 9 / 15 9. The currently selected cell address is displayed in ____. A. Name Box B. Formula Bar C. Both A and B D. None of the above 10 / 15 10. Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used when there are more than two columns in the array A. CountIF B. NOW C. Lookup D. VLookup 11 / 15 11. Which is not a Text function in MS Excel? A. CODE() B. CLEAN() C. CHAR() D. DB() 12 / 15 12. What is the correct value of the function? =ROUND (1.9867,2) A. 1.98 B. 1.99 C. 2 D. 1 13 / 15 13. Which of the following is NOT a box in the PivotTable Fields List? A. Column Labels B. Report Filter C. Values D. Formulas 14 / 15 14. Excel is a ____ program developed by Microsoft. A. Spreadsheet B. Document C. Data management D. All of the above 15 / 15 15. Which function is used to return the number of cells in a range that meet a condition set forth in the formula? A. Lookup B. VLookup C. NOW D. CountIF Your score is The average score is 53% LinkedIn Facebook Twitter VKontakte Restart quiz Questions, Quiz
