Change the zoom of the SALES worksheet to 90%.
Enter a function in the cell C9 of the SALES worksheet in order to calculate the sum of the cell range C5:C8.
Enter the appropriate function in the cell C14 so as to calculate the maximum sales figure for January (cell range C5:C8).
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.
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.
Change the type of the chart displayed on the active worksheet into 3D Clustered Column chart.
Out of the Microsoft Office applications already opened, terminate Microsoft Excel only.
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
Rename the Sheet3 worksheet to SheetFor2004 and delete the Sheet2 worksheet.
Apply the following formatting to the active worksheet:
Cell A1: bold writing,
Cell A2: italics,
Cell A3: underlined writing,
Cell A4: double underlined writing.
Copy only the formatting of the cell range A1:A5 and paste it to the cell range D7:D11
Apply landscape orientation and Letter paper size on the active worksheet.
Select the columns C, D, E, F and H.
Using the pattern of the cell range A1:A2 reproduce the dates displayed up to the date 01/01/2005.
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).
Use the function date(), to insert the date 9 July 1968 in the cell C5.
Change the size of the picture to 50% in height and to 120% in width in relation to its original size.
Copy the cell range B4:E11 from the 2004 sheet to the same cell range in the 2005 sheet.
Hide column C.
Select the cell containing the word motherboard in the active worksheet.
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.
Format all borders of the cell range B5:J9 with a single continuous line of automatic color.
Insert in the cell C116 a function to count the total of cells containing numbers within the cell range C3:C110.
Use the appropriate function in the cell G12 to calculate the average of the values displayed in the cell range G5:G10.
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.
What problem does the following list present?
The correct way to calculate a sum is displayed in cell…
How can we open the Help window of the application?
A nice practice we can apply when naming worksheets is to...
Click on the appropriate point of the photo to display the print preview of the worksheet already opened.