NEW
Font size
WorksheetsMS Excel - Empowerment Technologies
Total questions: 18
Worksheet time: 13mins
What do you call the intersection of a row & a column?
Cell
Cell name
Cell range
Cell reference
What do you call an expression that calculates the value of a cell?
Label
Constant
Formula
Operator
Microsoft Excel is ___________________ application.
spreadsheet
worksheet
workbook
liverspread
What is the name of the function that adds a range of cells?
SUM
ADD
TOTAL
PLUS
What is the name of the function is a function used to add a certain range of cells if a condition is met?
ADDIF
SUMIF
COUNTIF
AVERAGEIF
Which of the following is NOT a mathematical operator in MS Excel?
*
\
^
+
Excel formulas always begin with a sign.
TRUE
FALSE
In Excel, the active cell is indicated by an underline.
TRUE
FALSE
Rows' headings are numbers while columns' headings are letters.
TRUE
FALSE
Which of the following is not a practical application of MS Excel?
Creating a database
Creating a letter
Computing grades
Calculating monthly sales of business
What will be the output of the formula: =SUMIF(B3:B8, "Male", D3:D8) ?
334
474
140
ERROR
What will be the output of the formula: =COUNT(B1:B8) ?
8
6
0
ERROR
What will be the output of the formula: =AVERAGEIF(B3:B8, Male, E3:E8) ?
85
75
65
ERROR
What will be the output of the formula: =IF(C3<85, "CHICKEN", "NUGGETS") ?
CHICKEN
NUGGETS
CHICKEN NUGGETS
ERROR
What will be the output of the formula: =COUNT(C3:C8) ?
519
6
ERROR
####
Create a formula to determine the sum of the average grades of all female students in the list.
=SUMIF(B3:B8, “Female”, F3:F8)
=AVERAGEIF(B3:B8, “Female”, F3:F8)
=SUMIF(F3:F8, “Female”, B3:B8)
=AVERAGEIF(F3:F8, “Female”, B3:B8)
Create a formula to count the number of orders delivered in Lake Sebu.
=COUNT(F2:F11, "Lake Sebu")
=COUNTIF(F2:F11, "Lake Sebu")
=COUNT(A2:F11, "Lake Sebu")
=COUNT(F3, F7, F11)
Get the total sales for all items in the list.
=SUMIF(A2:A4, "Quantity", B2:B4)
=(B2*C2)+(B3*C3)+(B4*C4)
=SUM(B2*C2+B3*C3+B4*C4)
=SUM(C2:C4)+SUM(B2:B4)
