Electronic Spreadsheet

note!Answer: C) Horizontal
In a column chart, the horizontal (category) axis shows the categories, while the vertical axis shows values.

note!Answer: B) mmm-dd-yyyy
'mmm' shows the three-letter month name, 'dd' the day, and 'yyyy' the four-digit year, giving 'Mar-17-2008'.

note!Answer: D) C2:F12
In Excel, a range is written with a colon between the first and last cell, such as C2:F12.

note!Answer: D) gradient fill
A gradient fill blends two or more colors smoothly across the shape.

note!Answer: B) 15
Excel stores and displays up to 15 significant digits of precision.

note!Answer: D) legend
The legend is the box that identifies the colors or symbols used for each data series in a chart.

note!Answer: D) all of the above
Table tools in Excel support sorting, filtering, and external data transfer, so all listed options apply.

note!Answer: D) row expand and collapse symbols
Row expand and collapse symbols (outline symbols) let you show or hide grouped rows.

note!Answer: C) Banded Columns
Banded Columns shades alternate columns; Banded Rows shades alternate rows.

note!Answer: B) Design
The Table Tools Design tab contains the Banded Rows checkbox option.

note!Answer: B) data bar
Data bars are conditional formatting bars that show relative cell values.

note!Answer: C) Print Area
Print Area defines the range of cells that Excel prints.

note!Answer: D) a left, right, and center section
Excel headers and footers have left, center, and right sections.

note!Answer: B) Logical
Logical functions such as IF, AND, and OR return TRUE or FALSE.

note!Answer: D) AVERAGE
AVERAGE is a statistical function; INT and ROUND are math functions and RAND is a math/random function.

note!Answer: A) The formula returns the text "RESTART".
Since A1 is not "YES", IF returns the value_if_false argument, which is "RESTART".

note!Answer: B) And
AND is a logical function; Year, Now, and Today are date/time functions.

note!Answer: B) financial
PMT calculates loan payments and belongs to the Financial category.

note!Answer: B) AutoSum
The AutoSum button automatically inserts the SUM function.

note!Answer: B) $
Dollar signs ($) before column and row letters mark absolute references, such as $A$1.