SuperTutor

(15)

$15/per page/Negotiable

About SuperTutor

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Business & Finance See all
Accounting,Business & Finance,Economics,Engineering,HR Management,Math Hide all
Teaching Since: Apr 2017
Last Sign in: 328 Weeks Ago, 4 Days Ago
Questions Answered: 12843
Tutorials Posted: 12834

Education

  • MBA, Ph.D in Management
    Harvard university
    Feb-1997 - Aug-2003

Experience

  • Professor
    Strayer University
    Jan-2007 - Present

Category > Business & Finance Posted 26 May 2017 My Price 10.00

Create a workbook

Create a workbook and sve it as [S.J] Excel 5-10.

  • Insert worksheets so that you have five worksheets in the workbook. Nae 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 a row labels. Use a five- 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. If a certain emplyee did not work on a specific day, type a zero (0) in the cell.
  • Total weekly hours by employee and show the total hours worked by day.
  • Ungroup the sheets and prepare the This Month sheet for 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 to the source data.
  • Arrange the windows so that you can place a screenshot of the Averages worksheet in the This Month sheet. Size and position the screenshot to the right of the data. Crop the screenshot, if you can, to remove the unnecessary part of the screenshot.

Answers

SuperTutor
(15)
Status NEW Posted 26 May 2017 07:05 AM My Price 10.00

-----------

Attachments

file 1495783946-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)
Relevent Questions