Excel Questions March 14, 2023 | No Comments 0 votes, 0 avg 161 123456789101112131415 Excel Questions 1 / 15 1. 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 2 / 15 2. Which function is used to get the location of text in a string in MS Excel? A. FIND() B. INDEX() C. SEARCH() D. STRINGSEARCH() 3 / 15 3. 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 4 / 15 4. A features that displays only the data in column (s) according to specified criteria A. Formula B. Sorting C. Filtering D. Pivot 5 / 15 5. What is the keyboard shortcut to insert a SUM formula in MS Excel? A. CTRL + = B. ALT + = C. ALT + S D. CTRL + ALT + = 6 / 15 6. Excel is a ____ program developed by Microsoft. A. Spreadsheet B. Document C. Data management D. All of the above 7 / 15 7. How can you remove borders applied in cells? A. Choose None on Border tab of Format cells B. Open the list on Border tool in Formatting toolbar then choose first tool C. Both of above D. None 8 / 15 8. The ____ function is used to convert to text in a number format in MS Excel. A. CONVERT() B. TEXT() C. NUM() D. CONVERTTEXT() 9 / 15 9. Excel is a program that is used to prepare a A. Slide presentation B. Spreadsheet C. Text document D. Database 10 / 15 10. 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 11 / 15 11. Which symbol is used to specify the fixed columns or rows in the formula? A. = B. * C. $ D. % 12 / 15 12. What is the extension of a Microsoft Excel file? A. msxcl B. xcl C. xlsx D. xlsm 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. Which logical function returns TRUE if all arguments evaluate TRUE; FALSE if not? A. OR B. AND C. IF D. ANDIF 15 / 15 15. The total number of rows in a worksheet? A. Unlimited B. 65,535 C. 1,048,576 D. 1,068,576 Your score isThe average score is 44% LinkedIn Facebook VKontakte Restart quiz By WordPress Quiz plugin Questions, Quiz
