Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Find solutions for your homewor home / study / business / accounting/ accounting questions and answers/create case problem 2 data file needed for this

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Find solutions for your homewor home / study / business / accounting/ accounting questions and answers/create case problem 2 data file needed for this ca Question: CREATE Case Problem 2 Data File needed for this Ca CREATE Case Problem 2 Data File needed for this Case Problene Balance.alss Scott Kahne Tool & Die Cheryl Hippe is a financial officer at Scon Kahine Tool & Die a manufacturing company Tocated in Mankato, Minnesota. Every month the company publishes a balance sheet, a report that details the company's assets and abilities Cheryl asked you to create the workbook with the text and formulas for this report. Complete the following 1. Open the Balance workbook located in the Excell> Case2 folder included with your Data Files. Save the workbook as Balance Sheet in the location specified by your instructor 2. In the Documentation sheet, enter your name in cell B3 and the date in cell 84 1. Go to the Balance Sheet worksheet Set the font size of the title in cell A1 to 28 points In cell A2, enter the ted Statement for March 2017. 5. Set the width of columns A and E to 30 characces. Se the width of columns B. CE and G to 12 characters. Set the width of column D to 4 characters. Uline. Hold down the Ctrl key as you click the column headings to select both adjacent and nonadjacent columns 6. Set the long size of the test in cells A, C, E, and G4 to 18 points 2. Set the font size of the text in cells AS. ES, A11, 1), AT4, ETS, A1, E20, and A24 to 14 points Enter the sales shown in Figure 1-45 in the specified cells 2 2 20 73 $ 94 #3 Q W E 200 600 74 MacBook Air 85 % A FA 6 & 7 R T Y

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting An Introduction to Concepts Methods and Uses

Authors: Michael W. Maher, Clyde P. Stickney, Roman L. Weil

11th edition

1111571260, 978-1111571269

More Books

Students also viewed these Accounting questions

Question

=+b) Are the conditions for ANOVA met? Why or why not?

Answered: 1 week ago