Multiple Choice
Which of the following is NOT one of the most commonly used chart type?
a. Bar Chart
b. X Y Chart
c. Pie Chart
d. Line Chart
b. X Y Chart
The periodic interest rate, such as a monthly interest rate
Rate PMT function
A visual depiction of numerical data
Chart
A complete set of data for an entity
Record
T/F Freezing rows and/or columns keeps all worksheets on the screen.
False; Keeps them visible as you scroll through a worksheet
Press _____ to enter data into a cell and keep that cell as the active cell.
a. Ctrl + Enter
b. Shift + F4
c. F2
d. Ctrl + F2
a. Ctrl + Enter
Evaluates true or false
Logic test function
Compares values across categories using horizontal bars
Bar Chart
An individual piece of data such as an address
Field
T/F: Each column in a table is a complete set of data for an entity.
False; represents a field that can contain an individual piece of data for a record.
Which of the following is NOT an option on the Page Layout tab?
a. Print titles
b. Print preview
c. Set the print area
d. Manage page breaks
b. Print preview
Displays the current date
the TODAY function
Shows each data point in proportion to the whole data series as a slice in a circular pie
Pie Chart
Is the process of displaying only records that meet special conditions
filtering
T/F: To display a long text label on two or more lines, within a single cell you use F2 to insert a line break after the first line.
False; insert a line break with Alt-Enter
Which of the following shows where automatic page breaks will occur in a worksheet?
a. By dotted red lines
b. By blue dashed lines
c. By solid blue lines
d. By solid black lines
b. By Blue dashed lines
Enables data to appear on two or more lines within a cell
Wrap Text
Places stacks data in segments on top of each other in one column, with each category in the data series represented by a different color.
Stacked Column Chart
A region of a worksheet with formulas dependent on values from an input area
Output area
T/F: In Excel 2016, a dataset is a collection of structured, related data in columns and rows.
True
For a straightforward, basic mathematical expression, it is best to use:
a. a nested formula inside of a function
b. the arithmetic mean or average of values
c. a formula like =C16*C17
d. a function such as = SUM(B4:C4)
c. a formula like =C16*C17
How are manual page breaks indicated in a worksheet?
By Solid Blue Lines
A(n) _____ is a key that identifies the color, gradient, picture, texture, or pattern of each data series in a chart.
Legend
Is a vertical line that borders the plot area to provide a frame of reference for measurements
Y-Axis
T/F: In order of precedence in Excel 2016 is a software application used to create and modify business communications.
False; controls the sequence in which Excel performs arithmetic operations