Excel Questions March 14, 2023 | No Comments 0 votes, 0 avg 151 123456789101112131415 Excel Questions 1 / 15 1. 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 2 / 15 2. Which is not a Text function in MS Excel? A. CODE() B. CLEAN() C. CHAR() D. DB() 3 / 15 3. How can we provide a dynamic range in ‘data Source’ of pivot tables? A. Create a Named range using Offset function B. Base the pivot table using the Named range created in Step 1 C. Both A and B D. None 4 / 15 4. The intersection of a column and a row in a worksheet is called ____. A. Box B. Cell C. Range D. Page Break 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. 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 7 / 15 7. 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 8 / 15 8. Which of the following is NOT a box in the PivotTable Fields List? A. Column Labels B. Report Filter C. Values D. Formulas 9 / 15 9. IF Statement can be written to carry out an action A. true B. false 10 / 15 10. What command allows you to highlight the cell(s) in a data table that matches your set-up information? A. Cell Styles B. Conditional Formatting C. AutoFormatting D. Data Table Styles 11 / 15 11. Which logical function returns TRUE if all arguments evaluate TRUE; FALSE if not? A. OR B. AND C. IF D. ANDIF 12 / 15 12. Under which Tab, the chart options are available in MS Excel? A. Data B. Insert C. Review D. View 13 / 15 13. Which function is used to trap and handle errors? A. IFERROR() B. ERROR() C. IFNA() D. IFTRAP() 14 / 15 14. Which function is used to get the location of text in a string in MS Excel? A. FIND() B. INDEX() C. SEARCH() D. STRINGSEARCH() 15 / 15 15. What is the default file name of Microsoft Excel file? A. Workbook.xlsx B. Workbook1.xlsx C. Worksheet.xlsx D. Worksheet1.xlsx Your score isThe average score is 43% LinkedIn Facebook VKontakte Restart quiz By WordPress Quiz plugin Questions, Quiz
