Excel Questions March 14, 2023 | No Comments 0 votes, 0 avg 79 123456789101112131415 Excel Questions 1 / 15 1. What is the default file name of Microsoft Excel file? A. Workbook.xlsx B. Workbook1.xlsx C. Worksheet.xlsx D. Worksheet1.xlsx 2 / 15 2. Getting data from a cell located in a different worksheet is called? A. Accessing B. Referencing C. Updating D. Functioning 3 / 15 3. Excel is a program that is used to prepare a A. Slide presentation B. Spreadsheet C. Text document D. Database 4 / 15 4. In ______ tab you will find AutoSum button. A. Formatting tab B. Formulas tab C. Standard tab D. Clipboard tab 5 / 15 5. 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 6 / 15 6. What function displays row data in a column or column data in a row? A. Hyperlink B. Index C. Transpose D. Rows 7 / 15 7. Which logical function returns TRUE if all arguments evaluate TRUE; FALSE if not? A. OR B. AND C. IF D. ANDIF 8 / 15 8. 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 9 / 15 9. Which programming language is used to write a Macro in MS Excel? A. C B. C++ C. Java D. Visual Basic 10 / 15 10. What is the keyboard shortcut to insert a SUM formula in MS Excel? A. CTRL + = B. ALT + = C. ALT + S D. CTRL + ALT + = 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 function inside other function is called A. Nested Function B. Round Function C. Inner Function D. None of the above 13 / 15 13. Excel is a program that is used to prepare a A. Slide presentation B. Spreadsheet C. Text document D. Database 14 / 15 14. Under which tab and in which function group will you find the option to insert a Pivot Table? A. Under the Insert tab in the Tables group B. Under the Formulas tab in the Data Analysis group C. In the Data group in the Pivot Tables group D. In the Data group in the Tables group 15 / 15 15. Excel is a ____ program developed by Microsoft. A. Spreadsheet B. Document C. Data management D. All of the above Your score is The average score is 49% LinkedIn Facebook Twitter VKontakte Restart quiz Questions, Quiz
