Excel Test 0 votes, 0 avg 173 123456789101112131415 Excel Questions 1 / 15 1. Which function is used to trap and handle errors? A. IFERROR() B. ERROR() C. IFNA() D. IFTRAP() 2 / 15 2. What is the keyboard shortcut to display the Format Cells dialog box in MS Excel? A. CTRL + F B. ALT + 1 C. CTRL + SHIFT + F D. CTRL + 1 3 / 15 3. _____ are equations that perform calculations on values in your worksheet. A. Functions B. References C. Formulas D. Constants 4 / 15 4. IF Statement can be written to carry out an action A. true B. false 5 / 15 5. Shortcut key CTRL + D is used to ____. A. Open font dialog box B. Open format cells dialog box C. Shift current cell's value in the right cell D. Fill down in the selection 6 / 15 6. The total number of columns in a worksheet? A. 26 B. 256 C. 12,834 D. 16,384 7 / 15 7. Which function will you use to enter current date and time in a worksheet cell? A. =today() B. =now() C. =time() D. =currentTime() 8 / 15 8. Which symbol is used to specify the fixed columns or rows in the formula? A. = B. * C. $ D. % 9 / 15 9. The NOW function calculates the difference in days between two dates. A. true B. false 10 / 15 10. 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 11 / 15 11. You can select the current Column in MS-Excel Worksheet by pressing? A. Ctrl + Space bar B. F8 + arrow key C. Shift + arrow key D. Shift + Space bar 12 / 15 12. Which of following functions MS-Excel have 1 SUM 2 CONCATENATE? A. Only 1 B. Only 2 C. None of 1 and 2 D. Both 1 and 2 13 / 15 13. What is the keyboard shortcut for creating a chart from the selected cell range? A. F2 B. F4 C. F8 D. F11 14 / 15 14. Getting data from a cell located in a different worksheet is called? A. Accessing B. Referencing C. Updating D. Functioning 15 / 15 15. Excel is a program that is used to prepare a A. Slide presentation B. Spreadsheet C. Text document D. Database Your score isThe average score is 43% LinkedIn Facebook VKontakte Restart quiz By Wordpress Quiz plugin