Excel Questions

1. What function will produce results that indicate whether a student has passed or failed a course by enter the text “Pass” or “Fail”?

2. In ______ tab you will find AutoSum button.

3. Press _____ to bring up search box.

4.  What function displays row data in a column or column data in a row?

5.  What is the first step for creating a Pivot Table?

6.  Which option allows you to display all numbers which are less than 0 (negative numbers) in red color in MS Excel?

7. Which function is used to get a date n working days in the future or past?

8. What command allows you to highlight the cell(s) in a data table that matches your set-up information?

9.  What is the keyboard shortcut for creating a chart from the selected cell range?

10. Statistical calculations and preparation of tables and graphs can be done using

11.  Under which tab and in which function group will you find the option to insert a Pivot Table?

12. Which programming language is used to write a Macro in MS Excel?

13. Which function is used to get the location of text in a string in MS Excel?

14. What is the collection of worksheets called?

15. The total number of rows in a worksheet?