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!!!!!!!

FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS