EXCEL
60. Consider the following screenshot of a slightly augmented version of the Sort Marks
workbook discussed. The macros attached to the buttons By ID #, By Name, and By
Mark sort the range “theData3,” which we can see has been defined as B3:D15.
a. What is the most likely reason for having included the blank cells B15:D15 in the definition of theData3?
61. Refer to the screenshot:
a. Supply a formula appropriate for cell L147 in the “S Balance” column.
Column L is for the A Balance bruh which column u talkin about
For the “S Balance” column, we might use the formula: “=IF($H$2=F147, M146+J147-K147,
M146)
b. Supply a formula appropriate for cell I137 of the “CD Charge” column.
Why would u need a formula for this column idgi
c. Explain the purpose and use of values in the Statement Number and Posting Order
columns in this spreadsheet.
The statement number corresponds to the S balance column, which totals the balance for that
particular statement. This allows the use to differentiate totals and organize expenses according
to when they were charged.
You've reached the end of your free preview.
Want to read all 6 pages?
- Spring '14
- BarbaraDaly
- Sort
