microcomputer-applications-4

1. In your own words, name at least three different file formats you can save Excel files in, and describe why you would use the different formats. Please count your words and do not use citations.

Please ensure your word count for the discussion response is at least 250 words, and you provide two scholarly sources.

2. Prepare a paper, which should be no more than two pages in length, which describes 3 features presented in unit 3â€s reading and how you can apply those features to your daily life.

3. Using Microsoft Excel or Excel online, complete Project 2-4 starting on page 58 in unit 3’s reading. Submit to the dropbox when finished.

4. Where would you go in Excel to save, select a template, change document properties, and close or exit Excel?

5. In Excel, which dialog box in Backstage view should you access to view and alter your workbookâ€s properties?

6. In Excel, what is a predesigned file that already has a significant amount of formatting, text, and other features?

7. Using Microsoft Excel or Excel Online, design and create a spreadsheet that organizes your total estimated personal expenses (including rent or house payments, car payments, loan payments, and other items on which you spend money) 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.

8. Building on the spreadsheet you created in question #6; 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 (you will add together your expenses for each of the twelve months, and then add together your income for each of the twelve months).

9. 8. Using the spreadsheet from questions 6 and 7. 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.

Total word count excluding number 1 must equal 1200 words. All must be cited in APA format according to APA template uploaded and referenced in APA format.

 

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code “Newclient” for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

The post microcomputer-applications-4 appeared first on Affordable Nursing Writers.