1223 Display the sales of the Della company in the cell Â8 of the vlookup worksheet, with the use of the function vlookup. You will find the sales of the company in the SALES worksheet. Then reproduce the function up to the cell B12. 1224 Display the representative of the Della company in the cell B8 of the hlookup workbook using the hlookup function. Representatives of companies are displayed in the SALES worksheet. Then reproduce the function up to the cell G8. 1225 Use the Lookup function to display in the cell C20 the value of the Column C that corresponds to the letter of the Column A, according to the letter displayed in the A20 cell. The table range is A1:C18. 1226 Format the cell range B1:B10 so that numbers are displayed with 4 decimal places and a thousand separator. Then insert the appropriate function in this cell range to display the difference in days between the date in column A and the current date and time. 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). 1228 Insert an appropriate function in the cell Ε2 to return the date for the values of the cell range A2:C2. Reproduce the function in the cell range Ε3:Ε11. 1229 Insert an appropriate function in the cell C3 to return a date using the year appearing in the cell C2, the month appearing in the cell Β3 and the 1st day of the month. Reproduce the function in the cell range C3:G14 using the same pattern. 1231 Use the function date(), to insert the date 9 July 1968 in the cell C5. 1241 Use the sumif function in the cell E15 to calculate the total points received by Gladbach . 1246 The cell range G3:H8 displays teams and countries of origin. Insert a function in the cell D2 to return the country name for the specific team. Then, reproduce the function in the cell range D3:D21. 1294 Enter the appropriate data in the cell range Α4:J5 and use the right function in the cell A1, to sum the TotalValue of Maria Anders orders (for total order values higher than 1000) and the sum of Thomas Hardy orders (for total order values less than 1000). 1539 Insert your birthday date in the cell A1. Insert a function in the cell A2 that always displays the current date. Insert a function in the cell A3 that displays the number of the days you have lived. Format the cell A3 in Number category with a thousand separator and without decimals. 1540 In the cell range B2:D21, insert the appropriate functions so that column B displays the day of the date appearing in column A, column C displays the month of the date appearing in column A, column D to displays the year of the date appearing in column A. 1547 Insert the appropriate functions in the cell range G5:G10 to calculate the future value of an investment based on periodical, regular payments and stable interest rate. Necessary data are provided in the cell range B5:F10. 1548 Insert the appropriate functions in the cell range G5:G10 that return the monthly payments for a loan based on regular payments and stable interest rate. Necessary data are provided in the cell range B5:F10. 1549 Insert the appropriate functions in the cell range G5:G10 that returns the present value of an investment based on future payments using current values. Necessary data are provided in the cell range B5:F10. 1550 Insert the appropriate function in the cell G5 that returns the net present value of an investment based on an annual discount rate and a series of future payments (negative values) and incomes (positive values). Necessary data are provided in the cell range B5:F10. 1551 Insert the appropriate functions in the cell range F5:F10 that calculate the interest per period. Necessary data are provided in the cell range B5:E10. 1552 Insert the appropriate function in the cell Ε3 that returns the value TRUE if the content of cell A3 is greater than 10 and the content of cell B3 is greater than 10 and the content of cell C3 is greater than 10 and the content of cell D3 is TRUE. Otherwise the function should return the value FALSE. Reproduce that function up to the cell Ε50. Finally, insert a function in the cell Ε1 that returns the value TRUE if the value TRUE is displayed at least once in the cell range E3:E50. (use only the AND and OR functions)