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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started