Home > Microsoft Excel > Quizzes > Excel Coursera Study Guide
Excel Coursera Study Guide
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 65% Most missed: “The values that an Excel function uses to perform operations are called:”
Excel Coursera Study Guide
Time left 00:00
25 Questions

1. The individual pages of an Excel document are called:

2. A ________ is a portion of a worksheet window bound by, and separated from, other portions by vertical or horizontal bars.

3. Performing a ________ involves changing the value in a cell to see what effect it has on values in other cells that are calculated using that value

4. To make data easier to understand, use a ________ instead of a table of numbers

5. Which type of chart would be the best to chart the number of votes each candidate received compared to the total number of votes cast?

6. On a pie chart, the ________ determines the size of each pie slice.

7. A ________ identifies a worksheet in a workbook.

8. _______ shrinks the width and height of the printed worksheet to fit a maximum number of pages.

9. To center worksheet data horizontally and vertically on a page, use the ________ dialog box

10. Which Excel function would be used to find the middle value of a list of test scores?

11. The ________, when outlined in black, indicates it is ready to accept data.

12. The Formula Bar displays the data known as the:

13. A ________ is formatted as a pattern of uniformly spaced horizontal rows and vertical columns.

14. Which is the Excel operator for multiplication?

15. A group of items that come one after another in succession is called:

16. Excel's ________ function finds the largest value in a selected range of cells.

17. Use the ________ button to add, remove, or change chart elements such as the chart title, the legend, and the data labels.

18. An Excel document is called a:

19. In the ________ you can enter a value or a formula or edit a value or formula in the active cell.

20. All Excel formulas begin with which symbol?

21. Functions that test for a specific condition are called ________ functions

22. To widen a column to fit the cell content of the widest cell in the column, use:

23. Labels that display along the bottom of a chart to identify the category of the data are called:

24. What are the Conditional Formatting options? What does each of these offer(cf notes)?

25. _______ generates and extends a series of values into adjacent cells based on the values of other cells.