5407

Top align the contents of the cell E1.

5408

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

5409

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

5410

Format the numbers of the cell range L5:L9 to be displayed as percentages with one decimal place and one leading zero.

5411

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 left of the number, without decimal places and with one leading zero. If the cell range contains any negative values, they should display in red color, without a negative sign.

5412

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

07/13/2013

13. July 2013

July 13, 2013

07/13/13 12:00 AM

5413

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.

5414

Apply the following formatting to the active worksheet:

Cell A1: bold writing,

Cell A2: italics,

Cell A3: underlined writing,

Cell A4: double underlined writing.

5415

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: red

Cell A5: Fill color: black

5416

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

5417

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 middle and horizontally to the left,

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

5418

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

5419

Aplly the following allignment-orientation in the active worksheet :

Cell Á1: rotation by 45 degrees,

Cell Á2: rotation by 270 degrees,

Cell Á3: rotation by 90 degrees,

Cell Á4: vertical orientation (vertically stacked)

5420

Copy the formatting of cell C2 to cell B2.

5421

Apply the following border format to the active worksheet:

Cell B2: All four borders, with single continuous line of 5pt width

Cell B4: Upper and bottom double line of 2,6pt width

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

5422

Apply the following formatting to the active worksheet:

Cell B2: Outline border with a 1pt red continuous line

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

Cell B10: Remove the background only.

5423

Format the cell range A1:A10 so that numbers are displayed in Number category with a thousand separator, one leading zero and 2 decimal places.

Format the cell range B1:B10 so that that numbers are displayed in Number category without thousand separator, one leading zero and with 4 decimal places.

5424

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

5425

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

5426

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

5427

Remove any formatting from cell E1.

5428

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

5429

Apply 1,10pt double line on top and bottom borders in cell A3 of the active spreadsheet.

5430

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

5431

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

5432

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

5433

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

5434

Rotate the contents of cell A1 by 45 degrees.

5435

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