Excel Questions March 14, 2023 | No Comments 0 votes, 0 avg 162 123456789101112131415 Excel Questions 1 / 15 1. What function will produce results that indicate whether a student has passed or failed a course by enter the text “Pass” or “Fail”? A. Count B. CountA C. IF D. SUM 2 / 15 2. Which is not a Text function in MS Excel? A. CODE() B. CLEAN() C. CHAR() D. DB() 3 / 15 3. What is the correct syntax of IF() function? A. =IF (logical_test, {[value_if_true]}, {[value_if_flse]}) B. =IF (logical_test, TRUE([value_if_true]), FALSE([value_if_false])) C. =IF (logical_test: [value_if_true], [value_if_false]) D. =IF (logical_test, [value_if_true], [value_if_false]) 4 / 15 4. A function inside other function is called A. Nested Function B. Round Function C. Inner Function D. None of the above 5 / 15 5. 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 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 function returns the current date? A. Lookup B. VLookup C. CountIF D. NOW 8 / 15 8. What is the collection of worksheets called? A. Ledger B. Book C. Testbook D. Workbook 9 / 15 9. What is the first step for creating a Pivot Table? A. Clicking on the Insert Tab and inserting a Pivot Table B. Create or select data that needs to be analyzed C. Deciding on which fields (column and row labels) to use to analyze the data D. None of the above 10 / 15 10. Which function is used to get the location of text in a string in MS Excel? A. FIND() B. INDEX() C. SEARCH() D. STRINGSEARCH() 11 / 15 11. 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 12 / 15 12. The total number of columns in a worksheet? A. 26 B. 256 C. 12,834 D. 16,384 13 / 15 13. 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) 14 / 15 14. Excel is a program that is used to prepare a A. Slide presentation B. Spreadsheet C. Text document D. Database 15 / 15 15. Press _____ to bring up search box. A. Shift + F3 B. Shift + F4 C. Shift + F5 D. Shift + F6 Your score isThe average score is 44% LinkedIn Facebook VKontakte Restart quiz By WordPress Quiz plugin Questions, Quiz
