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