Excel Questions March 14, 2023 | No Comments 0 votes, 0 avg 5 123456789101112131415 Excel Questions 1 / 15 1. What is the collection of worksheets called? A. Ledger B. Book C. Testbook D. Workbook 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. Which function is used to trap and handle errors? A. IFERROR() B. ERROR() C. IFNA() D. IFTRAP() 4 / 15 4. When you insert an Excel file into a Word document, the data are A. Hyperlinked B. Placed in a word table C. Linked D. Embedded 5 / 15 5. The total number of rows in a worksheet? A. Unlimited B. 65,535 C. 1,048,576 D. 1,068,576 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. Under which Tab, the chart options are available in MS Excel? A. Data B. Insert C. Review D. View 8 / 15 8. 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 9 / 15 9. Which symbol is used to specify the fixed columns or rows in the formula? A. = B. * C. $ D. % 10 / 15 10. _____ are equations that perform calculations on values in your worksheet. A. Functions B. References C. Formulas D. Constants 11 / 15 11. What function will result in the total number of entries in the cell range B5 to B14 A. Count B. MAX C. MIN D. SUM 12 / 15 12. Which logical function returns TRUE if one or more arguments evaluates to TRUE; FALSE if all arguments evaluate to FALSE? A. OR B. AND C. IF D. ANDIF 13 / 15 13. Statistical calculations and preparation of tables and graphs can be done using A. Adobe Photoshop B. Excel C. Notepad D. Power Point 14 / 15 14. Which logical function returns TRUE if all arguments evaluate TRUE; FALSE if not? A. OR B. AND C. IF D. ANDIF 15 / 15 15. 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 Your score is The average score is 53% LinkedIn Facebook Twitter VKontakte Restart quiz Questions, Quiz
