Excel Questions March 14, 2023 | No Comments 0 votes, 0 avg 161 123456789101112131415 Excel Questions 1 / 15 1. 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 2 / 15 2. Which feature is used to wrap extra-long text into multiple lines in MS Excel? A. Word Wrap B. Letter Wrap C. Text Wrap D. Wrap Text 3 / 15 3. Which programming language is used to write a Macro in MS Excel? A. C B. C++ C. Java D. Visual Basic 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. In MS-Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the _______ menu A. Edit B. Format C. Tools D. All of the above 6 / 15 6. Which of the following is NOT a box in the PivotTable Fields List? A. Column Labels B. Report Filter C. Values D. Formulas 7 / 15 7. 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) 8 / 15 8. 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 9 / 15 9. The intersection of a column and a row in a worksheet is called ____. A. Box B. Cell C. Range D. Page Break 10 / 15 10. Which symbol is used to specify the fixed columns or rows in the formula? A. = B. * C. $ D. % 11 / 15 11. In ______ tab you will find AutoSum button. A. Formatting tab B. Formulas tab C. Standard tab D. Clipboard tab 12 / 15 12. Which is not a Text function in MS Excel? A. CODE() B. CLEAN() C. CHAR() D. DB() 13 / 15 13. You can select the current Column in MS-Excel Worksheet by pressing? A. Ctrl + Space bar B. F8 + arrow key C. Shift + arrow key D. Shift + Space bar 14 / 15 14. 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 15 / 15 15. Which function is used to create a date with year, month, and day? A. DATE() B. DATEDIF() C. DATEVALUE() D. CURDATE() Your score isThe average score is 44% LinkedIn Facebook VKontakte Restart quiz By WordPress Quiz plugin Questions, Quiz
