ACCT 2010 SPRING 2021 ADLER Company EXCEL ASSIGNMENT SUBMIT ELECTRONICALLY IN THE D2L DROPBOX INSTRUCTIONS · You should download the EXCEL File to your storage device. Save the file as the following...

The instructions needed as well as the excel document to use are attached.


ACCT 2010 SPRING 2021 ADLER Company EXCEL ASSIGNMENT SUBMIT ELECTRONICALLY IN THE D2L DROPBOX INSTRUCTIONS · You should download the EXCEL File to your storage device. Save the file as the following filename: Your Name Excel 1 (EX: Leif Ratliff Excel 1). . · Complete the worksheet (columns D-). The cells F14, E26, and D27 have been done for you as an example. REMEMBER: DO NOT TYPE #’s in the Income Statement and Balance Sheet columns, but instead you are required to import (use =) values from the adjusted balance columns [Columns C and D] · Note that the summation formula in cells B31 and C31 have been provided. · As you prepare the financial statements found in separate tabs at the bottom of the screen, be reminded that all the numbers that go on the financial statements are ALREADY in the worksheet or in a prior statement. You will IMPORT your financial statement numbers from other worksheets by using formulas referencing the appropriate number from the worksheet. Remember * indicates that a formula (=) is needed. · HOW TO REFERENCE BETWEEN WORKSHEETS. (SEE Cell F11 on Income Statement as an example) The Excel file contains multiple sheets: The Columnar Worksheet, the Income Statement, Statement of Retained Earnings, and the Balance Sheet. The numbers you will use in the statements SHOULD BE IMPORTED from the Columnar Worksheet OR a prior financial statement. For example, the Salaries Expense amount that goes on the Income Statement can be found in the Income Statement Debit Column on the Columnar Worksheet. Try this for a test run of importing from another worksheet. 1. Find and highlight cell E13 (Salary Expense) on the Income Statement which requires a formula (****) 2. Enter the = sign in cell E13 3. Click on the “Columnar Worksheet” Tab (below) because you want to obtain the Salary Expense number from the Income Statement column of the worksheet 4. Go to Cell D27 and click on this cell (IT FLASHES) 5. Hit the ENTER key 6. Now you are back at E13 on the Income Statement and your Salaries Expense # has been IMPORTED from the Columnar Worksheet. NOTE: This is an INDIVIDUAL ASSIGNMENT. Your submitted work will be checked for academic integrity. THE PROPER use of EXCEL is a significant part of the points related to this assignment so CHECK YOUR WORK: Click on each cell and you should find the = sign and a cell address or mathematical calculation---- If you find a TYPED (hard-coded) cell, THIS IS AN ERROR that needs to be corrected before submitting your assignment. If you need assistance with using Excel, please seek assistance in the Accounting lab or use another HELP resource.