Show:
Vocabulary
Window Labeling
Shortcuts
Functions
Pointers
100
A name for a collection of characters.
What is font?
100
A range of cells.
C10:F10 is an example of what?
100
[F2]
In an Excel worksheet, which keyboard shortcut lets you edit a cell?
100
MIN
What functions gives you them smallest number in the range?
100
Lets you edit and select a cell.
What does the normal pointer do?
200
Automatically resizes the column to accommodate the widest entry.
What does Autofit do?
200
Merge and Center
What button on an Excel window lets you combine a range of cells and center align them?
200
To the last cell you have worked in.
Where does [End] take you in a worksheet?
200
MAX.
What is the function that finds the largest number in a range of cells?
200
Column Resize.
What pointer lets you resize the column?
300
It adds dollar signs and two decimal places to the data.
What is the Accounting Number Format?
300
AutoSum
What button lets you sum up a range of cell?
300
[Home]
What keyboard shortcut take you to cell A1?
300
It determines the number of cells in a range.
What is COUNT?
300
Select a range of cells.
What does the fill handle let you do?
400
Cell styles.
What are predesigned combinations of formats?
400
Fill Collor
What button in the font group of the home tab lets you fill in a cell?
400
Lets you cycle through different types of cell references.
What is does [F4] let you do?
400
ROUND.
What function rounds a value to a specific decimal place?
400
Move Pointer.
What pointer lets you select and move a cell?
500
Automatically applies different data formats to data.
What happens when data is Conditionally formatted?
500
D7, C6, A1, etc.
What is an example of a cell address?
500
[CTRL]
What key do you press to copy while dragging and dropping cells?
500
Adds the values in a range of cells then divides by the number of cells.
What is AVERAGE?
500
Copy Pointer.
What pointer lets you create a duplicate of selected cells?