NEW
Font size
S
M
L
XL
WorksheetsQuiz T2
Total questions: 20
Worksheet time: 10mins
Name
Class
Date
1.
What is another term for an Excel spreadsheet?
a)
Worksheet
b)
File
c)
Workbook
d)
Document
2.
The active cell is the same thing as the ____
a)
Cell box
b)
Name box
c)
Sheet 1
d)
Selected cell
3.
The cell reference and the cell name are the same things.
a)
TRUE
b)
FALSE
c)
-
d)
-
4.
Which of the following is a type of data that can NOT be used in calculations?
a)
Numbers
b)
Values
c)
Labels
d)
None of the above can be used
5.
Labels are right aligned in the cell.
a)
TRUE
b)
FALSE
6.
When the cell is not wide enough to hold a number, which symbols appear in the cell?
a)
#######
b)
????????
c)
/\/\/\/\/\/\/\
d)
Error
7.
What is the formula to find the lowest number in cells C1:C4?
a)
#DIV/0!
b)
MIN
c)
MAX
d)
Average
8.
What would I use to combine cells A1:A9?
a)
Adjust column width
b)
wrap text
c)
Change font size
d)
merge
9.
How do you select an entire column?
a)
Hold down the shift key as you click anywhere in the column.
b)
Hold down the Ctrl key as you click anywhere in the column
c)
Click the column heading letter
d)
Select Edit > Select > Column from the menu
10.
Which formula gets the biggest value of a range of cells?
a)
MAX
b)
MIN
c)
LARGE
d)
SUM
11.
Which number formatting style adds the dollar signs and commas to values?
a)
Adjust Decimal
b)
Percent
c)
Comma
d)
Currency
12.
You can only work in one cell at a time. The actual cell that you are working in is called what?
a)
Column
b)
Name Box
c)
Active Cell
d)
Row
13.
The feature to center text across several cells is called:
a)
Wrap Text
b)
Merge and Center
c)
Shrink to Fit
d)
Number Formatting
14.
This icon + is called the what?
a)
Fill handle
b)
Arrow
c)
Pointer
15.
For which of the following tasks would you use the fill handle?
a)
to apply shading
b)
to apply a border
c)
to copy a formula from cell A2 to cell A3
16.
Instead of typing in cell references, you can use the mouse click for Excel to enter the cell names into formulas for you.
a)
TRUE
b)
FALSE
17.
You can only select cells that are adjacent to each other.
a)
TRUE
b)
FALSE
18.
What allow quickly apply the content for one cell to another cell?
a)
Active cell
b)
Autocell
c)
Auto sum
d)
Auto Fill
19.
Part # 523456 is entered on a spreadsheet, is this a label or a value?
a)
value
b)
label
20.
Values are right aligned in the cells.
a)
True
b)
False
Reset
![5th Obj [MT June '21]](https://cf.quizizz.com/image/image-loader.svg)
