Grader – Directions Excel 2019 Undertaking
Exp19_Excel_Ch04_Cap_Tech_Support
Undertaking Description:
You’ve got been employed as a scholar Helpant within the IT division of your College. As a part of your obligations, you might have been requested to boost the Excel workbook used to investigate the departments efficiency. The workbook accommodates information of all help points resolved over the previous 12 months. You’ll convert the info to a desk, format the desk, kind and filter the desk, insert calculations to judge key efficiency indicators, and put together the worksheet for printing
Steps to Carry out:
| Step | Directions | Factors Doable |
| 1 | Obtain and open the file named EXP19_Ch04_Cap_TechSupport.xlsx. Grader has robotically added your final title to the start of the filename. | zero |
| 2 | Freeze Panes so the primary row containing column headings (Row 5) on the SupportCalls worksheet will stay static when scrolling. Be certain that Rows 1-4 are seen. | 5 |
| three | Convert the info to a desk, title the desk SupportCalls, and apply the Gold, Desk Fashion Medium 12. | 13 |
| 4 | Take away duplicate information. | 6 |
| 5 | Add a brand new column to the desk named Length. | 4 |
| 6 | Create a formulation utilizing unqualified structured references to calculate the times required to resolve the incident (Date Resolved – Date Created). | 10 |
| 7 | Add a complete row to show the Common days required to resolve a difficulty. | 6 |
| eight | Type the desk by Agent Identify in alphabetical order, add a second degree to kind by Description, and create a customized kind order as follows: Is not going to energy on, Virus, Printing Points, Software program Replace, Forgotten Password. Add a 3rd degree to kind by Length smallest to largest. Mac customers, to create the customized checklist, from the Excel menu, click on Preferences. Within the dialog field, click on Customized Lists. | 12 |
| 9 | Filter the desk to solely show closed incidents as indicated within the standing column. | 10 |
| 10 | Use Fast Assessment to use the default Information Bars conditional formatting (Strong Blue Fill) to the Length column (vary I6:I85). Mac customers, on the Residence tab, click on Conditional Formatting, level to Information Bars, and beneath Strong Fill, click on Blue Information Bar. | 12 |
| 11 | Create a brand new conditional format that appliesRed fill andbold font to incident (vary A6:A85) that required 30 or extra days to resolve. Make sure you use relative cell references within the conditional format formulation. | 12 |
| 12 | Change web page breaks so web page 2 begins with the Laptop ID column (column E). | 2 |
| 13 | Set the print scale to 85%. | 4 |
| 14 | Add a customized footer along with your title on the left facet, the sheet title code within the middle, and the file title code on the precise facet. | 4 |
| 15 | Save and shut the workbook. Submit the workbook as directed. | zero |
| Whole Factors | 100 |
Created On: 10/14/2020 1 Exp19_Excel_Ch04_Cap – Tech Help 1.13
