Excel Test 0 votes, 0 avg 5 123456789101112131415 Excel Questions 1 / 15 1. Which bar show the used formula of selected active cell? A. Formula bar B. Ribbon C. Menu bar D. Scroll bar 2 / 15 2. 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 3 / 15 3. _____ are equations that perform calculations on values in your worksheet. A. Functions B. References C. Formulas D. Constants 4 / 15 4. Shortcut key CTRL + D is used to ____. A. Open font dialog box B. Open format cells dialog box C. Shift current cell's value in the right cell D. Fill down in the selection 5 / 15 5. Which function is used to get days, months, or years between two dates? A. DATE() B. DATEDIF() C. DATEVALUE() D. CURDATE() 6 / 15 6. Press _____ to bring up search box. A. Shift + F3 B. Shift + F4 C. Shift + F5 D. Shift + F6 7 / 15 7. An array is a systematic arrangement of similar objects, usually in rows and columns. A. true B. false 8 / 15 8. A features that displays only the data in column (s) according to specified criteria A. Formula B. Sorting C. Filtering D. Pivot 9 / 15 9. Under which Tab, the chart options are available in MS Excel? A. Data B. Insert C. Review D. View 10 / 15 10. This is not a function category in Excel. A. Logical B. Text C. Financial D. Data series 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. 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 13 / 15 13. What function displays row data in a column or column data in a row? A. Hyperlink B. Index C. Transpose D. Rows 14 / 15 14. Which function is used to create a date with year, month, and day? A. DATE() B. DATEDIF() C. DATEVALUE() D. CURDATE() 15 / 15 15. 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 Your score is The average score is 53% LinkedIn Facebook Twitter VKontakte Restart quiz