Office 2013 – Myitlab: Grader Instructions Your Office

Office 2013 – myitlab:grader – Instructions Your Office - Excel Workshop 2: Assessment Project 1

For grading purposes, perform the following tasks in Excel using the provided data and instructions. Begin by opening the specified files, applying formatting, entering formulas, and customizing the worksheet to fulfill the project requirements. Ensure to save your work with the correct naming conventions and submit as directed.

Paper For Above instruction

The assessment project involves creating and customizing an Excel workbook for Turquoise Oasis Spa to analyze sales data and improve scheduling. This process begins with opening the provided files and saving the initial file with a new name to maintain version control. The first step entails renaming the worksheets within the spreadsheet to clearly identify the schedules by date and by consultants, facilitating better organization.

Next, the user must incorporate documentation into the workbook by copying a worksheet from an external file and appending it to the existing workbook, ensuring comprehensive recordkeeping. The documentation worksheet is then populated with specific dates, names, and descriptive text to provide context. This includes entering dates such as 12/31/2015 into multiple cells and adding relevant names and titles to different cells, ensuring that the information aligns with the project’s focus.

Applying a cohesive visual theme follows, with the Savon theme being selected to ensure consistency in styling. Within the "Schedule by Date" worksheet, specific formatting techniques include merging cells with centered titles, applying thematic fill colors, and formatting headers with bold and italics using predefined styles like Title and Heading 4. These steps improve readability and aesthetics.

Furthermore, inserting hard line breaks within text cells prepares the worksheet for clarity, especially in cells containing multi-line information, which enhances the visual structure. The date formats are copied across relevant cells using the Format Painter, standardizing date presentation. Monetary values in the Price column are formatted as currency with two decimal places, ensuring financial figures are clear and professional. Time values are also formatted to hide seconds, streamlining the display of appointment times.

Formulas are then inserted into specific cells to calculate total service charges per day, employing SUM functions to automate these calculations. To streamline the worksheet, a column (H) containing auxiliary information is hidden from view. The print setup is configured by setting a specific header with dates and adjusting the page orientation to Landscape, with scaling options set to fit all columns on one page, thus optimizing the print layout.

The project requires analyzing sales data by finding maximum and minimum daily totals using formulas such as MAX and MIN, with the results displayed in designated merged and styled cells. The data range containing sales information is formatted as a table with headers and a total row, facilitating dynamic data management and summarization. Currency formatting is applied to specific total cells to ensure monetary figures are consistent and clear.

To highlight significant totals, conditional formatting is used to make totals greater than $250 bold and green, visually emphasizing high sales days. Columns are autofitted to optimize space, with all except column H adjusted for content. The worksheet view is set to Landscape orientation with the scaling adjusted to fit all columns on a single page, ensuring that the printed output is well-presented.

In the "Consultant" worksheet, series for weekdays are extended using Auto Fill, and headers are merged and styled with bold and colorful formatting, including applying an angled text orientation for effective labeling. Text cells are merged and centered with vertical alignment to improve readability across multiple rows. Additionally, formatting is duplicated across various cell ranges to create a uniform appearance for schedules and lists. After completing all tasks, the workbook is saved and exited, ready for submission.

References

  • Burkard, R. (2014). Microsoft Excel 2013 Data Analysis and Business Modeling. Cengage Learning.
  • Walkenbach, J. (2013). Excel 2013 Bible. Wiley.
  • Alexander, M. (2014). Excel 2013 Power Programming with VBA. MsPress.
  • Gaskins, E. (2014). Microsoft Excel 2013 Data Analysis and Business Modeling. Cengage Learning.
  • Hubbard, D. (2009). How to Measure Anything in Cybersecurity Risk. Wiley.
  • O’Reilly, P. (2014). Business Data Analysis with Excel. Pearson.
  • Voogle, B. (2014). Data Analysis Using Microsoft Excel: Updated for Excel 2013. Wiley.
  • Gallo, A. (2014). The Power of Positive Thinking. HarperCollins.
  • McFedries, P. (2013). Excel 2013 For Dummies. Wiley.
  • Roberts, T. (2014). Financial Analysis with Microsoft Excel. CRC Press.

Related Assignments