Excel Quiz No. 47 Posted on May 12, 2020September 26, 2021 by Vijay A. Verma Quiz 47 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 The presence of comments is shown by a small triangle in the right upper corner of which color (by default) Cyan Yellow Red Green 2 / 10 Which of these is not provided by Proofing group in Excel Spelling Thesaurus Encyclopedia Research 3 / 10 If you protect workbook, you will be able to do Hide a workbook Fill color in a workbook Rename a workbook Delete a workbook 4 / 10 Can we Track Changes like we can do in Word? TRUE FALSE 5 / 10 It is not possible to insert rows in a protected worksheet TRUE It is possible provided we check Insert Rows during protection It is possible provided we check Edit Objects during protection It is possible provided we don't supply any password during protection 6 / 10 Worksheet protection can be applied only in Locked cells? TRUE FALSE 7 / 10 How to provide sorting facility in a protected workbook? It is possible only through VBA While protecting, check Sort It is not possible to provide Sort in a protected workbook While protecting, don't put password 8 / 10 The shortcut for inserting a new comment is SHIFT+F2 CTRL+SHIFT+F2 F2 CTRL+F2 9 / 10 To protect a sheet, password is mandatory? TRUE FALSE 10 / 10 What is the shortcut for Spell Check in Excel? F2 F8 F7 F5 Your score is LinkedIn Facebook Twitter Retake quiz Exit
