Problem
A. Explain the three different types of cell referencing.
B. Why are named ranges useful? What limitations are there in creating the names for ranges?
C. Why is the syntax of an Excel function important? How can you distinguish between required and optional portions of a function?
D. In the math and statistical functions, what are the differences between the ROUND function and the INT function? Give a business example of when you would use each.
E. What is the difference between the TODAY and the NOW functions? Why is this difference important?