1|Page
MISY 5325 MS Excel Midterm Exam || Most Recent
Exam Actual Complete Real Verified Exam Questions
And Correct Answers (Verified Answers) Already
Graded A+ | Guaranteed Success!! Newest Exam!!!
What should be pressed if a user wants to select cells or a
range of cells which are not ajacent? - Answer-Ctrl Key
Linda deposits $200 into the bank every month. The
Annual interest rate is 6%. She deposits money for four
years. Which one of the following is the function to
calculate the money at the end of the fourth year? -
Answer--FV(6%/12,4*12,200)
Typically, the function AUTOSUM should be used to find
the total for a column containing data in percentage%. -
Answer-False
A ctrl key should be pressed if users want to select cells or
a range of cells which are not adjacent. - Answer-TRUE
To properly move a chart to another worksheet, you
should use the function ________ move chart - Answer-C.
move chart
,2|Page
If users enter the functions correctly, the functions SUMIF
and DSUM should return the same result. - Answer-TRUE
Which of the following of cell reference will not change
when the formula was copied and pasted in another cell? -
Answer-B. $A$1 (Absolute Reference)
Which one of the following statement is NOT true about
the function Table? - Answer-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
____________ - Answer-C. Ctrl + Accent
The PV function is usually used to calculate the ending
balance of the loan in an amortization schedule. - Answer-
TRUE
The function Hide will allow users to hide the column, but
not row. - Answer-FALSE
,3|Page
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? -
Answer-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. -
Answer-TRUE
"$A$1" is a cell reference that will not change when the
formula was copied and pasted in another cell. - Answer-
True
The functions "SUMIF" & "DSUM" should return the same
result. - Answer-True
To properly move a chart to another worksheet, you
should use what function? - Answer-Move Chart
, 4|Page
To display the formulas on the worksheet, press_____. -
Answer-Ctrl+Accent
Once the table function is applied on the data, there is NO
way to convert it back. - Answer-False
The function Hide will allow users to hide the column, but
not row. - Answer-FALSE
(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). - Answer-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. -
Answer-FALSE
MISY 5325 MS Excel Midterm Exam || Most Recent
Exam Actual Complete Real Verified Exam Questions
And Correct Answers (Verified Answers) Already
Graded A+ | Guaranteed Success!! Newest Exam!!!
What should be pressed if a user wants to select cells or a
range of cells which are not ajacent? - Answer-Ctrl Key
Linda deposits $200 into the bank every month. The
Annual interest rate is 6%. She deposits money for four
years. Which one of the following is the function to
calculate the money at the end of the fourth year? -
Answer--FV(6%/12,4*12,200)
Typically, the function AUTOSUM should be used to find
the total for a column containing data in percentage%. -
Answer-False
A ctrl key should be pressed if users want to select cells or
a range of cells which are not adjacent. - Answer-TRUE
To properly move a chart to another worksheet, you
should use the function ________ move chart - Answer-C.
move chart
,2|Page
If users enter the functions correctly, the functions SUMIF
and DSUM should return the same result. - Answer-TRUE
Which of the following of cell reference will not change
when the formula was copied and pasted in another cell? -
Answer-B. $A$1 (Absolute Reference)
Which one of the following statement is NOT true about
the function Table? - Answer-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
____________ - Answer-C. Ctrl + Accent
The PV function is usually used to calculate the ending
balance of the loan in an amortization schedule. - Answer-
TRUE
The function Hide will allow users to hide the column, but
not row. - Answer-FALSE
,3|Page
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? -
Answer-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. -
Answer-TRUE
"$A$1" is a cell reference that will not change when the
formula was copied and pasted in another cell. - Answer-
True
The functions "SUMIF" & "DSUM" should return the same
result. - Answer-True
To properly move a chart to another worksheet, you
should use what function? - Answer-Move Chart
, 4|Page
To display the formulas on the worksheet, press_____. -
Answer-Ctrl+Accent
Once the table function is applied on the data, there is NO
way to convert it back. - Answer-False
The function Hide will allow users to hide the column, but
not row. - Answer-FALSE
(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). - Answer-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. -
Answer-FALSE
