Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 7, Problem 3R
To determine
Print the worksheet and print formulae.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Instructions 1. Download the Chart workbook from Google Classroom.
2. Insert a Line chart into our practice Word document.
3. Open our Chart workbook in Excel. Copy the data and paste it into the chart's spreadsheet.4. Change the chart title to Monthly Sales.
5. Change the chart type to Stacked Column.6. Double-click the axis title, then rename it Sale Profits.
In June 2021, Chan Lee opened a photography studio that provides services to public and private
schools. His firm's Chart of Accounts and financial activities for the first month of operations
appear below:
Chan Lee Photography Studio
Chart of Accounts
ASSETS
REVENUE
101
Cash
404
Service Fees
111
Accounts Receivable
EXPENSES
Rent Expense
Salaries Expense
Telephone Expense
Utilities Expense
Miscellaneous Expense
Supplies
Office Furniture
121
511
141
512
Office Equipment
Photographic Equipment
LIABILITIES
142
513
151
514
531
202
Accounts Payable
OWNER’S EQUITY
Chan Lee, Capital
Chan Lee, Drawing
301
302
Date
Transactions
June 1 Chan Lee invested P300,000 cash in the business.
2 Issued Check # 1001 for P30,000 to pay the June rent.
5 Purchased desks and other office furniture for P50,000 from Office Plus;
received Invoice # 5312, payable in 60 days.
6 Issued Check # 1002 for P150,000 to purchase photographic equipment.
7 Purchased photography supplies for P40,000, paid with Check # 1003.…
Write a SQL query to calculate the total purchase amount of customer_id 3005
Chapter 7 Solutions
Excel Applications for Accounting Principles
Ch. 7 - Del Rio began Rio Enterprises on January 1 with...Ch. 7 - Del Rio began Rio Enterprises on January 1 with...Ch. 7 - Prob. 3RCh. 7 - Del Rio began Rio Enterprises on January 1 with...Ch. 7 - What changes would have taken place if Dels...Ch. 7 - Suppose Dels purchase prices had remained...Ch. 7 - Del Rio began Rio Enterprises on January 1 with...Ch. 7 - Reset the November 20 purchase to 150 units,...Ch. 7 - Click the Chart sheet tab. On the screen is a...
Knowledge Booster
Similar questions
- Click the Chart sheet tab. This chart is based on the problem data and the two income statements. Answer the following questions about the chart: a. What is the title for the X-axis? b. What is the title for the Y-axis? c. What does data range A represent? d. What does data range B represent? e. Why do the two data ranges cross? f. What would be a good title for this chart? When the assignment is complete, close the file without saving it again. Worksheet. The VARCOST2 worksheet is capable of calculating variable and absorption income when unit sales are equal to or less than production. An equally common situation (that this worksheet cannot handle) is when beginning inventory is present and sales volume exceeds production volume. Revise the worksheet Data Section to include: Also, change actual production to 70,000. Revise the Answer Section to accommodate this new data. Assume that Anderjak uses the weighted-average costing method for inventory. Preview the printout to make sure that the worksheet will print neatly on one page, and then print the worksheet. Save the completed file as VARCOSTT. Check figure: Absorption income, 670,000. Chart. Using the VARCOST2 file, fix up the chart used in requirement 5 by adding appropriate titles and legends and formatting the X- and Y-axes. Enter your name somewhere on the chart. Save the file again as VARCOST2. Print the chart.arrow_forwardAnswer True or False to each of the following. 1. To add a customer you click on the Task menu. True/False 2. A list of all the accounts used by a company showing the assigned numbers to each account is called Chart of Accounts. True/False 3. Reports can only be generated for final accounts when using an accounting software package. True/False 4. Under the File Menu, more than one company can be viewed at a time. True/False 5. To add a vendor click on Maintain, add vendor. True/False Answer True or False to each of the following. 1. A quote can be converted to a sales invoice 2. Most companies use batch posting instead of real-time posting for transactions 3. The Peachtree system can use both the accrual basis and cash basis to record transactions of accounting 4. To set up a new company, you would select the maintain option on the menu bar 5. Accounts descriptions cannot be changed once they have been savedarrow_forwardConstruct a Purchase Ledger Control Account, using your own numerical example, with five items?arrow_forward
- Required information (The Excel worksheet form that appears below is to be used to recreate part of the example relating to Turbo Crafters that appears earlier in the chapter.) Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell B13 enter the formula "= B5". After entering formulas in all of the cells that contained question marks, verify that the dollar amounts match the example in the text. Check your worksheet by changing the estimated total amount of the allocation base in the Data area to 50,000 machine-hours, keeping all of the other data the same as in the original example. If your worksheet is operating properly, the predetermined overhead rate should now be $6.00 per machine-hour. If you do not get this answer, find the errors in your worksheet and correct them. Save your completed Applying Excel form to your computer and then upload it here by clicking "Browse." Next, click "Save." You will use this…arrow_forwardClick on the "Prepare Fin Sts" tab and enter your name in Cell C1. If Cell C1 is left blank, you will not be able to see your score. Each graded cell is highlighted in yellow. Select all account titles/labels using dropdowns. Enter formulas for all dollar amounts. The formula must only contain cell addresses. Each correct formula will begin with =, +, or -. The basic mathematical operators are +, -, * and / Addition: To add the values in cells A1 and B4, the formula is =A1+B4 Subtraction: To subtract the value in cell B4 from the value in cell A1, the formula is =A1-B4 Multiplication: To multiply the values in cells A1 and B4, the formula is =A1*B4 Division: To divide the value in cell A1 by the value in cell B4, the formula is =A1/B4 THIS FILE REQUIRES THE USE OF =SUM FOR ALL TOTALS AND SUBTOTALS The =SUM function adds all values…arrow_forwardConstruct a Sales Ledger Control Account, using your own numerical example, with five items of your choice?arrow_forward
- Using Excel, create a table that shows the relationship between the interestearned and the amount deposited, as shown. we will first create the dollar amount column and the interest row, as shown . Next we will type into cell B3 the formula = $A3*B$2. We can now use the Fill command to copy the formula in other cells, resulting in the table as shown. Note that the dollar sign before A3 means column A is to remain unchanged in the calculations when the formula is copied into other cells. Also note that the dollar sign before 2 means that row 2 is to remain unchanged in calculations when the Fill command is used.arrow_forwardPlease prepare journal entries using the Perpetual Inventory System. And also, please follow the format. Thank you and have a great day ahead!:)arrow_forwardPlease let me know if you need additional information. There is a tab that includes a product, customer and order log tables.arrow_forward
- 1 ) By using FIFO method: Post Journal entries for Sales and CGS?arrow_forwardCustom fields can be created ____________________.Select all that apply. Select one or more: A. on the Advanced tab of Account and Settings B. on the Expenses tab of Account and Settings C. on the Sales tab of Account and Settings D. on the Company tab of Account and Settingsarrow_forwardWhere can you initiate a Credit Memo in QuickBooks Online? (Choose 2)(Select all that apply) A. Gear icon > Credit Memo B. Sales Center > All Sales > New Transaction > Credit Memo C. Sales Center > New Invoice, then toggle the Credit Memo button D. +New button > Credit Memo E. Sales Center > All Sales > Import Transactionsarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning