Page 86 - 2622_Delhi Police Public School_C-6

Q Answer the following questions:
A
1. What are gridlines in a chart?

2. What do you mean by operators in Excel?

3. What will be the final result of the following formula:
=((10+6)/SQRT(8))

4. Explain any two rules for using functions in Excel.

5. If cells A2 and A3 contain 10 and 20 values, respectively, then what will be the output of the following
function:
=IF(A2 > A3, "A2 is greater than A3", "A2 is not greater than A3")

Scratch Your Brain. 21 st Century #Critical Thinking
#Communication
Skills
1. Match the following formulas with their outputs:
Formula Output
a. =MAX(SUM(10, 20, 30),AVERAGE(10, 20, 30)) i. ORANGE6

b. =CONCATENATE(UPPER("Orange"), LEN("Orange")) ii. 25

c. =POWER(ABS(-5),ABS(-2)) iii. 60
d. =LEN("12345") + LEN("Excel") iv. 5

e. =SQRT(INT(20.45) + SQRT(25)) v. 10

2. Competency-based/Application-based questions:
a. Avi has created the following worksheet:

Product Sales Quantity Price per Unit
A 100 10

84 Premium Edition-VI