Question: QUESTION 17 Spreadsheet software can be used to communicate financing, investing and operating activities for a business. Which statement would contain this information? Balance Sheet
QUESTION 17 Spreadsheet software can be used to communicate financing, investing and operating activities for a business. Which statement would contain this information?
| Balance Sheet | ||
| Income Statement | ||
| Statement of Cash Flows | ||
| Statement of Retained Earnings |
5 points
QUESTION 18 A footer would be placed on a spreadsheet document _____to communicate additional information to the reader
| At the bottom of the page | ||
| At the top of the page | ||
| On the right side of the page | ||
| On the left side of the page |
5 points
QUESTION 19 When preparing a horizontal analysis, using software, the percentage of change for land would be calculated using a formula?
| Dividing land by total assets | ||
| Dividing current and past years' land cost | ||
| Multiplying current year market value and total assets | ||
| Adding past years and depreciation on the land |
5 points
QUESTION 20 You need to prepare a budgeted income statement so you create a spreadsheet formula in Excel with a $ in front of the letter and number (ex. $A$4) in the cell address for the percentage increase from last year to this year, this means that
| The answer will always be shown in the same cell address such as A4 even if a new file is opened | ||
| The answer will be shown in a cell that is at least as wide as the specified number in the formula such as 4 | ||
| The answer will be shown with a dollar sign such as $100 so it is easier for the reader to understand rather than a percentage | ||
| The number in the cell remains constant even if the formula is copied to another location. |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
