MISY 5325 EXCEL MIDTERM ULTIMATE REVIEW
QUESTIONS & ANSWERS
A ctrl key should be pressed if users want to select cells or a range of cells which are
not adjacent. - Answers - TRUE
To properly move a chart to another worksheet, you should use the function ________
move chart - Answers - C.
move chart
If users enter the functions correctly, the functions SUMIF and DSUM should return the
same result. - Answers - TRUE
Which of the following of cell reference will not change when the formula was copied
and pasted in another cell? - Answers - B. $A$1 (Absolute Reference)
Which one of the following statement is NOT true about the function Table? - Answers -
C. Once the Table function is applied on the data, there is no way to convert it back.
(The above statement is FALSE/NOT TRUE)
To display the formula in a worksheet, a user should press ____________ - Answers -
C. Ctrl + Accent
The PV function is usually used to calculate the ending balance of the loan in an
amortization schedule. - Answers - TRUE
The function Hide will allow users to hide the column, but not row. - Answers - FALSE
Linda deposits 200 into a bank every month. The annual interest rate is 6%. She
deposits the money for 4 years. Which one of the following is the function to calculate
the money she would have at the end of the fourth year? - Answers - C. = -FV(6%/12,
4*12, 200)
[with a minus - sign before the future value]
Typically, the function Autosum should not be used to find the total for a column
containing data in percentage. - Answers - TRUE
The function Hide will allow users to hide the column, but not row. - Answers - FALSE
Linda deposits 200 into a bank every month. The annual interest rate is 6%. She
deposits the money for 4 years. Which one of the following is the function to calculate
the money she would have at the end of the fourth year? - Answers -
,(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). - Answers - 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. - Answers - 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. - Answers - TRUE
(Excel) TRUE/FALSE:
You can clear cell contents and formatting by tapping or clicking Clear Contents on the
Clear button menu. - Answers - TRUE
(Excel) TRUE/FALSE:
The equal sign (=) precedes a formula. - Answers - TRUE
(Excel) TRUE/FALSE:
The most common error when entering a formula is to reference the wrong cell in the
formula. - Answers - 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. - Answers - FALSE
(Excel) TRUE/FALSE:
The arithmetic operator, ^, directs Excel to perform the division operation. - Answers -
FALSE
(Excel) TRUE/FALSE:
As in algebra, you can use brackets to override the order of operations Excel follows to
perform formula calculations. - Answers - 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. - Answers - 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. - Answers - 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. - Answers - TRUE
(Excel) TRUE/FALSE:
Worksheet titles and subtitles should be as wordy as possible. - Answers - 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. - Answers - FALSE
(Excel) TRUE/FALSE:
The AutoCorrect feature can automatically capitalize the first letter in the names of
days. - Answers - 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. - Answers -
TRUE
(Excel) TRUE/FALSE:
When entering dollar values in cells, you also must type the dollar sign ($), commas,
and any trailing zeros. - Answers - FALSE
(Excel) TRUE/FALSE:
You can turn off the Bold formatting for selected text by clicking the Roman button
(Home tab | Font group). - Answers - FALSE
EXCEL:
, An Excel _____ allows data to be summarized and charted easily.
a. worksheet
b. workflow
c. document
d. presentation - Answers - 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 - Answers - 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 - Answers - d. cell
EXCEL:
______ is/are used to place worksheet, column, and row titles on a worksheet.
a. Color
b. Text
c. Links
d. Tabs - Answers - b. Text
EXCEL:
Clicking the _______ box completes an entry.
a. Cancel
b. Formula
c. Enter
d. Tab - Answers - c. Enter
EXCEL:
QUESTIONS & ANSWERS
A ctrl key should be pressed if users want to select cells or a range of cells which are
not adjacent. - Answers - TRUE
To properly move a chart to another worksheet, you should use the function ________
move chart - Answers - C.
move chart
If users enter the functions correctly, the functions SUMIF and DSUM should return the
same result. - Answers - TRUE
Which of the following of cell reference will not change when the formula was copied
and pasted in another cell? - Answers - B. $A$1 (Absolute Reference)
Which one of the following statement is NOT true about the function Table? - Answers -
C. Once the Table function is applied on the data, there is no way to convert it back.
(The above statement is FALSE/NOT TRUE)
To display the formula in a worksheet, a user should press ____________ - Answers -
C. Ctrl + Accent
The PV function is usually used to calculate the ending balance of the loan in an
amortization schedule. - Answers - TRUE
The function Hide will allow users to hide the column, but not row. - Answers - FALSE
Linda deposits 200 into a bank every month. The annual interest rate is 6%. She
deposits the money for 4 years. Which one of the following is the function to calculate
the money she would have at the end of the fourth year? - Answers - C. = -FV(6%/12,
4*12, 200)
[with a minus - sign before the future value]
Typically, the function Autosum should not be used to find the total for a column
containing data in percentage. - Answers - TRUE
The function Hide will allow users to hide the column, but not row. - Answers - FALSE
Linda deposits 200 into a bank every month. The annual interest rate is 6%. She
deposits the money for 4 years. Which one of the following is the function to calculate
the money she would have at the end of the fourth year? - Answers -
,(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). - Answers - 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. - Answers - 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. - Answers - TRUE
(Excel) TRUE/FALSE:
You can clear cell contents and formatting by tapping or clicking Clear Contents on the
Clear button menu. - Answers - TRUE
(Excel) TRUE/FALSE:
The equal sign (=) precedes a formula. - Answers - TRUE
(Excel) TRUE/FALSE:
The most common error when entering a formula is to reference the wrong cell in the
formula. - Answers - 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. - Answers - FALSE
(Excel) TRUE/FALSE:
The arithmetic operator, ^, directs Excel to perform the division operation. - Answers -
FALSE
(Excel) TRUE/FALSE:
As in algebra, you can use brackets to override the order of operations Excel follows to
perform formula calculations. - Answers - 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. - Answers - 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. - Answers - 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. - Answers - TRUE
(Excel) TRUE/FALSE:
Worksheet titles and subtitles should be as wordy as possible. - Answers - 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. - Answers - FALSE
(Excel) TRUE/FALSE:
The AutoCorrect feature can automatically capitalize the first letter in the names of
days. - Answers - 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. - Answers -
TRUE
(Excel) TRUE/FALSE:
When entering dollar values in cells, you also must type the dollar sign ($), commas,
and any trailing zeros. - Answers - FALSE
(Excel) TRUE/FALSE:
You can turn off the Bold formatting for selected text by clicking the Roman button
(Home tab | Font group). - Answers - FALSE
EXCEL:
, An Excel _____ allows data to be summarized and charted easily.
a. worksheet
b. workflow
c. document
d. presentation - Answers - 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 - Answers - 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 - Answers - d. cell
EXCEL:
______ is/are used to place worksheet, column, and row titles on a worksheet.
a. Color
b. Text
c. Links
d. Tabs - Answers - b. Text
EXCEL:
Clicking the _______ box completes an entry.
a. Cancel
b. Formula
c. Enter
d. Tab - Answers - c. Enter
EXCEL:
