File Needed: None
Completed Project File Name: [your initials] Excel 5-10.xlsx
Create a new workbook and save it as [your initials] Excel 5-10. Modify your workbook according to the following guidelines: • Insert worksheets so that you have five worksheets in the workbook. Name the sheets Week 1,
Week 2, Week 3, Week 4, and This Month.
• Group all the sheets and type the names of five employees in a column as row labels. Use a
f ive- or seven-day workweek, typing the day names as column headings.
• Add a main title. Enter the number of hours worked for each employee for each day worked. It a certain employee did no
• Total weekly hours by employee and show the total hours worked by day.
• Ungroup the sheets and prepare the This Month sheet tor consolidation using Sum without links.
• Copy one of the sheets to create an Averages sheet. Use Average to consolidate work hours for all employees with links
• Arrange the windows so that you can place a screenshot of the Averages worksheet in the This Month sheet. Size and p he following guidelines: a certain employee did not work on a specific day, type a zero (0) in the cell. for all employees with links to the source data.
is Month sheet. Size and position the screenshot to the right of the data. Crop the screenshot, it you can, to remove the unnecessary part o ove the unnecessary part of the screenshot.

SuperTutor

(15)

Status NEW Posted 29 May 2017 07:05 AM My Price 9.00

-----------

Attachments

file 1496043165-Solutions file.docx preview (51 words )

S-----------olu-----------tio-----------ns -----------fil-----------e -----------Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k y-----------ou -----------for----------- yo-----------ur -----------int-----------ere-----------st -----------and----------- bu-----------yin-----------g m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l b-----------e q-----------uic-----------kly----------- on-----------lin-----------e a-----------nd -----------giv-----------e y-----------ou -----------exa-----------ct -----------fil-----------e a-----------nd -----------the----------- sa-----------me -----------fil-----------e i-----------s a-----------lso----------- se-----------nt -----------to -----------you-----------r e-----------mai-----------l t-----------hat----------- is----------- re-----------gis-----------ter-----------ed -----------onÂ----------- th-----------is -----------web-----------sit-----------e -----------Tha-----------nk -----------you----------- -----------

Not Rated(0)

• Buy Answer