Excel Questions March 14, 2023 | No Comments 0 votes, 0 avg 148 123456789101112131415 Excel Questions 1 / 15 1. Press _____ to bring up search box. A. Shift + F3 B. Shift + F4 C. Shift + F5 D. Shift + F6 2 / 15 2. 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 3 / 15 3. Advanced Functions are used in higher-level operations such as in conditional and comparison equations to compute interest rates, due dates and payment terms, and financial projections. A. true B. false 4 / 15 4. The total number of rows in a worksheet? A. Unlimited B. 65,535 C. 1,048,576 D. 1,068,576 5 / 15 5. Which programming language is used to write a Macro in MS Excel? A. C B. C++ C. Java D. Visual Basic 6 / 15 6. What function will produce results that indicate whether a student has passed or failed a course by enter the text “Pass” or “Fail”? A. Count B. CountA C. IF D. SUM 7 / 15 7. 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 8 / 15 8. 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 9 / 15 9. Which function returns the current date? A. Lookup B. VLookup C. CountIF D. NOW 10 / 15 10. 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 11 / 15 11. 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 12 / 15 12. MS-Excel uses the ______ Function when creating a data table A. Average B. Count C. Both of These D. Table 13 / 15 13. In ______ tab you will find AutoSum button. A. Formatting tab B. Formulas tab C. Standard tab D. Clipboard tab 14 / 15 14. A worksheet range is a A. A command used for data modeling B. A range of values such as from 23 to 234 C. A group of cells D. A group of worksheets 15 / 15 15. What is the keyboard shortcut to insert a SUM formula in MS Excel? A. CTRL + = B. ALT + = C. ALT + S D. CTRL + ALT + = Your score isThe average score is 43% LinkedIn Facebook VKontakte Restart quiz By WordPress Quiz plugin Questions, Quiz
