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