Reading...
Play button
Play button
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;
27 Cards in this Set
- Front
- Back
|
Workbook
|
like a notebook that is created when excel is started
|
|
|
Worksheet
|
found inside the notebook. It is organized into a rectangular grid.`
|
|
|
Cell
|
The basic unit of a worksheet into which you enter data
|
|
|
Cell Reference
|
A cells unique address which is the coordinates if the intersection of the column and row
|
|
|
Active Cell
|
The cell into which you can enter data
|
|
|
Name Box
|
Contains the cell reference for the active cell
|
|
|
Home Tab
|
called the primary, contains groups with more frequently used commands
|
|
|
Gallery
|
A set of choices, often geographical, arranged in a grid or list
|
|
|
Charts
|
Pictorial representation of data, These are often referred to as graphics
|
|
|
Task Pane
|
A window that contains additional commands and can stay open
|
|
|
Formula Bar
|
located below the ribbon. Data displays inside this bar as it is being typed
|
|
|
Mini Toolbar
|
Appears automatically based on tasks you perform
|
|
|
Quick ACcess Toolbar
|
Provides easy access to frequently used commands
|
|
|
Office Button
|
Central location for managing and sharing workbooks
|
|
|
Menu
|
Contains a list of commands
|
|
|
Left Aligned
|
Means that the cell entry is positioned at the far left in the cell
|
|
|
Sum Function
|
Provides a convenient way of adding up columns or rows of cells
|
|
|
Merging Cells
|
Involves creating a single cell by combining two or more selected cells
|
|
|
Embedded Chart
|
A chart that is drawn on the same worksheet as the data
|
|
|
Arguments
|
Values used with a function
|
|
|
Average function
|
sums the numbers in the specified range and then divides the sum by the number of non-zero cells in the range
|
|
|
Max Function
|
Displays the highest value in a range of values
|
|
|
Fixed Dollar sign
|
Appears to the far left of the number. There may be spaces between it and the number
|
|
|
Floating dollar sign
|
APpears to the immediate left of the number with no spaces between it and the number
|
|
|
Page Layout view
|
Allows you to create or modify a worksheet while viewing how it will look in printed format
|
|
|
Formulas Version
|
show the actual formulas that you have entered
|
|
|
Debugging
|
The process of finding errors in a worksheet
|
