Question:
Creating and testing check digits.
a. Create a spreadsheet that will take as input a five-digit account number and calculate a check digit using this formula: (5 x left-most digit + 4 x next digit + 3 x third digit + 2 x fourth digit + fifth digit) modulus division by 7. (Modulus division returns the remainder - for example: 11 modulus division by 3 = 2). The check digit then becomes the 6th (right-most) digit in the account number. Your spreadsheet should look like this:
b. Add another panel to the spreadsheet that takes as input a six-digit account number and uses the check digit formula in part a to test whether or not the account number is valid. Your solution should look like this:
Transcribed Image Text:
Solutions to Excel Problems Romney and Steinbart 12th edition.xlsx - Microsoft Excel Home Insert Page Layout Formulas Data Revieww Vieww Developer Wrap Text Merge & Center ▼ $ ▼% , 108:08 Conditional asorm at Cell ▼ Insert Delete For at Acrobat 2 AutoSum Calibri General Copy B 1 u ▼沓て Or ▼▲▼ Sort & Find & Paste 물로 E E Format Painter Clear Filter Select Editing Clipboard Font Alignment Number Styles 124 vi Check digits - creation and use a. Creating check digits Formula (5 xleft-most digit + 4x next digit +3x third digit+ 2 x fourth digit +fifth digit) mod 7 Fifth Check digitActual Raw account # digit digit digit digit digit calculation account # 0 123450 1 123461 2 123472 3 123483 4 123494 4 123504 5123515 6 123526 0 123530 First Second ThirdFourthh 12345 12346 12347 12348 12349 12350 12351 12352 12353 14 ㅖ ト Problem 9-5 Problem 10-5 | Problem 10-10 Problem 12-4 part a Problem 12-4 b and c Problem 12-12 Problem 13-3 Ready ou 100% : Solutions to Excel Problems Romney and Steinbart 12th edition.xlsx - Microsoft Excel Home Insert Page Layout Formulas Data Review vieww Developer Acrobat A Define Name ▼ Trace Precedents Show Formulas Calculate Noww f Use in Formula Trace Dependents ◆ Error Checking ▼ Insert AutoSum Recently Financial Logica Text Date & Lookup & Math More Function Name Formula Window Calculation Calculate Sheet Used Time Reference & Trig FunctionsManager Create from Selection Remove Arrowws Function Library Defined Names Formula Auditing Calculation D23 vi Check digits - creation and use a. Creating check digits Formula (5 xleft-most digit + 4x next digit +3x third digit+ 2 x fourth digit +fifth digit) mod 7 Fifth Check digitActual Raw account # digit digit digit digit digit calculation account # 0 123450 1 123461 2 123472 3 123483 4 123494 4 123504 5123515 6 123526 0 123530 First Second ThirdFourthh 12345 12346 12347 12348 12349 12350 12351 12352 12353 b. Testing check digits Account number First Second Third Fourth Fifth Valid? digit dig digit didigi Check digit YIN) 123530 123534 4 N 25 27 14 Problem 9-5 Problem 10-5 | Problem 10-10 Problem 12-4 part a Problem 12-4 b and c Problem 12-12 Problem 13-3 Ready