Questions from Microsoft Excel and Access for Accounting

Q: What do solvency ratios represent?

What do solvency ratios represent?

Q: Why is the point-and-click method of cell referencing

Why is the point-and-click method of cell referencing easier than typing references directly into worksheet cells?

Q: Which ratios are usually formatted as percentages?

Which ratios are usually formatted as percentages?

Q: What function is built-into Excel to help you calculate straight

What function is built-into Excel to help you calculate straight-line depreciation?

Q: Describe the shape of the three lines in a depreciation comparison chart

Describe the shape of the three lines in a depreciation comparison chart depicting straight-line, double declining balance, and sum-of-the-year’s digits depreciation.

Q: What arguments does the SLN function take?

What arguments does the SLN function take?

Q: Should the arguments in the SLN function be values or references?

Should the arguments in the SLN function be values or references?

Q: Why should the arguments in the SLN function be values or references

Why should the arguments in the SLN function be values or references?

Q: Should references used as arguments to the SLN function be absolute or

Should references used as arguments to the SLN function be absolute or relative?

Q: Create a new What SUP Cost Analysis a. Using the

Create a new What SUP Cost Analysis a. Using the ch7-02 file to start your work, create a worksheet to do the following: i. Calculate the Hi-Lo Method variable cost/hour open and fixed cost. ii. Predi...