1103

Top align the contents of the cell E1.

1111

Format the cell range C15:J15 to display a simple continuous line border on the top and bottom sides of the cell range.

1112

Format the cell range C22:J22 so that the numbers are displayed with a thousand separator and without decimal places. If there are negative numbers, they should be displayed in red color without the negative sign.

1113

Format the numbers of the cell range L5:L9 so that they are displayed as percentages with one decimal place.

1114

Format the cell range C20:J21 of the SALES worksheet so that the numbers are displayed with a thousand separator, the currency symbol is displayed on the right of the number and without decimal places. If the cell range contains any negative values, they should be displayed in red color, without the negative sign.

1164

Apply the appropriate date format to the cell range A1:A4, so that the date is displayed as follows:

6/13/2013

13-Jun-2013

June 13, 2013

6/13/13 13:20

1165

Apply the following formatting to the active worksheet:

Cell A1: Font: Arial, Size: 22,

Cell A2: Font: Times New Roman, Size: 20,

Cell A3: Font: Arial, Size: 10,

Cell A4: Font: Times New Roman, Size: 14.

1166

Apply the following formatting to the active worksheet:

Cell A1: bold writing,

Cell A2: italics,

Cell A3: underlined writing,

Cell A4: double underlined writing.

1167

Apply the following formatting to the active worksheet:

Cell A1: Font color: red,

Cell A2: Fill color: blue and Font color: yellow,

Cell A3: Fill color: black and Font color: white,

Cell A4: Fill color: Gray 25%,

Cell A5: Pattern style: thin vertical stripe, using fill color: white and pattern color: Gray 25%.

1168

Copy only the formatting of the cell range A1:A5 and paste it to the cell range D7:D11

1169

Apply the following alignment to the active worksheet:

Cell A1: to the center of the cell (horizontally and vertically),

Cell A2: to the top left corner of the cell,

Cell A3: vertically in the center and horizontally to the left,

Cell A4: horizontally at the center and vertically at the bottom.

1170

Merge the word Title in the cell range A1:D1 and apply center alignment.

1171

Aply the following alignment-orientation in the active worksheet:

Cell A1: rotation by 45 degrees,
Cell A2: rotation by -90 degrees,
Cell A3: rotation by 90 degrees,
Cell A4: vertical orientation (vertical text)

1188

Copy the formatting of the cell C2 and paste it in the cell B2.

1196

Apply the following border format to the active worksheet:

Cell B2: Outline border, thickest continuous line

Cell B4: Upper and bottom double thin line

Cell B10: Clear the outline border as well as the diagonal lines.

1197

Apply the following formatting to the active worksheet:

Cell B6: Outline border with a thin red continuous line

Cell B8: Right border line and bottom border line (both lines thick, continuous and blue color). Then add a diagonal line from top-left to bottom-right (thick line, continuous and blue color)

Cell B10: Remove the pattern and the background.

1219

Format the cell range A1:A10 so that numbers are displayed with a thousand separator and 2 decimal places (use the Number category).

Format the cell range B1:B10 so that numbers are displayed without thousand separator and with 4 decimal places (use the Number category).

1220

Format the cells A1:B10 so that numbers are displayed with a thousand separator, with 2 decimal places and in the default currency of the system (use the Currency Category).

1221

Copy the formatting of the cell range A1:E5 and paste it to the cell range G1:Ê5.

1222

Apply text wrapping to the cell A1 and unwrap the text appearing in the cell B1.

1274

Remove any formatting from the cell E3.

1285

Change the font to Arial at the cell A1 of the active worksheet.

1286

Apply double line style borders on the top and bottom at the cell B4 of the active spreadsheet.

1287

On the active spreadsheet apply white fill color in cell A4.

1288

Format the cell range C22:J22 so that the numbers appear with a thousand separator and without decimal places.

1289

Format the cell range C20:J21 of the worksheet SALES so that the currency symbol appears at the right of the numbers.

1292

Apply center (horizontal and vertical) alignment to the contents of the cell A1 of the active worksheet.

1293

Rotate the contents of the cell A1 by 45 degrees.

1304

Format all borders of the cell range B5:J9 with a single continuous line of automatic color.