DePaul University Tour Expenses Excel Worksheet Hello, I need help making an excel following the instructions in the file attached. E1HmwkDir.docx su2020 G

DePaul University Tour Expenses Excel Worksheet Hello, I need help making an excel following the instructions in the file attached. E1HmwkDir.docx
su2020
Goal: To practice the beginning skills we have learned in Excel, use this list of instructions to create a
new Excel workbook. If I specify a cell reference – use that cell reference.
1. Type your full name in cell A1 and expand the column so that your name fits, without visually
overrunning the cell.
2. Put your birthday, the short date formatting version in cell A2 and copy down to cell A5, so that
your birthday is correctly displaying (copy, don’t fill)
a. Change the value in A3 to be formatted as long date formatting
b. Change the value in A4 to be formatted as Accounting, displaying no decimal places
c. Change the value in A5 to be formatted as a percentage, displaying no decimals
(See last page of these directions for finished picture)
3. Starting in Cell C2, type the following values:
4.
5.
6.
7.
Merge and Center C2 across C2:H2
In Column H: Calculate the sum down Column H: (remember to calculate once and fill)
In Row 9, Calculate the sum in D9and use the Fill function across the row (see picture)
Replicate the instructions for Row 9 by using the Average, Min and Max functions. See picture
below for correct calculations.
8. Format cells using Number and Font group tools, including applying Currency style, filling cells
with color and using borders on cells.
E1HmwkDir.docx
su2020
See next page
9. In Column J: type values and use fill function to complete:
10. In Column K:
• K1, type: Series Data
• K2: type 10
• K3: type 20
11. Use Fill or flash fill function to complete the series in Column K:
12. Make sure all columns are sized and formatted as my pictures.
SEE NEXT PAGE for complete finished picture
E1HmwkDir.docx
su2020
1. Type your full name in cell A1 and expand the
column so that your name fits, without visually
overrunning the cell.
2. Put your birthday, the short date formatting
version in cell A2 and copy down to cell A5, so
that your birthday is correctly displaying (copy,
don’t fill)
a. Change the value in A3 to be formatted as
long date formatting
b. Change the value in A4 to be formatted as
Accounting, displaying no decimal places
c. Change the value in A5 to be formatted as a
percentage, displaying no decimals
(See last page of these directions for finished
picture)
3. Starting in Cell C2, type the following values:
4. Merge and Center C2 across C2:H2
5. In Column H: Calculate the sum down Column
H: (remember to calculate once and fill)
6. In Row 9, Calculate the sum in D9and use the
Fill function across the row (see picture)
7. Replicate the instructions for Row 9 by using
the Average, Min and Max functions. See
picture below for correct calculations.
8. Format cells using Number and Font group
tools, including applying Currency style, filling
cells with color and using borders on cells.
9. In Column J: type values and use fill function
to complete:
10. In Column K:
K1 tine: Series Data
9. In Column J: type values and use fill function
to complete:
10. In Column K:
• K1, type: Series Data
· K2: type 10
· K3: type 20
11. Use Fill or flash fill function to complete the
series in Column K:
12. Make sure all columns are sized and
formatted as my pictures.
.

Purchase answer to see full
attachment