15 Jul The project in this module follows proper design guidelines and uses Excel to create the worksheet shown in
The project in this module follows proper design guidelines and uses Excel to create the worksheet shown in Figure 2 – 1. Every two weeks, the owners of Olivia’s Art Supply create a salary report by hand, where they keep track of employee payroll data. Before paying employees, the owners must summarize the hours worked, pay rate, and tax information for each employee to ensure that the business properly compensates its employees. This report also includes the following information for each employee: name, email address, number of dependents, hours worked, hourly pay rate, tax information, net pay, and hire date. As the complexity of creating the salary report increases, the owners want to use Excel to make the process easier
LAb1 Perform the following tasks: 1. Enter and format the worksheet title Aylin Insurance and worksheet subtitle Premium Analysis in cells A1 and A2. Change the theme of the worksheet to the Berlin theme. Apply the Title cell style to cells A1 and A2. Change the font size in cell A1 to 26 points, and change the font size in cell A2 to 18 points. Merge and center the worksheet title and subtitle across columns A through E. Draw a thick outside border around the range A1:A2. 2. Change the width of column A to 20.00 points. Change the widths of columns B through E to 14.00 points. Change the heights of row 3 to 36.00 points and row 14 to 25.50 points.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.