Excel Questions March 14, 2023 | No Comments 0 votes, 0 avg 92 123456789101112131415 Excel Questions 1 / 15 1. 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 2 / 15 2. ____ appear at the bottom of the Excel window. A. Title bar B. Formula bar C. Work sheet tabs D. Name box 3 / 15 3. Which function is used to get the location of text in a string in MS Excel? A. FIND() B. INDEX() C. SEARCH() D. STRINGSEARCH() 4 / 15 4. 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 5 / 15 5. 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 6 / 15 6. Which logical function returns TRUE if all arguments evaluate TRUE; FALSE if not? A. OR B. AND C. IF D. ANDIF 7 / 15 7. The total number of columns in a worksheet? A. 26 B. 256 C. 12,834 D. 16,384 8 / 15 8. Which function is used to get a date n working days in the future or past? A. WORKDAY() B. DAY() C. WORKDATE() D. DAYM() 9 / 15 9. 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 10 / 15 10. A function inside other function is called A. Nested Function B. Round Function C. Inner Function D. None of the above 11 / 15 11. Which symbol is used to specify the fixed columns or rows in the formula? A. = B. * C. $ D. % 12 / 15 12. An array is a systematic arrangement of similar objects, usually in rows and columns. A. true B. false 13 / 15 13. 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 14 / 15 14. Which function is used to remove extra spaces from the text in MS Excel? A. REMOVE() B. TRIM() C. TRUNC() D. All of the above 15 / 15 15. A features that displays only the data in column (s) according to specified criteria A. Formula B. Sorting C. Filtering D. Pivot Your score is The average score is 48% LinkedIn Facebook Twitter VKontakte Restart quiz Questions, Quiz
