WorksheetsExcel L1-L3
Total questions: 20
Worksheet time: 10mins
A selection consisting of more than one cell is called a ____.
group
range
block
section
Double-clicking the auto fill block function only works ______.
horizontally but not vertically
for number patterns
vertically but not horizontally
for word patterns
A column may be filled automatically by double-clicking the auto fill block only if the column next to the selected range_______.
has cells containing data
is the same width
has a color fill
is empty
An entire row can be selected by _________.
double clicking any cell in the column
clicking the column header
clicking the row number
clicking the name box
The header and footer are only visible when you are in _____.
custom view
page layout view
page break preview
normal view
The __________ contains commands for managing files, data about files and Excel Options.
backstage view
page layout view
page break preview
normal view
The mouse pointer used to continue a pattern by filling adjacent cells is ________.
The mouse pointer used to select a range of cells is ________.
The mouse pointer used to move a cell or a range of cells is ________.
What data type is in cell ABC12?
Accounting
Fraction
Scientific Notation
Currency
Percentage
What data type is in cell BE13?
Accounting
Percentage
Scientific Notation
Currency
Fraction
What data type is in cell L3?
Accounting
Fraction
Scientific Notation
Currency
Percentage
What data type is in cell M6?
Accounting
Fraction
Percentage
Currency
Scientific Notation
What data type is in cell PAM8?
Accounting
Scientific Notation
Percentage
Currency
Fraction
In Excel, all formulas must begin with a(n) ________.
ƒx
=
+
$
An entire column can be selected by _________.
double clicking any cell in the column
clicking the column header
clicking the row number
clicking the name box
If ##### is displayed in a cell, that means ______ for the number to be displayed.
there are hash tags entered
there is not enough space
there is too much space
you need to increase the font size
Excel has a feature called ________ that allows additional cells to be filled with data based on the pattern in a selected range.
Cell View
Auto Fill
Active Cell
Cell Alignment
The ________ is indicated by the thick, green border around the selected cell.
Cell View
Auto Fill
Active Cell
Cell Alignment
When an equation such as =5+4 is entered in a cell, the cell will display ______ although the cell contains the equation.
nothing
the equation
=5+4
the solution
