MISY 5325 EXAM WITH ALL CORRECT & VERIFIED
ANSWERS (UPDATED TO PASS)
fill handle Correct answer-The small black square in the lower right corner of a selected cell
The fill handle is used to Correct 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 Correct answer-False
It is the most efficient way
True or False: Merge and Center function must be performed one row at a time. Correct answer-
True
How can you adjust the width of the column to the width of the largest item in the column Correct
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 Correct answer-True
Steps to move the chart to the new worksheet Correct 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.
Correct answer-False
True or False: All formulas in Excel start with a equal sign Correct answer-True
True or False: According to the Priority Rule in Excel, the Addition and Subtraction will be executed
before the Division and Multiplication. Correct answer-False
True or False: Any calculation placed inside the parenthesis will be executed first Correct answer-
True
Instead of typing the cell reference you can use what method Correct 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
Correct answer-relative reference
True or False: Format Painter button will copy the data (not the format) to another cell. Correct
answer-False
True or False: The Common Button will format will format all numbers with two decimal places and
have a 1000 comma separator Correct answer-True
With this function, the format of the cells will be changed automatically when the data in such cells
meet the condition. Correct answer-conditional formatting
ANSWERS (UPDATED TO PASS)
fill handle Correct answer-The small black square in the lower right corner of a selected cell
The fill handle is used to Correct 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 Correct answer-False
It is the most efficient way
True or False: Merge and Center function must be performed one row at a time. Correct answer-
True
How can you adjust the width of the column to the width of the largest item in the column Correct
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 Correct answer-True
Steps to move the chart to the new worksheet Correct 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.
Correct answer-False
True or False: All formulas in Excel start with a equal sign Correct answer-True
True or False: According to the Priority Rule in Excel, the Addition and Subtraction will be executed
before the Division and Multiplication. Correct answer-False
True or False: Any calculation placed inside the parenthesis will be executed first Correct answer-
True
Instead of typing the cell reference you can use what method Correct 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
Correct answer-relative reference
True or False: Format Painter button will copy the data (not the format) to another cell. Correct
answer-False
True or False: The Common Button will format will format all numbers with two decimal places and
have a 1000 comma separator Correct answer-True
With this function, the format of the cells will be changed automatically when the data in such cells
meet the condition. Correct answer-conditional formatting
