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:
tableABCPayroll Information,,Employee,Years,SalaryMary,John,Paulo,Rose,Bill,
Save the worksheet with your Full Name and Student ID;
Rename the sheet tab Payroll;
Insert a Table using this data;
Sort Table from to ;
Format Salary Column as Currency;
Bold the entire worksheet;
The font and font size of the worksheet should be Calibri and except for the title which should be Times New Roman and ;
The worksheet title should to be centered across the columns AC;
The worksheet title should have a font color of white and a background color of blue;
The columns titles in row should be centered and blue color;
The range should have a single line top border and a double line bottom border:
Cells AC should be italicized;
The height of row should be pixels inches;
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
