Page 22 - Code Craft Computer-7

C. True and False assessment.
1. The Count Numbers function counts the cells in a range having numeric data.

2. The AutoSum option is present in the Editing group on the Home tab.
3. Microsoft Excel formulas can start with the '+' sign.
4. There are five types of cell references.

D. Give appropriate responses to the questions.
1. What do you mean by function? Name some of the commonly used functions.

2. What is the use of AutoSum feature?
3. What is the cell reference? Mention its types.
4. Differentiate between relative, absolute and mixed references.
5. What is formula?

Analyt ical Skills

Consider the worksheet given alongside.

What will be the output of the following formulas?
a. =SUM(C3:C8) ___________________
b. =AVERAGE(B3:B5) ___________________

c. = MAX (D3:D8) ___________________
d. = PRODUCT (B3:B4) ___________________
e. = MIN (B3:B8) ___________________

f. = COUNT (C3:C8) ___________________

Practical Session #Experiential Learning
A. Read the worksheet given alongside. Then, calculate the Sales tax and Total.

22