CS 200 Review Excel.docx - EXCEL 60 Consider the following screenshot of a slightly augmented version of the Sort Marks workbook discussed The macros

CS 200 Review Excel.docx - EXCEL 60 Consider the following...

This preview shows page 1 - 3 out of 6 pages.

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:
Image of page 1
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.
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 6 pages?

  • Spring '14
  • BarbaraDaly
  • Sort

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture