Excel Quiz 37 Posted on April 30, 2017September 26, 2021 by Vijay A. Verma Quiz 37 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 A1=456789 and I apply the following custom format, then what would be the result - #.##, 456.79 K 456.79 4567.89 456,789 2 / 10 To fill in First Name and Last Name, which Excel functionality should be used? Name manager Advanced filter Flash fill Formula bar 3 / 10 What would be the answer for =SIGN(-40) 1 -40 -1 0 4 / 10 What would be the result for =TEXT(NOW(),"mmm") Current month in 1 or 2 letter number like 1, 2,......10,11,12 Current month in 2 letter number like 01, 02, 03 Current minutes Current month in 3 letter text like Jan, Feb, Mar 5 / 10 What function is performed by the button enclosed in red zone? Paints the cell with required formatting Paints the cell with required color Paste special Copies the format from one object (cell) to another 6 / 10 To add a background picture to your Excel sheet Insert tab > Pictures Page layout tab > Background View tab > Background pictures Insert tab > Online Pictures 7 / 10 Which functionality is found under 2 menu items (Home and Data)? Paste Special Evaluate formula Filter Go to 8 / 10 What would be the answer for =MATCH(18,A:A,1) 4 5 3 #N/A 9 / 10 Which of the below is not a Microsoft supplied Add-in? Power pivot Power query Inquire Text to columns 10 / 10 ALT+T+O is shortcut for Excel options Format as table Insert table Copy table Your score is LinkedIn Facebook Twitter Retake quiz Exit
