Description
Hello,
I need someone experienced with Excel to help complete a homework assignment for my online class. Attached to this question are various images that will help you navigate the website. You will have full access to the website, and can use the resources in the Course Content folder.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Here is the excel
1)
Copy Me
Copy Me
2)
3)
Cut Me
Sum the array of numbers in G8 then copy the below array of numbers
5
7
55
44
16
Select Cells B8 to E8 & Paste Special Transpose in cell B10
5 * to transpose right-click and select the 4th item under Paste
7
55
44
4)
Select cell B17, click format painter, and click on cell B19
Format Painter(cell width)
Style
5)
6)
Put the described border on the columns below
Left Border
Right Border
Top Border
Bottom Border
Outside Border
Thick Box Border
For cell B34 create a dashed border by clicking on more borders
Dashed Border
127
Fill m
hello
6)
Fill me yellow
Fill me red
10)
Go to more colors and create custom color
7)
Text color red
Text color green
Go to more colors and create custom color
11)
8)
Use the alignment buttons to change the following
Center me!
To the left!
12)
To the right!
Custom Date (day/mo only)
9)
Use the alignment buttons to change the following
Top
Center
Bottom
de
gr
ee
s
m
e4
5
Rotate me up
Ro
ta
te
Indent me two spaces
Unindent me
I take up too much
space, wrap me!
13)
*Row 11 should be TALLER now
I take up too much space, merge me!
*L13 with M13 and N13
Number
Currency
Percentage
More Decimals (8)
Less Decimals (1)
Fraction
Short Date
L...