Session 4 Review Questions: Multiple-choice Quiz
Settings
Session 4
- 1.What combination of keys moved to the top of the spreadsheet?
- A.
CTRL+ALT
- B.
ALT+HOME
- C.
CTRL+END
- D.
CTRL+HOME
- 2.Which keyword key allowsyou to select nonadjacent cells?
- A.
CTRL
- B.
ALT
- C.
SHIFT
- D.
TAB
- 3.Which keyboard key allows you to select adjacent cells?
- A.
CTRL
- B.
ALT
- C.
SHIFT
- D.
TAB
- 4.To move the graphs you must:
- A.
Drag it to a new location.
- B.
Select it and then drag it to a new location.
- C.
Resize it to fit the area that is already in.
- D.
You cannot move the graph.
- 5.To move a graph you must:
- A.
Drag it to a new location.
- B.
Select it and then drag it to a new location.
- C.
Resize it to fit the area is already in.
- D.
You cannot move the graph.
- 6.A trendline is a line that:
- A.
Indicates trends based on mathematical calculations that can determine the next value on a chart.
- B.
Shows movement of information.
- C.
Indicates the value is going up.
- D.
Indicates the value is going down.
- 7.A line chart:
- A.
Displays data in columns or bars.
- B.
Displays the trend of data over time.
- C.
Displays data in a table format.
- D.
Displays data in a pie or circle graph.
- 8.Use this type of trend line to show whether a stock value is steadily rising or falling:
- A.
Prediction
- B.
Exponential
- C.
Linear Forecast
- D.
Moving Average
- 9.A linear forecast trendline:
- A.
Randomly calculates or predicts a future value.
- B.
Divides the current values to find an average.
- C.
Determines the number of periods to predict a future value.
- D.
Calculates or predicts the future value by using existing values.
- 10.To create a stock market trendline, the spreadsheet program uses:
- A.
The stock market index.
- B.
The trendlines of other companies in the stock market.
- C.
The amount of shares astockbroker has purchased.
- D.
The data in the chart.
Back to top