Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Labyrinthelab com lrc

25/03/2021 Client: saad24vbs Deadline: 7 Days

Microsoft Excel is a worksheet application that can be used

to facilitate accounting tasks. You will find that even the most

basic elements of accounting can be completed more efficiently

in the Excel environment. In this chapter, you will examine two

fundamental accounting concepts: the accounting equation and

the transaction recording process. These accounting concepts will

provide the foundation for all subsequent topics. As you examine

these topics, you will be introduced to a number of basic Excel

features.

1 The Accounting Equation and Recording Journal Entries LEARNING OBJECTIVES

■■ Display the accounting equation

■■ Record journal entries

■■ Enter data and numbers in Excel

■■ Use Undo and Redo in Excel

■■ Print worksheets

EFA.indb 1 7/13/18 5:50 PM

© Labyrinth Learning. All rights reserved. http://www.lablearning.com

2 Excel for Accounting Chapter 1: The Accounting Equation and Recording Journal Entries

City Music World City Music World is a retail store located in Niskayuna, NY. The store sells musical equipment and offers lessons for beginning and experienced musicians. The company has used pen and paper to track accounting activity since its inception in 1979 and has now decided to work with Excel to increase its efficiency. You are spearheading this process.

In this chapter, you will examine how the accounting equation and journal entries can be expressed within Excel. You will then examine how this data can be managed within Excel and then conclude by reviewing printing methods.

Journal entries for City Music World (left) and their corresponding impact on the accounting equation (right) can be easily entered in Excel.

P R O J E C T

EFA.indb 2 7/13/18 5:50 PM

© Labyrinth Learning. All rights reserved. http://www.lablearning.com

Entering Data to Display the Accounting Equation 3

The Accounting Equation The accounting equation is a simple formula that must remain in balance at all times. The equation is as follows:

Assets are items of value within the business. Types of assets include Cash, Accounts Receivable (monies owed to the business from a customer), Supplies, Inventory, Equipment, and Land. These resources are used to generate income for the business.

Liabilities are the portions of assets owed to entities outside the business. Examples include Accounts Payable (monies owed by the business to other companies), outstanding loans, mortgages, and monies received in advance of services rendered (such as a sports team receiving season ticket revenue before the actual games are played).

Owner’s Equity is the portion of the assets not owed to entities outside the organi- zation. This portion of the assets represents that to which the owner(s) can lay claim, hence the term owner’s equity.

Stated in different terms, the accounting equation dictates that all items of value (assets) equal the portion of the assets owed to others (liabilities) plus the portion of the assets not owed to others (owner’s equity). Remember that the accounting equation must always be in balance. If you find that total assets do not equal total liabilities plus total owner’s equity, you must identify and correct the error.

Entering Data to Display the Accounting Equation

Within Excel, data is entered into the active cell, which is surrounded by a thick border known as the highlight. Data may be entered as text (used for headings and entries containing alphabetic char- acters) or numbers (can be entered directly or can be calculated using formulas). Excel recognizes whether the data you enter is text, a number, or a formula.

EFA.indb 3 7/13/18 5:50 PM

© Labyrinth Learning. All rights reserved. http://www.lablearning.com

4 Excel for Accounting Chapter 1: The Accounting Equation and Recording Journal Entries

Data Types Entries are defined as one of two main classifications: constant values or formulas. Depending on the method used, the accounting equation can use entries from each classification. Constant values can be text, numeric, or a combination of both. Formula entries display the results of dynamic calculations.

Completing Cell Entries Text and numbers are entered by positioning the highlight in the desired cell, typing the text or number, and completing the entry. You can use [Enter], [Tab], or any of the arrow keys to complete an entry. The method you use determines where the active cell moves.

Entry Completion Method Where the Active Cell Will Appear

(Enter] It will move down to the next cell.

(Tab) It will move to the next cell to the right.

[¥][£][¡][¢] It will move to the next cell in the direction of the arrow key.

[Esc] The entry will be deleted and the current cell will remain active.

When [Tab] is used to populate multiple cells in a row and [Enter] is used to complete the entry, the highlight is returned to the beginning of the next row. This simplifies the process of entering multiple rows of data.

The Enter and Cancel buttons appear on the Formula Bar whenever you enter or edit an entry. The Enter button completes the entry and keeps the highlight in the current cell. Similar to the [Esc] key, the Cancel button discards changes made before completing the entry.

TIP! Simply clicking within a different cell after typing a cell entry also confirms the typed entry.

Deleting and Replacing Entries You can delete an entire entry after it has been completed by clicking in the cell and tapping [Delete]. Likewise, you can replace an entry by clicking in the cell and typing a new entry.

Number Formats When entering numbers, it isn’t necessary to type commas, dollar signs, and other number formats. Instead, you can use Excel’s formatting commands (located on the Home tab of the Ribbon) to add the desired number formats.

This entry is a constant value. This entry is a formula that results in the sum of 33,250 being displayed.

Cancel button

Enter button

EFA.indb 4 7/13/18 5:50 PM

© Labyrinth Learning. All rights reserved. http://www.lablearning.com

Entering Data to Display the Accounting Equation 5

Decimals and Negative Numbers You should always type a decimal point if the number you are entering requires one. Likewise, you should precede a negative number entry with a minus (–) sign or enclose it in parentheses ( ).

