Skip to main content

The following spreadsheet shows an organizational chart for a small company that provides computer help desk services over the telephone. The company has a number of general and administrative personnel and two levels of telephone support. Customer service representatives (CSRs) are the first to receive initial telephone support calls. If the CSR is unable to solve the problem, the call is passed to a software analyst who is more skilled than the CSRs to handle more complex questions.

The following spreadsheet shows an organizational chart for a small company that provides computer help desk services over the telephone. The company has a number of general and administrative personnel and two levels of telephone support. Customer service representatives (CSRs) are the first to receive initial telephone support calls. If the CSR is unable to solve the problem, the call is passed to a software analyst who is more skilled than the CSRs to handle more complex questions.

To make the data understandable to a computer, it needs to be given more structure than it currently has. If you choose rows and columns to hold related information and then fill in the blanks, the computer will be able to process the data with speed and efficiency.

Part I: Perform the following operations using the worksheet provided:

  1. Make a duplicate of the worksheet called “Report,” and save it using the following naming scheme: FirstInitialLastName_week1IPa (e.g., MRogers_week1IPa.xls).
  2. Make the new worksheet labeled “FirstInitialLastName_week1IPa” the active sheet.
  3. Row 2 will be used to hold column names. Name the first column “Job Title.” Name the second column “Full Name.” Name the third column “Manager.”
  4. Select and move the data in columns B and C to the left so that it aligns with the CEO data. Keep the data in the same rows, even if there are blanks separating them.
  5. Move the two job titles that are now in Column B left so that they are now in Column A.
  6. Move the group of software analyst names left to Column B. Do the same for the group of customer service representatives.
  7. Use the Fill Down ribbon tool to copy the job title to each blank cell in Column A that is opposite a name.
  8. Populate Column C with the name of the corresponding manager for each employee. For the CEO, leave the corresponding Column C entry blank.
  9. Set the column widths of Columns A, B, and C to best fit the data.
  10. Column D should be blank. Delete Column D.

Part II: One of the most common worksheet functions is SUM. Perform the following operations on the FirstInitialLastName_week1IPa worksheet:

  1. Unhide Columns D through P.
  2. Using the SUM function and Fill Right operation, create a row of sums of all columns that hold dollar amounts beneath the data rows. Boldface this row of sums.
  3. At the first blank column to the right of the data (this should be Column Q), name the column “Net Salary” in row 2.
  4. Using formulas and the SUM function, calculate the net salary, which would be the salary (Column E) minus all deductions (Columns F through P).
  5. Save the spreadsheet.


Comments

Post a Comment

Popular posts from this blog

Netanel (1996) talks about the NIEP theory approach to copyright and the democratic paradigm. Explain the difference between these in your own words. Lessig (2008) talks about read-only (RO) and read/write (RW) culture. How can copyright facilitate both of these?

chapter one Introduction A ‘‘Largely Ignored Paradox’’ The u.s. supreme court has famously labeled copyright ‘‘the engine of free expression.’’1 Copyright law, the Court tells us, provides a vital economic incentive for the creation and distribution of much of the literature, commentary, music, art, and film that makes up our public discourse. Yet copyright also burdens speech. We often copy or build upon another’s words, images, or music to convey our own ideas effectively. We cannot do that if a copyright holder withholds permission or insists upon a license fee that is beyond our means. And copyright does not extend merely to literal copying. It can also prevent parodying, remolding, critically dissecting, or incorporating portions of existing expression into a new, independently created work. Consider The Wind Done Gone, a recent, best-selling novel by African American writer Alice Randall. Randall’s novel revisits the setting and characters of Margaret Mitchell’s classic Civil War...
Post a Comment
Read more

How did life in the British colonies contribute to creating a unique American identity?

How did life in the British colonies contribute to creating a unique American identity? How do you see that identity manifested in modern American society? 200 to 300 words Click here for more on this paper ……. Click here to have a similar A+ quality paper done for you by one of our writers within the set deadline at a discounted Assignment status :  Solved by our Writing Team at EssayCabinet.com. MAKE YOUR ORDER
Post a Comment
Read more

Different types of teams found in the workplace

There are many different types of teams found in the workplace. However, no matter what label is assigned to the team, there are still fundamentals that make the team successful. The highest performing team is committed to a common goal and purpose as well as each individual’s success and personal growth. With that in mind, consider the following question that you get from a protégé you are mentoring:   We have various work groups on the plant floor. Some seem to work better together than others. Why is that? Use the library and Internet to research this topic so you can answer the question. Click here for more on this paper ……. Click here to have a similar A+ quality paper done for you by one of our writers within the set deadline at a discounted Assignment status :  Solved by our Writing Team at EssayCabinet.com. MAKE YOUR ORDER
Post a Comment
Read more