Excel Quiz 4 Posted on December 20, 2014September 24, 2021 by Vijay A. Verma Quiz 4 This is a general quiz to test your Excel knowledge. There are a total of 10 questions to answer. To pass, you need to answer at least 6 questions correctly. Please fill in your Name & Email to take the Quiz (Name and E Mail are not shared with anybody else. E Mail is used to mail the pdf certificate to you when you pass) 1 / 10 What does shortcut F7 do? Starts Spellcheck Doesn't do anything Opens Macro windows Performs a Save As .xlsx 2 / 10 In R1C1 notation, what R3C4? E3 A1 D3 C4 3 / 10 If I put formula =ROWS($1:1) and drag this down, what action would happen? Gives Error It will give row number of that row The column will be filled sequentially with numbers 1, 2, 3 and so on The column will be filled with number 1 4 / 10 What does following formula do? =RAND()*(b-a)+a Generates a random number between a and b Generates a random number which takes seed from a and b Generates a random number which is less than a Generates a random number which is greater than b 5 / 10 What is the answer for =CHOOSE(3,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec") Apr Jan Mar Blanks 6 / 10 What does following formula do? =COUNTIF(A1:A10,"<>0") Counts the number of blanks which are not equal to blanks Count the number of cells which are either not equal to 0 or blanks Gives the answer of 10 Counts the number of cells which are not equal to 0 7 / 10 If A1="X" and A2="x", then answer for =EXACT(A1,A2) would be Blanks TRUE FALSE 0 8 / 10 Maximum UNDO levels in Excel is 32 64 100 99 9 / 10 You can't print Gridlines FALSE TRUE 10 / 10 When sorting, numbers get sorted before alphabets i.e. numbers have priority over alphabets. TRUE FALSE Your score is LinkedIn Facebook Twitter Retake quiz
