Adv. computer applications excel

Which of the following format symbols displays text along with numbers entered in a cell?

" " (quotation marks)

Which of the following is the path to the Refresh All button?

(DATA tab | Connections group)

What is the path to the What-If Analysis button?

(DATA tab | Data Tools group)

Which of the following is the path to the 'Get Data From Text' button?

(DATA tab | Get External Data group)

Which of the following is the path to the Name Manager button?

(FORMULAS tab | Defined Names group)

Which of the following is the path to the 'Lookup & Reference' button?

(FORMULAS tab | Function Library group)

Which of the following is the path to the Insert Cells button?

(HOME tab | Cells group)

Which of the following is the path to the Fill button?

(HOME tab | Editing group)

Which of the following is the path to the Borders button?

(HOME tab | Font group)

The path to the Comma Style button is ____.

(HOME tab | Number group)

Which of the following is the path to the Format as Table button?

(HOME tab | Styles group)

The path to the Sum button is ____.

(Home tab | Editing group)

Which of the following is the path to the 'Insert a SmartArt Graphic' button?

(INSERT tab | Illustrations group)

Which of the following is the path to the Insert WordArt button?

(INSERT tab | Text group)

Which of the following is the path to the Protect Sheet button?

(REVIEW tab | Changes group)

To hide an entire workbook on an unattended computer, click the Hide button on the ____.

(VIEW tab | Window group)

Which of the following is the path to the Switch Windows button?

(VIEW tab | Window group)

The values ____ satisfy a custom filter criteria that displays records in which the Experience field contains a value greater than or equal to 3 and less than or equal to 5.

3, 4, 5

The general form of the VLOOKUP function is ____.

=VLOOKUP(lookup_value, lookup_table, col_index_num)

As you link workbooks, the cell reference inserted by Excel each time you tap or click a cell in a workbook results in a(n) ____ cell reference.

Absolute

Which of the following is the maximum number of active data tables per worksheet?

As many as you want

When you first create a table, Excel automatically enables ____.

AutoFilter

Why is the VLOOKUP function used more often than other lookup functions?

Because most tables are vertical

To create an exact copy of a formula without replication, hold down the ____ key while dragging the fill handle.

CTRL

You should hold down the ____ key to select the nonadjacent cells.

CTRL

To copy the contents of a cell to the cell directly below it, click the target cell and press ____.

CTRL+D

____ ensures that users do not change values inadvertently that are critical to the worksheet.

Cell protection

____ formatting allows you to create rules that change the formatting of a cell or range of cells based on the value of a particular cell.

Conditional

The process of summarizing data included on multiple worksheets on one worksheet like the one shown in the accompanying figure is called ____.

Consolidation

The comparison criteria in the ____ range determine the records that will pass the test when the Advanced Filter dialog box is used.

Criteria

You should click ____ in the Category list on the Number sheet in the Format Cells dialog box to select or create a format code.

Custom

When a template is created, dummy ____ isare used to verify the formulas in the template.

Data

The following sequence, Jan, Feb, Mar, etc., is an example of a ____ series.

Date

A ____ file contains data fields separated by a selected character.

Delimited

A check mark in the ____ check box speeds up printing by ignoring formatting and not printing most graphics.

Draft quality

____ records allows you to pull data from a table so that you can analyze or manipulate the data further.

Extracting

Once you have selected a range to chart, you can press ____ to draw a chart on a worksheet.

F11

A table also is called a record.

False

By default, the cell that is active when a Web query is performed will become the lower-left cell of the imported range.

False

Data in descending sequence is sorted from lowest to highest, earlier to most recent, or alphabetically from A to Z.

False

If you are summing numbers on noncontiguous sheets, hold down the SHIFT key rather than the CTRL key when selecting the sheets.

False

It is not necessary to understand the layout of data you want to import; Excel automatically arranges each data element in the worksheet.

False

It is not possible to replicate formulas after completing an import, so be sure to complete the replication before the import.

False

Spreadsheet specialists usually format a worksheet before they enter any data.

False

The VLOOKUP and HLOOKUP functions provide greater flexibility than the MATCH and INDEX functions.

False

To locate a string in a worksheet, you can use the Locate command on the Locate and Select menu.

False

When a table is active, the FORMAT tab on the Ribbon provides powerful commands that allow you to alter the appearance and contents of a table quickly.

False

You can add only a maximum of five conditional formats to a range.

False

You can use the ROUND function to determine how much the borrower of a loan still owes at the end of each year.

