100%(6)6 out of 6 people found this document helpful
This preview shows page 1 - 3 out of 6 pages.
EXCEL60. 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 aboutFor 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 idgic. Explain the purpose and use of values in the Statement Number and Posting Ordercolumns 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.