Excel Questions March 14, 2023 | No Comments 0 votes, 0 avg 127 123456789101112131415 Excel Questions 1 / 15 1. Which is not a Text function in MS Excel? A. CODE() B. CLEAN() C. CHAR() D. DB() 2 / 15 2. 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 3 / 15 3. The ____ function is used to convert to text in a number format in MS Excel. A. CONVERT() B. TEXT() C. NUM() D. CONVERTTEXT() 4 / 15 4. Which function returns the current date? A. Lookup B. VLookup C. CountIF D. NOW 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. 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 7 / 15 7. When you insert an Excel file into a Word document, the data are A. Hyperlinked B. Placed in a word table C. Linked D. Embedded 8 / 15 8. What is the correct value of the function? =ROUND (1.2345,2) A. 1.24 B. 1.23 C. 1. 25 D. 2 9 / 15 9. The currently selected cell address is displayed in ____. A. Name Box B. Formula Bar C. Both A and B D. None of the above 10 / 15 10. The total number of columns in a worksheet? A. 26 B. 256 C. 12,834 D. 16,384 11 / 15 11. 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 12 / 15 12. 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 13 / 15 13. Which symbol is used to specify the fixed columns or rows in the formula? A. = B. * C. $ D. % 14 / 15 14. 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 15 / 15 15. Excel is a program that is used to prepare a A. Slide presentation B. Spreadsheet C. Text document D. Database Your score is The average score is 44% LinkedIn Facebook Twitter VKontakte Restart quiz Questions, Quiz
