WorksheetsExcel Quiz 2
Total questions: 13
Worksheet time: 12mins
Name
Class
Date
1.
What is a cell?
a)
a period during which a retailer sells goods at reduced prices
b)
the smallest structural and functional unit of an organism
c)
a small room in which a prisoner is locked up
d)
an intersection of a row and column
2.
Each cell has its own name or _______________based on its column and row.
a)
formula address
b)
email address
c)
mailing address
d)
cell address
3.
What happens when you delete the entire cell?
a)
The cells below it will shift to fill in the gaps and replace the deleted cells.
b)
The cells above it will shift to fill in the gaps and replace the deleted cells.
c)
The cells left of it will shift to fill in the gaps and replace the deleted cells.
d)
The cells right of it will shift to fill in the gaps and replace the deleted cells.
4.
What does the AutoFit feature allow you to do?
a)
set the column's width to the default of 12 pts
b)
set a column's width to fit its content automatically
c)
set all of the columns' widths to the same amount
d)
set all of the columns' widths to the default of 12 pts
5.
If I want to insert a row between rows 6 and 7, which row do I select before using the Insert command?
a)
6 and 7
b)
7
c)
6
d)
neither
6.
If I want to insert a column between columns A and B, which column do I select before using the Insert command?
a)
B
b)
A
c)
A and B
d)
neither
7.
What do number formats do?
a)
They tell Excel what type of font to use.
b)
They tell Excel exactly what type of data you are using.
c)
They tell Excel what language to use.
d)
They tell Excel what color font to use.
8.
What is the default number format for all data if Excel isn't able to guess which type you want to use?
a)
Decimal
b)
General
c)
Percentage
d)
Data
9.
If you choose Currency format, what does Excel do to the numbers in the cells? Check all that apply.
a)
displays 2 decimal places
b)
Adds a %
c)
displays 1 decimal place
d)
Adds a $
10.
Where can you see the actual value of a cell?
a)
name box
b)
format menu
c)
in the cell
d)
formula bar
11.
Where is the New sheet button located?
a)
top right corner of the Excel window
b)
bottom right corner of the Excel window
c)
bottom left corner of the Excel window
d)
top left corner of the Excel window
12.
Once you create a new worksheet, you can not rename it.
a)
True
b)
False
13.
Why would you want to change the tab colors in a worksheet?
a)
Why would you want to change the tab colors in a worksheet?
b)
to stay more organized
c)
because it looks cool
d)
to create a rainbow on my screen
100 %
