Microsoft Excel Test Review 2

Which of the following file format is commonly used to import data into a database program?

A) .CSV

The command to move to a specific cell or range of cells in a large worksheet is called

A) Go To

Which of the following is the command would you use to move to cells that have special characteristics, are blank, or contain constants?

A) Go To Special

Which of the following are some frequently and commonly used file formats for Excel?

B) Excel Template, Excel 97-2003 Workbook, CSV or tab delimited

The defined table range will automatically display as the ________ range in the Advanced Filter dialog box.

B) List

Which of the following markers CANNOT be added to sparklines?

B) Mid Point

Themes can be found within the ________ tab in the Themes group.

B) Page Layout

are cells that are referred to by a formula in another cell.

B) Precedent cells

By default, when a non-numeric field is added to a PivotTable, it is placed in the ________ area.

B) Row Labels

Which of the following is the method of summarizing values in the data area of a PivotTable report by using the values in other cells in the data area?

B) Summary calculation

If you have defined a two-column range of cells containing names and phone numbers, you would use the ________ function to match a name with a number.

B) VLOOKUP

Multiple sets of data can be pulled out or ________ from a filtered list and placed below the table of data.

B) extracted

In a PivotTable or PivotChart report, data is derived from a ________ in the source data.

B) field

The first step in adding subtotals to a group or list is to sort the data by the ________ for which you want to create a subtotal.

B) field

Cells that have external references to other workbooks are displayed in the Watch Window toolbar only when the other workbooks are:

B) open.

The initial amount of a loan also is called the:

B) principal.

61) If you change the underlying data on which the PivotTable report is based, you must also ________ or update the PivotTable to reflect the new data.

B) refresh

To enhance the appearance of sparklines, use

B) styles

Column charts present data graphically in ________ columns.

B) vertical

If the Select locked cells option is selected in the Protect Sheet dialog box, the user can click the locked cells and ________ the formulas.

B) view

Which of the following is NOT a way to define a name for a cell or group of cells?

Select the range, click in the Formula Bar, and then type the name.

A defined name provides a logical reference to:

data

A ________ is a word or string of characters in Excel that represents a cell, a range of cells, a formula, or a constant value.

defined name

11) If you calculate payments that are too high for your budget, you might consider:

extending the time period to pay the loan

An advantage to naming a range of cells is that you can use the name in a:

formula

In the lookup formula, the defined range is referred to as the:

table array

31) A theme combines font sets for:

text and headings.

To determine a monthly interest rate, you must divide the annual interest rate by:

twelve

Using various interest rates to determine the amount of loan payments is called:

what if analysis

The Future value (Fv) at the end of the time period is usually ________ for loans.

zero

Use a(n) ________ to apply complex criteria to a single column.

D) Advanced Filter

In the PivotTable field list, you can rearrange existing fields or reposition those fields by using which of the following areas at the bottom of the layout section?

D) Column Labels

If you are able to work from the Templates folder, Excel will automatically set the file type to

D) Excel Workbook (*.xlsx)

To set column and row titles on the screen while you scroll, which of the following command(s) would you use?

D) Freeze Panes

A method to find a specific value for a cell by adjusting the value of one other cell is:

D) Goal Seek.

For the ________, only one of the two comparison criteria that you specify must be true.

D) Or comparison operator

You can apply a ________ to the entire PivotTable report

D) PivotTable Style

Hyperlinks can be attached to which of the following items?

D) Text and graphics

By using the ________ command, you can see the relationships between formulas and cells.

D) Trace Precedents

A hyperlink in a worksheet may take you to which of the following locations:

D) another location in the worksheet or the company intranet.

Objects that make up a chart are called

D) chart elements

To make comparisons among related data, use a ________ chart.

D) column

To display trends over time, use a ________ chart.

D) line

If you want to see how different interest rates affect a monthly payment, you would use a:

D) one-variable data table.

To create a form for others to complete, you should first ________ the cells that will need to be filled in and then protect the workbook.

D) unlock

When creating a data table, you enter the PMT function in the ________ of your range of data.

D) upper left corner

A ________ is a list of values that are acceptable for a range of cells.

D) validation list

Which of the following rules is NOT acceptable for defining names?

Defined names can be the same as a cell reference.

An advanced filter that is used for copying selected rows to another part of the worksheet is called ________.

(D) extracting

If the file to which a hyperlink refers to is moved or renamed, or a Web page to which a hyperlink refers has a new address, which of the following do you need to do to the hyperlink to make it work correctly?

A) Modify the hyperlink to reflect the change

