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? Goal Seek Data Table Scenario Manager PMT 2 / 10 "What would be the answer for =A3:C3 B1:B6 with reference to below picture 1 7 26 17 3 / 10 The formula =PI() gives what answer 0 Fills the cell with a series of 0s 2.71 3.14 4 / 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 5 / 10 In R1C1 notation, how will the cell D8 be written? R8C4 R1C8 R4D1 R8C1 6 / 10 What will formula =SUBTOTAL(3,A1:A100) do? Will count all non-blank cells in the range A1:A100 Will count all blank cells in the range A1:A100 Will sum the range A1:A100 Will average the range A1:A100 7 / 10 What would be the answer forĀ =INDEX(A1:D6,5,4) 28 7 17 0 8 / 10 To enter Array formula, what buttons need to be pressed? CTRL+SHIFT+ENTER Enter ALT+ENTER SHIFT+ALT+ENTER 9 / 10 The answer for formula =EOMONTH("4/21/14",0) would be 4/30/14 Will give error 4/1/14 1/1/14 10 / 10 Shortcut key for Autosum is CTRL++ ALT+= CTRL+ SHIFT+ Your score is LinkedIn Facebook Twitter Retake quiz