Excel knowledge test Welcome to the Excel Knowledge test! Enter your information and answer the questions. You will receive the results immediately after the test on the e-mail address you enter below. Based on the test results it will become clear which Excel level best suits you. The system does NOT save any answers in case the test is finished early. Note: If you don't know an answer, check "I don't know the answer" for a correct result! Correctly guessing questions can give the wrong indication of your level. Fill in your details and start the test right away! Name Email Company / Business Phone number Excel Basis Question 1 How do you create the sequence below in Excel? You use a formula You type in the text manually You type January in cell A1 and drag down the fill handle of this cell Using the Sort button, retrieve the custom list Months All of the above answers are correct I don't know the answer Geen Excel Basis Question 2 Cell D20 is selected, which key combination will make A1 the active cell? CTRL + END CTRL + A CTRL + 1 CTRL + HOME CTRL + ENTER I don't know the answer Geen Excel Basis Question 3 What could the information below mean in a cell? The cell has incorrect formatting The column is not wide enough for the chosen number format The cell contains a wrong formula The row is too narrow None of the above answers are correct I don't know the answer Geen Excel Basis Question 4 Column A contains 50 product names. These product names should be removed so that an empty column remains. How can you do this? You select column A, right-click on the selection and choose delete You select the product names and use the Delete key You select the names and use the Backspace key You select the names, press space bar and then Enter I don't know the answer Geen Excel Basis Question 5 Columns A and B contain a list of products with prices excluding VAT. You want to put the prices including VAT (21%) in column C. How can you do this? You put a formula in C4: =B4+21% You select column C and press CTRL-V You put 21% in cell A1, a formula in cell C4: =A1*B4+A1 and copy the formula to the cells below None of the above answers are correct I don't know the answer Geen Excel Basis Question 6 In the image below, Cell C1 must contain the product (multiplication) of A1 and B1 using a formula. What is the correct formula to be used for this? =A1xB1 =SUM(A1:B1) =SUM(A1*B1) =A1*B1 I don't know the answer Geen Excel Basis Question 7 Which button allows you to copy the formatting of a cell? Image 1 Image 2 Image 3 Image 4 Image 1 Image 2 Image 3 Image 4 None of the images are correct I don't know the answer Geen Excel Basis Question 8 If you want to divide the value of cell A3 by the value of cell A4, what is the correct formula? =A3:A4 =A3*A4 =A3\A4 =A3/A4 I don't know the answer Geen Excel Basis Question 9 A row of numbers needs to be added, which button can you use for that? Image 1 Image 2 Image 3 Image 4 Image 1 Image 2 Image 3 Image 4 None of the above answers are correct I don't know the answer Geen Excel Basis Question 10 Column A contains a list of 20,000 product names. You want to move this to column B. How can you do this? Select the entire column A, move your cursor to the edge of the selection and drag the edge of the selection one column to the right Select Column A, click CTRL-X, click in cell B1 and use the key combination CTRL-V Select column A, right-click on the selection, choose Cut, right-click on cell B1 and choose Paste All of the above answers are correct I don't know the answer Geen Excel Basis Question 11 If you copy and paste using the keys CTRL-V is it possible to choose different paste options? Yes, before you paste Yes, while pasting Yes, after pasting No this is not possible I don't know the answer Geen Excel Basis Question 12 What do you delete when you press the Delete key after selecting a cell? The contents of the cell Everything, formatting and content The formatting of the cell Part of the formula I don't know the answer Geen Excel Basis Question 13 You want to remove an incorrect value in a large list so that an empty cell remains. How can you do this? Select the cell, right click and choose delete Select the column with the incorrect value, right-click and choose delete Select the cell and use the delete button I don't know the answer Geen Excel Basis Question 14 How do you select column A and row 1 at the same time? Clicking on column heading A and row button 1 Click on the column heading A and then click on the row button 1 while holding down the SHIFT key Click the column heading A and then click the row button 1 while holding down the ALT key Click the column heading A and then click the row button 1 while holding down the CTRL key I don't know the answer Geen Excel Basis Question 15 What is the result of the following formula: =10-5*3+5/2 10 2,5 -2,5 -7,5 None of the above answers are correct I don't know the answer Geen Excel Basis Question 16 You want to change a large piece of text in one cell because there is a typo. How can you do this? You click in the cell and type the correction and press Enter You click in the cell and give the copy command. Then paste the text into Word, correct the typo and copy and paste the typo into the Excel cell You double-click in the cell, type the correction and click Enter I don't know the answer Geen Excel Basis Question 17 What will be the cell contents if you enter the formula below exactly (including "") into a cell?"=5/12" "=5/12" 0,416667 It will display a month 5/12 I don't know the answer Geen Excel Basis Question 18 How do you get multiple lines of text in the same cell? (see example below) By using Shift – Enter By using the tab key Using the button Text Wrap By using the Alt-Enter key All of the above answers are correct This is not possible, you can only add this as an image I don't know the answer Geen Excel Basis Question 19 How do you quickly create the sequence of numbers 3, 6, 9, 12, 15 Place the numbers 3 and 6 in cells A1 and A2, select them and drag the selection's fill handle down Put the number 3 in cell A1, put the formula =A1+3 in the next cell and copy this cell down Place the number 3 in cell A1, select the cell and drag down with the right mouse button with the fill handle, after releasing it choose the series... option, enter 3 as the interval value and click OK All of the above answers are correct I don't know the answer Geen Excel Basis Question 20 Which button converts the format of a number to Financial number format? Image 1 Image 2 Image 3 Image 4 Image 1 Image 2 Image 3 Image 4 The correct image is not listed I don't know the answer Geen Excel Gevorderd TD Question 21 You want to make a pie chart from the following data where you can see what percentage one part (Sportstad) is of the circle. How can you do this? You calculate all the percentages, put them in column C, select A1:C6, and create the graph You calculate the percentage with a formula and paste it to the graph you create by selecting A1:B6 and select command create Pie chart You create the graph and drag the segment out a bit You make a pie chart; select only the Sports City point and give the command Add graph element in the Graph formats group on the Design tab/Graph design (365) and then via Data labels choose the Percentage. All of the above answers are correct I don't know the answer Geen Excel Gevorderd TD Question 22 You want to sort a list by product (Product) and each Product by date (Datum), see image. How can you do this? You select the entire list, choose the Sort button, choose the Date field, sort from oldest to new, choose the Add Level button and choose the Product field, sort from A to Z You select the Date column and the Product column and click the A-Z button on the Data tab You select a date, click on the A-Z button, Select a Product and click on the A-Z button You create a table from the data list and use the advanced filter button None of the above answers are correct I don't know the answer Geen Excel Gevorderd TD Question 23 You want to graphically visualize the price movements of twenty shares in an Excel worksheet. The prices of the shares lie in different ranges (some a few cents per share, others hundreds of euros per share). Which action is best? You choose the chart type Pie Chart You choose Sparklines You choose the Column Chart chart type with multiple Y-axes You choose a line chart (Line Chart) with multiple Y-axes All of the above answers are correct I don't know the answer Geen Excel Gevorderd TD Question 24 A data list includes a male/female column and an eye color column. The full list includes both men and women who have brown, blue, green and gray eyes. How can you make a selection of women with blue eyes and men with brown eyes? You use the advanced filter and a create a criteria area of three rows You use the advanced filter and a create a criteria area of two rows You use the advanced filter without a criteria area This is not possible with one advanced filter command I don't know the answer Geen Excel Gevorderd TD Question 25 In a list you want the lines to be alternately colored and uncolored and the data to be sorted. How can you do this? You insert a row where the added data belongs according to the sorting order You add the row at the bottom and sort the list as desired You add two rows (one colored and one non-colored), enter the additional data and sort the list as desired You create a table from the list and sort the list as desired I don't know the answer Geen Excel Gevorderd TD Question 26 You have a data list with several thousand rows of data. You want to create a pie chart showing the distribution of profit (Winst) by product (Product): You select the Product and Profit (Winst) columns and on the Insert tab, choose the Pie Chart option You group the rows by Product and choose the Pie Chart option on the Insert tab You create a PivotTable based on the data list, choose the Product and Profit fields and use the PivotChart button to create a pie chart You create a table based on the data list and on the Insert tab, choose Pie Chart None of the above answers are correct I don't know the answer Geen Excel Gevorderd TD Question 27 You want to sort a data list by the month of a sale date (for example, 10-01-2017 comes before 03-03-2016, the year is not important). You proceed as follows: You give the column of the Sales Date field a custom format so that only the month is visible and you sort by this column You create a table from the data list and choose the Sales Date column, Sort from Oldest to New You use an extra column with formulas that show the month of the sale date and sort them accordingly from smallest to largest You sort using the Sort dialog and choose sort by the custom list "January, February, March, April, May, June, July, August, September, October, November, December" All of the above answers are correct I don't know the answer Geen Excel Gevorderd TD Question 28 You want all cells in which the text 'success' is placed to automatically be colored red. Which option do you choose? Conditional formatting, Highlighting rules for cells, Greater than Conditional formatting, highlighting rules for cells, Text with or Equal to Conditional formatting, highlighting rules for cells, Text with That is not possible I don't know the answer Geen Excel Gevorderd TD Question 29 You want to show a pivot table with margin percentage per product in a data list with several thousand rows: profit/(sales-profit), how can you do this? You add the Product field to the pivot table and also a calculated margin field with the formula =profit/(sales-profit) You add the Product field to the pivot table and also the Profit field, where profit is shown as a percentage of sales You add the Product, Sales and Profit fields to the pivot table, create a formula =profit/(sales-profit) and copy it This cannot be done via a pivot table I don't know the answer Geen Excel Gevorderd FF Question 30 In a list of $ amounts, you want to add all the $ amounts that are positive and at the same time you want to add the negative figures: You use formulas such as =SUMIF(A1:A100,">") and =SUMIF(A1:A100,"<") You use formulas such as =COUNTIF(A1:A100,">") and =COUNTIF(A1:A100,"<") You use formulas such as =SUMIF(A1:A100,"negative") and =SUMIF(A1:A100,"positive") You use formulas such as =SUMIF(A1:A100,">0") and =SUMIF(A1:A100,"<0") I don't know the answer Geen Excel Gevorderd FF Question 31 To pin (make absolute) the cell reference to cell A4 in a formula, the following action is required (tip: test1 is the name of Cell A4): =A4*B4 =$A$4*B4 =test1*B4 Both =$A$4*B4 and =test1*B4 can be used I don't know the answer Geen Excel Gevorderd FF Question 32 What does A210 mean in a formula? The value in cell A2 is greater than 10 The value in cell A2 is less than 10 The value of A is between 2 and 10 The value in cell A2 is not equal to 10 I don't know the answer Geen Excel Gevorderd FF Question 33 Which function belongs to the following description? "Check whether a condition is met. Return a certain value if the specified condition is TRUE and a different value if it is FALSE" IF function OR function AND function TRUE function All of the above answers are correct I don't know the answer Geen Excel Gevorderd FF Question 34 What error is in the following formula? =IF(A2=15,"pass;fail") There are too many = signs in the formula The semicolons are in the wrong place The quotation marks are incorrect The outcome is always "successful" I don't know the answer Geen Excel Gevorderd FF Question 35 What does the term FALSE mean when using the vertical search function? The item you are looking for cannot be found The item you are looking for appears (at least) twice If an item you are looking for is not found, you will receive this error All of the above answers are correct None of the above answers are correct I don't know the answer Geen Excel Gevorderd FF Question 36 You want to know how old someone is based on his or her date of birth, you do the following: You use the YEAR function and apply it to the date of birth You use the YEAR. PART function and apply it to the date of birth You change the cell properties of the cell containing the date of birth and only show the year =INTEGER((TODAY()-GebDat)/365 or DATEDIF(GebDat,TODAY(),"Y") None of the answers are correct I do not know the answer Geen Excel Gevorderd FF Question 37 You want to prevent a user from deleting a worksheet. How can you do this? You protect the worksheet via the Check tab. You choose the Protect workbook button You can't counter this. You can always delete a worksheet unless it is the only worksheet You set the cell lock on all cells of the worksheet You protect the workbook via the Review tab. You choose the Protect worksheet button I don't know the answer Geen Excel Gevorderd FF Question 38 What is the logical continuation of the formula: =IF(NOW()-TODAY()>0.5 ;"sometimes";"always") ;"TRUE";"FALSE") ;"it's late";"it's early") ;1,0) ;"it is late") I do not know the answer Geen Excel Gevorderd FF Question 39 You want to enter data on a number of sheets at the same time. How can you do this? You choose the Commit button on the tab and indicate which tabs you want to work on at the same time You choose the correct tabs in the Search window and then enter the data You select all tabs to be changed by holding down the SHIFT or CTRL key and selecting the tabs, then typing your data on one of the selected tabs. You click the Group button on the Data tab. Then select the tabs you want to work on at the same time This is not possible in Excel I do not know the answer Geen Excel Gevorderd FF Question 40 You will see the following formula: =G12*(1+VAThigh). What does this mean? The VATHigh function returns the VAT amount of cell G12 There is a cell with the value 21 called VAThigh and an amount including VAT is calculated There is a cell somewhere called VAThigh and an amount including VAT is calculated The formula is wrong, you get an error message in Excel I do not know the answer Geen Excel Expert Question 41 How can you force a cell not to accept a value above a given value (e.g. 100)? Via Formatting the cell Through Cell Security Via Conditional Formatting Via a validation rule None of the above answers are correct I do not know the answer Geen Excel Expert Question 42 You will receive a file containing name, address and city details of customers. Unfortunately, one column contains the first name, middle names and last name combined in one cell. This means that you cannot sort by last name and you cannot properly provide mailings to these customers. What do you do? You split the first name, middle names, and last name with the Text to Columns command. You use the LEFT function to separate the surname With Custom Sort you use the Sort from left to right option. You use the FIND.SPEC (SEARCH) function to find the space and then use the PART (MID) function to get the last name separated None of the above answers solve the problem I do not know the answer Geen Excel Expert Question 43 A selection box has been placed on a worksheet. When a contact person is selected in the selection box, the name of the associated store is displayed in cell J4. The people and shops are in a list.How could this have been made? A selection box has been placed on a worksheet. When a contact person is selected in the selection box, the name of the associated store is displayed in cell J4. The people and shops are in a list. A check box has been placed with the link to cell J4. The data in the selection box is determined using the input range of the selection box The data in the checkbox is determined by list validation. A check box has been placed with the link to cell J4 This was created with a macro and NOT with a drop-down list The data in the selection box is determined using the input range of the selection box. Cell J4 contains a formula with the INDEX function I do not know the answer Geen Excel Expert Question 44 With the Solver a solution can be found for: The error #VALUE! (#VALUE!) that is shown as the result of a formula Calculating a monthly mortgage payment or a monthly amount to be paid for an investment, based on the amount to be borrowed, the interest rate and the term of the loan The number of decimal places in a result so that this number is meaningful Achieving the best results in situations where multiple variables and constraints influence I do not know the answer Geen Excel Expert Question 45 You want to automate a number of actions in Excel and create a macro for this purpose using the macro recorder. The intention is that data from an Excel file supplied weekly will be added to the bottom of a total file.Above are some of the figures from week 3 from 2018. The number of rows of data varies per week.When recording the macro, you should pay attention to: Selecting the week number list using the keyboard shortcut CTRL-Shift-arrow Adding a keyboard shortcut to the macro Saving the macro in the personal macro workbook Sorting the week list by week number None of the answers are correct I do not know the answer Geen Excel Expert Question 46 You will receive a text file (New.txt) every day with data from the previous day. You want to process these quickly. You already have a macro that copies data from a worksheet (New) to a collection sheet (Total) and generates a report based on that.How do you quickly get the new data from the text file onto the New sheet? You use Power Query to put the data into a suitable form that can be copied to Excel You open the text file in Excel, copy the data to the New sheet where you first deleted the old data A macro cannot process a text file. You must first use the Text to Columns command You refresh the data on the New sheet after you have linked to the text file there I do not know the answer Geen Time's up
