Complex Formula
Functions
Mixed cell reference
Adjusting column width
Sheet tabs
100
Copying cell entries: what are ways you can do that?
Copy & paste buttons, keyboard shortcuts, fill handle, drag-and-drop
100
What finds the average/ mean in the range
AVERAGE
100
What changes when copied?
Row or column
100
How do you auto fit
Double-click to right column heading
100
Other methods: whats another way for inserting?
Insert worksheet button
200
What uses more than one arithmetic operator
Complex formula
200
What finds the largest number in the range
MAX
200
What are some examples of a mixed cell reference?
$A1 or A$1
200
How do you resize?
Drag line to right of column heading to left
200
What can right clicking do?
Rename, move/copy, Tab color, insert/delete
300
What utilizes order of precedence form the left to right
Parenthesis, Reference operators, exponets, multiplication and division, lastly addition and subtraction
300
What finds the smallest number in the range
MIN
300
[F4] cyc;es through cell references are?
Relative, absolute, mixed 1, mixed 2
300
Inserting rows and columns: Inserting and entire row/ column, How do you do that?
Right click
300
Other methods: whats another way you can rename a sheet
Double click
400
How do you drag and drop
[CTRL] (dragging from any side of cell pointer)
400
What is a mathematical function that totals values in a feild
SUM
400
What is formed using a specific cell
Absolute cell reference
400
What does the format button do?
Edits column width
400
Other methods: Another way for moving?
Drag & drop
500
How do you use the copy & paste buttons
Right clicking
500
When creating functions, make sure the range only contains ____ with relevent values
Cells
500
What are some examples of absolute cell reference
$A$1 or $G$10:$G$5
500
Inserting rows and columns: What tab has shading?
Home tab
500
Other methods: Whats another way for copying?
Drag & drop w/ [CTRL]
M
e
n
u