{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

# C1 - The formula in Card assembles the name as shown You...

This preview shows page 1. Sign up to view the full content.

Part C – Construct Excel Formulas [7 points] Use only the data shown to answer the following questions. All ranges have been named using the labels that appear in the worksheets. This graphic is from a workbook used to analyze probability in card games. This section “deals” cards. S is one of the integers 1, 2, 3, or 4, and is randomly chosen. Suit is assigned by an IF statement according to the corresponding value of S . 1 - Clubs 2 - Diamonds 3 - Hearts 4 - Spades R_ is an integer in the range 2 to 14 inclusive, also chosen randomly. Rank is assigned by an IF statement according to R_, using the following mapping: Values in the range 2 to 10 are copied from R 11, 12, 13, and 14 are replaced by “Jack”, “Queen”, “King”, and “Ace”
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: The formula in Card assembles the name as shown. You are required to write ONLY SOME of the formulae. Assume that other cells contain formulae that do what's required there. 1) Show the formula for Rank . [4] =IF( R_<11, R_, IF( R_=11, "Jack", IF( R_=12, "Queen", IF( R_=13, "King", "Ace")))) A variety of answers will accomplish the task. The keys are: a nested IF structure with 4 IF functions 1 point conditions that identify each of the 5 ranges of R 1 point copying R into Rank for values 2 through 10 1 point assigning the appropriate literal strings for each other value 1 point 2) Create a formula for the Card column.[3] = Rank & “ of ” & suit C1...
View Full Document

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern