Excel Questions March 14, 2023 | No Comments 0 votes, 0 avg 86 123456789101112131415 Excel Questions 1 / 15 1. 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 2 / 15 2. What is the keyboard shortcut to insert a SUM formula in MS Excel? A. CTRL + = B. ALT + = C. ALT + S D. CTRL + ALT + = 3 / 15 3. 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 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. The intersection of a column and a row in a worksheet is called ____. A. Box B. Cell C. Range D. Page Break 7 / 15 7. The currently selected cell address is displayed in ____. A. Name Box B. Formula Bar C. Both A and B D. None of the above 8 / 15 8. Which of following functions MS-Excel have 1 SUM 2 CONCATENATE? A. Only 1 B. Only 2 C. None of 1 and 2 D. Both 1 and 2 9 / 15 9. What is the default file name of Microsoft Excel file? A. Workbook.xlsx B. Workbook1.xlsx C. Worksheet.xlsx D. Worksheet1.xlsx 10 / 15 10. Getting data from a cell located in a different worksheet is called? A. Accessing B. Referencing C. Updating D. Functioning 11 / 15 11. Which programming language is used to write a Macro in MS Excel? A. C B. C++ C. Java D. Visual Basic 12 / 15 12. ____ appear at the bottom of the Excel window. A. Title bar B. Formula bar C. Work sheet tabs D. Name box 13 / 15 13. IF Statement can be written to carry out an action A. true B. false 14 / 15 14. What dialog box allows you to change a field name in a PivotTable? A. Field Options B. Field Pane C. Field Settings D. Field Structure 15 / 15 15. 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 Your score is The average score is 49% LinkedIn Facebook Twitter VKontakte Restart quiz Questions, Quiz
