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

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

View Full Document Right Arrow Icon
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”
Background image of page 1
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

This note was uploaded on 12/16/2010 for the course CSE CSE 1520 taught by Professor Paul during the Spring '09 term at York University.

Ask a homework question - tutors are online