DATA PRESENTATIONS EXAM
QUESTIONS AND CORRECT DETAILED ANSWERS
ALREADY GRADED A+ | GUARANTEED PASS
A visual key that describes the data series used on a chart and the
colored elements that represent those series Correct Answer>Legend
A label, generally, at the top of a column of data, used to describe the
rest of the data Correct Answer>Header
An option in the number format, drop-down menu that defines any
type of number and can be configured to display the number in
standardized ways. Correct Answer>Number
Used to define a number as money; currency values will be displayed
with the monetary symbol appropriate for the currency described in
two decimal places Correct Answer>Currency
Used to define a number as money; the accounting data type has fewer
options in the currency type Correct Answer>Accounting
, When a category of data in a chart is compared to itself. Example, if a
chart contains blue and orange, vertical columns, the blue columns can
be compared to learn more about the trend of the date of represented
by the blue columns. Correct Answer >Intra-category comparison
An excel file that stores all the information, previous calculations, and
analyses that you may have already completed. Must contain atleast
one worksheet. Correct Answer>Workbook
A collection of cells arranged in the form of a table that contains the
actual data and calculations. - ✔✔✔ Correct Answer>Worksheet
Small box that stores an individual piece of data or a calculation in a
worksheet - ✔✔✔ Correct Answer>Cell
The content within a cell. Correct Answer>Value
A stack of cells arranged vertically from the top to the bottom of a
worksheet - labeled with a letter. Correct Answer>Column
Collection of cells arranged horizontally from left to right of a
worksheet- labeled with a number of Correct Answer>Row