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

Explain why HAMILTON is considered “a cultural monument?”

  Module 7: Theatre Now: Steps Toward Diversity Chapter Questions Read Chapter 9 “Musicals of the Twenty-First Century” (pages 244 to 246) and Chapter 10 (pages 247 to 260) in your textbook. Choose only 5 of these questions to answer. Write your answers in your own words; if you choose to quote from the textbook, remember to identify the source. Question # Chapter Questions 1 9 Explain how Broadway musicals have changed in the 21st century. 2 9 Explain why HAMILTON is considered “a cultural monument?” 3 10 Identify the current focus/topics of the American theatre’s social awareness. 4 10 Give an example of how current theatre is addressing inequality in each of these areas: (a) gender and sexuality (b) racism (c) access to theatre for people with disabilities 5 10 How has theatre moved from its pre-1960s attitude that plays must not be open about the Love that dare not speak its name? [This expression was first used by Lord Alfred Douglas in his 1894 poem, “Two Loves” written in refere
Post a Comment
Read more

CBS Undercover Boss website

  Go to the CBS   Undercover Boss   website and search for a full episode of the show. Imagine you are the CEO of the company in the selected episode.  please do this with 2 pages Provide a detailed comparison of two job positions from the episode. Perform a job analysis of each position. Provide a clear, detailed description of your method of collecting the information for the job analysis. Examples include one-on-one, interview, or survey. Create a detailed job description from the two positions you analyzed. Provide clear, conclusive rationale for why the job analyses and job descriptions comply with state and federal regulations. Support your propositions, assertions, arguments, or conclusions with at least three credible, relevant, and appropriate sources synthesized in a coherent analysis. Cite each source on your source list at least once within your assignment. For help with research, writing, and citation, access the  library  or review  library guides . Write clearly and conc
Post a Comment
Read more