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.

Place your order
(550 words)

Approximate price: $22

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
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

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

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

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more