Questions from Microsoft Excel and Access for Accounting

Q: Explain the arguments used in the SUM function.

Explain the arguments used in the SUM function.

Q: Explain the importance of parentheses in formulas.

Explain the importance of parentheses in formulas.

Q: What is another term for vertical analysis?

What is another term for vertical analysis?

Q: Which ratios are usually formatted as numbers?

Which ratios are usually formatted as numbers?

Q: What base amount is used for vertical analysis of an income statement

What base amount is used for vertical analysis of an income statement?

Q: What base amount is used for vertical analysis of a balance sheet

What base amount is used for vertical analysis of a balance sheet?

Q: What base amount is used for horizontal analysis of both income statements

What base amount is used for horizontal analysis of both income statements and balance sheets? Give an example.

Q: What do profitability ratios represent?

What do profitability ratios represent?

Q: Create a new What SUP Present Value Analysis a. Using

Create a new What SUP Present Value Analysis a. Using the ch7-01 file to start your work, modify that worksheet to do the following: i. Calculate the annuity payment required at the end of each year f...

Q: What do liquidity ratios represent?

What do liquidity ratios represent?