The default summary function for data fields containing numbers in an Excel PivotTable is

A) Sum

An Excel function that looks up values in a table array arranged as vertical columns is the ________ function.

A) VLOOKUP

The process of changing the values in cells to see how those changes affect the outcome of formulas on a worksheet is called:

A) What-If Analysis.

Criteria and List ranges use a(n) ________ reference when defining a database area in a spreadsheet.

A) absolute

Subtotaled rows that are totaled and summarized are referred to as ________ data.

A) detail

By default, Excel displays a chart as a(n) ________ object within the worksheet.

A) embedded

Fonts are associated with different themes and can be customized by:

A) mixing Colors and Fonts from any of the supplied themes.

The Text Pane includes ________ in which text can be typed.

A) placeholders

Cells referred to by a formula in another cell are called

A) precedent cells

All cells are locked by default, but the locking feature is only enabled when ________ is applied.

A) protection

In Excel the interest percentage on a loan is called the:

A) rate.

The ________ refers to the location where the name is recognized without qualification.

A) scope of a name

The category of slicer items is indicated by the ________.

A) slicer header

If you want all of the forms within an organization to have a uniform appearance and the data organized in the same way, you should use

A) standardization

Saving an Excel worksheet as a ________ separates the cells of each row with tab characters.

A) text file

Sparklines are

A) tiny charts that fit within a cell.

When you create a chart, you must first decide if you are going to plot values representing

A) totals OR details

To determine the number of months to repay a loan, you must multiply the number of years by:

A) twelve.

The defined range for a lookup formula must have at least ________ rows or columns.

A) two

Which of the following command would you use to open multiple worksheets on the screen?

B) Arrange All

________ is a technique that improves accuracy because it limits and controls the type of data an individual can enter into a form.

B) Data validation

A field that is being removed from the PivotTable report is indicated by a(n)

C X

For each and every one of the comparison criteria that you specify to be true, you would use the

C) And operator

Various styles, such as Headings and Title, can be applied by using ________ in the Styles group.

C) Cell Styles

The What-If Analysis button is found on the ________ tab.

C) Data

When you save a template on your own computer to the default location, it will be available for future use from ________.

C) My templates

Which of the following areas of a PivotTable field list allows you to average values?

C) Values

In the Name Manager dialog box, defined names are listed by:

C) alphabetical order.

The entire chart with all of its elements is called the ________.

C) chart area

A red triangle in the upper right corner of a cell indicates that there is a(n)

C) comment

The use of two or more criteria on the same row, it is known as a(n) ________.

C) compound criteria.

Before you create a validation list, you must first ________ the cells that you want to restrict to only valid entries from the list.

C) control

A(n) ________ is a range of cells that shows how changing certain values in your formula affect

C) data table

The PivotChart displays ________ that you can click on to choose a filter and change the data displayed in the chart.

C) field buttons

When clicked, a ________ will take you to another location in the worksheet, another file location, a Web page on the Internet, or to your organization's intranet.

C) hyperlink

The first sort level is sometimes referred to as the

C) major sort

The key that defines the colors assigned to categories in a chart is called a(n)

C) object

Before printing or distributing a large worksheet, the Preview option will allow you to see:

C) orientation and page breaks.

When you protect a worksheet, you may add an optional ________ to prevent someone from disabling the worksheet protection.

C) password

You can share worksheets or workbooks with others by:

C) printing paper copies, sending the file electronically, or posting the file to the Web or a shared workspace.

To prevent others from changing the formulas and formatting of a worksheet, you should use

C) protection

If you try to enter data in a protected cell, a message appears informing you that the cell is protected and therefore,

C) read-only

A predesigned set of colors, fonts, lines, and fill effects that look good together and can be applied across all Office 2010 applications is known as a:

C) theme.

Loans are typically made for a period of:

C) years.

functions look up a value in a defined range of cells located in another part of the workbook to find a corresponding value.

Lookup

Data tables are NOT used to:

argument. C) determine the Future value (Fv).

f you calculate payments that are too high for your budget, you might consider:

borrowing less money

When you start typing a formula, such as =SUM(B Excel will display the ________, which contains all of Excel's built in functions starting with the letter B.

formula auto complete list

The Function Library group can be found on which tab?

formulas

When you borrow money, the amount charged to you is called:

interest

If you want to copy only the value in a cell and not the formula, use

paste special

In the Data Validation dialog box, you can create a ________ that provides the user with instructions about what to

screentip

Which of the following is NOT a rule for defining names?

spaces are valid