Formatting Changes Other formatting changes can be made from the Font group on the Home tab, including bold, italics, and underline. In order to apply these changes to non-adjacent cells, the [Ctrl] key can be used while highlighting the desired cells with the mouse.

Home→Font→Bold | [Ctrl]+[B] Home→Font→Italic | [Ctrl]+[I] Home→Font→Underline | [Ctrl]+[U]

Develop Your Skills EA1-D1

In this exercise, you will create a workbook in Excel and enter the headers and amounts that comprise the accounting equation for City Music World.

Before You Begin: Be sure to visit the Learning Resource Center at labyrinthelab.com/lrc to retrieve the student files for this course before beginning this exercise.

1. Start Excel and open a Blank Workbook template file.

2. Save the file in your Chapter 01 folder as: EA1-D1-AcctEquation-[YourName]

Enter Headers for the Accounting Equation

3. Make cell A1 active by clicking the mouse pointer in it.

4. Type Assets and tap [Tab].

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Top Grade Tutor
Isabella K.
Top Rated Expert
Quality Assignments
Buy Coursework Help
Assignment Hub
Writer Writer Name Offer Chat
Top Grade Tutor

ONLINE

Top Grade Tutor

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$54 Chat With Writer
Isabella K.

ONLINE

Isabella K.

Give me a chance, i will do this with my best efforts

$39 Chat With Writer
Top Rated Expert

ONLINE

Top Rated Expert

I have read your project details. I can do this within your deadline.

$81 Chat With Writer
Quality Assignments

ONLINE

Quality Assignments

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$18 Chat With Writer
Buy Coursework Help

ONLINE

Buy Coursework Help

I will cover all the points which you have mentioned in your project details.

$52 Chat With Writer
Assignment Hub

ONLINE

Assignment Hub

I have read and understood all your initial requirements, and I am very professional in this task.

$86 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Trap shooting foot position - Proprietary estoppel by encouragement - How to solve exponential inequalities with different bases - Managing nonprofit organizations tschirhart pdf - Gravimetric analysis worksheet with answers - Competency Final Paper - Stat 200 week 5 homework problems - Captive audience susan p crawford - Google in china case study analysis answers - ¿adónde van maite y álex? (el parque) maite y álex van al parque. - Argument for and Against Slavery - Nursing Project - Community health nursing - Leadership and knowledge sharing within an organization - Advantages and disadvantages of contracting out - German maestro cs 6508 - Market myopia definition - Http www earthcalendar net index php - An examined life critical thinking and ethics pdf free - Organic growth company is presently testing a number - Essay - 63 divided by 2 - Data Management Need in 8 hours - An example of a committed fixed cost is - Solution to mat 144 mission trip assignment details - Gary hamel on busting bureaucracy - Employment - Nanda nursing diagnosis for endometrial cancer - Week 5 Report - The art of followership pdf - Sociology - English writing - The Presentation - The nose by nikolai gogol questions and answers - Enzymatic browning of apples experiment - Printing and numerical registering co v sampson - 125 mcg to mg - Discussion Board Questions - Economic Assignment(12 hours) - Summaries and Critique Rough Draft - Analyze how forgiveness is utilized for both intrapersonal characteristics and interpersonal relations improvements. - The content of a table header cell is ____ by default in most browsers. - Underlying Assumptions - A store sold a case of scented candles for 17.85 - Help with homework - Peer Workshop - "My Negotiations Skills & Approach Essay - Reactivity of group 2 - How to make a science fair display board - Supply & Demand - Need help with chemistry homework - Analysis of poverty and crime. - When target costing and target pricing are used together - Practical aviation and aerospace law workbook answer key - The losers club discussion questions - One step equations with fractions worksheet - Uses of double displacement reaction - Can apple cider vinegar cure trichomoniasis - Death portrayed in 20th century art - Braun and clarke thematic analysis - Lbs indos cell contact number - Crime scene simulation - Technology in Healthcare - Responsibility reports for cost centers - I need 4000 words Report the Importance of Personal Finance - 39 beauville avenue murrumbeena - International association for the study of pain definition - Lab 4 - The other side is not dumb summary - MKTG201 Week 1 Assignment 1 - Gmi ps200 oxygen sensor - Discussion / Read Chapter 5 and 12 / Answer and Comment / need it within 8 hours - Shell side reynolds number - Cots time and attendance application - Find the mean median and mode of the weights - Help revising and inserting on a thesis paper that’s already written - The modern study of intergroup behaviour takes into account: - Caution risk of electric shock - Size it up worksheet answers - Orange smasher task not working - What happens if a business fails to meet objectives - Juice plus compensation plan 2021 - What's the difference between a parallelogram and a rectangle - Communicable disease article hcs 457 - Cultural interview example - Intensive aftercare programs for juveniles - Wicked witch of the west guards - Social exclusion knowledge network - Artwork that uses appropriation - Use goal seek to perform a break even analysis - Response to Classmates Discussions - Http www strategicbusinessinsights com vals surveynew shtml - Prodiscover basic for mac - Contemporary strategic management concepts - Gillette case study - Brooke dalzell podiatry tamworth - Compare and contrast academic and nonacademic writing - Respiratory Case Study - Hashimoto's Thyroiditis - First ionisation energy of sodium - Junior sea cadet brassard