NEW
Font size
S
M
L
XL
Worksheets2. Formulas & Function in Excel 2021
Total questions: 10
Worksheet time: 5mins
Name
Class
Date
1.
The _______ function calculates the total of a given set of values.
a)
SUM
b)
AVERAGE
c)
COUNT
d)
MAX
2.
The ______ function checks a condition to evaluate True or False.
a)
IF
b)
CHECK
c)
EVALUATE
d)
ASSERT
3.
________ means arranging data in ascending or descending order.
a)
Sorting
b)
Searching
c)
Filtering
d)
Grouping
4.
_____ means to see important data and hide the rest in excel.
a)
Filtering
b)
Sorting
c)
Pivoting
d)
Merging
5.
A formula in excel begins with an ________
a)
=
b)
A
c)
1
d)
X
6.
_________ are used for graphical representation of data.
a)
Tables
b)
Charts
c)
Paragraphs
d)
Equations
7.
A group of selected cells is called a __________.
a)
Array
b)
Range
c)
Matrix
d)
Cluster
8.
A ______ is a predefined formula in Excel.
a)
Function
b)
Cell
c)
Worksheet
d)
Workbook
9.
Which of the following error occurs when the formula is not recognised by excel?
a)
Value Error
b)
Name Error
c)
Div/0 Error
d)
Num Error
10.
_______ function returns the largest value in a range.
a)
MIN
b)
AVG
c)
SUM
d)
MAX
Reset
