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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!