click below
click below
Normal Size Small Size show me how
Excel C and D
Excel Unit C and D Test Review
| Question | Answer |
|---|---|
| The ____ of a cell determines how the labels and values look | format |
| The default Accounting number format adds dollar signs and ____ decimal places to the data | two |
| A chart that is inserted directly in the current worksheet is called a(n) ____ chart | embedded |
| ____ marks indicate the scale of measure for each value on the y-axis. | Tick |
| A collection of related data points is called a ____. | data series |
| Which chart type would be the best candidate to spot trends and extrapolate information based on research data? | scatter |
| A(n) ____ chart compares distinct object levels using vertical bars; is the Excel default | column |
| Each value in a cell selected for a chart is called a ____. | data point |
| You can change the ____ of labels and values in cells to be left, right, or center. | alignment |
| Major ____ represent the values at the value axis tick marks. | gridlines |
| ###### in a cell means that the ____________. | column is too narrow to display the value completely |
| To show how individual volume changes over time in relation to total volume, use a(n) ____. | area chart |
| A pie chart ____. | compares sizes of pieces as part of a whole |
| Which two charts compare trends over time intervals? | line and scatter |
| Which chart type would you use to compare distinct objects over time using horizontal bars? | bar |
| Which chart type would be the best candidate to emphasize sales trends over a period of 6 months? | line |
| A scatter chart ____. | compares trends over uneven time or measurement intervals |
| A combination chart adds a(n) ____ axis to chart related data | secondary |
| Presents information in a pictorial format | chart |
| Equal to 1/72 of an inch | point |
| Has a default value of 8.43 characters, a little less than one inch. | column width |
| Often contains numerical values that help you interpret the size of chart elements | value axis |
| A predefined set of attributes that gives your Excel worksheet a professional look | theme |
| Visually represents each data point. | data marker |
| An independent element on a worksheet. | object |
| A type of conditional formatting that visually illustrates differences among values | data bar |