Excel Final

Which of the following appears in the title bar of grouped worksheets?

(Group)

What happens if you click the Dialog Box Launcher at the lower-right corner of a group header?

A dialog box appears displaying additional options

The _______ Column Width command adjusts a column's width to fit the longest entry

AutoFit

If you no longer want data grouped by the values in a particular column, click the Ungroup arrow on the Data tab and then click_____?

Clear the Outline

What are the steps in launching Excel?

Click Start, All Programs, Microsoft Office, Microsoft Office Excel 2007.

What option in the Move or Copy dialog box must be selected when you are copying a worksheet?

Create a copy

In Excel, if you restrict cell entries to certain data types and do not enter an Error Alert title or text, the user will not know that an entry is invalid.

False

In Excel, once you have applied a filter to a range of data, you cannot remove it.

False

Only one Style can be applied to a cell or a range of cells

False

The default width for a worksheet's columns cannot be changed

False

While you can delete any worksheet in a workbook, you can only add new worksheets to the end of a workbook.

False

While you can erase the data contained in a worksheet row, you cannot delete the row itself.

False

absolute cell reference

In a formula, a reference to a specific cell.

Which of the following lets you preview how a worksheet will look when printed?

Page Layout View

Which of the following inserts a new row immediately below row 2?

Select any cell in row 3, click the arrow next to Insert in the Cells group, and click Insert Sheet Rows.

Nonadjacent cells may be selected by using which of the following methods?

Select the first cell, hold down the CTRL key, and select additional cells

To make a worksheet tab green, right-click the tab, click _______, and then click green

Tab color

What happens to blank cells when data in a worksheet is sorted?

They are always placed at the end

A quick way to access the Format Cells dialog box is to right-click in a cell

True

Conditional formatting rules take precedence over manual formatting that has been applied to a worksheet.

True

Excel allows you to both sort and filter data by cell attributes

True

If worksheet columns D through E are hidden, the column headings will skip from C to F.

True

Patterns may be added as the background for a cell

True

Regardless of the format applied to and displayed in a cell, its true value is shown in the formula bar.

True

To increase the width of a cell so that you can see all the text it contains, double-click the marker between it and the next cell.

True

When you copy a worksheet, the copy will retain the original sheet's formatting

True

When you increase the font size used in a cell, the row's height is automatically increased to accommodate the larger font.

True

You can copy a single cell, a range of cells, or an entire worksheet

True

auto filter

a built-in set of filtering capabilities that you can apply to worksheet data

auto complete

a feature that completes text entries that you start to key in a column of data if the first few letters that you key match an exisiting entry in that column

attribute

a formatting characteristic of text or a cell

chart

a graphical representation of numeric data in a worksheet

character

a letter, number, punctuation, mark, or symbol

axis

a line bordering the chart plot area used as a fram of reference for measurement

chart sheet

a sheet in a workbook that contains only a chart

clip

a single media file including art, sound, animation, or movies

add-in

a supplemental program that can be installed to extend the capabilities of excel by adding custom commands and specialized features

certificate authority

a trusted third-party entity that issues digital certificates for use by others parties

The 2 A's of Excel. This axiom infers worksheet data and formulas must be _____. And, that the worksheet's _____ is easy to read

accurate, appearance

auto fill

an excel feature that automatically fills cells with data from another celll or range of cells or completes a data series

Which of the following appears when you first launch excel?

blank workbook

The real strength in excel is it's ability to..

calculate and analyze numbers based on the numeric values

The easiest way to select an entire row is to _____.

click the row heading

Calibri 11-point is the _____ font in Microsoft Excel 2007

default

Cell Styles may contain predefined formatting for what?

font face, font size, and special effects

The Format Painter can copy and paste which the following..

formatting

change history

in a shared workbook, information that is maintained about changes made in past editing sessions

Where does the data you enter into the Excel worksheet appear

in the active cell

When merging cells, only data in the upper _____ cell will remain

left

If you sort dates in ascending order, they will be placed in _____.

order from earliest to most recent date

Color scales, icon set, and data bars make up Excel's..

preset conditional format options

ascending order

sort order in which alphabetic data appears A to Z, numeric data appears from lowest to highest or smallest to largest, and dates appear from oldest to most recent

The three types of data you can enter into Excel are ____, ____, and _____.

text, numbers, and formulas

change tracking

the ability to market and keep track of changes that have been made to a workbook

active cell

the cell in which you can enter data.

chart area

the entire chart and all its elements

cell

the intersection of a column and a row in a worksheet

boundary

the line that divides columns or rows on an excel worksheet

authenticate

the process of verifying that people and products are who and what they claim to be

arguments

the value that a function uses to perform operations or calculations

The Subtotal dialog box lets you specify the locations within the worksheet at which values in a column should be subtotaled.

true

Command tabs are divided into groups based on which paradigm

type of task to be performed

array

used to build single formulas that produce multiple results or operatee on a group of aruments that are arranged in rows and columns