Help me study for my Excel class. I’m stuck and don’t understand.
Your answer to each of these questions should not exceed 50 words.
And respond with 2-3 sentence to two classmates, I will post when the classmates post
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, sum of the years digits, and fixed-declining balance.
