Excel Questions March 14, 2023 | No Comments 0 votes, 0 avg 51 123456789101112131415 Excel Questions 1 / 15 1. Which of the following is an example of text in a spreadsheet? A. 2763 B. Sales 1994 1995 C. =A1+A2+A3 D. .=sum (A1+A2+A3) 2 / 15 2. IF Statement can be written to carry out an action A. true B. false 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 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 5 / 15 5. Which function is used to get the location of text in a string in MS Excel? A. FIND() B. INDEX() C. SEARCH() D. STRINGSEARCH() 6 / 15 6. 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 7 / 15 7. 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 8 / 15 8. 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 9 / 15 9. The total number of rows in a worksheet? A. Unlimited B. 65,535 C. 1,048,576 D. 1,068,576 10 / 15 10. Which is not a Text function in MS Excel? A. CODE() B. CLEAN() C. CHAR() D. DB() 11 / 15 11. What is the keyboard shortcut to insert a SUM formula in MS Excel? A. CTRL + = B. ALT + = C. ALT + S D. CTRL + ALT + = 12 / 15 12. Which symbol is used to specify the fixed columns or rows in the formula? A. = B. * C. $ D. % 13 / 15 13. ____ appear at the bottom of the Excel window. A. Title bar B. Formula bar C. Work sheet tabs D. Name box 14 / 15 14. 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 15 / 15 15. 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 Your score is The average score is 53% LinkedIn Facebook Twitter VKontakte Restart quiz Questions, Quiz