In a computer spreadsheet, absolute cell reference can be represented as
a) B3
b) $B$3
c) B$3
d) $B3
Working with Formulas and functions
The …… function multiply all the numbers given as argument.
a) sum()
b) product()
c) add()
d) none of these
The correct formula of product function is/are……..
a) =product (A, B)
b) Product (A, B)
c) =PRODUCT (A*B)
d) product (A*B)
The function
that adds all the number that user specifies as argument.
a) sum()
b) add()
c) collect()
d)
none of these
The function
that returns the average of arguments is called………….
a) sum function
b) average
function
c) Product function
d)
Add function