False

You should not credit the source of an image unless you can specifically name the image creator.

False

Each row of an Excel worksheet used to create a table can store a record, and each column can store a(n) ____.

Field

You can drill all of the following down through a workbook EXCEPT ____.

Groupings

Webpages use a file format called ____.

HTML

To prevent sensitive data from being seen in a worksheet, you can hide the worksheet by clicking ____ on the shortcut menu.

Hide

A cell ____ often is created from column or row titles.

Name

You can display the ____ tab to specify page setup options.

PAGE LAYOUT

When you print a worksheet or use the Page Setup dialog box, Excel inserts ____ breaks that show the boundaries of what will print on each page.

Page

You can scale a worksheet so that it will fit on one page with an option on the ____ tab in the Page Setup dialog box.

Page

To prevent round-off errors, use the ____ function.

ROUND

To select adjacent sheets, select the first sheet by clicking its tab and then hold down the ____ key and click the sheet tab at the other end of the list of adjacent sheet tabs.

SHIFT

Which of the following is the path to the 'Get Data From Text' button? (DATA tab | Get External Data group) The ____ function is useful when you want to add values in a range only if they meet criteria.

SUMIF

The ____ provides step-by-step instructions for importing data from a text file into an Excel worksheet.

Text Import Wizard

You can add text to a SmartArt graphic by using the ____.

Text Pane

____ examines the formulas in a workbook in a manner similar to the way the spell checker examines a workbook for misspelled words.

The formula checker

A cell name often is created from column and row titles.

True

Database is the name most often assigned to a table.

True

Excel allows you to import data from webpages.

True

Excel automatically selects the Left column check box in the Create Names from Selection dialog box in order to determine which option to select automatically.

True

If added, a footer appears at the bottom of every printed worksheet page.

True

In some situations, you may find that a column of data imported from Word should be split into two columns.

True

The HLOOKUP and VLOOKUP functions can be inserted by tapping or clicking the 'Lookup & Reference' button (FORMULAS tab | Function Library group).

True

The Import Data dialog box allows you to choose in which cell to import the text from a text file and to specify properties of the imported text.

True

The Normal style is the format style that Excel initially assigns to all cells in a new workbook.

True

The result of an arithmetic operation, such as multiplication or division, is accurate to the factor with the least number of decimal places.

True

The system date might be displayed as a series of number signs if the date, as initially formatted by Excel, does not fit in the width of the cell.

True

When Range Finder is active, you can drag the outlines from one cell to another cell to change the cells referenced in the formula, provided the cells have not been named.

True

When a cell is formatted for a percent, if you enter the number .5 Excel translates the value as 50%.

True

When a range is transposed, the first row of the selected range becomes the first column in the destination range, and so forth.

True

When you add a new shape to a SmartArt graphic, Excel rearranges the shapes in the graphic to fit in the same area.

True

When you create a new custom format code, Excel adds it to the bottom of the Type list in the Number sheet in the Format Cells dialog box to make it available for future use.

True

When you insert a new worksheet, Excel places the new sheet tab to the left of the active tab.

True

You can create and then assign a style to a cell, a range of cells, a worksheet, or a workbook.

True

You can tap or click the arrow to the right side of a cell in the total row to display a list of available statistical functions.

True

You can transpose directly from copied Word tables.

True

____ can describe any type of data.

XML

Names are ____ cell references.

absolute

A(n) ____ shows the beginning and ending balances and the amount of payment that is applied to the principal and interest during each payment period.

amortization schedule

For the VLOOKUP function to work correctly, the table ____ must be in sequence from lowest to highest.

arguments

Data is in ____ sequence if it is in order from lowest to highest.

ascending

The following sequence, 1, 1, 1, etc., is an example of a(n) ____ series.

auto fill

Cell ____ can be used to distinguish the different functional parts of a worksheet.

borders

The arguments in ____ in the ScreenTip for a function are optional.

brackets

When a template is created, dummy ____ is are used to verify the formulas in the template.

data

Names are ____ to the workbook.

global

A ____ is a reference to a cell or range of cells in another workbook.

link

In the Sort dialog box, shown in the accompanying figure, the ____ is the Sort by field.

major sort key

You can delete a data table by selecting the data table and then ____.

pressing the DELETE key

In the accompanying figure, the Print area box accepts a name or a ____ to print.

range

Importing ____ provides greater flexibility to manipulate text in Excel.

raw data

The field or fields selected for sorting records are called ____ keys.

sort