MISY 5325 Excel Midterm Ultimate Review |
Comprehensive Midterm Excel Review |Que &
Answ
(Excel) TRUE/FALSE:
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). ** Answ** TRUE
(Excel) TRUE/FALSE:
To use the AutoCalculate area, select the range of cells containing the numbers for a
calculation you want to verify and then press and hold or double-click the AutoCalculate
area to display the Customize Status Bar shortcut menu. ** Answ** FALSE
(Excel) TRUE/FALSE:
The Microsoft Office Specialist (MOS) program provides an opportunity for you to obtain
proof that you have the Excel 2013 skills required by employers. ** Answ** TRUE
(Excel) TRUE/FALSE:
You can clear cell contents and formatting by tapping or clicking Clear Contents on the
Clear button menu. ** Answ** TRUE
(Excel) TRUE/FALSE:
The equal sign (=) precedes a formula. ** Answ** TRUE
(Excel) TRUE/FALSE:
The most common error when entering a formula is to reference the wrong cell in the
formula. ** Answ** TRUE
(Excel) TRUE/FALSE:
An asterisk (*) following a cell reference in a formula is the arithmetic operator that
directs Excel to perform the division operation. ** Answ** FALSE
(Excel) TRUE/FALSE:
The arithmetic operator, ^, directs Excel to perform the division operation. ** Answ**
FALSE
,(Excel) TRUE/FALSE:
As in algebra, you can use brackets to override the order of operations Excel follows to
perform formula calculations. ** Answ** FALSE
(Excel) TRUE/FALSE:
If you drag the fill handle to the left or up, Excel will increment the series rather than
decrement the series. ** Answ** FALSE
(Excel) TRUE/FALSE:
The Increase Indent button indents the contents of a cell to the right by three spaces
each time you click it. ** Answ** FALSE
(Excel) TRUE/FALSE:
A requirements document includes a needs statement, source of data, summary of
calculations, and any other special requirements for a worksheet. ** Answ** TRUE
(Excel) TRUE/FALSE:
Worksheet titles and subtitles should be as wordy as possible. ** Answ** FALSE
(Excel) TRUE/FALSE:
When you tap or click the Enter box to complete an entry in a cell, the active cell moves
down to the next cell in the same column. ** Answ** FALSE
(Excel) TRUE/FALSE:
The AutoCorrect feature can automatically capitalize the first letter in the names of
days. ** Answ** TRUE
(Excel) TRUE/FALSE:
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. ** Answ**
TRUE
(Excel) TRUE/FALSE:
When entering dollar values in cells, you also must type the dollar sign ($), commas,
and any trailing zeros. ** Answ** FALSE
,(Excel) TRUE/FALSE:
You can turn off the Bold formatting for selected text by clicking the Roman button
(Home tab | Font group). ** Answ** FALSE
EXCEL:
An Excel _____ allows data to be summarized and charted easily.
a. worksheet
b. workflow
c. document
d. presentation ** Answ** a. worksheet
EXCEL:
The first step in creating an effective worksheet is to make sure you _____.
a. apply font formatting
b. understand what is required
c. insert chart
d. enter the data ** Answ** b. understand what is required
EXCEL:
To enter data in a cell, you must first select the _____.
a. row
b. worksheet
c. column
d. cell ** Answ** d. cell
EXCEL:
______ is/are used to place worksheet, column, and row titles on a worksheet.
a. Color
b. Text
c. Links
d. Tabs ** Answ** b. Text
EXCEL:
Clicking the _______ box completes an entry.
a. Cancel
, b. Formula
c. Enter
d. Tab ** Answ** c. Enter
EXCEL:
The ______ feature works behind the scenes, fixing common typing or spelling
mistakes when you complete a text entry.
a. AutoComplete
b. AutoCorrect
c. AutoFormat
d. AutoTyping ** Answ** b. AutoCorrect
EXCEL:
Pressing the_____ key to complete an entry activates the adjacent cell to the right.
a. RIGHT ARROW
b. LEFT ARROW
c. UP ARROW
d. DOWN ARROW ** Answ** a. RIGHT ARROW
EXCEL:
In Excel, a number can contain the characters _______.
a. 0 1 2 3 4 5 6 7 8 9
b. + - ( ) , /
c. . $ % E e
d. all of the above ** Answ** d. all of the above
EXCEL:
The ______ is the small black square located in the lower-right corner of the heavy
border around the active cell.
a. selection handle
b. sizing handle
c. fill handle
d. copy handle ** Answ** c. fill handle
EXCEL:
The _____ button allows you to choose whether you want to copy the values from the
source area to the destination area with formatting.
Comprehensive Midterm Excel Review |Que &
Answ
(Excel) TRUE/FALSE:
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). ** Answ** TRUE
(Excel) TRUE/FALSE:
To use the AutoCalculate area, select the range of cells containing the numbers for a
calculation you want to verify and then press and hold or double-click the AutoCalculate
area to display the Customize Status Bar shortcut menu. ** Answ** FALSE
(Excel) TRUE/FALSE:
The Microsoft Office Specialist (MOS) program provides an opportunity for you to obtain
proof that you have the Excel 2013 skills required by employers. ** Answ** TRUE
(Excel) TRUE/FALSE:
You can clear cell contents and formatting by tapping or clicking Clear Contents on the
Clear button menu. ** Answ** TRUE
(Excel) TRUE/FALSE:
The equal sign (=) precedes a formula. ** Answ** TRUE
(Excel) TRUE/FALSE:
The most common error when entering a formula is to reference the wrong cell in the
formula. ** Answ** TRUE
(Excel) TRUE/FALSE:
An asterisk (*) following a cell reference in a formula is the arithmetic operator that
directs Excel to perform the division operation. ** Answ** FALSE
(Excel) TRUE/FALSE:
The arithmetic operator, ^, directs Excel to perform the division operation. ** Answ**
FALSE
,(Excel) TRUE/FALSE:
As in algebra, you can use brackets to override the order of operations Excel follows to
perform formula calculations. ** Answ** FALSE
(Excel) TRUE/FALSE:
If you drag the fill handle to the left or up, Excel will increment the series rather than
decrement the series. ** Answ** FALSE
(Excel) TRUE/FALSE:
The Increase Indent button indents the contents of a cell to the right by three spaces
each time you click it. ** Answ** FALSE
(Excel) TRUE/FALSE:
A requirements document includes a needs statement, source of data, summary of
calculations, and any other special requirements for a worksheet. ** Answ** TRUE
(Excel) TRUE/FALSE:
Worksheet titles and subtitles should be as wordy as possible. ** Answ** FALSE
(Excel) TRUE/FALSE:
When you tap or click the Enter box to complete an entry in a cell, the active cell moves
down to the next cell in the same column. ** Answ** FALSE
(Excel) TRUE/FALSE:
The AutoCorrect feature can automatically capitalize the first letter in the names of
days. ** Answ** TRUE
(Excel) TRUE/FALSE:
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. ** Answ**
TRUE
(Excel) TRUE/FALSE:
When entering dollar values in cells, you also must type the dollar sign ($), commas,
and any trailing zeros. ** Answ** FALSE
,(Excel) TRUE/FALSE:
You can turn off the Bold formatting for selected text by clicking the Roman button
(Home tab | Font group). ** Answ** FALSE
EXCEL:
An Excel _____ allows data to be summarized and charted easily.
a. worksheet
b. workflow
c. document
d. presentation ** Answ** a. worksheet
EXCEL:
The first step in creating an effective worksheet is to make sure you _____.
a. apply font formatting
b. understand what is required
c. insert chart
d. enter the data ** Answ** b. understand what is required
EXCEL:
To enter data in a cell, you must first select the _____.
a. row
b. worksheet
c. column
d. cell ** Answ** d. cell
EXCEL:
______ is/are used to place worksheet, column, and row titles on a worksheet.
a. Color
b. Text
c. Links
d. Tabs ** Answ** b. Text
EXCEL:
Clicking the _______ box completes an entry.
a. Cancel
, b. Formula
c. Enter
d. Tab ** Answ** c. Enter
EXCEL:
The ______ feature works behind the scenes, fixing common typing or spelling
mistakes when you complete a text entry.
a. AutoComplete
b. AutoCorrect
c. AutoFormat
d. AutoTyping ** Answ** b. AutoCorrect
EXCEL:
Pressing the_____ key to complete an entry activates the adjacent cell to the right.
a. RIGHT ARROW
b. LEFT ARROW
c. UP ARROW
d. DOWN ARROW ** Answ** a. RIGHT ARROW
EXCEL:
In Excel, a number can contain the characters _______.
a. 0 1 2 3 4 5 6 7 8 9
b. + - ( ) , /
c. . $ % E e
d. all of the above ** Answ** d. all of the above
EXCEL:
The ______ is the small black square located in the lower-right corner of the heavy
border around the active cell.
a. selection handle
b. sizing handle
c. fill handle
d. copy handle ** Answ** c. fill handle
EXCEL:
The _____ button allows you to choose whether you want to copy the values from the
source area to the destination area with formatting.
