Homework Help is Here – Start Your Trial Now!
Business
Accounting
See below. I just need help with the red box with the 20,000 answer in it. It came back as incorrect. I believe that the answer is correct but the cell reference/mathematical formula that was used came back as incorrect. Note that this needs to include both cell referencing and the appropriate mathematical formula. The pictures are the of the same problem, just shows two different perspectives. NOTE THAT THIS IS ALL THE INFORMATION I WAS GIVEN!!!!!!!

See below. I just need help with the red box with the 20,000 answer in it. It came back as incorrect. I believe that the answer is correct but the cell reference/mathematical formula that was used came back as incorrect. Note that this needs to include both cell referencing and the appropriate mathematical formula. The pictures are the of the same problem, just shows two different perspectives. NOTE THAT THIS IS ALL THE INFORMATION I WAS GIVEN!!!!!!!

Pkg Acc Infor Systems MS VISIO CD
Pkg Acc Infor Systems MS VISIO CD
10th Edition
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:Ulric J. Gelinas
Chapter11: The Billing/accounts Receivable/cash receipts (b/ar/cr) Process
Section: Chapter Questions
Problem 3DQ
See similar textbooks
icon
Related questions
Question

See below. I just need help with the red box with the 20,000 answer in it. It came back as incorrect. I believe that the answer is correct but the cell reference/mathematical formula that was used came back as incorrect. Note that this needs to include both cell referencing and the appropriate mathematical formula. The pictures are the of the same problem, just shows two different perspectives. NOTE THAT THIS IS ALL THE INFORMATION I WAS GIVEN!!!!!!!

 

 
.00 20 Formatting as Table Styles K14 fx =(C7*C9)-K13 A C D E F H 1 Formula: Multiply, Subtract; Cell Referencing K L 2 3 Using Excel to Record Stock Entries Student Work Area 4 PROBLEM Required: Provide input into cells shaded in yellow in this template. Select account names from the drop-down lists. Use cell references to the data area. Use mathematical formulas to calculate any amounts not given. 5 On May 10, Pilar Corporation issues common stock for cash. 6 Shares of stock issued 2,500 8 Par value per share 24 5.00 Amount at which stock issued 24 13.00 Journalize the issuance of the stock. 10 11 Date Debit Credit 12 May 10 Cash 32,500 13 Common Stock 12,500 14 Paid-in Capital in Excess of Par - Common Stock 20,000 15
Transcribed Image Text:.00 20 Formatting as Table Styles K14 fx =(C7*C9)-K13 A C D E F H 1 Formula: Multiply, Subtract; Cell Referencing K L 2 3 Using Excel to Record Stock Entries Student Work Area 4 PROBLEM Required: Provide input into cells shaded in yellow in this template. Select account names from the drop-down lists. Use cell references to the data area. Use mathematical formulas to calculate any amounts not given. 5 On May 10, Pilar Corporation issues common stock for cash. 6 Shares of stock issued 2,500 8 Par value per share 24 5.00 Amount at which stock issued 24 13.00 Journalize the issuance of the stock. 10 11 Date Debit Credit 12 May 10 Cash 32,500 13 Common Stock 12,500 14 Paid-in Capital in Excess of Par - Common Stock 20,000 15
Sort & Filter Find & Select Analyze Data Formatting as Table Styles Semaithety 00' Format v K14 fx (C7*C9)-K13 H 1 Formula: Multiply, Subtract; Cell Referencing K L M R 3 Using Excel to Record Stock Entries 4 PROBLEM Student Work Area Required: Provide input into cells shaded in yellow in this template. Select account names from the drop-down lists. Use cell references to the data area. Use mathematical formulas to calculate any amounts not given. 5 On May 10, Pilar Corporation issues common stock for cash. 6. 7 Shares of stock issued 2,500 Par value per share 24 5.00 9 Amount at which stock issued 24 13.00 Journalize the issuance of the stock. 10 11 Date Debit Credit 12 May 10 Cash 13 32,500 Common Stock 12,500 +20,000 14 Paid-in Capital in Excess of Par - Common Stock Incorrect 15 Feedback: Use a cell reference and a mathematical calculation to determine the amo received that exceeds the par value of the stock. Instruction: 8.3% of your score. Formula: Multiply, Subtract; Cell reference. Use cell referencing to the Problem area with a mathematical formula. 16 17 18 19 20 21 22
Transcribed Image Text:Sort & Filter Find & Select Analyze Data Formatting as Table Styles Semaithety 00' Format v K14 fx (C7*C9)-K13 H 1 Formula: Multiply, Subtract; Cell Referencing K L M R 3 Using Excel to Record Stock Entries 4 PROBLEM Student Work Area Required: Provide input into cells shaded in yellow in this template. Select account names from the drop-down lists. Use cell references to the data area. Use mathematical formulas to calculate any amounts not given. 5 On May 10, Pilar Corporation issues common stock for cash. 6. 7 Shares of stock issued 2,500 Par value per share 24 5.00 9 Amount at which stock issued 24 13.00 Journalize the issuance of the stock. 10 11 Date Debit Credit 12 May 10 Cash 13 32,500 Common Stock 12,500 +20,000 14 Paid-in Capital in Excess of Par - Common Stock Incorrect 15 Feedback: Use a cell reference and a mathematical calculation to determine the amo received that exceeds the par value of the stock. Instruction: 8.3% of your score. Formula: Multiply, Subtract; Cell reference. Use cell referencing to the Problem area with a mathematical formula. 16 17 18 19 20 21 22
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Accounting Changes and Error Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Pkg Acc Infor Systems MS VISIO CD
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:
9781133935940
Author:
Ulric J. Gelinas
Publisher:
CENGAGE L
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS