BIM FINAL QUESTIONS AND ANSWERS
A requirements document includes a needs statement, source of data, summary of
calculations, and any other special requirements for a worksheet. - Answers :T
Worksheet titles and subtitles should be as wordy as possible. - Answers :F
A thin red border indicates the active cell. - Answers :F
Both the Cancel button and the Enter button appear on the formula bar when you begin
typing in a cell. - Answers :T
The AutoCorrect feature can automatically capitalize the first letter in the names of
days. - Answers :T
You should press the SPACEBAR to clear a cell. - Answers :F
The equal sign (=) precedes a formula. - Answers :T
The most common error when entering a formula is to reference the wrong cell in the
formula. - Answers :T
An asterisk (*) following a cell reference in a formula is the arithmetic operator that
directs Excel to perform the division operation. - Answers :F
The arithmetic operator, ^, directs Excel to perform the division operation. - Answers :F
Moving from left to right, the first calculation in the order of operations is negation (-). -
Answers :T
The Insert Options button lists formatting options. - Answers :T
Excel has more than 400 functions that perform just about every type of calculation you
can imagine. - Answers :T
Excel attempts to guess which cells you want to include in the function by looking for
ranges that are adjacent to the selected cell and that contain numeric data. - Answers :T
The range automatically selected by Excel is always correct. - Answers :F
The AVERAGE function requires that the argument be included within parentheses
following the function name. - Answers :T
When you click the Decrease Font Size button, Excel assigns the next highest font size
in the Font Size gallery. - Answers :F
,You can click the Format Cells Dialog Box Launcher to open the Format Cells dialog
box. - Answers :T
You cannot format an entire column at once. - Answers :F
With the accounting number style, a floating dollar sign appears immediately to the left
of the first digit in a dollar value with no spaces. - Answers :F
The Percent Style button instructs Excel to display a value as a percentage, determined
by multiplying the cell entry by 100, rounding the result to the nearest percent, and
adding a percent sign. - Answers :T
The Increase Indent button indents the contents of a cell to the right by three spaces
each time you click it. - Answers :F
A date stamp shows the date a workbook, report, or other document was created or the
time period it represents. - Answers :T
A relative cell reference instructs Excel to adjust the cell reference as it copies it to the
destination area. - Answers :T
The <= comparison operator means less than or equal to. - Answers :T
The underline format underlines the entire cell, not just the characters in the cell. -
Answers :F
The range of entries that identifies the major groups for a clustered column chart are
called the category names. - Answers :T
When you magnify a worksheet, Excel enlarges the view of the characters on the
screen and displays more rows and columns. - Answers :F
When text is longer than the width of a column, Excel displays the overflow characters
in adjacent cells to the right as long as those adjacent cells contain no data. - Answers
:T
Excel can display characters in only three font colors: black, red, and blue. - Answers :F
A character with a point size of 10 is about 10/72 of one inch in height. - Answers :T
Modifying the column widths usually is done last because other formatting changes may
affect the size of data in the cells in the column - Answers :T
Live preview is available on a touch screen. - Answers :F
, You can turn off the Bold formatting for selected text by clicking the Roman button
(Home tab | Font group). - Answers :F
To add a pie chart, first select the data to be charted and then tap or click the Insert Pie
or Doughnut Chart button (INSERT tab | Charts group). - Answers :T
With Excel in Edit mode, you can edit cell contents directly in the cell. - Answers :T
Exploding worksheet columns and rows is a useful technique for viewing large
worksheets that extend beyond the window. - Answers :F
An Excel ____ allows data to be summarized and charted easily.
a.
worksheet
c.
document
b.
workflow
d.
presentation - Answers :A
The first step in creating an effective worksheet is to make sure you ____.
a.
apply font formatting
c.
insert a chart
b.
understand what is required
d.
enter the data - Answers :B
To enter data in a cell, you must first select the ____.
a.
row
c.
column
b.
worksheet
d.
cell - Answers :D
____ is/are used to place worksheet, column, and row titles on a worksheet.
a.
Color
c.
Links
A requirements document includes a needs statement, source of data, summary of
calculations, and any other special requirements for a worksheet. - Answers :T
Worksheet titles and subtitles should be as wordy as possible. - Answers :F
A thin red border indicates the active cell. - Answers :F
Both the Cancel button and the Enter button appear on the formula bar when you begin
typing in a cell. - Answers :T
The AutoCorrect feature can automatically capitalize the first letter in the names of
days. - Answers :T
You should press the SPACEBAR to clear a cell. - Answers :F
The equal sign (=) precedes a formula. - Answers :T
The most common error when entering a formula is to reference the wrong cell in the
formula. - Answers :T
An asterisk (*) following a cell reference in a formula is the arithmetic operator that
directs Excel to perform the division operation. - Answers :F
The arithmetic operator, ^, directs Excel to perform the division operation. - Answers :F
Moving from left to right, the first calculation in the order of operations is negation (-). -
Answers :T
The Insert Options button lists formatting options. - Answers :T
Excel has more than 400 functions that perform just about every type of calculation you
can imagine. - Answers :T
Excel attempts to guess which cells you want to include in the function by looking for
ranges that are adjacent to the selected cell and that contain numeric data. - Answers :T
The range automatically selected by Excel is always correct. - Answers :F
The AVERAGE function requires that the argument be included within parentheses
following the function name. - Answers :T
When you click the Decrease Font Size button, Excel assigns the next highest font size
in the Font Size gallery. - Answers :F
,You can click the Format Cells Dialog Box Launcher to open the Format Cells dialog
box. - Answers :T
You cannot format an entire column at once. - Answers :F
With the accounting number style, a floating dollar sign appears immediately to the left
of the first digit in a dollar value with no spaces. - Answers :F
The Percent Style button instructs Excel to display a value as a percentage, determined
by multiplying the cell entry by 100, rounding the result to the nearest percent, and
adding a percent sign. - Answers :T
The Increase Indent button indents the contents of a cell to the right by three spaces
each time you click it. - Answers :F
A date stamp shows the date a workbook, report, or other document was created or the
time period it represents. - Answers :T
A relative cell reference instructs Excel to adjust the cell reference as it copies it to the
destination area. - Answers :T
The <= comparison operator means less than or equal to. - Answers :T
The underline format underlines the entire cell, not just the characters in the cell. -
Answers :F
The range of entries that identifies the major groups for a clustered column chart are
called the category names. - Answers :T
When you magnify a worksheet, Excel enlarges the view of the characters on the
screen and displays more rows and columns. - Answers :F
When text is longer than the width of a column, Excel displays the overflow characters
in adjacent cells to the right as long as those adjacent cells contain no data. - Answers
:T
Excel can display characters in only three font colors: black, red, and blue. - Answers :F
A character with a point size of 10 is about 10/72 of one inch in height. - Answers :T
Modifying the column widths usually is done last because other formatting changes may
affect the size of data in the cells in the column - Answers :T
Live preview is available on a touch screen. - Answers :F
, You can turn off the Bold formatting for selected text by clicking the Roman button
(Home tab | Font group). - Answers :F
To add a pie chart, first select the data to be charted and then tap or click the Insert Pie
or Doughnut Chart button (INSERT tab | Charts group). - Answers :T
With Excel in Edit mode, you can edit cell contents directly in the cell. - Answers :T
Exploding worksheet columns and rows is a useful technique for viewing large
worksheets that extend beyond the window. - Answers :F
An Excel ____ allows data to be summarized and charted easily.
a.
worksheet
c.
document
b.
workflow
d.
presentation - Answers :A
The first step in creating an effective worksheet is to make sure you ____.
a.
apply font formatting
c.
insert a chart
b.
understand what is required
d.
enter the data - Answers :B
To enter data in a cell, you must first select the ____.
a.
row
c.
column
b.
worksheet
d.
cell - Answers :D
____ is/are used to place worksheet, column, and row titles on a worksheet.
a.
Color
c.
Links
