1.
A quick way to access the Format Cells dialog box is to right-click in a cell: True
2.
absolute cell reference: In a formula, a reference to a specific cell.
3.
active cell: the cell in which you can enter data.
4.
add-in: a supplemental program that can be installed to extend the capabilities of excel by adding custom commands and specialized features
5.
arguments: the value that a function uses to perform operations or calculations
6.
array: used to build single formulas that produce multiple results or operatee on a group of aruments that are arranged in rows and columns
7.
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
8.
attribute: a formatting characteristic of text or a cell
9.
authenticate: the process of verifying that people and products are who and what they claim to be
10.
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
11.
auto fill: an excel feature that automatically fills cells with data from another celll or range of cells or completes a data series
12.
auto filter: a built-in set of filtering capabilities that you can apply to worksheet data
13.
axis: a line bordering the chart plot area used as a fram of reference for measurement
14.
boundary: the line that divides columns or rows on an excel worksheet
15.
Calibri 11-point is the _____ font in Microsoft Excel 2007: default
16.
cell: the intersection of a column and a row in a worksheet
17.
Cell Styles may contain predefined formatting for what?: font face, font size, and special effects
18.
certificate authority: a trusted third-party entity that issues digital certificates for use by others parties
19.
change history: in a shared workbook, information that is maintained about changes made in past editing sessions
20.
change tracking: the ability to market and keep track of changes that have been made to a workbook
21.
character: a letter, number, punctuation, mark, or symbol
22.
chart: a graphical representation of numeric data in a worksheet
23.
chart area: the entire chart and all its elements
24.
chart sheet: a sheet in a workbook that contains only a chart
25.
clip: a single media file including art, sound, animation, or movies
26.
Color scales, icon set, and data bars make up Excel's..: preset conditional format options
27.
Command tabs are divided into groups based on which paradigm: type of task to be performed
28.
Conditional formatting rules take precedence over manual formatting that has been applied to a worksheet.: True
29.
Excel allows you to both sort and filter data by cell attributes: True
30.
If worksheet columns D through E are hidden, the column headings will skip from C to F.: True
31.
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
32.
If you sort dates in ascending order, they will be placed in _____.: order from earliest to most recent date
33.
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
34.
In Excel, once you have applied a filter to a range of data, you cannot remove it.: False
35.
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
36.
Only one Style can be applied to a cell or a range of cells: False
37.
Patterns may be added as the background for a cell: True
38.
Regardless of the format applied to and displayed in a cell, its true value is shown in the formula bar.: True
39.
The _______ Column Width command adjusts a column's width to fit the longest entry: AutoFit
40.
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
41.
The default width for a worksheet's columns cannot be changed: False
42.
The easiest way to select an entire row is to _____.: click the row heading
43.
The Format Painter can copy and paste which the following..: formatting
44.
The real strength in excel is it's ability to..: calculate and analyze numbers based on the numeric values
45.
The Subtotal dialog box lets you specify the locations within the worksheet at which values in a column should be subtotaled.: true
46.
The three types of data you can enter into Excel are ____, ____, and _____.: text, numbers, and formulas
47.
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
48.
To make a worksheet tab green, right-click the tab, click _______, and then click green: Tab color
49.
What are the steps in launching Excel?: Click Start, All Programs, Microsoft Office, Microsoft Office Excel 2007.
50.
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
51.
What happens to blank cells when data in a worksheet is sorted?: They are always placed at the end
52.
What option in the Move or Copy dialog box must be selected when you are copying a worksheet?: Create a copy
53.
When merging cells, only data in the upper _____ cell will remain: left
54.
When you copy a worksheet, the copy will retain the original sheet's formatting: True
55.
When you increase the font size used in a cell, the row's height is automatically increased to accommodate the larger font.: True
56.
Where does the data you enter into the Excel worksheet appear: in the active cell
57.
Which of the following appears in the title bar of grouped worksheets?: (Group)
58.
Which of the following appears when you first launch excel?: blank workbook
59.
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.
60.
Which of the following lets you preview how a worksheet will look when printed?: Page Layout View
61.
While you can delete any worksheet in a workbook, you can only add new worksheets to the end of a workbook.: False
62.
While you can erase the data contained in a worksheet row, you cannot delete the row itself.: False
63.
You can copy a single cell, a range of cells, or an entire worksheet: True
