Font size
WorksheetsWeek 6 Review
Total questions: 25
Worksheet time: 13mins
What tab is the font group located on?
format
home
file
layout
To adjust column width, move the cursor between the ___________ until the cursor becomes a two-way arrow then press the left mouse button and drag left or right to resize the column.
numbers
column
letters
lines
An excellent tool to use for putting first and last names from a column into two separate columns is
fill handle
flash fill
back office
font format
The cell alignment group is found on the ________ tab
layout
format
home
design
What does SUM do in Excel?
Adds together all the cells in a given range
Summarises all the cells in a given range
Finds something in all the cells in a given range
Holds all the cells ransom in a given range
What does the following tool do?
Adds borders to a cell
Selects 4 cells
Highlights cells
Drops cells to a lower level
What does this tool do?
Changes the font colour
Adds red lines under letters
Changes the highlight colour
Makes font smaller
Changes the direction of the text in a cell
Makes the text point north east
Adds a blue arrow to a cell
Adds a blue arrow and text to a cell
What function can I use to shorten the length of this formula? (read the options carefully)
=A1+B1+C1+A2+B2+C2
=SUM(A1:C2)
=SUM(A1 - C2)
SUM(A1:C2)
=ADD(A1:C2)
A method to rearrange data by switching the positions of columns & rows
Cut
Paste
Clipboard
Transpose
A cell address that can change in a copied formula, so the new address is expressed in relation to the cell containing the copied formula.
Series
Relative reference
Contiguous range
Date
A cell address in a formula that will not change when you copy the formula to another location. I$I
Arithmetic operators
Keyboard shortcuts
Absolute reference
Drag-and-drop
An instruction excel uses to calculate a result
Scale
Formula
Order of precedence
Default column width
A feature that causes long cell entries to appear on multiple lines
Wrap text
Range
SUM function
Noncontiguous range
Keyboard shortcuts for choosing ribbon commands that you display by pressing "ALT"
Date
Key Tips
Collapse Dialog button
Expand Dialog button
The feature that enables Excel to create a series automatically
Range
Series
Show Formula
Auto Fill
There are 2 types of cell reference, absolute and relative. Select the relative cell reference.
A
A7
7
$A$7
Which formula uses an absolute cell reference?
=A1+B2
=A1+$B$2
=A1*B2
=A1/B2
Which symbol makes a cell reference absolute?
@
&
#
$
Absolute cell references should be used when possible to avoid having to make multiple updates when a key value changes.
True
False
Absolute cell references do not change when replicated (filled down).
True
False
Which of these formula will calculate 10% of an amount.
= 10% / B3
= B3 / 10
= 10% * B3
= B3 * 5%
Which key on the keyboard do we press to make a cell reference absolute?
F2
F4
F6
F8
What are the correct terms for copying a formula to a range of cells. (You may select more than one answer.)
Fill across
Copy and Paste
Fill down
Replicate
The borders command is found in what group on the Home tab?
Font
Cell
Style
Editing
