BUS Problem Solving – Answer 13 Excel questions

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.