Question 1: What is the difference between using a relative cell reference, an absolute cell reference, and a mixed cell reference?
Question 2: What is a circular reference and why would you need to avoid it?
Question 3: What information is required to use a PMT function?
Question 4: what are the strengths of line charts and column charts, and discuss how each chart compares different features of the same data.
Question 5: When you should use a dashboard chart?
Question 6: Critical Thinking: We are becoming an increasingly visual society, and we respond to the graphic features in a chart more than those in a worksheet. Therefore, shouldn’t every Excel worksheet you create have an accompanying chart? Why or why not?
Question 7: List three types of conditional formatting and the steps you would take to apply them to your worksheet?
Question 8: Briefly describe each of the arguments in an IF function IF (logical_test,value_if_true,value_if_false).
Question 9: Write the correct syntax for the VLOOKUP function. Give a brief explanation of each of the four arguments that are included in VLOOKUP?
Question 10: Write the correct syntax for the LOOKUP function. Give a brief explanation of each of the three arguments that are included in LOOKUP?
Question 11: Briefly describe five of the nine IS functions. The options are: ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF, and ISTEXT.
Question 12: What is the correct syntax of the PMT function? Briefly describe each of the arguments associated with this function.
Question 13: Briefly describe each of the following depreciation methods: straight-line depreciation, double-declining balance, the sum of the year's digits, and fixed-declining balance.
Sample Solution