Excel Exam Study Guide
A pie chart can be rotated up to
360 degrees.
Cell style
A defined set of formatting characteristics such as font, font size, and font color.
Use the Home tab to
AutoFit column widths.
The keyboard shortcut to display Print Preview is
Ctrl + F2.
3
D is short - for three-dimensional.
You can create a custom footer in
Excel.
Using a Function button on the status bar is
NOT a way to create a formula.
Alt + =
SUM function
In Goal Seek, you enter the specific value that you want to achieve in the
To value box.
Data series
a group of related data points.
Value
a number, date, or time of day.
Excel table
a series of rows and columns that contains related data that can be managed independently from other.
Data bar
a shaded bar that provides a visual cue about the value of a cell relative to other cells.
Fund
a sum of money set aside for a specific purpose.
Label
a text value.
Data point
a value that originates in a worksheet cell and is used in a chart.
Chart sheet
a worksheet that contains only a chart.
AVERAGE function
adds a range of cells and divides by the number of values in the range.
SUM function
adds a range of cells.
Worksheet
also known as a spreadsheet.
Formula
an equation that performs mathematical calculations.
A logical test is
any value or expression that you can evaluate as true or false.
Logical test
any value or expression with a true or false result.
Sort
arranges data in a specific order.
If two cells are merged into one, the cell contents are
automatically centered in the new, merged cell.
In a line chart, the x
axis resides - along the bottom of the chart.
Axis
border a chart plot area.
The <, >, and <>
can be described as comparison operators.
Use the Page Layout tab to
change a worksheet to landscape orientation.
Relative cell reference
changes when a formula is copied and pasted.
A chart and all of its elements is known as the
chart area.
IF function
checks whether a condition is met and returns a true or false value.
Comparison operator
compares values in an Excel function or formula.
The COUNT function
counts the number of cells in a range that contain a number.
COUNT function
counts the number of cells in a range that contain numbers.
COUNTIF function
counts the number of cells in a range that meet the given Condition.
Use the Insert tab to
create a recommended chart.
Ctrl + X
cut
You can use the Switch/Row Column command to swap data over the axis
data being charted on the vertical axis will move to horizontal axis and vice versa.
Use the Formulas tab to
display formulas on the screen.
Filter
displays only a portion of data that matches a criteria
The status bar
displays the current cell mode, the page number, and the zoom buttons.
Spreadsheet
displays upon startup of Excel.
Workbook
displays upon startup of Excel.
Absolute cell reference
does not change when a formula is copied and pasted.
Move Chart button
does not display to the right side of a selected chart.
You can edit the data or a label in a cell by
doubleclicking the cell and then positioning the insertion point within the cell.
The Freeze Panes command
enables you to select one or more rows or columns and then (lock) them into place.
Chart area
entire chart and all of its elements.
Banded rows display when
even rows are formatted differently from odd rows.
Use the File tab to
export a document as a PDF file.
Conditional format
formatting applied to a cell based on criteria.
On your keyboard, the hyphen key and the forward slash key
function identically in date formats.
Row
group of horizontal cells on a worksheet.
Column
group of vertical cells on a worksheet.
Legend
identifies the data markers in a chart.
The # symbol in Excel is used to
indicate that a cell is not wide enough to display a formula or function result.
Alt + = is a way to
insert the SUM function into a cell.
Cell
intersection of a row and column.
A data series
is a group of related data points represented by data markers.
Freeze
keeps rows or columns fixed.
Consecutive operators with the same level of precedence are calculated from
left to right.
When you type text in a cell it is
left-aligned.
MEDIAN function
locates the middle value in a range of cells.
The sheet tabs display on the
lower area of the workbook window.
Enterprise fund
money for municipal services for which a fee is charged.
General fund
money set aside for the normal operating activities of a city.
In Excel 2016, row headings are identified by
numbers.
The Format Painter button is located
on the mini toolbar and the Home tab.
Ctrl + V
paste
Ctrl + F2
print preview
The Flash Fill function in Excel
recognizes a pattern in the data of a worksheet.
When you copy a formula to another cell and the cells in the formula change, the cells are known as
relative cell references.
F4
repeat
Excel's NOW function
retrieves the date from the computer's clock.
Hold down the Ctrl key to
select nonadjacent cells.
Split
separates a window into panes.
Pie chart
shows the relationship of parts to a whole.
When using a touchscreen,
tapping the item is the same as clicking an item.
The $ symbol represents
that a cell is an absolute cell reference in a function or formula.
A filter icon indicates
that a filter is applied to the data in the table.
A green plus sign identifies
the Chart Elements button when you select a chart.
To size a chart proportionately, hold down
the Shift key and drag a corner sizing handle.
An outlined cell in a worksheet is
the active cell.
General format, Calibri, 11 pt is
the default number format in Excel 2016.
In Goal Seek, the Set cell box contains
the formula that calculates the information you seek.
A pie chart shows
the relationship of each part to a whole.
When a new column is inserted into a worksheet
the remaining columns move to the right.
Data marker
the representation in a chart of a value from a worksheet.
To indicate a range, include a colon between
the two cell references.
You must select two ranges on a worksheet
to create a pie chart.
Volatile
updates automatically.
You can leave the year off entirely
when typing a date into a cell.
If a sheet tab has a background color
you know that it is not selected.
The Percent Style button formats selected cells as a percentage with
zero decimal places.
