Excel Questions March 14, 2023 | No Comments 0 votes, 0 avg 117 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. In MS Excel, ‘Merge and Center’ is used to ____. A. Combine and centre the content of the selected cell B. Combine and centre the content of the current row C. Concatenate the text of the two cells and returns the text D. None of the above 3 / 15 3. 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 4 / 15 4. What is the keyboard shortcut for creating a chart from the selected cell range? A. F2 B. F4 C. F8 D. F11 5 / 15 5. The total number of columns in a worksheet? A. 26 B. 256 C. 12,834 D. 16,384 6 / 15 6. 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 7 / 15 7. What dialog box allows you to change a field name in a PivotTable? A. Field Options B. Field Pane C. Field Settings D. Field Structure 8 / 15 8. Which function is used to trap and handle errors? A. IFERROR() B. ERROR() C. IFNA() D. IFTRAP() 9 / 15 9. Excel is a ____ program developed by Microsoft. A. Spreadsheet B. Document C. Data management D. All of the above 10 / 15 10. Which function is used to remove extra spaces from the text in MS Excel? A. REMOVE() B. TRIM() C. TRUNC() D. All of the above 11 / 15 11. Which function returns the current date? A. Lookup B. VLookup C. CountIF D. NOW 12 / 15 12. In ______ tab you will find AutoSum button. A. Formatting tab B. Formulas tab C. Standard tab D. Clipboard tab 13 / 15 13. The total number of rows in a worksheet? A. Unlimited B. 65,535 C. 1,048,576 D. 1,068,576 14 / 15 14. 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 15 / 15 15. Which option displays the total number of cells, formulas, charts, tables, sheets, etc. in a Workbook? A. Workbook Statistics B. Statistics C. Excel Statistics D. Workbook Analysis Your score is The average score is 45% LinkedIn Facebook Twitter VKontakte Restart quiz Questions, Quiz
