subject

1. Open a new workbook in Excel. 2. Save the file in the C:/Computer Literacy/Student/Unit_4 folder. Save it as Unit_4_Assignment_1_YourName where YourName is your full name. For example, if your name is Ben Smith, the file name would be Unit_4_Assignment_1_BenSmith. 3. Enter the following data in row 1 to create the top headers for your budget: a. Enter January in cell B1. b. Enter February in cell C1. c. Select cells B1 and C1, select the fill handle in the lower-right corner of cell C1, and then extend the selection to cell M1 to fill the range with month names. d. Enter Total in cell N1. 4. Enter the following data in column A to create the left-side headers for your budget. a. Enter Lunch money in cell A2. b. Enter Transportation in cell A3. c. Enter Movie tickets in cell A4. d. Enter Clothes in cell A5. e. Enter Haircut in cell A6. f. Enter Restaurants in cell A7. g. Enter Total in cell A8. 5. Adjust the column widths as necessary so that all text is visible and not overlapping other cells 6. Select the range A1:N1, and apply a border format to the bottom border of the range. 7. Select cell N1, and apply the bold format. 8. Select the range N1:N7, and apply a light green color to the range. 9. Enter an estimate of the cost of each item in your budget for each month of the year. 10. Select the range B2:M7, and apply the Accounting Number format to the selected range. 11. Insert two rows above the current row 1. 12. In cell A1, enter the current date and format it with the 14-Mar-2012 date format. 13. Select cell N4 and enter the following formula: =SUM(B4:M4) 14. Copy the formula in cell N4 to the range N5:N9. 15. Select cell B10 and enter the following formula: =SUM(B4:B9) 16. Select cell B10, then select the fill handle and extend the selection right to M10. 17. Select the range A10:M10, and apply the Total cell style. 18. In cell A12, enter the text Annual Average, and apply bold format. 19. In cell B12, enter the following formula: =AVERAGE(B10:M10) 20. Select the range A4:M9, and sort the data alphabetically a to z

ansver
Answers: 1

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 13:00
Which option should u select to ignore all tracked changes in a document
Answers: 1
question
Computers and Technology, 23.06.2019 13:00
Which one of the following voltages should never be measured directly with a vom? a. 1200 v b. 500 v c. 800 v d. 100v
Answers: 2
question
Computers and Technology, 24.06.2019 10:00
When writing a business letter, how many times can you use the same merge field in a document? once once, unless using the address block feature unlimited it will depend on the type of document you choose
Answers: 1
question
Computers and Technology, 24.06.2019 15:00
In excel, what happens to the cell contents when you click and drag a cell into multiple cells?
Answers: 1
You know the right answer?
1. Open a new workbook in Excel. 2. Save the file in the C:/Computer Literacy/Student/Unit_4 folder....
Questions
question
Mathematics, 02.02.2021 14:00
Questions on the website: 13722359