Assignment 3-2: Basic Excel
Instructions
Download and open Assignment 3-2 Worksheet from the Moodle shell, and format it as follows:
1) The first two columns, Department and First Name, are too narrow to display. Change the width of both columns so all data can be seen.
2) Modify the Font across the whole worksheet to Times New Roman, 8 point. You might have to repeat this step again so that the worksheet is uniform.
3) Modify the Row Height across the entire document to Height: 31.20 (52 pixels)
4) Insert a row above row 11 and type in the following data:
a) Department: IT
b) First Name: Ernest
c) Last Name: Hemingway
d) User Name: hemingwaye
e) Put Xs in columns headed Part 1, Part 2, Part 3
f) Leave column G blank
g) Total: 568945
h) Address: 6528 Longfellow Rd Euless, TX 77459
5) Move the Address column to the immediate left of the User Name column
6) Move the Status column to the end, after the Total column
7) Wrap the text of the Address column so each line of the address is seen.
8) Insert a row above row 1 and do the following:
a) Type Roadrunner Inc. Company Presentations, Font 18
b) Select cells A1 through J1
c) Click Merge and Center
d) Click on Cell A1, make the fill color light green
9) Change the data in the Total column to currency number format
10) Make all data (and headings) left justified, bottom aligned in each cell
11) Save your assignment as [your initials]_assignment3-2.xlsx and upload it to the Moodle shell, Week 3.
