Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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_2

Step: 3

blur-text-image_3

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

Week 3: Moment of force: scalar formulation...explain it

Answered: 1 week ago