Font size
WorksheetsMS Excel: Working with Formulas and Functions [G4]
Total questions: 10
Worksheet time: 50mins
TRUE or FALSE
A formula is an expression Excel which calculates the value of a cell.
It always begins with a plus ( + ) sign.
(a)
Excel calculates based on the _____ hierarchy of operations.
PEMDAS
ADSMEP
PEDMAS
MADPES
TRUE or FALSE
A relative cell reference changes when a formula is copied to another cell.
(a)
The two types of cell references are ______ and _____ .
(Click 2 options)
Absolute
Relative
Complete
Optional
Which icon means the AutoSum command?
Functions are a set of formatting choices such as colors, fonts, and effects that you can apply on your worksheet data or other items.
Which icon will you click to see and use different formulas?
You can enter function through the following methods, EXCEPT _____.
Using the Insert Function feature
Using the AutoComplete feature
Using the formula bar
Using the AutoRecover feature
In writing a formula, one should start with a/an _____ sign , followed by the function, and then the cell range which are contained in parentheses.
dollar ( $ )
equal ( = )
plus ( + )
minus ( - )
TRUE or FALSE
Computations in Excel are done using formulas, which are composed of functions.
(a)
TRUE or FALSE
The AVERAGE function calculates the average of a group of numbers. It calculates the sum of the cells and then divides that value by the number of cells in the argument.
(a)
