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