excel

1.

How do sparklines differ from charts? Explain.

2.

a) Briefly describe the syntax and arguments of the IF function.

Give an example of how the IF function could be used in a business situation. Explain

b) Evaluate the following expressions:

=OR (FALSE, TRUE, TRUE)      _____________________________                                               

=AND (3>5, TRUE)     _____________________________                                                      

=NOT (OR (FALSE, FALSE, TRUE))   _____________________________                                    

=AND (A2>6, NOT (FALSE)) where A2 contains the value 25 ____________________________

3.

The textbook suggested that before using the formula auditing tools, you take the following three steps: fix obvious errors; use the Error Alert button, and examine the formula.

Please briefly describe each of these steps.

4. How is a PivotChart different from a normal chart in Excel?

How PivotChart could be used in a business situation. 

Argument your answer.