Question: Create an Excel worksheet and enter the following data: table [ [ , A , B , C ] , [ 1 , Payroll

Create an Excel worksheet and enter the following data:
\table[[,A,B,C],[1,Payroll Information,,],[2,,,],[3,Employee,Years,Salary],[4,,,],[5,Mary,4,50000],[6,John,6,60000],[7,Paulo,5,45000],[8,Rose,2,70000],[9,Bill,3,55000],[10,,,]]
Save the worksheet with your Full Name and Student ID;
Rename the sheet tab Payroll;
Insert a Table using this data;
Sort Table from A to Z;
Format Salary Column as Currency;
Bold the entire worksheet;
The font and font size of the worksheet should be Calibri and 11 except for the title which should be Times New Roman and 16;
The worksheet title should to be centered across the columns A-C;
The worksheet title should have a font color of white and a background color of blue;
The columns titles in row 3 should be centered and blue color;
The range A3-C3 should have a single line top border and a double line bottom border:
Cells A3-C3 should be italicized;
The height of row 13 should be 24 pixels inches);
 Create an Excel worksheet and enter the following data: \table[[,A,B,C],[1,Payroll Information,,],[2,,,],[3,Employee,Years,Salary],[4,,,],[5,Mary,4,50000],[6,John,6,60000],[7,Paulo,5,45000],[8,Rose,2,70000],[9,Bill,3,55000],[10,,,]]

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!