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 E2 to return the date for the values of the cell range A2:C2. Reproduce the function in the cell range E3:E11.

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. Use the VLOOKUP function

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 E3 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 E50. Finally, insert a function in the cell E1 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)