tech

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! The assignment must be completed by Thursday March 7, 2019 at 2:30PM central time. MUST BE SUBMITTED ON TIME MEETING ALL EXPECTATIONS! 

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.