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