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.
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.
Navigate to the cell E11 and display the total of the cells displaying numbers in the cell range E6:E9.
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.
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.
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.
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.
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.
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.
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.
Enter a function in the cell A1 to display the current date.
Display the values of the cell range A1:A20 in the cell range B1:B20 using a rounded up with 2 decimal places.
Display the values of the cell range A1:A20 in the cell range B1:B20 using a rounded down with 2 decimal places.
Display the first three letters of the entries in the cell range A1:A20 in the respective cell range B1:B20.
Display the last three letters of the entries within the cell range A1:A20 in the respective cell range B1:B20.
Display the second to fifth letter of the entries of the cell range A1:A20 in the respective cell range B1:B20.
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.
Enter the appropriate function in cell C1 to return the ascending order of the number 18 (cell A3) within the cell range A2:A17.
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.
Enter the appropriate function in the cell G1 to return the average of sales over 100€ effectuated by salesman Goutoudis.