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