1.
What combination of keys moved to the top of the spreadsheet?
Correct Answer
D. CTRL+HOME
Explanation
Pressing the combination of keys CTRL+HOME moves the cursor to the top left cell of the spreadsheet. This allows the user to quickly navigate to the beginning of the spreadsheet, making it easier to work with large amounts of data.
2.
Which keyword key allowsyou to select nonadjacent cells?
Correct Answer
A. CTRL
Explanation
The CTRL key allows you to select nonadjacent cells. By holding down the CTRL key while clicking on different cells, you can select multiple cells that are not next to each other. This is a useful feature when you need to perform actions or formatting on multiple cells at once without selecting all the cells in between.
3.
Which keyboard key allows you to select adjacent cells?
Correct Answer
C. SHIFT
Explanation
The SHIFT key allows you to select adjacent cells. By holding down the SHIFT key and clicking on a cell, you can select that cell and all the cells in between it and the previously selected cell. This is a useful shortcut when you want to quickly select a range of cells in a spreadsheet or a block of text in a document.
4.
To move the graphs you must:
Correct Answer
B. Select it and then drag it to a new location.
Explanation
The correct answer is to select the graph and then drag it to a new location. This means that in order to move the graphs, you need to first click on the graph to select it and then use the mouse to drag it to a different position on the screen. Simply dragging the graph without selecting it first will not move it. Additionally, resizing the graph or not being able to move it are not valid methods for moving the graph.
5.
To move a graph you must:
Correct Answer
B. Select it and then drag it to a new location.
Explanation
To move a graph, you need to select it first and then drag it to a new location. This means that simply dragging the graph without selecting it will not move it. Selecting the graph before dragging ensures that you are moving the intended graph and not any other element on the screen. This action allows you to reposition the graph within the given area or move it to a different location altogether.
6.
A trendline is a line that:
Correct Answer
A. Indicates trends based on mathematical calculations that can determine the next value on a chart.
Explanation
A trendline is a line that indicates trends based on mathematical calculations that can determine the next value on a chart. This means that it is not just showing the movement of information or indicating whether the value is going up or down, but it actually uses mathematical calculations to predict the future values on the chart. It helps to identify patterns and trends in the data, allowing for better analysis and decision-making.
7.
A line chart:
Correct Answer
B. Displays the trend of data over time.
Explanation
A line chart is a type of graph that displays the trend of data over time. It uses a line to connect data points, showing the progression or change in the data over a specific period. Unlike bar or column charts, which display data in a visual representation of columns or bars, a line chart focuses on illustrating the trend or pattern of the data points. It is commonly used to analyze and track data over time, such as stock prices, population growth, or sales figures.
8.
Use this type of trend line to show whether a stock value is steadily rising or falling:
Correct Answer
C. Linear Forecast
Explanation
A linear forecast trend line is used to show whether a stock value is steadily rising or falling. This type of trend line is based on a straight line equation, where the slope indicates the direction and magnitude of the trend. If the slope is positive, it indicates a steady increase in the stock value over time. Conversely, if the slope is negative, it indicates a steady decrease in the stock value. Therefore, a linear forecast trend line is suitable for analyzing the overall trend and direction of a stock's value.
9.
A linear forecast trendline:
Correct Answer
D. Calculates or predicts the future value by using existing values.
Explanation
A linear forecast trendline calculates or predicts the future value by using existing values. It analyzes the trend and relationship between the current values and uses this information to estimate what the future value might be. This method assumes a linear relationship between the variables and uses regression analysis to determine the best-fit line. By extrapolating this line into the future, it can provide a forecast for upcoming periods.
10.
To create a stock market trendline, the spreadsheet program uses:
Correct Answer
D. The data in the chart.
Explanation
The correct answer is "The data in the chart." This is because to create a stock market trendline, the spreadsheet program needs the actual data points from the stock market, such as the stock prices over a period of time. The trendline is then drawn based on this data to show the general direction and pattern of the stock's movement. The stock market index, trendlines of other companies, and the amount of shares purchased by a stockbroker are not directly used to create the trendline.