Study Guides (256,238)
CA (124,594)
York (10,242)
EECS (202)
EECS 1520 (172)
Midterm

Test 1 version 2 part b

1 Page
159 Views

Department
Electrical Engineering and Computer Science
Course Code
EECS 1520
Professor
Heather Jenkins

This preview shows half of the first page. Sign up to view the full page of the document.
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.
The left worksheet includes parameters:
Categories are used to select the Rate to apply to calculate Markup.
In the right worksheet:
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
.
Category, Markup, Price, and Stockroom are calculated.
Categories Rate
B 100%
G 125%
M 110%
W 150%
Code Cost Category Markup Price Stockroom
123W $ 3.40 W $ 5.10 $ 8.50 3
254B $ 9.84 B $ 9.84 $ 19.68 4
256W $ 5.60 W $ 8.40 $ 14.00 6
255G $ 12.39 G $ 15.49 $ 27.88 5
274B $ 4.49 B $ 4.49 $ 8.98 4
358M $ 0.95 M $ 1.05 $ 2.00 8
568M $ 9.52 M $ 10.47 $ 19.99 8
Notes to Markers:
Each underline represents 1 point.
Each underline represents ½ point.
1) Write an Excel formula to calculate the values in the Category column. [2]
= RIGHT (Code, 1)
2) Write an Excel formula to calculate the values in the Markup column. [5]
= LOOKUP (Category, Categories, Rate) * Cost
3) A column in an Excel worksheet named Letter Grade contains this formula:
=IF(Score<80,"B",IF(Score<70,"C",IF(Score<60,"D",IF(Score<50,"F","A"))))
What will appear in Letter Grade when Score is 56?
B

Loved by over 2.2 million students

Over 90% improved by at least one letter grade.

Leah — University of Toronto

OneClass has been such a huge help in my studies at UofT especially since I am a transfer student. OneClass is the study buddy I never had before and definitely gives me the extra push to get from a B to an A!

Leah — University of Toronto
Saarim — University of Michigan

Balancing social life With academics can be difficult, that is why I'm so glad that OneClass is out there where I can find the top notes for all of my classes. Now I can be the all-star student I want to be.

Saarim — University of Michigan
Jenna — University of Wisconsin

As a college student living on a college budget, I love how easy it is to earn gift cards just by submitting my notes.

Jenna — University of Wisconsin
Anne — University of California

OneClass has allowed me to catch up with my most difficult course! #lifesaver

Anne — University of California
Description
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. The left worksheet includes parameters:  Categories are used to select the Rate to apply to calculate Markup. In the right worksheet:  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.  Category, Markup, Price, and Stockroom are calculated. Categories Rate Code Cost Category Markup Price Stockroom B 100% 123W $ 3.40 W $ 5.10 $ 8.50 3 G 125% 254B $ 9.84 B $ 9.84 $ 19.68 4 M 110%
More Less
Unlock Document


Only half of the first page are available for preview. Some parts have been intentionally blurred.

Unlock Document
You're Reading a Preview

Unlock to view full version

Unlock Document

Log In


OR

Don't have an account?

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


OR

By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.


Submit