Order ID:89JHGSJE83839 Style:APA/MLA/Harvard/Chicago Pages:5-10 Instructions:
The Excel MOS Associate Exam
Grader – Instructions Excel 2019 Project
MOS19_XL_PROJ5 – Charts 1.3
Project Description:
In this project, you will manage charts to meet objectives 5.1 through 5.3 of the Excel MOS Associate exam. To complete the project, you will create charts 5.1, modify charts 5.2, and format charts 5.3. Note: This project was created for PC users since the MOS Exam is completed in the PC user environment.
Steps to Perform:
Step Instructions Points Possible 1 Start Excel. Download and open the file named Student_MOS19_XL_PROJ5_Charts.xlsx. Save the file as Last_First_MOS19_XL_PROJ5_Charts. 0 2 Edit the chart to include the 4th Quarter data series. 8 3 Change the Rows/Columns so that the Departments are the Legend entries. 8 4 Resize the chart to the range B14:G30, ensuring that the chart is just inside the cells’ borders. 6 5 Insert a title for the chart and enter Government Expenses. 6 6 Add Alt Text to the chart and enter the description, Chart shows a comparison of government expenses for the first through fourth quarters. 10 7 Insert a 3-D Pie Chart comparing the Department Totals using Departments as the legend. The chart title will display as Department Total. 8 8 Move the Department Total chart to a new sheet and rename the sheet Pie Chart. 6 9 Apply Chart Style 3, and then apply Colorful Palette 3. 8 10 On the Expenses worksheet use Quick Analysis to apply Data Bars to the range F4:F11. Note, Mac users, apply Solid Blue Data Bars to the range. 8 11 Ensure that the chart is not selected. Insert a Right Block Arrow shape pointing to the Capital Projects data for the 4th Quarter of the Government Expenses chart. Position the shape in row 18 and resize the shape so that the Height is 0.20 and the Width is 1.07. Hint: 8 12 On the Pie Chart sheet, insert a Text Box in the Department Total chart. Position the text box in the pie shape to the right of the 29% data label. In the text box, type Largest percent, apply Bold to the text, and then resize the Text Box to Height 0.30 and Width 1.2. 12 13 Change the Chart Layout to 1. Use the snipping tool to take a rectangular snip of the Pie Chart Area including the title. Copy and then paste the snip in cell I2 of the Expenses worksheet. Resize the snip so that the upper left corner sits just inside the cell borders of I2, Height 5.91 and Width 6.67. 12 14 Ensure the worksheets are in the following order: Pie Chart, Expenses. Save and close Last_First_MOS19_XL_PROJ5_Charts.xlsx. Exit Excel. Submit the file as directed.
RUBRIC
Excellent Quality
95-100%
Introduction 45-41 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Literature Support
91-84 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Methodology
58-53 points
Content is well-organized with headings for each slide and bulleted lists to group related material as needed. Use of font, color, graphics, effects, etc. to enhance readability and presentation content is excellent. Length requirements of 10 slides/pages or less is met.
Average Score
50-85%
40-38 points
More depth/detail for the background and significance is needed, or the research detail is not clear. No search history information is provided.
83-76 points
Review of relevant theoretical literature is evident, but there is little integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are included. Summary of information presented is included. Conclusion may not contain a biblical integration.
52-49 points
Content is somewhat organized, but no structure is apparent. The use of font, color, graphics, effects, etc. is occasionally detracting to the presentation content. Length requirements may not be met.
Poor Quality
0-45%
37-1 points
The background and/or significance are missing. No search history information is provided.
75-1 points
Review of relevant theoretical literature is evident, but there is no integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are not included in the summary of information presented. Conclusion does not contain a biblical integration.
48-1 points
There is no clear or logical organizational structure. No logical sequence is apparent. The use of font, color, graphics, effects etc. is often detracting to the presentation content. Length requirements may not be met
You Can Also Place the Order at www.collegepaper.us/orders/ordernow or www.crucialessay.com/orders/ordernow Analyze the Water Footprint Results