Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
35 Cards in this Set
- Front
- Back
Argument |
The value the function uses to perform a calculation, including a number, text, or acell reference that acts as an operand. (EX 100) |
|
Financial functions
|
Functions used to analyze loans and investments. (EX 107)
|
|
Function
|
Shorthand way to write an equation that performs a calculation. (EX 100)
|
|
Logical functions
|
Functions that display text or values if certain conditions exist. (EX 110)
|
|
Mathematical functions
|
Functions, such as the square root and rounding functions that manipulate quantitative data in a worksheet. (EX 103)
|
|
Text functions
|
Functions that are used to format and work with cell contents. (EX 113)
|
|
Ascending sort
|
Data with letters arranged in alphabetical order (A to Z), data with numbers arranged from lowest to highest, and data with dates arranged from earliest to latest. (EX 122)
|
|
Comment
|
A note attached to a cell that is usually used to explain or identify information contained in the cell. (EX 147)
|
|
Conditional formatting
|
Highlights worksheet data by changing the look of cells that meet aspecified condition. (EX 127)
|
|
Descending sort
|
Arranges data with letters from Z to A, data with numbers from highest to lowest, and data with dates from oldest to newest. (EX 122)
|
|
Filter
|
Displays a subset of the data that meets certain criteria and temporarily hides the rows that do not meet the specified criteria. (EX 124)
|
|
Hyperlink
|
A cell in a worksheet that opens another file or page when you click it. (EX 142)
|
|
Picture
|
A digital photograph or other image file. (EX 134)
|
|
Screenshot
|
A picture of all or part of something you see on your monitor, such as a Word document, an Excel workbook, a photograph, or a Web page. (EX 137)
|
|
Shape
|
Shapes, such as rectangles, circles, arrows, lines, flowchart symbols, and callouts, can help make a worksheet more informative. (EX 130)
|
|
Sort
|
Rearranging the data in a more meaningful order.(EX 122)
|
|
Template
|
A predesigned workbook file that you can use as the basis or model for a new workbook. (EX 139)
|
|
Destination
|
The location where the data will appear after it is transferred. (EX 161)
|
|
Source
|
The location the data is being transferred from. (EX 161)
|
|
Worksheet range
|
A group of adjacent worksheets. (EX 162)
|
|
Chart
|
A graphical representation of data. (EX 174)
|
|
Chart area
|
The entire chart and all other chart elements. (EX 185)
|
|
Chart layout
|
Specifies which elements are included in a chart and where they are placed. (EX 184)
|
|
Chart sheet
|
A separate sheet in the workbook that stores a chart. (EX 179)
|
|
Chart style
|
Formats the chart based on the colors, fonts, and effects associated with the workbook’s theme. (EX 184)
|
|
Column chart
|
Chart that uses bars of varying heights to illustrate values in a worksheet. (EX 175)
|
|
Data marker
|
A symbol that represents a single data point or value from the corresponding worksheet cell. (EX 186)
|
|
Data series
|
A group of related information in a column or row of a worksheet that is plotted on the chart. (EX 177)
|
|
Data table
|
A grid that displays the data plotted in the chart. (EX 185)
|
|
Embedded chart
|
After you select a chart type and style, the chart is inserted as an embedded chart in the center of the worksheet. (EX 178)
|
|
Legend
|
A list that identifies patterns, symbols, or colors used in a chart. (EX 182)
|
|
Line chart
|
Chart that is similar to a column chart, but where columns are replaced by points connected by a line. (EX 175)
|
|
Pie chart
|
Chart that shows the relationship of a part to a whole. (EX 176)
|
|
Plot area
|
The graphical representation of all of the data series. (EX 185)
|
|
Sparkline
|
Mini charts that you can insert into a cell. (EX 192) |