1. You are working with a spreadsheet using Microsoft Office Excel 2007. The spreadsheet contains a number of headings across the top that should be filled with a dark gray color. You have selected the cells to which you wish to have the dark gray color applied. What path will allow you to apply this formatting with the least amount of effort?

A. Right-click the highlighted cells | Format Cells | Fill tab
B. Home Tab | Font group | Fill Color
C. Home Tab | Number group | Fill Color
D. Insert Tab | Font group | Fill Color

2. You are working on a spreadsheet for a presentation. One of your columns will represent a dollar amount in US currency. If the number is less than 0, you want the number to appear as red in color, with a red border and grey background, and to show the amount with the $000 format. You do not want to change any other part of the appearance of the spreadsheet. How would you accomplish this?

A. Format Menu | Autoformat
B. Home tab | Conditional Formatting
C. View tab | Page Layout
D. Page Layout tab | Themes

3. You want to save your workbook as an Excel 2007 file that will support macros. What Save As option should you select?

A. Excel Workbook
B. Excel Macro-Enabled Workbook
C. Excel Template
D. Excel 97-2003 Workbook

4. You have created a pie chart outlining your company's sales for last year. You have been asked to move this chart to its own worksheet where there is more space. Which steps will allow you to do this? (Choose two)

A.None. Charts can only be moved within the worksheet in which they were created.
B.Add a new sheet to the workbook and drag the chart to the new sheet.
C.With the chart selected, select the Design contextual tab. Click Move Chart in the Location group to display the Move Chart dialog box.
D.With the chart selected, right-click and select Move Chart to display the Move Chart dialog box.

5. A co-worker has created a worksheet with Excel 2007, and it contains hundreds of rows with several columns. They have asked you to help them arrange the information into a more organized manner. It must first be arranged alphabetically on the Product Name column, and then by descending order on the Unit Price column. The Product Name column contains text, and the Unit Price column contains numeric data. Which step would allow you to arrange the data within those columns using the specified criteria?

A. Select a cell within the Product Name column, and use the Sort A to Z command found within the Sort & Filter group of the Data tab. Select a cell within the Unit Price column, and use the Sort Largest to Smallest command of the same group.
B. Select a cell within one of the data columns, and click the Sort command found within the Data tab. Set the first rule to sort the Product Name values with an order of A to Z. Click the Add Level command and configure the next rule to sort the Unit Price values with an order of Largest to Smallest.
C. Select a cell within the Product Name column, and use the Sort Z to A command found within the Sort & Filter group of the Data tab. Select a cell within the Unit Price column, and use the Sort Smallest to Largest command of the same group.
D. Select a cell within one of the data columns, and click the Sort command found within the Data tab. Set the first rule to sort the Product Name values with an order of A to Z. Click the Add Level command and configure the next rule to sort the Unit Price values with an order of Z to A.

Back to Home Page
Site Code:
FINDCT
English Close