Page 63 - 2611_SmartGPT Pro V(5.0) C-5

3. Write 'T' for true and 'F' for false.
a. The X-axis is the horizontal axis of the chart, which is also called the category axis.

b. In an Excel worksheet, text is aligned on the right side of a cell.

c. Excel calculates expressions within parentheses (... , ...) first.

d. The @ sign is used to form an absolute cell reference.

e. =MINUTE(NOW()) will return minutes from a current time.

4. Think and answer.
a. What are gridlines in a chart?

b. What do you mean by operators in Excel?

c. What will be the final result of the following formula:

=((10+6)/SQRT(8))
________________________________________________________________________________

d. Explain any two rules for using functions in Excel.
________________________________________________________________________________

________________________________________________________________________________
e. 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")
________________________________________________________________________________

________________________________________________________________________________

21 st
5. Competency-based/Application-based questions. Century #Critical Thinking
a. Avi has created the following worksheet: Skills

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?

Charts, Formulas & Functions in Excel 61