Excel Questions March 14, 2023 | No Comments 0 votes, 0 avg 162 123456789101112131415 Excel Questions 1 / 15 1. What function displays row data in a column or column data in a row? A. Hyperlink B. Index C. Transpose D. Rows 2 / 15 2. Which function will you use to enter current date and time in a worksheet cell? A. =today() B. =now() C. =time() D. =currentTime() 3 / 15 3. Which logical function returns TRUE if all arguments evaluate TRUE; FALSE if not? A. OR B. AND C. IF D. ANDIF 4 / 15 4. 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 5 / 15 5. Which function is used to return the number of cells in a range that meet a condition set forth in the formula? A. Lookup B. VLookup C. NOW D. CountIF 6 / 15 6. The NOW function calculates the difference in days between two dates. A. true B. false 7 / 15 7. Which symbol is used to specify the fixed columns or rows in the formula? A. = B. * C. $ D. % 8 / 15 8. 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 9 / 15 9. 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 10 / 15 10. Which function is used to trap and handle errors? A. IFERROR() B. ERROR() C. IFNA() D. IFTRAP() 11 / 15 11. 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 12 / 15 12. Which function is used to get the location of text in a string in MS Excel? A. FIND() B. INDEX() C. SEARCH() D. STRINGSEARCH() 13 / 15 13. What is the correct value of the function? =ROUND (1.2345,2) A. 1.24 B. 1.23 C. 1. 25 D. 2 14 / 15 14. Which of the following is NOT a box in the PivotTable Fields List? A. Column Labels B. Report Filter C. Values D. Formulas 15 / 15 15. Which bar show the used formula of selected active cell? A. Formula bar B. Ribbon C. Menu bar D. Scroll bar Your score isThe average score is 44% LinkedIn Facebook VKontakte Restart quiz By WordPress Quiz plugin Questions, Quiz
