Excel Questions March 14, 2023 | No Comments 0 votes, 0 avg 157 123456789101112131415 Excel Questions 1 / 15 1. Which of the following is an example of text in a spreadsheet? A. 2763 B. Sales 1994 1995 C. =A1+A2+A3 D. .=sum (A1+A2+A3) 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. Press _____ to bring up search box. A. Shift + F3 B. Shift + F4 C. Shift + F5 D. Shift + F6 4 / 15 4. Which function is used to return the number of cells in a range that meet a condition set forth in the formula? A. Lookup B. VLookup C. NOW D. CountIF 5 / 15 5. What is the extension of a Microsoft Excel file? A. msxcl B. xcl C. xlsx D. xlsm 6 / 15 6. 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 7 / 15 7. 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 8 / 15 8. What is the correct value of the function? =ROUND (1.2345,2) A. 1.24 B. 1.23 C. 1. 25 D. 2 9 / 15 9. Which of the following is NOT a box in the PivotTable Fields List? A. Column Labels B. Report Filter C. Values D. Formulas 10 / 15 10. 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 11 / 15 11. What function displays row data in a column or column data in a row? A. Hyperlink B. Index C. Transpose D. Rows 12 / 15 12. Which function is used to get a date n working days in the future or past? A. WORKDAY() B. DAY() C. WORKDATE() D. DAYM() 13 / 15 13. Under which Tab, the chart options are available in MS Excel? A. Data B. Insert C. Review D. View 14 / 15 14. Which is not a Text function in MS Excel? A. CODE() B. CLEAN() C. CHAR() D. DB() 15 / 15 15. This is not a function category in Excel. A. Logical B. Text C. Financial D. Data series Your score isThe average score is 43% LinkedIn Facebook VKontakte Restart quiz By WordPress Quiz plugin Questions, Quiz