Question
Here is the question, I need to do this as an Excel sheet. Using the L1_Titan_Employees Excel file, complete the worksheet using the instructions below
Here is the question, I need to do this as an Excel sheet.
Using the L1_Titan_Employees Excel file, complete the worksheet using the instructions below saving it 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 worksheet you 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started