Page 37 - ThinkGPT_V2.1_C6_Flipbook
P. 37
Information Literacy
byte Quest Critical Thinking
Write the output of the following:
1. =MIN(5,7,8)
2. =LEFT("Computer", 4)
3. =AVERAGE(12,3,6)
4. =LEN("Touch")
5. =COUNT(4,8,12)
REFRESH
Excel allows users to create custom formulas to perform calculations on their data.
A cell reference is a cell address that can be used in a formula to denote a specific cell.
The equal to sign (=) tells Excel that the succeeding characters constitute a formula.
A group of selected cells is called a range.
Excel also contains built-in formulas called functions that make it easy to perform common calculations
on data.
TeCh Ready
A. Tick ( ) the correct option.
1. Which of the following cell references can be included in the relative reference?
(i) A3 (ii) A$1
(iii) $A$4 (iv) $D6
2. Which of the following function is used to calculate the average of a range of values?
(i) AVERAGE (ii) AVG
(iii) SUM (iv) MAX
3. What is a group of selected cells called?
(i) Selection (ii) Cell range
(iii) Combination (iv) Value
4. What does the NOW() function display?
(i) Date (ii) Time
(iii) Both (i) and (ii) (iv) None of these
Formulas and Functions in Excel 35

