Add the following data to the "Pay Rate" and "Hours" columns for each of the 4 employees:
This will be for columns B, C, E, G, and I
Assuming the four employees are listed in rows 2, 3, 4, and 5, and the data to be added is as follows:
Employee 1:
Pay Rate: $15.00
Hours: 40
Employee 2:
Pay Rate: $18.50
Hours: 35
Employee 3:
Pay Rate: $20.00
Hours: 45
Employee 4:
Pay Rate: $12.75
Hours: 30
The data can be added to the columns as follows:
Cell B2: $15.00
Cell C2: 40
Cell E2: $18.50
Cell G2: 35
Cell I2: $20.00
Cell J2: 45
Cell L2: $12.75
Cell N2: 30
For Employee 2, the data can be added to the next row:
Cell B3: $15.00
Cell C3: 40
Cell E3: $18.50
Cell G3: 35
Cell I3: $20.00
Cell J3: 45
Cell L3: $12.75
Cell N3: 30
Continue this pattern for the remaining employees in rows 4 and 5.