Business
In daily life, you solve all sorts of problems, such as which car purchase makes the most exonomic sense when comparing purchase price, mileage, and maintenance, or which software package will help your bikign club manage its fnds, plan road trips, and keep memberships up to date. To solve these and other problems, you need to collect data that tracks the current situation, determine your ultimate goal, and then follow a logical progression to the best solution. Developing an excel table can help you trck the data you need to solve such problems.
In this excercise you need to slect an activity in which you participate or an organization to which you belong, and identifty a one-time or process-orented problem that needs to be solved. Then create a worksheet and develop an Excel table to track relevant data and create a solution to the problem.
1. Identify a problem to solve. This can be a one-time problem, such as a car pruchase or a process-oriented problem, such as tracking membership data for a club to which you belong. Determine feasible alternatives to solve the proglem, and then collect the data you need to evaluate these alternatives.
2. Plan the organization of your workbook and the excel table you will devleop based on how you will use the data. Consider the outputs you want to create, and the fields needed to produce those outputs. Decide what each record represnets (such as data on a participant) and then identify the fields and field names (such as last name, first name, birth date, and so on) which in each record. What calcuations will you need to preform? How do you want to formate the information?
3. Create a doumation worksheet that includes name, the date, and the purpose of our workbook. include a data definition table to document the fields in each record. Formate the worksheet appropriately.
4. Create an Excel table to track the data needed to solve the problem you identified. Enter an appropriate table name and column headers. Add one or more calculated columns to the table to preform calculations on the data that you will use to solve the problem.
5. Improve the appearance of the table by using appropriate formatting.
6. apply validity chekcs to improve the accurancy of data entry.
7. Add records to the table.
8. apply conditional formatting to at least one column in the table to visually highlight some aspect of the data that will help you evaluate the solve problem.
9. Add a comment to the column with the conditional formating to explain what the conditional formatting shows and how it wil help you to evaluate and solve the problem.
10. Insert a total row in the table, and then make appropriate summary calculations that you can use an evaluate and solve the proglem.
11. Divide the table into two horizontal panes- one for the dta and one for the Total row.
12. sort the dtat in a logical way
13. Use a filter to answer a question about the data to help you evaluate and solve the problem.
14. Crete a PivotTable an da PivotChart to analyze the data. Format filter and sort the PivotTable appropriately.
15. In a word doument, explain the probelm you solved, identify the alternatives you considered, doument the data you collected to evaluate the alternatives, and then describe the results of your annalysis. Include the PivotChart in the word document.
16. In an appropriate worksheet, insert a hyperlink that links to the word doument you created.
17. Create at least one macro to automate a repetivie task you need to perform in the workbook, such as printing or saving a worksheet as a PDF file.
18. Prepare your workbook for printing. Include headers and footers that idicate the filename of your workbook, the workbooks author, and the date on which the report is printed. If a printed worksheet will extend across several pages, repeat appropriate print titles across all of the pages, and include page numbers and the total number of pages on each printed page.
19. Save the workbook.