You are editing a worksheet in Excel 2010. After doing formatting of your sheet, you insert column A.

You want to format column A as column B is formatted. Mark the tool that will help you in accomplishing the task.

You are editing a worksheet on Excel 2010. You are required to join two cells into one large cell.
Which of the following tabs contains options for merging two or more cells into a large cell?

You are creating a worksheet on Excel 2010. You want to select entire worksheet (including the
blank cells). Through which of the following steps can you accomplish your task?
Each correct answer represents a complete solution. Choose two.

Martha has just upgraded her Office 2007 to Office 2010. She is creating a report on Excel 2010 and
needs to print it. From where can she check the preview of her spreadsheet and print it?

You are creating a worksheet in Excel 2010. You need to merge five adjacent cells of rows 1 to 5 in
your worksheet to make them a large cell. You select the five rows and columns. Mark the merge
option that you will choose to accomplish the task.

Rick is working on a worksheet in Excel 2010. He has entered data in the worksheet as shown in the image below:

He wants to hide column B of the worksheet. Which of the following options will he choose to
accomplish the task with least amount of effort?

While printing a spreadsheet in Excel 2010, all of the following scaling options are available except
which one?

Martha has created a report in Excel 2010. She wants to construct header and footer before printing
the report. How can she accomplish the task?

You are working on a report on Microsoft Excel 2010 for your organization. You need to link a cell to
a Web page that displays some graphical reports of the past accounting year. Which of the following
options will you use in the spreadsheet to accomplish the task?

You need to create a worksheet containing sales data of different salesmen of a company. You are
using Microsoft Excel 2010 to create the sheet. Your assistant has compiled the required data in a
text file. You need to import data from the text file. Mark the option you will choose to accomplish this task.