Microsoft Excel 2007

1.

1 point

True or False: You can download templates from Microsoft Office Online to use in Excel

True

False

2.

1 point

True or False: Goal Seek is a type of What-if analysis that you can use to find an input value to a problem if you know the result you need

True

False

3.

1 point

Click the ______ and select New to create a new, blank workbook.

Home Tab

File Menu

Microsoft Office Button

Ribbon

4.

1 point

______ is a common spreadsheet task that allows you to reorder data.

Formatting

Sorting

Grouping

AutoSum

5.

1 point

Data Bars and Color Scales are types of _______.

Data Formatting

Table Formatting

Other types of Formatting

Conditional Formatting

6.

1 point

True or False: You can use numbers or cell references in formulas

True

False

7.

1 point

Excel uses _______ to determine which mathematical calculations to preform first in a complex formula.

What-if Analysis

the Order of Operations

Formulas

the Conditional Formatting Rules

8.

1 point

The _______ command removes information from the selected cell.

Cut

Remove

Paste

Copy

9.

1 point

The AutoSum command is located on the ______ tab.

Function

Formula

None of these

Data

10.

1 point

The _____ command allows you to indicate specific rows or columns that will be repeated on each print page.

Print Preview

Print Titles

Print Area

Print Home

11.

1 point

True of False: When you Format as a Table, drop- down filter arrows automatically appear in the first row.

True

False

12.

1 point

A cell is _________.

an intersection of a row and column

both answers

another name for a worksheet

neither answer

13.

1 point

True or False: You can change column width, but you cannot change row height.

True

False

14.

1 point

To group worksheets that are contiguous, or side by side, use the _____ key

F11

Shift

Ctrl

Enter

15.

1 point

With ________ you can change the formatting on the cells that meet certain criteria such as above average, top 10%, or greater than/less than the specific amount

Pivot Tables

Conditional Formatting

What-if Analysis

Reports

16.

1 point

How many sheets are there in a workbook by default?

two

one

four

three

17.

1 point

True or False: When you insert a chart in Excel, it appears in the selected worksheet with the source data, by default

True

False

18.

1 point

True or False:Each column label in your spreadsheet becomes a field that can be used to pivot table report.

True

False

19.

1 point

True or False: When you use the Subtotal command, cells are grouped together.

True

False

20.

1 point

Which of the following commands is not in the Alignment Group?

Merge and Center

Sort and Filter

Wrapped text

Align Center