Integrated Business Excel

Which of these symbols cannot be used to perform arithmetic operations in Excel?

&

The formula ____ will add together the contents of cells A5 through A8.

=SUM(A5:A8)

Relative reference

A cell reference that changes when a formula is copied to a new location.

Absolute reference

A cell reference that does not change when a formula is copied to a new location.

Mixed reference

A cell reference that is part relative and part absolute

If you want the Find and Replace dialog box to search the entire workbook for a specific word, click the ____ button.

Find All

Which of the following tasks can you perform on the View tab?

Hide a worksheet's gridlines.

One way to make a column wider is to choose ____.

Home>Cells>Format and click Column Width

What is the primary advantage of using the Replace All option in the Find and Replace dialog box?

It saves time.

If you do not want a worksheet's gridlines to be printed, choose ____.

Page Layout>Sheet Options and deselect View under Gridlines

You can apply a theme by choosing ____.

Page Layout>Themes>Themes

If you want to automatically replace every occurrence of "Mrs." with "Ms." without first looking at each occurrence, select ____ in the Find and Replace dialog box.

Replace All

You work for an auto body repair shop. Business information is stored in a workbook with eight different worksheets, each keeping track of a specific type of data. The problem is that different people have created each worksheet. Each has used different fonts, colors, and other formatting characteristics. Which of the following would probably be most useful in giving this workbook a professional appearance?

Themes

By default, a new workbook contains how many worksheets?

Three

Which of the following is not a task that the Design tab allows you to perform?

add a function

PMT function

calculates payments for a loan based on interest rates, number of payments and amount of loan.

FV function

calculates the future value of an investment based on a constant interest rate.

PV function

calculates the present value of a loan or an investment based on a constant interest rate.

C11 is an example of a ____.

cell reference

Worksheets are made up of boxes called ____.

cells

If you want a row to be just tall enough so that all of its contents are visible, ____.

choose AutoFit Row Height in the Format list on the Home tab

A dialog box is used to ____.

enter information to perform a specific task

Before Excel can use the Replace command, it must first use the ____ command.

find

Underline is an example of a ____ style.

font

You can edit the contents of a cell either in the cell itself or ____.

in the formula bar

If you are creating a worksheet that contains your company's quarterly sales and you want to allow readers to access additional sales information on the company's Web site, you could ____.

insert a hyperlink to the company's site

Excel is excellent for tasks such as ____.

keeping track of a budget

Changing font color affects ____.

only the contents of the currently selected cells

A worksheet's row heads ____.

run down the left edge of the worksheet

You can hide a worksheet's column headings by going to the _____ group on the _____ tab.

show:view

Another name for a worksheet is a ____.

spreadsheet

Excel is a type of ____ software.

spreadsheet

When a column is hidden, ____.

the letter associated with the hidden column is not shown

Choose Page Layout>Page Setup>Background to ____.

use the contents of a graphical file as a worksheet's background

____ alignment lets you align the contents of a cell to its top, center, or bottom.

vertical

To use Hide & Unhide, choose Home>Cells>Format, and look under ____.

visibility