Question

Read the scenario below and then answer the
question to the right.

The manager of a small engineering company is
setting up a spreadsheet to help track cash flow
for each month. The spreadsheet will track
incoming payments from clients. It will also track
outgoing payments for rent utilities employee
salaries, and insurance.

What is the best way to set up the spreadsheet?

A. List each expense in a row. List each income
source in a column.

B. List each expense and income source in a
separate column List each month in a row.

C. List each month in a column. List each
expense in a row.

D. List each expense in a column. List each
month in a row

Answer 1

Answer:

B. List each expense and income source in a separate column List each month in a row.

Explanation:

The manager is making the spreadsheet for helping track the cash flow. The spreadsheet will be keeping track of the outgoing and incoming payments from the clients. And it is also going to track the outgoing payments like rent and the whole cashflow. And for that, the Manager should mention the expense and the income source in a separate column and list all the months in a row. And hence, the B. is the correct option.

Answer 2

Answer:

B

Explanation:

The best way to set up the spreadsheet is to list each expense and income source in a separate column. List each month in a row.