MISY 5325 COMPREHENSIVE
EXAMINATION TEST 2026 VERIFIED
QUESTIONS AND ANSWERS GRADED A+
●● The fill handle is used to. Answer: copy and paste data
●● True or False: The fill handle is the least efficient way to copy and
paste a formula from one cell to a range of cells. Answer: False
It is the most efficient way
●● True or False: Merge and Center function must be performed one
row at a time.. Answer: True
●● How can you adjust the width of the column to the width of the
largest item in the column. Answer: double click on column border
●● True or False: In order to select the range that is not a continuous
range, you must use the control key. Answer: True
●● Steps to move the chart to the new worksheet. Answer: under the
Design tab
click the Move Chart icon
the Move Chart dialog-box will pop up
, Select the New Sheet
●● True or False: If you move a chart correctly you will see the cell
background behind the chart.. Answer: False
●● True or False: All formulas in Excel start with a equal sign. Answer:
True
●● True or False: According to the Priority Rule in Excel, the Addition
and Subtraction will be executed before the Division and Multiplication..
Answer: False
●● True or False: Any calculation placed inside the parenthesis will be
executed first. Answer: True
●● Instead of typing the cell reference you can use what method.
Answer: clinking method
●● If you copy a cell containing a formula and paste the formula into
another cell, the formula will be changed accordingly, depending on how
many rows or columns you have moved. This is called. Answer: relative
reference
●● True or False: Format Painter button will copy the data (not the
format) to another cell.. Answer: False
EXAMINATION TEST 2026 VERIFIED
QUESTIONS AND ANSWERS GRADED A+
●● The fill handle is used to. Answer: copy and paste data
●● True or False: The fill handle is the least efficient way to copy and
paste a formula from one cell to a range of cells. Answer: False
It is the most efficient way
●● True or False: Merge and Center function must be performed one
row at a time.. Answer: True
●● How can you adjust the width of the column to the width of the
largest item in the column. Answer: double click on column border
●● True or False: In order to select the range that is not a continuous
range, you must use the control key. Answer: True
●● Steps to move the chart to the new worksheet. Answer: under the
Design tab
click the Move Chart icon
the Move Chart dialog-box will pop up
, Select the New Sheet
●● True or False: If you move a chart correctly you will see the cell
background behind the chart.. Answer: False
●● True or False: All formulas in Excel start with a equal sign. Answer:
True
●● True or False: According to the Priority Rule in Excel, the Addition
and Subtraction will be executed before the Division and Multiplication..
Answer: False
●● True or False: Any calculation placed inside the parenthesis will be
executed first. Answer: True
●● Instead of typing the cell reference you can use what method.
Answer: clinking method
●● If you copy a cell containing a formula and paste the formula into
another cell, the formula will be changed accordingly, depending on how
many rows or columns you have moved. This is called. Answer: relative
reference
●● True or False: Format Painter button will copy the data (not the
format) to another cell.. Answer: False