Excel Test 0 votes, 0 avg 162 123456789101112131415 Excel Questions 1 / 15 1. The currently selected cell address is displayed in ____. A. Name Box B. Formula Bar C. Both A and B D. None of the above 2 / 15 2. 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 3 / 15 3. Which function is used to trap and handle errors? A. IFERROR() B. ERROR() C. IFNA() D. IFTRAP() 4 / 15 4. What is the correct value of the function? =ROUND (1.9867,2) A. 1.98 B. 1.99 C. 2 D. 1 5 / 15 5. Which is not a Text function in MS Excel? A. CODE() B. CLEAN() C. CHAR() D. DB() 6 / 15 6. In ______ tab you will find AutoSum button. A. Formatting tab B. Formulas tab C. Standard tab D. Clipboard tab 7 / 15 7. What is the keyboard shortcut to insert a new sheet in the current workbook in MS Excel? A. Shift + F9 B. Shift + F10 C. Shift + F12 D. Shift + F11 8 / 15 8. What command allows you to highlight the cell(s) in a data table that matches your set-up information? A. Cell Styles B. Conditional Formatting C. AutoFormatting D. Data Table Styles 9 / 15 9. IF Statement can be written to carry out an action A. true B. false 10 / 15 10. Under which tab and in which function group will you find the option to insert a Pivot Table? A. Under the Insert tab in the Tables group B. Under the Formulas tab in the Data Analysis group C. In the Data group in the Pivot Tables group D. In the Data group in the Tables group 11 / 15 11. What is the extension of a Microsoft Excel file? A. msxcl B. xcl C. xlsx D. xlsm 12 / 15 12. What is the keyboard shortcut for creating a chart from the selected cell range? A. F2 B. F4 C. F8 D. F11 13 / 15 13. What is the first step for creating a Pivot Table? A. Clicking on the Insert Tab and inserting a Pivot Table B. Create or select data that needs to be analyzed C. Deciding on which fields (column and row labels) to use to analyze the data D. None of the above 14 / 15 14. How can we provide a dynamic range in 'data Source' of pivot tables? A. Create a Named range using Offset function B. Base the pivot table using the Named range created in Step 1 C. Both A and B D. None 15 / 15 15. The total number of columns in a worksheet? A. 26 B. 256 C. 12,834 D. 16,384 Your score isThe average score is 44% LinkedIn Facebook VKontakte Restart quiz By Wordpress Quiz plugin
