100%(10)10 out of 10 people found this document helpful
This preview shows page 1 - 2 out of 3 pages.
ExcelQuestion 53 Consider the following screen snapshot of a slightly augmented version of the Sort Marks workbook we discussed in lecture.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.(Your answers should focus on how Excel works, and not just describe what the user of this workbook is doing.)Part a) What is the most likely reason for having included the blank cells B15:D15 in the definition of theData3?Part b) Why use a named range at all — that is, why wouldn’t it be sufficient to simply specify the range of cells to be sorted by writing B3:D15 in the macros that sort this data?Question 54 Here is a picture of the model solution for the Excel Assignment. Refer to it as you answer this question on the following two pages.Part a) Supply a formula appropriate for cell L147 of the “S Balance” column.You may refer to cells by their literal row and column addresses (eg J93 or RC[-2]) in situations where a named range would actually be more appropriate.