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

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

View Full Document Right Arrow Icon
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. The graphic above is from a workbook 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 randomly chosen. 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. 
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

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

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online