Excel Quiz 44 Posted on August 7, 2019September 26, 2021 by Vijay A. Verma Quiz 44 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 To print comments also in Excel In Page Setup under Sheet tab, select appropriate items in Comments box In Print Area under Page Layout, double select cells containing comments Under Page Layout, check Comments Comments can not be printed 2 / 10 To print Gridlines in Excel Page Layout > Check View under Gridlines if not already checked Gridlines can not be printed File > Options > Advanced > Check Show Gridlines if not already checked Page Layout > Page Setup > Sheet tab > Check Gridlines 3 / 10 The custom code for entering current date in Header / Footer section is &DC &CD &D &C 4 / 10 What is the default page size in Excel unless changed? A2 Legal A4 Letter 5 / 10 When you create a table, where you can change its name? Name Manager box Both in Design tab and Name Manager box Only in Design tab Design tab 6 / 10 Themes can be selected from which tab in Excel Formulas Home Page Layout Insert 7 / 10 To insert workbook name in header / footer of Excel worksheet, what is the custom code &WK &K &F &W 8 / 10 To insert a graphical background such as picture in Excel Insert > Online Pictures > Background Insert > Background Page Layout > Background Insert > Picture > Background 9 / 10 What is the shortcut for invoking Print in Excel? SHIFT+P ALT+P CTRL+SHIFT+P CTRL+P 10 / 10 To print only a part of the worksheet (not entire worksheet) Page Layout > Margins > Select margins > Print Page Layout > Size > Select the size > Print Page Layout > Print Area > Set Print Area > Print A part of the worksheet can not be printed in Excel Your score is LinkedIn Facebook Twitter Retake quiz Exit
Not able to login using my email ID