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