Assignment
1. Prepare a paper describing all of the key terms listed below, and how they can be beneficial for creating and modifying Excel worksheets.
Key Terms: Auto Fill, Auto Complete, copy, cut, fill handle, Flash fill, formula bar, keyword, label, move pointer, Office Clipboard, paste, range, selecting text, workbook properties.
2. Where would you go in Excel to save, select a template, change document properties, and close or exit Excel?
3. In Excel, which dialog box in Backstage view should you access to view and alter your workbook's properties?
4. In Excel, what is a predesigned file that already has a significant amount of formatting, text, and other features?
5. Using Microsoft Excel or Excel Online, design and create a spreadsheet that organizes a total of estimated personal expenses (such as rent or house payments, car payments, loan payments, and other items on which money is spent) by month for a twelve-month period. This can be fictional data, as long as it's realist data. Format the cells using the accounting number format, and add a worksheet title in cell A1. Merge and center cell A1 across the top of your worksheet, and format the text appropriately to give it a professional appearance.
6. Building on the spreadsheet you created in question #5; add your monthly income over the last 12 months. This can be fictional data, as long as it's realist data. You may need to change your worksheet title to reflect this additional information. Format the monthly income using the accounting number format. Use the SUM function to calculate your total expenses, as well as your total income (add together expenses for each of the twelve months, and then add together income for each of the twelve months).
7. Using the spreadsheet from questions 5 and 6. Use the AVERAGE, MAX, and MIN functions to determine the following:
- Use the AVERAGE function to determine your average monthly expenses
- Use the AVERAGE function to determine your average monthly income
- Use the MAX function to determine how much you spent during the month when your monthly expenses were the highest.
- Use the MAX function to determine how much income you received during the month when your monthly income was the highest.
- Use the MIN function to determine how much you spent during the month when your monthly expenses were the lowest.
- Use the MIN function to determine how much income you received during the month when your monthly income was the lowest.
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.