1115

Enter the text Computer Sales in the left section of the header of the SALES worksheet.

1117

Format the 2ndhour2 worksheet so that the second row is automatically printed at the top of each page.

1122

Extend automatically the pattern of the cell range A3:A4 to the cell range A5:A138

1128

Set the text Sales per Product as title of the chart displayed on the 2ndhour2 worksheet.

1130

Correct the error of the formula in cell D19 of the 2ndhour2 worksheet.

1131

Insert a new worksheet between the SALES worksheet and the 2ndhour2 sheet. Name it SALES 2003

1134

Select the cell range B1:K9 and set it as print area.

1140

Rename the sheets of the active workbook as follows:

Sheet1: Income

Sheet2: Expenses

Sheet3: Total

Insert the value 1000 in the cell A1 of the Income worksheet.

Insert the value 500 in the cell A1 of the Expenses sheet.

Display the difference between the value of the cell A1 of the Income worksheet and the value of the cell A1 of the Expenses worksheet (NOT 1000-500), in the cell A1 of the Total worksheet.

If the value of the cell A1 in the Income or in the Expenses worksheet changes, the value displayed on the Total worksheet should change as well.

1141

Insert a 3-D column chart in the Contest2 sheet to display the sales of the four companies for August, as they appear on the SALES worksheet. Change the color of the columns to blue, the shape of the columns to Full Pyramids (2) and the chart depth to 150.

1142

Sort all data of the Competiton1 worksheet firstly by Salesman then by District and lastly by Total. All fields should be sorted in ascending order. Then format the Total field so that the cells displaying a value less than or equal to 1000 are displayed in red font color.

1151

Change the settings of the application as follows:

User Name: kostas

Number of Recent Documents: 9

and make the formulas visible.

1163

Set the order of the sheets as follows:

1) mySheetFor2004

2) mySheet2

3) mySheetFor2005

4) mySheet1.

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

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)

1173

Set the following fill effects in the active chart:

Gradient fill: color 1: red and color 2: White, Background 1

Type: Linear and

Direction: from red (top) to white (bottom).

The chart should not display any borders.

1175

Change the color of the active pie chart as follows:

RAM Memory to Black, Text 1

Hard Drive to Red,

Screen to White, Background 1

 

1180

Set the margins of the active worksheet as follows:

Top: 1,5", bottom: 1,5"
Left: 0,5", right: 0,5"
Header: 0,75", footer: 0,75"

1189

Given that sales equal to beginning pieces + supplies - end pieces - destroyed pieces, enter a formula in the cell range F7:F9 that returns the sales for each product.

Enter a formula in the cell range H7:H9 that returns the sales value in Drachmas and use the result to calculate the sales value in Euros in the cell range I7:I9. (the euro-drachma exchange rate is provided in the cell G2)

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.

1204

Modify the footer of the SALES worksheet so that the current date is printed on the left section. Also modify the footer of the 2ndhour2 worksheet so that the current time is printed on the right section.

1208

Save the active workbook, as Text (Macintosh) type, under the name myMac.txt in the IL-ates\Excel folder of your desktop.

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).

1289

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

1297

The cell G9 displays the cost of the RAM memory in euros. Calculate the cost of the RAM memory in dollars in the cell H9 taking into account the euro to dollar exchange rate displayed in the cell E19. Then reproduce the formula in the cell range H10:H17.

1298

Adjust automatically the width of the second (B) column and the height of the seventh (7) row of the active sheet.

1300

Align the text COMPUTER SALES of the cell B1 horizontally at the center of the cell range B1:J1 without merging the cells.

1543

Insert the appropriate function in the cell range B1:B50 that rounds the values of column A to 4 decimal places. Insert the appropriate function in the cell range C1:C50 that rounds the values of column A to 2 decimal places. Insert the appropriate function in the cell range D1:D50 that rounds the values of column A to the left of the decimal point.

1706

Use the appropriate function in the cell C8 to display the value 198, if the cell C2 value is higher than or equal to 3000. Otherwise, the function returns the value 0.198.

1880

Use the proper function in the cell B1 to count the blank cells in the cell range A1:A400.

1882

Display the percentage data labels on the active chart.