EECS 1520 Lecture : v1pB.pdf
mahika.c06 and 40040 others unlocked
54
EECS 1520 Full Course Notes
Verified Note
54 documents
Document Summary
Part b construct excel formulas [8 points] Use only the data shown to answer the following questions. All ranges have been named using the labels that appear in the worksheets. The graphics below are taken from an inventory/sales system. Categories are used to select the rate to apply to calculate markup. Code and cost hold data entered by the user. Code includes the category of each item as the last character and the stockroom number as the last digit. Each underline represents point: write an excel formula to calculate the values in the price column. = cost + markup: write an excel formula (do not use if or lookup) that will produce the values in the. There are many ways of selecting the character: Mid (code, 3, 1) for this alternative add 1 point for overall correctness. A column in an excel worksheet named letter grade contains this formula: