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