NEW
Font size
Worksheetsexcel exam
Total questions: 20
Worksheet time: 40mins
what we call the letters
colums
rows
Ms Excel stands for
main source excel
mid source excel
mail server excel
Microsoft
which tab on excel has charts and tables
File
Insert
numbers and symbols used to express a calculation. Always begins with an = sign.
formula
work sheet
Which formula gets the smallest value of a range of cells?
Max
Min
What would be a correct formula for SUM in excel?
A. =SUM (B3:B9)
A. =Min(B3:B9)
What is the green bar at the top of Excel referred to as?
the data bar
the ribbon
the data bar
. If you see a series of "######" in a cell, that means the following:
The column width is not wide enough
error data
A selection of two or more cells is called a ________. Example A1:A4
Table
cells
range of cells
this icon stands for
autosum
functions
error
exit
this icon stand for
file
save
title
function
What is this icon
merge and center
merge
center
title
Excel can find the average of a range of numbers by using the _________ function
AVERAGE
MIN
Max
SUM
COUNT counts cells which are...
Numbers only
letters and numbers
If you selected (A1:B5) what is this called?
row
column
A range of cells
cell grouping
Which one is a correct cell address?
A1
1A
A
1
Error on excel when the formula contains invalid data is ......?
#Value
Auto sum
Operators
Auto Sum
where is the option auto sum present
formula tab
alignment tab
numbers tab
font tab
Error in your formula
#div/0!
AutoFill
#name?
Columns
Which formula should I use for multiplication (5 x 2)?
=C2*C3 Enter
5 x 2
5 x 2 =
5*2
