|Total of questions: 232|
|Total of questions: 232|
|First steps (3 Fragen)|
|Basic Settings (19 Fragen)|
|Cells (4 Fragen)|
|Formulas and Functions (34 Fragen)|
|Formatting (11 Fragen)|
|Charts (21 Fragen)|
|Special functions 1 (20 Fragen)|
|Special functions 2 (19 Fragen)|
|Images (3 Fragen)|
|Data (30 Fragen)|
|Sortings, Filters, Macros, Templates (17 Fragen)|
|DIPLOMA level questions (6 Fragen)|
|MS Excel Expert 2016, 2013, 2010, 2007, 2003 (BENCHMARK) (30 Fragen)|
|MS Excel Expert 2016, 2013, 2010, 2007, 2003 (ASSESSMENT) (15 Fragen)|
Enter the appropriate function in the cell B1, so that if the value in the cell (A1) is higher than 5000, the function will return 1. If the value in the cell A1 is less than or equal to 5000, the function will return 0. Reproduce the function up to the cell B10.
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).
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.
Move the active image so that the top left corner is in cell D7.
Calculate the subtotals of the turnover, for each change in Geographical Direction within the cell range A3:C19.
Hide the COMPUTERS worksheet.
There is a comment in the cell K9. Replace the text with the following one Total for all
Run mymacro in the cell B4.
Format, automatically, the cell range A1:A100 to display numbers with two decimal spaces and a thousand separator, if they are higher than zero. If they are less than zero, numbers will be displayed with three decimal places and a thousand separator in red font color. If they are zero, the word Zero will be displayed in green font color.
Use custom number formatting.
Move the legend on the top of the chart appearing on the 2ndhour2 worksheet. Then, change its width to the maximum.
Insert the appropriate function in the cell A1 that returns how many times the value CPU is displayed in the cell range A3:A50. Insert the appropriate function in the cell B1 that returns the count of cells containing values less than or equal to 20 in the cell range B3:B50.
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 C14 of the active worksheet and insert there the appropriate function to display the average of the values of the cell range D6:D9.
Use the word code as password to protect the cell range B5:B24. Make sure the rest of the cells allow for data entry.
Open the Report.xltx template located in the IL-ates\Excel folder on your Desktop. Correct the formulas entered in cells C32 and D32 and save the template as Report2.xltx to the same folder.