Question: a . Format cell A 1 with the Title cell style. Format the range A 2 :A 3 with bold b . Change the width

a. Format cell A1 with the Title cell style. Format the range A2:A3 with bold
b. Change the width of the column A to 15. Change the width of columns B through D to 12
c. Merge and center the range A1:D1
d. In cell B2 enter the current date and then apply the Long Date Format
e. Merge and center the range B2:D2
f. In cell B3 enter 7:55 PM for the time and then apply the Time format
g. Merge and center B3:D3
h. Format the text in the range A2:D3 in 12 point Cambria
i. Wrap the text in C5
j. Format the range A5:D5 with the Accent 1 cell style and then bold and center the cells
k. Format the range B6:B9 in the Number format with a comma separator and no decimal places
Format the range C6:D9 with the Currency format with 2 decimal places
m. In cell B10 use the SUM function to add the total number of gallons sold and then format the cell with the Total cell style
n. In cell D10 use the SUM function to add the total sales and then format the cell with the Total cell style. Compare your worksheet to the Figure below
 a. Format cell A1 with the Title cell style. Format the

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!