Excel Questions March 14, 2023 | No Comments 0 votes, 0 avg 162 123456789101112131415 Excel Questions 1 / 15 1. Which function will you use to enter current date and time in a worksheet cell? A. =today() B. =now() C. =time() D. =currentTime() 2 / 15 2. The currently selected cell address is displayed in ____. A. Name Box B. Formula Bar C. Both A and B D. None of the above 3 / 15 3. 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 4 / 15 4. 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 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. Which programming language is used to write a Macro in MS Excel? A. C B. C++ C. Java D. Visual Basic 7 / 15 7. IF Statement can be written to carry out an action A. true B. false 8 / 15 8. Which is not a Text function in MS Excel? A. CODE() B. CLEAN() C. CHAR() D. DB() 9 / 15 9. 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 10 / 15 10. You can select the current row in MS-Excel Worksheet by pressing? A. Ctrl + Space bar B. F8 + arrow key C. Shift + arrow key D. Shift + Space bar 11 / 15 11. Which symbol is used to specify the fixed columns or rows in the formula? A. = B. * C. $ D. % 12 / 15 12. 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 13 / 15 13. This is not a function category in Excel. A. Logical B. Text C. Financial D. Data series 14 / 15 14. 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 15 / 15 15. 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 Your score isThe average score is 44% LinkedIn Facebook VKontakte Restart quiz By WordPress Quiz plugin Questions, Quiz
