Page 26 - 2617_JSSPS_C-6

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
Skills
#Communication
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
B 150 20
C 80 30
D 200 40

Now, he wants to calculate the total amount for each product. Which function of Excel will help him
to do so?
b. Mayra has written her first and last names in cells F1 and F2, respectively. To display the complete
name, she has entered the following formula in cell F3:
=CONCATENATE(F1+F2)
However, she does not get the correct output. What could be the possible reason for not getting
the correct output?

c. Simi is working on a worksheet in which she wants to display the names of the students in
uppercase. Which Excel function will help her to achieve this?

d. Romi wants to calculate the total number of values in a particular range. Which function of Excel
should he use to accomplish this?

24 Premium Edition-VI