Topic 9 and 10 due in 12 hours

Instructions:

Create an Excel file according to the instructions below. Save the changes to the file, and upload to Moodle.

Q1) Start MS Excel, on the New/Templates screen, click on Blank workbook and create a spreadsheet that is identical to the one below (minus the at top-right):

Guidelines:

1) (2 pts) Font = Times New Roman for all

2) Font size:

a. (2 pts) Pam’s 2016 Expenses header, in black, bold and size = 15

b. (2 pts) Expense category headers and month, in red, bold and size = 12

c. (2 pts) Bold total amounts

3) (2 pts) Dollar values format = Currency (no cents; whole dollar)

4) (2 pts) Center expense category headers and expense values in columns B thru F

5) (2 pts) Left justify months in column A, right justify totals in column G

6) (2 pts) Select similar cell shading colors to image below – don’t have to be exact color identical

7) (2 pts) Select cell border similar to image below

8) (2 pts) Use the Sum function to add the totals

Q2) Save as MSExcel File-1.xlsx

Q3) Upload Excel file to Moodle.