Excel Quiz 6 Posted on February 7, 2015September 24, 2021 by Vijay A. Verma Quiz 6 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 Which of the below is not an example of What-If analysis? PMT Data Table Scenario Manager Goal Seek 2 / 10 What will formula =SUBTOTAL(3,A1:A100) do? Will count all blank cells in the range A1:A100 Will count all non-blank cells in the range A1:A100 Will sum the range A1:A100 Will average the range A1:A100 3 / 10 The answer for formula =EOMONTH("4/21/14",0) would be 1/1/14 Will give error 4/1/14 4/30/14 4 / 10 Shortcut key for Autosum is SHIFT+ CTRL++ CTRL+ ALT+= 5 / 10 To enter Array formula, what buttons need to be pressed? ALT+ENTER Enter SHIFT+ALT+ENTER CTRL+SHIFT+ENTER 6 / 10 In R1C1 notation, how will the cell D8 be written? R4D1 R1C8 R8C4 R8C1 7 / 10 What would be the answer forĀ =INDEX(A1:D6,5,4) 28 17 7 0 8 / 10 "What would be the answer for =A3:C3 B1:B6 with reference to below picture 7 26 1 17 9 / 10 If I take the snapshot of a cell using Camera tool, then the snapshot will mimic the original cell i.e. if original cell changes the value, the changed value will reflect in the snapshot. TRUE FALSE 10 / 10 The formula =PI() gives what answer 3.14 0 2.71 Fills the cell with a series of 0s Your score is LinkedIn Facebook Twitter Retake quiz