QUESTIONS AND ANSWERS FULL
SOLUTION
●● 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.