odd/even labels	even	odd	even	odd	even	odd	even	odd	even	odd	even	odd	even	odd	even	odd
position	16	15	14	13	12	11	10	9	8	7	6	5	4	3	2	1
Credit Card Number	5	4	5	7	6	2	3	8	9	8	2	3	4	1	1	0	Spring 2021
double	10	8	10	14	12	4	6	16	18	16	4	6	8	2	2
greater than 9?	True	False	True	True	True	False	False	True	True	True	False	False	False	False	False
even digits (root values)	1		1		3		6		9		4		8		2		total	?
odd digits		4		7		2		9		8		3		1			Check Digit	?

Make sure the Credit Card Number in cells B5:P5 is 5457 6238 9823 411

The fifth step in the Luhn Algorithm is to sum all the root digits that have been prepared in Cells B8:P9

Step 5: Sum the digits in positions B8:P9 and place the result in cell S8. Do this with a formula using the =SUM() function and cell references.

What is the value in Cell S8 ?

Question 6 options:

	188
	67
	162
	169
	141
	62
	106
	34
	102
	28

Hide hint for Question 6
Use a formula with the SUM function in cell S8

Question 7 (10 points)

Saved

Make sure the Credit Card Number in cells B5:P5 is 5457 6238 9823 411

Step 6: Calculate a "check digit". Multiply the sum of root digits (value in cell S8) by 9, then locate the remainder when divided by 10.

Finding the remainder is done using a math function called modulus. Now is a good time to lookup the Excel function MOD to understand how it works. (You need to use the MOD function to get full credit for this task.)

The first argument of the MOD function is number. This is the sum of root digits (value in S8) multiplied by 9.

The second argument of the MOD function is the Divisor. This is the what you want to divide number by. The divisor is 10 for the Luhn Algorithm, which gives a single digit result.

What is the value in Cell S9 ?

Question 7 options:

	60.3
	7
	9
	3
	8
	10
	603