Excel advance assesment test


Home - Contact Us - Courses - Learn online free - Assessment - Manuals - Sitemap - Articles - Company profile - Newsletters - Tips


Test your advance excel knowledge 1) What is the purpose of the following formula, =IF(AND(A1>-5,A1<5),A1,"")? a) It will give you the number in A1, if it is a number between -5 and 5, and give you a blank cell, if it is not b) This formula will not work c) It will give you the number in A1, if it is between -5 and 5, and give you a cell with a space in if it is not d) It will give you the number in A1, if it is a number frrom -5 to 5, and give you a blank cell, if it is not 2) What will be the answer of the following formula, =IFERROR(5/0,1,0)? a) 5 b) 0 c) This formula will not work d) 1 3) Look at the below windows. In the first one we have a file, with employee names in. We need the salaries for them, which is in another file (see window 2). Which name would give an error? a) Christal b) Dann c) Nico d) Suzie 4) Which of these does not describe a method of combining the content of two cell into one? a) Concatenate b) Merge cells c) & d) VBA coding 5) How do you take out spaces in pivottables, see table below for which spaces we refer to? a) Under option, go to "fill empty spaces" b) You have to arrange your data so that spaces do not occur c) You cannot do it, you have to use formulas next to the pivottable to fill empty spaces d) Make sure your source data has not empty spaces 6) Under which toolbar would you insert a checkbox? a) Insert toolbar b) Home toolbar c) Formula toolbar d) Developer toolbar 7) If we want to insert a link in a cell to cell A1, and then copy this link to the right and keep the link to cell A1, but when we copy and paste down, it should move to cell A2, A3 etc. Which one would work? a) =A1 b) =A$1 c) =$A$1 d) =$A1 8) Which of these formula will give you the length of a text in a cell? a) Search b) Len c) Count d) Countif 9) What is wrong with this formula, =COUNTIF(i7,i:i)? a) You cannot count a value in same column that you are searching for b) The formula is missing a field c) The range and category is switch around d) Nothing is wrong 10) Which of the following cannot be done by an autofilter? a) Filter between two numbers b) Filter by colour c) Filter by specific text in a cell c) Filter by formula
Home \| Testimonials \| Terms & Conditions \| Contact Us \| Courses \| Manuals \| Sitemap \| Articles