NEW
Font size
WorksheetsExcel Chapter 1
Total questions: 30
Worksheet time: 15mins
What is each square in Excel called?
Square
field
cell
box
What button should you press after entering a formula?
tab
enter
arrow keys
click a blank cell
Rows run in which direction?
Horizontal
Vertical
Diagonal
None
What direction do columns run?
Horizontal
Vertical
Diagonal
None
Which button allows you to copy formats to multiple cells?
Enter
Autofit
Font style
Format Painter
How do you know a range of cells is selected in a formula?
it is highlighted by a solid line
it has a dotted line around the cells
it changes to bold
it turns red
What is an example of a range address?
A1:B3
A1;B3
A1-B3
A1*B3
In a cell address, which comes first?
the row number
the column letter
the row letter
the column number
If a cell has a dotted green line blinking around it, how can you cancel it?
backspace
tab
delete
escape (Esc)
What is the FASTEST way to add a column of cells together?
click subtotal button
type the sum formula by hand
click the autosum button
neither of these are ways to add cells
What does ##### mean in a cell?
You entered a wrong number
You misspelledsomething
The cell is not wide enough to fit the information
The formula is wrong
An active cell is indicated by a green
dark wide border
dotted border
blinking border
none
How many different ways did we talk about adding a column of cells together in Excel?
1
2
3
4
You can use Excel like a calculator?
True
False
You can delete data from a cell by
clicking on the cell and pressing delete key
you can't delete data
by double clicking on the cell and pressing backspace
both using delete and backspace key as indicated
How do you correct data in a cell?
delete all the data then retype it
use the formula bar at the top of excel
What do you use to easily finish a series of numbers/month/day down a column?
cross hair
duplicate cell
copy
fill handle
When you insert a row, does it go above or below the selected row?
above
below
When you insert a column, does it go to the left or right of the selected column?
left
right
Which button at the bottom of the screen allows you to add a header?
1st
2nd
3rd
Columns are categorized by which of the following?
Letters
Numbers
Rows are categorized by which of the following?
Letters
Numbers
What is the shortcut for copy?
CTRL + X
CTRL + C
CTRL + Z
CTRL + V
What is the shortcut for paste?
CTRL + X
CTRL + C
CTRL + Z
CTRL + V
What is the shortcut for cut?
CTRL + X
CTRL + C
CTRL + Z
CTRL + V
What is the shortcut for undo?
CTRL + X
CTRL + C
CTRL + Z
CTRL + V
Which key allows you to select non-adjacent (not next to each other) cells?
Enter
Delete
Shift
CTRL
To clear a cell's content, what does the icon on the toolbar look like?
a red x for delete
an eraser
scissors
a paintbrush
What group on the toolbar allows you to change a cell format to currency?
number
alignment
styles
font
What is the best way to select several cells at once on a spreadsheet?
shift key
click and drag
CTRL key
None of the above
