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