Reference no: EM132250737
Assignment
Answer the assigned questions completely and in narrative, third person format. The paper consist of 1000 WORDS. Also, include at least three (3) scholarly sources in your responses. Paper must be completed in APA format. NO PLAGIARISM!
1. Using APA guidelines (be sure to cite your sources) 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, AutoComplete, 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.