Cis 122l need someone good with excel

 

Assignment #3 – Pages EX 60-61 Case Problem 2 – Complete steps 1 – 19 in the textbook then complete the steps below in the same workbook.

Insert a new sheet.

Name the new sheet with your first and last name.

Hide the sheet.

Save the file with your name and Balance Sheet (e.g. SmithJ Balance Sheet).

Submit this file using the provided link on the assignments page. 

Part II: Certification Skills 

     

Case Problem 2 

Data File needed for this Case Problem: Balance.xlsx 

Scott Kahne Tool & Die Cheryl Hippe is a  nancial of cer at Scott Kahne Tool & Die, a manufacturing company located in Mankato, Minnesota. Every month the company publishes a balance sheet, a report that details the company’s assets and liabilities. 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 Excel1 > Case2 folder included with your Data Files. Save the workbook as Balance Sheet in the location speci ed by your instructor.
     
  2. In the Documentation sheet, enter your name in cell B3 and the date in cell B4.
     
  3. Go to the Balance Sheet worksheet. Set the font size of the title in cell A1 to 28 points.
     
  4. In cell A2, enter the text Statement for March 2017.
     
  5. Set the width of columns A and E to 30 characters. Set the width of columns B, C, F, and G to
    12 characters. Set the width of column D to 4 characters. (Hint: Hold down the Ctrl key as you click the column headings to select both adjacent and nonadjacent columns.)
     
  6. Set the font size of the text in cells A4, C4, E4, and G4 to 18 points.
     
  7. Set the font size of the text in cells A5, E5, A11, E11, A14, E15, A19, E20, and A24 to 14 points.
     
  8. Enter the values shown in Figure 1-45 in the speci ed cells. (see attachments)
     

Assignment #4 – Read the information in the Additional Instructions & Corrections document for Week 1 to learn how to customize the Quick Access Toolbar (QAT). After you have learned how to edit the QAT, complete the exercise below.

Note: You may need to do this exercise on a PC as the Mac version of Excel may not have these abilities.

Move the QAT below the ribbon.

Add the following commands (buttons) to the QAT: New, Open, Print Preview and Print, Close All.

Add the AutoSum split button, (that is with the pop up menu arrowhead so you can access more functions).
 

Put the commands in the same order as the screen shot above.

Take a screen shot of the entire screen including the toolbar and ribbon by pressing the Print Screen key on the keyboard.

Paste the screen shot into a new Word document. (To insert it into a Word document: Open a new Word document, then Paste.)

Save the Word document with your name and QAT (e.g. SmithJ QAT).

Submit this file using the provided link on the assignments page by the deadline.

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

We value our customers and so we ensure that what we do is 100% original..
With us you are guaranteed of quality work done by our qualified experts.Your information and everything that you do with us is kept completely confidential.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

The Product ordered is guaranteed to be original. Orders are checked by the most advanced anti-plagiarism software in the market to assure that the Product is 100% original. The Company has a zero tolerance policy for plagiarism.

Read more

Free-revision policy

The Free Revision policy is a courtesy service that the Company provides to help ensure Customer’s total satisfaction with the completed Order. To receive free revision the Company requires that the Customer provide the request within fourteen (14) days from the first completion date and within a period of thirty (30) days for dissertations.

Read more

Privacy policy

The Company is committed to protect the privacy of the Customer and it will never resell or share any of Customer’s personal information, including credit card data, with any third party. All the online transactions are processed through the secure and reliable online payment systems.

Read more

Fair-cooperation guarantee

By placing an order with us, you agree to the service we provide. We will endear to do all that it takes to deliver a comprehensive paper as per your requirements. We also count on your cooperation to ensure that we deliver on this mandate.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency