Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Here is the question, I need it as an Excel sheet. Using theL1_Titan_Employees Excel file, complete the worksheet using the instructions below savingit as firstName_lastName_L1_Titan_Employees.

Here is the question, I need it as an Excel sheet.

Using theL1_Titan_Employees Excel file, complete the worksheet using the instructions below savingit as "firstName_lastName_L1_Titan_Employees". (note:firstName and lastName are your first and last names).

Objectives

1.Move and copy cells using different methods.

2.Use the "Fill Handle" to fill and copy.

3.Format worksheet by changing column widths and row heights, text appearance, and borders.

4.Print spreadsheet using options.

Background: You will be completing an Employee worksheet for the Titan Off-Campus Shops.The worksheetyou will use is the L1_Titan_Employees file.Open it and complete the following instructions.(Note:when no specific cell reference is given, you are to use your best judgment based upon how the worksheet is set up for you to decide what cells are involved or where a result should be placed.)

1.Move the contents of the cells in the range K8-S22 over to A5-I19 (Under the column headings).

2.Using the "Fill Handle", copy the formula in I5 down through I19.

3.Center the title and sub-title across the worksheet columns.

4.Change the font of the Title to size 18 and the sub-title to size 14.

5.Make the column headings bold and italicized.

6.Center the column headings within each column.

7.Reduce the number of decimal places in cell G5 to 0.

8.Re-size each column to the "Best fit" for the column.

9.Place a border under the column headings.

10.Place a border under the last set of values (row 19).

11.Increase the height of row 4 by approximately 1/3

12.Change the print orientation to Landscape.

Here is the Excel sheet

image text in transcribed
Titan Off-Campus Shops Employee Details Employee | Last Name First Name Departmen Title Start Date Beginning SCurrent Sal Salary Change 18201001 Murphy John Admin CEO 1/13/1982 55,000.00 82,000 27,000 18201002 Jones Emily Finance CFO 1/13/1982 55,000 82,000 18201003 Ta Janie Admin VP 1/13/1982 45,000 75,000 18202001 Nguyen Phil Finance Accountant 2/1/1982 38,000 62,000 18202002 Park Julie Sales Sales Assoc 2/2/1982 25,000 31,000 18310001 Tanaka Nathan Operations Warehouse 1/14/1983 18,000 29,000 18310002 Ohayan Sapir Operations Warehouse 1/14/1983 18,000 29,000 18311001 Aki Jireh Sales Sales Assoc 11/5/1983 17,000 31,000 18311002 Aames Chris Sales Sales Assoc 11/5/1983 17,000 29,000 18501001 Cuomo Jake Sales Sales Assoc 1/7/1985 21,000 31,000 18503001 Sharifi Jam Finance Accountant 3/14/1985 39,000 59,000 19205001 Nemoto Tom Sales Sales Mana 5/14/1992 45,000 70,000 21505002 Chang Keith Operations Warehouse 5/2/2015 31,000 45,000 21506001 Sanchez Neil Sales Sales Assoc 6/1/2015 27,000 27,000 21506002 Gibson Norm IT Webmaster 6/1/2015 41,000 41,000 vious

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

Precalculus

Authors: Michael Sullivan

9th edition

321716835, 321716833, 978-0321716835

More Books

Students also viewed these Mathematics questions

Question

What is a management control system?

Answered: 1 week ago