NEW
Font size
WorksheetsBasic Formulas and Functions
Total questions: 10
Worksheet time: 3mins
Sum, average, count, and maximum value are examples of what?
Formulas
Functions
Calculations
Spreadsheet Data
Which symbol is used to start a formula?
+
-
=
>
Which of the following formulas show the correct use of the SUM function?
-SUM(H3-H10)
=SUM(H3:H10)
=SUM(H3...H10)
+SUM(H3:H10)
See the following formula. Which of the following formula is the another method of the given formula?
=(B2+C2+D2+E2)/4
= SUM (B2,C2,D2,E2)
= MAX(B2:E2)
= SUM(B2,E2/4)
= AVERAGE (B2:E2)
The bar where information appears as you input data is called ______________.
file bar
help bar
window bar
formula bar
What is the Sum formula?
Sum( )
Sum( )=
=( )Sum
=Sum( )
The function that lets you add up a range of cells or values
AVERAGE
SUM
MIN
MAX
To alert Excel that you are entering a formula and not text, type a(n) _________________ proceeding the formula
@
=
'
#
Microsoft Excel is categorized as a ________________ software.
Database
Spreadsheet
Presentation
Word Processing
The ______________ function is used to determine how many pupils were able to get a passing score in a test.
COUNT
COUNTA
COUNTIF
COUNTBLANK
