# C - Part C Construct Excel Formulas[10 points Use only the...

This preview shows pages 1–2. Sign up to view the full content.

Part C – Construct Excel Formulas [10 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” The formula in  Card  assembles the name as shown. You are required to write ONLY SOME of the formulae.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 2

C - Part C Construct Excel Formulas[10 points Use only the...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online