Excel Quiz 43 Posted on April 23, 2019September 26, 2021 by Vijay A. Verma Quiz 43 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 In win-loss sparkline, the size of both +ve and -ve values are same irrespective of the values? TRUE FALSE 2 / 10 Which functionality can be used to insert small charts in a cell to see trends at a glance? Pivot chart Sparklines Textbox Charting 3 / 10 What would be the answer for following - =MROUND(1238,10) 1238.1 1230 1240 1235 4 / 10 Which is not a part of Pivot table? Calculated Field Text to columns Slicers Calculated item 5 / 10 In case of inserting online pictures, which site you can use to insert online pictures? Twitter Bing Flickr Facebook 6 / 10 Which functionality in Insert tab can you use to insert Smileys? Equation Symbol Slicer Timeline 7 / 10 Timelines can be used with Table Pivot Table Both Table and Pivot Table Neither Table not Pivot Table 8 / 10 What is the shortcut for Pivot table wizard? ALT+D ALT+P ALT+D+P CTRL+P+T 9 / 10 What is the shortcut for creating a table? CTRL+T CTRL+L Both CTRL+T and CTRL+L None of the above 10 / 10 Call outs can be inserted from Text box Word Art Smart Art Shapes Your score is LinkedIn Facebook Twitter Retake quiz Exit
Question 2: I have no idea wha ve+ and ve- mean. I looked into the Microsoft.com excel support pages and I do not see any description of what these mean. Question 8: Do you mean Text Boxes.? I do not understand your vernacular. Reply
Question 2: I have no idea wha ve+ and ve- mean. I looked into the Microsoft.com excel support pages and I do not see any description of what these mean.
Question 8: Do you mean Text Boxes.? I do not understand your vernacular.