Question

Kyle uses a spreadsheet to keep track of his spending. This is an example of Kyle’s spreadsheet for two months:
A 2-column table with 14 rows. Column 1 labeled transaction with entries beginning balance, rent, paycheck, groceries, tax refund, textbooks, insurance, garage sale, clothes, rent, electric bill, paycheck, party, insurance. Column 2 labeled Amount in dollars with entries 626.88, 335.13, 202.44, 77.05, 103.72, 96.33, 56.25, 42.67, 62.54, 335.13, 77.39, 215.15, 113.48, 56.25.
Kyle thinks that he could improve this spreadsheet, but he is not sure how. Choose the statement or statements that would help Kyle’s spreadsheet become more organized.
I. The spreadsheet should contain at least two copies of every entry for backup purposes.
II. It is hard to tell the debits from the credits. They should be in different colors, different columns, or otherwise differentiated.
III. Having the dates, or at least the months, of each transaction would make things easier to find.
a.
I and II
b.
III only
c.
II and III
d.
I, II, and III

Answer 1

c. II and III

I is not a good suggestion (duplication inside the sheet creates confusion and errors; backups should be separate files or versioned copies). II and III would make the sheet clearer and easier to use.