MGT 2180- MODULE 2 EXAM QUESTIONS AND
ANSWERS
Which of the following functions calculates payments for a loan if regular payments are
made and the interest rate is constant? - Answers - PMT function
In Excel, the active cell displays a solid border around the cell, and the address for the
active cell appears in the Name box - Answers - true
how to change zoom level - Answers - go to slider at bottom of page
Which of the following pie charts has a follow center? - Answers - doughnut chart
cell F6 is the intersection of row F and column 6 - Answers - FALSE
once you have created a chart, it is possible to change the chart type - Answers - true
which of the following chart types displays the magnitude of change over time and
shows the rate of change? - Answers - area
which of the following could you add to a chart to predict future values? - Answers -
trendline
how to resize charts - Answers - just grab and drag the edges
which of the following shapes can you use to highlight important parts of a chart? -
Answers -
how to clear the print area - Answers - page layout-- print area-- clear print area
which of the following is a rectangular area bounded by the horizontal and vertical
axes? - Answers - plot area
what can pie charts graph? - Answers -
each group of data points or values used in a graph is a data series - Answers - TRUE
which of the following function keys makes it easier to insert a range name in a formula?
- Answers - F3
which of the following options allows you to copy formatting attributes and styles from
one cell to another cell or group of cells? - Answers - format painter
ANSWERS
Which of the following functions calculates payments for a loan if regular payments are
made and the interest rate is constant? - Answers - PMT function
In Excel, the active cell displays a solid border around the cell, and the address for the
active cell appears in the Name box - Answers - true
how to change zoom level - Answers - go to slider at bottom of page
Which of the following pie charts has a follow center? - Answers - doughnut chart
cell F6 is the intersection of row F and column 6 - Answers - FALSE
once you have created a chart, it is possible to change the chart type - Answers - true
which of the following chart types displays the magnitude of change over time and
shows the rate of change? - Answers - area
which of the following could you add to a chart to predict future values? - Answers -
trendline
how to resize charts - Answers - just grab and drag the edges
which of the following shapes can you use to highlight important parts of a chart? -
Answers -
how to clear the print area - Answers - page layout-- print area-- clear print area
which of the following is a rectangular area bounded by the horizontal and vertical
axes? - Answers - plot area
what can pie charts graph? - Answers -
each group of data points or values used in a graph is a data series - Answers - TRUE
which of the following function keys makes it easier to insert a range name in a formula?
- Answers - F3
which of the following options allows you to copy formatting attributes and styles from
one cell to another cell or group of cells? - Answers - format painter
