On the vlookup worksheet display the sales of the Della company, using the function vlookup in cell Â8. You will find the sales of the company in the SALES worksheet. Then reproduce the function up to cell B12.
Display the representative of the Della company in cell Â8 of the hlookup workbook using the hlookup function. Representatives of companies are recorded in the SALES worksheet. Then reproduce the function up to cell G8.
Display in cell C20, the value of cell Á20, in the column C of the table Á1:C18 by using the function Lookup.
(The answer may be different on the solution video because the cell values change every time you run TEST4U).
Format the cell range Â1:Â10 so that numbers are displayed with 4 decimal places, one leading zero and a thousands 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.
Insert the appropriate function in cell Á1, to return the current date and time. Insert the appropriate function in cell A2, to return the current date and time increased by 4 days (+ 4 days). Insert the appropriate function in cell Á3, to return the current date and time increased by 365 days (+ 365 days).
Insert a appropriate function in cell Å2 to return the date for the values of the cell range A2:C2. Reproduce the function in the cell range Å3:Å11.
Insert a appropriate function in cell C3 to return a date using the year appearing in cell C2, the month appearing in cell Â3 and the 1st of the month. Reproduce the function in the cell range C3:G14 using the same pattern.
Using the function date(), insert the date 9 July 1968 in cell C5.
Insert your birthday date in cell Á1. Insert a function in cell A2 that always displays the current date. Insert a function in cell A3 that displays the number of the days you have lived. Format cell Á3 in Number category with a thousand separator, one leading zero and without decimal places.
Use the appropriate function in cell G12 to calculate the average of the values displayed in the cell range G5:G10.
Use the appropriate function in cell J4 to calculate the average number of items sold in April.
Navigate to cell C14 of the active worksheet and use the appropriate function to display the average of values displayed in the cell range D6:D9.
Navigate in cell A8 and insert a function that returns the word Loss, if the income is less than expenses. Otherwise, the function will return the difference between income and expenses.
Use the appropriate function in cell C8 to display the value 198, if the cell C2 value is higher than or equal to 3000. Otherwise, the function will return the value 0.198.
Navigate to cell A8 and use the appropriate function to display the total of cells displaying numbers within the cell range A1:A6.
Navigate to 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 will return the text No.
Navigate to cell E11 and display the total of cells displaying numbers in the cell range E6:E9.