Font size
S
M
L
XL
WorksheetsExcel - Formulas and Functions
Total questions: 10
Worksheet time: 10mins
Name
Class
Date
1.
(a) are pre-designed formulas in Excel used to perform calculations.
2.
The (a) function rounds a number to the nearest integer.
3.
The (a) function is used to display the current date.
4.
The (a) function finds the largest number in the given range.
5.
A (a) formula has only one type of operator.
6.
Three types of cell references
a)
Relative
b)
Absolute
c)
Mixed
d)
All of the above
7.
The (a) reference occurs when a formula in a cell refers to its own cell value directly or indirectly.
8.
The (a) function is used to join two or more than two strings together.
9.
(a) fubnction returns square root of a number.
10.
(a) function calculates the greatest common divisor or highest common factor of two or more integers.
Reset
