1692

Navigate to the cell A8 and insert there a function that returns the word Loss, if the income is less than expenses. Otherwise, the function returns the difference between income and expenses.

1742

Navigate to the cell B10 and use the appropriate function to display the text YES, if the price of the item SCREEN is less than 115. Otherwise, the function returns the text NO.

1806

Navigate to the cell E11 and display the total of the cells displaying numbers in the cell range E6:E9.

1850

Navigate to the SALES worksheet and insert a function in the cell E9 which derives data from the cell range C5:C24, in order to calculate the sum of sales achieved by the salesman Lambropoulos.

1856

Enter the appropriate formula or function in the cell range E5:E9 to return the Surname and the Name of the client using a space between them.

1858

Enter the appropriate function in the cell G6 to return the sum of order quantities effectuated before 02/07/2004 for the products displaying the word VIPER in their description.

1865

Enter the appropriate function in the cell range F5:F16 to return the financial forecast for the year 2010, according to the criteria provided within the cell range I3:K6.

1866

Enter a function in the cell H3 to return the maximum quantity of the set1 item for the client Lambropoulos Stelios. Then, enter the appropriate function in the cell H4 to return the minimum.

1876

In the cell A1 of the active worksheet enter a formula to calculate the sum appearing in all the A1 cells of the worksheets a1 through a8.

1877

Enter a function in the cell range D4:H23 to return the interest amounts for the interest rates displayed in the cell range C4:C23 and for the loan amounts appearing in the cell range D3:H3.

1879

Enter a function in the cell A1 to display the current date.

1891

Display the values of the cell range A1:A20 in the cell range B1:B20 using a rounded up with 2 decimal places.

1892

Display the values of the cell range A1:A20 in the cell range B1:B20 using a rounded down with 2 decimal places.

1893

Display the first three letters of the entries in the cell range A1:A20 in the respective cell range B1:B20.

1894

Display the last three letters of the entries within the cell range A1:A20 in the respective cell range B1:B20.

1895

Display the second to fifth letter of the entries of the cell range A1:A20 in the respective cell range B1:B20.

1896

Display in the cell G1 the number of people from the cell range A5:E28 who were examined in Word and achieved a score higher than 90 points.

 

1914

Enter the appropriate function in cell C1 to return the ascending order of the number 18 (cell A3) within the cell range A2:A17.

1915

Enter in the cell B2 the appropriate function which will return the text appearing in the cell A2 deleting spaces before and after the name. Copy the function in the cell range Â3:Â4.

1916

Enter the appropriate function in the cell G1 to return the average of sales over 100€ effectuated by salesman Goutoudis.