MISY 5325 | UPDATED Questions with 100% Verified
Answers
Q1: fill handle
A: The small black square in the lower right corner of a selected cell
Q2: The fill handle is used to
A: copy and paste data
Q3: 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
A: False
It is the most efficient way
Q4: True or False: Merge and Center function must be performed
one row at a time.
A: True
Q5: How can you adjust the width of the column to the width of
the largest item in the column
A: double click on column border
Q6: True or False: In order to select the range that is not a
continuous range, you must use the control key
A: True
Q7: Steps to move the chart to the new worksheet
A: under the Design tab
click the Move Chart icon
the Move Chart dialog-box will pop up
Select the New Sheet
Q8: True or False: If you move a chart correctly you will see the
cell background behind the chart.
A: False
Q9: True or False: All formulas in Excel start with a equal sign
A: True
Q10: True or False: According to the Priority Rule in Excel, the
Addition and Subtraction will be executed before the Division
, and Multiplication.
A: False
Q11: True or False: Any calculation placed inside the parenthesis
will be executed first
A: True
Q12: Instead of typing the cell reference you can use what method
A: clinking method
Q13: 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
A: relative reference
Q14: True or False: Format Painter button will copy the data (not the
format) to another cell.
A: False
Q15: True or False: The Common Button will format will format all
numbers with two decimal places and have a 1000 comma
separator
A: True
Q16: With this function, the format of the cells will be changed
automatically when the data in such cells meet the condition.
A: conditional formatting
Q17: To display the worksheet with formulas, press
A: CTRL + `
Q18: True or False: A System Date formula will display the current
date and time every time we open the work sheet
A: True
Q19: What is the System Date formula?
A: =NOW()
Answers
Q1: fill handle
A: The small black square in the lower right corner of a selected cell
Q2: The fill handle is used to
A: copy and paste data
Q3: 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
A: False
It is the most efficient way
Q4: True or False: Merge and Center function must be performed
one row at a time.
A: True
Q5: How can you adjust the width of the column to the width of
the largest item in the column
A: double click on column border
Q6: True or False: In order to select the range that is not a
continuous range, you must use the control key
A: True
Q7: Steps to move the chart to the new worksheet
A: under the Design tab
click the Move Chart icon
the Move Chart dialog-box will pop up
Select the New Sheet
Q8: True or False: If you move a chart correctly you will see the
cell background behind the chart.
A: False
Q9: True or False: All formulas in Excel start with a equal sign
A: True
Q10: True or False: According to the Priority Rule in Excel, the
Addition and Subtraction will be executed before the Division
, and Multiplication.
A: False
Q11: True or False: Any calculation placed inside the parenthesis
will be executed first
A: True
Q12: Instead of typing the cell reference you can use what method
A: clinking method
Q13: 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
A: relative reference
Q14: True or False: Format Painter button will copy the data (not the
format) to another cell.
A: False
Q15: True or False: The Common Button will format will format all
numbers with two decimal places and have a 1000 comma
separator
A: True
Q16: With this function, the format of the cells will be changed
automatically when the data in such cells meet the condition.
A: conditional formatting
Q17: To display the worksheet with formulas, press
A: CTRL + `
Q18: True or False: A System Date formula will display the current
date and time every time we open the work sheet
A: True
Q19: What is the System Date formula?
A: =NOW()
