Part C [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.
Recall from Test 1 that the graphic below is S_ is one of the integers 1, 2, 3, or 4, and is
from a workbook to analyze probability in randomly chosen.
Suit is assigned by an IF statement according
This section “deals” cards. 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
Values in the range 2 to 10 are copied
11, 12, 13, and 14 are replaced by “Jack”,
“Queen”, “King”, and “Ace”
The formula in Card assembles Rank and
Suit into the name as shown.