Session 4 Review Questions: Multiple-choice Quiz

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Billerica.k12.ma
B
Billerica.k12.ma
Community Contributor
Quizzes Created: 6 | Total Attempts: 4,597
Questions: 10 | Attempts: 60

SettingsSettingsSettings
Session 4 Review Questions: Multiple-choice Quiz - Quiz


Session 4


Questions and Answers
  • 1. 

    What combination of keys moved to the top of the spreadsheet?

    • A.

      CTRL+ALT

    • B.

      ALT+HOME

    • C.

      CTRL+END

    • D.

      CTRL+HOME

    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.

    Rate this question:

  • 2. 

    Which keyword key allowsyou to select nonadjacent cells?

    • A.

      CTRL

    • B.

      ALT

    • C.

      SHIFT

    • D.

      TAB

    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.

    Rate this question:

  • 3. 

    Which keyboard key allows you to select adjacent cells?

    • A.

      CTRL

    • B.

      ALT

    • C.

      SHIFT

    • D.

      TAB

    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.

    Rate this question:

  • 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.

    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.

    Rate this question:

  • 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.

    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.

    Rate this question:

  • 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.

    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.

    Rate this question:

  • 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.

    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.

    Rate this question:

  • 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

    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.

    Rate this question:

  • 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.

    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.

    Rate this question:

  • 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.

    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.

    Rate this question:

Related Topics

Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.