Your work at Company.com includes the preparation of company documents using Microsoft
Office 2010. You are using Microsoft Office Excel 2010 to create a workbook.
The workbook contains sensitive information. You want the word CONFIDENTIAL to be
displayed on every page when the workbook is printed.
You have a picture file named confidential.gif that contains the required CONFIDENTIAL
What should you do with the picture file?
A. You should use the Insert Picture function and select confidential.gif.
B. You should insert the picture file as a background using the Background function on the Page
C. You should insert the picture file into a header using the Headers and Footers function on the
D. You should insert the picture file as a watermark using the Watermark function on the Page
You work in the office at Company.com. Your computer has just been upgraded from Microsoft
Office 2007 to Microsoft Office 2010.
You create a workbook using Microsoft Office Excel 2010. Microsoft Office 2010 has a new
feature called the Backstage View. The Backstage View gives you access to functions that
affect the workbook as a whole and to settings that affect the application itself.
How do you get to the Backstage View?
A. By selecting the Custom Views option on the View tab.
B. By clicking the File tab.
C. By clicking the Office Button on sheet.
D. By clicking the Page Layout tab.
Kara Lang works as the Human Resources manager at Company.com. She is using Microsoft
Office Excel 2010 to create a workbook. The workbook wil be used to record days taken off for
vacations or il ness.
The company contains departments named Sales, Marketing, Production and IT.
Kara often needs to enter the names of company employees when she creates workbooks.
Kara wants to be able to use the Fil Handle function to ease the task of entering names in a
workbook. She asks you for assistance in enabling the Fil Handle function.
How can you help Kara?