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 If A1="X" and A2="x", then answer for =EXACT(A1,A2) would be TRUE 0 Blanks FALSE 2 / 10 In R1C1 notation, what R3C4? E3 D3 A1 C4 3 / 10 What does shortcut F7 do? Starts Spellcheck Performs a Save As .xlsx Opens Macro windows Doesn't do anything 4 / 10 Maximum UNDO levels in Excel is 99 100 64 32 5 / 10 When sorting, numbers get sorted before alphabets i.e. numbers have priority over alphabets. FALSE TRUE 6 / 10 You can't print Gridlines TRUE FALSE 7 / 10 What is the answer for =CHOOSE(3,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec") Mar Apr Jan Blanks 8 / 10 If I put formula =ROWS($1:1) and drag this down, what action would happen? The column will be filled with number 1 The column will be filled sequentially with numbers 1, 2, 3 and so on Gives Error It will give row number of that row 9 / 10 What does following formula do? =RAND()*(b-a)+a Generates a random number which is greater than b Generates a random number which is less than a Generates a random number which takes seed from a and b Generates a random number between a and b 10 / 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 Counts the number of cells which are not equal to 0 Gives the answer of 10 Your score is LinkedIn Facebook Twitter Retake quiz