WorksheetsMS Excel Functions
Total questions: 45
Worksheet time: 23mins
The function that lets you add up a range of cells or values
SUM
AVERAGE
MIN
MAX
CS or Class Standing is the ___________ of Q1%, Q2% and EXER
sum
min
max
average
What function was used to find the lowest grade?
average
sum
min
max
What function was used to find the highest grade?
average
min
sum
max
The Count column found on the Grade Count table, can be computed by this function.
counta
countif
count
countblank
Counts the number of cells that contain numbers
Sum
Counta
Count
Argument
Count the number of cells based on one criteria
Sumif
Productif
Averageif
Countif
Symbol used to multiply
$
&
.
*
to count any fields containing numbers we use:
countIF function
counta function
count function
countIFs function
to find out how many persons are there in a certain field, the following function is applied
average(--:--)
count(--:--)
counta(--;--)
counta(--:--)
the structure of countif is:
contif(criteria,range of cells)
countif(range of cells, criteria, range of cells)
countif(range of cells, criteria)
What function was used to find the lowest grade?
average
sum
min
max
In the picture, why is D2 through D5 placed in paranthesis?
So Excel knows to total the cells before performing the next operation.
So the total of the cells can be multiplied rather than added.
So the calculation will be done last.
The discount formula can be explained by saying the _______ minus 10% of the ___________ or multiplying the ________ times 90%.
total
Sum
percentage
The function that lets you add up a range of cells or values
AVERAGE
SUM
MIN
MAX
What function was used to find the lowest grade?
average
sum
min
max
All formulas used within the table are seen on the __________
cells
cell reference
name box
formula bar
If the following was entered into a cell, what would appear in that cell? sum(A1:B3)
the sum of A1 through B3
sum(A1:B3)
nothing
The numbers in Excel represent the...
Rows
Columns
Cells
Data
The letters in Excel represent the...
Rows
Columns
Cells
Data
Numbers down the left side of the spreadsheet.
Status Bar
Formula Bar
Column Labels
Row Labels
Letters of the alphabet going across the top of the spreadsheet.
Title Bar
Column Labels
Row Labels
Status Bar
The intersection of a column and a row is called a __________.
Four-way Stop
Formula Bar
Cell
Template
What icon do you choose to align the text at the top, middle, or bottom of a cell?
What is this icon?
Zoom
Sort and Filter
Symbol
Merge and Center
The cell address of the highlighted cell is
C
4
A4
C4
Which formula gets the smallest value of a range of cells?
MAX
MIN
SMALL
SUM
Which of these symbols is used to do a division on a computer?
\
*
/
|
Which of the following formulas is not entered correctly?
=10+50
=B7+B8
=B7+14
=10+50;
Which operator is used to multiply in Excel?
+
x
/
*
Which of the following option is a formula?
A. =SUM(A1:A5)
B. Add A1 - A5
C. Subtract the numbers
D. A1 = A5
All formulas in Excel begin with the following symbol
A. +
B. =
C. %
D. #
Which function can find the highest value in a cell range?
a. MAXVALUE
b. HIGHEST
c. TOP
d. MAX
Which of the following is not a function of MS - Excel?
a. AVERAGE
b. ADD
C.MIN
d. MAX
