Adding Images to a Document

To add an image to a document go to the insert tab. Once you are in the insert tab go to the illustrations group and click on the picture button. Then you choose which picture you want and insert it. To add a background go to the page layout tab and in the page setup group click on the background button. You can then choose which picture you want to put as the page background. You can also delete a page background by going to the page layout tab and under the page setup group click on delete background.

Changing the Appearance od Data Based on Its Value

To change the apperance of data first select what you want to change the appearance. Then go to the home tab. In the styles group click on conditional formatting. Then point to one of the choices and you can pick which appearance you want for the group of data that you have and what the data's value is based on.

Making Numbers Easier to Read

To make numbers easier to read you have to first select the cell that you want to change. Then you go to the home tab. In the font group click on the dialog expander. Then when the dialog box opens you have to click on something in the category list depending on what you want to change. Once you choose something from the category list then you can choose something in the type list.

Applying Workbook Themes and Table Styles

To apply an existing theme go to the page layout tab and in the themes group click on the themes button. You can then click on the theme that you want to apply to your workbook. You can apply a new table style by going to the styles group on the home tab and clicking on the format as table button. Then click on the new table style button and you can then customize how you want to your new table style to be.

Defining Styles

To define a style first make sure you are on the home tab. Then go under the styles group and click on cell styles. There are multiple styles that can help you with the style you want on your worksheet. You can also create a new style by going to the home tab and going to the styles group and clicking on cell styles. From here you click on new cell style. The style dialog box will pop up and you name the new style. Then click on the format button and the format cells dialog box will pop up and you can customize the new style the way you want by clicking on the different tabs and creating it the way you want it to look.

Formatting Cells

To format a cell the way you want it first select the cell or cells you want to format. Then under the home tab in the font group click on the buttons that you want to use to format the cell or cells. You can also click on the dialog box launcher in the font group under the home tab to get to the format cells dialog box to format cells.

Excel 2007 Practice Exam

• modifying the formula from one worksheet to another worksheet
• modifying the formula from a worksheet to another worksheet
• creating a formula to calculate something from one worksheet to another workbook and creating a formula to calculate something from one worksheet to another worksheet
• saving a specific workbook in another workbook
• copying and pasting a comment
• calculating the average of a column based on another column
• modifying the cell range in a completed chart