1102

Change the zoom of the SALES worksheet to 90%.

1106

Enter a function in the cell C9 of the SALES worksheet in order to calculate the sum of the cell range C5:C8.

1109

Enter the appropriate function in the cell C14 so as to calculate the maximum sales figure for January (cell range C5:C8).

1110

In the cell C15 enter a function which returns the word DELLA, if the content of the cell C5 is equal to the content of the cell C14; otherwise the formula returns the word other.

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.

1126

Change the type of the chart displayed on the active worksheet into 3D Clustered Column chart.

 

1139

Out of the Microsoft Office applications already opened, terminate Microsoft Excel only.

1154

Insert the following data on the active spreadsheet:

cell A1: 10
cell A2: 100
cell A3: 333
cell B1: kostas
cell B2: stelios
cell B3: despina

1162

Rename the Sheet3 worksheet to SheetFor2004 and delete the Sheet2 worksheet.

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.

1168

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

1181

Apply landscape orientation and Letter paper size on the active worksheet.

1195

Select the columns C, D, E, F and H.

1214

Using the pattern of the cell range A1:A2 reproduce the dates displayed up to the date 01/01/2005.

1227

Insert the appropriate function in the cell A1, to return the current date and time. Insert the appropriate function in the cell A2, to return the current date and time increased by 4 days (+ 4 days). Insert the appropriate function in the cell A3, to return the current date and time increased by 365 days (+ 365 days).

1231

Use the function date(), to insert the date 9 July 1968 in the cell C5.

1234

Change the size of the picture to 50% in height and to 120% in width in relation to its original size.

1236

Copy the cell range B4:E11 from the 2004 sheet to the same cell range in the 2005 sheet.

1253

Hide column C.

1258

Select the cell containing the word motherboard in the active worksheet.

1301

Go to the computer worksheet and decrease the height of the chart without moving it, so that the contents of the cell range B15:C15 may appear.

1304

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

1310

Insert in the cell C116 a function to count the total of cells containing numbers within the cell range C3:C110.

1671

Use the appropriate function in the cell G12 to calculate the average of the values displayed in the cell range G5:G10.

1909

Calculate the quotient of the division of the cell O2 value by the cell O22 value, in the cell P2, using absolute reference to the appropriate cell.

11042

What problem does the following list present?

11044

The correct way to calculate a sum is displayed in cell…

11407

How can we open the Help window of the application?

11773

A nice practice we can apply when naming worksheets is to...

12898

Click on the appropriate point of the photo to display the print preview of the worksheet already opened.