Excel Questions

0 votes, 0 avg
39

Excel Questions

1 / 15

1.  What is the keyboard shortcut to switch between open Excel windows?

2 / 15

2. An array is a systematic arrangement of similar objects, usually in rows and columns.

3 / 15

3. Excel is a program that is used to prepare a

4 / 15

4. What is the collection of worksheets called?

5 / 15

5. Press _____ to bring up search box.

6 / 15

6. Under which Tab, the chart options are available in MS Excel?

7 / 15

7. Which symbol is used to specify the fixed columns or rows in the formula?

8 / 15

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

9 / 15

9. A features that displays only the data in column (s) according to specified criteria

10 / 15

10. 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.

11 / 15

11. Which of the following is NOT a box in the PivotTable Fields List?

12 / 15

12. What dialog box allows you to change a field name in a PivotTable?

13 / 15

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

14 / 15

14. Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used when there are more than two columns in the array

15 / 15

15. Which option is used to quickly convert a range of cells to a table with its own style converted in MS Excel?

Your score is

The average score is 56%