Edu 7266 Excel Review

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 Robmchs
R
Robmchs
Community Contributor
Quizzes Created: 2 | Total Attempts: 334
Questions: 16 | Attempts: 265

SettingsSettingsSettings
Edu 7266 Excel Review - Quiz

With the whole Microsoft office package, Microsoft Excel, otherwise known as excel spreadsheets is one of the hardest concepts to immediately understand. Edu 7266 Excel Review helps in its mastery. Enjoy the quiz and all the best.


Questions and Answers
  • 1. 

    Can an Excel spreadsheet be used as the "data source" for a Word Mail Merge ?

    • A.

      Yes

    • B.

      No

    Correct Answer
    A. Yes
    Explanation
    Yes, an Excel spreadsheet can be used as the "data source" for a Word Mail Merge. This means that the data from the Excel spreadsheet can be merged into a Word document to create personalized documents such as letters, labels, or envelopes. The Mail Merge feature in Word allows users to easily import and merge data from various sources, including Excel, to streamline the process of creating customized documents.

    Rate this question:

  • 2. 

    On an Excel sheet the active cell is indicated by ____.

    • A.

      A dark wide border

    • B.

      A dotted border

    • C.

      A blinking border

    • D.

      None of the above

    Correct Answer
    A. A dark wide border
    Explanation
    The active cell on an Excel sheet is indicated by a dark wide border. This border helps the user easily identify which cell is currently selected and ready for editing or formatting. It stands out from the other cells and provides a visual cue for the user's current location on the sheet. The dark wide border helps prevent any confusion or mistakes when working with multiple cells or navigating through a large dataset.

    Rate this question:

  • 3. 

    If cells: A1=90 A2=85 A3=80 A4=75 A5=75 What will be your formula if you are going to get the average?

    Correct Answer
    =AVERAGE(A1:A5)
    =(A1+A2+A3+A4+A5)/5
    =average(a1:a5)
    =(a1+a2+a3+a4+a5)/5
    Explanation
    The formula to calculate the average of the given cells is =AVERAGE(A1:A5) or =(A1+A2+A3+A4+A5)/5. Both formulas will yield the same result, which is the average of the values in cells A1, A2, A3, A4, and A5.

    Rate this question:

  • 4. 

    What's a quick way to extend these numbers to a longer sequence, for instance 23 through 40?

    • A.

      Select the last two cells and drag the fill handle over the range you want, for instance 18 more rows.

    • B.

      Select the range you want, including the three cells, point to Fill on the Edit menu, and then click Down.

    • C.

      Copy the third cell, click in the cell below it, on the Standard toolbar click the down arrow on the paste button, and select Paste Special

    Correct Answer
    A. Select the last two cells and drag the fill handle over the range you want, for instance 18 more rows.
    Explanation
    To extend the numbers to a longer sequence, you can select the last two cells and drag the fill handle over the range you want. This will automatically fill in the sequence with the desired numbers, in this case, from 23 through 40. This method is quick and efficient as it saves time compared to manually typing in each number.

    Rate this question:

  • 5. 

    You have a list containing all the employees in your organization.  You elect the AutoFilter command, and then select New York from the location field.  What is the result?

    • A.

      The list is sorted by city, with New York first.

    • B.

      The rows where the location is New York are written to another worksheet.

    • C.

      The rows where the location is not New York are deleted.

    • D.

      The rows where the location is not New York are hidden.

    Correct Answer
    D. The rows where the location is not New York are hidden.
    Explanation
    When you select New York from the location field and use the AutoFilter command, the result is that the rows where the location is not New York are hidden. This means that only the rows with New York as the location will be visible, while the rows with any other location will be hidden from view.

    Rate this question:

  • 6. 

    What function key will convert cell reference to absolute, if you are in the formula bar with the cell reference selected?

    • A.

      F11

    • B.

      F5

    • C.

      F7

    • D.

      F4

    Correct Answer
    D. F4
    Explanation
    Pressing the F4 key in the formula bar with the cell reference selected will convert the cell reference to absolute. This means that the cell reference will remain fixed and will not change when the formula is copied or moved to other cells.

    Rate this question:

  • 7. 

    If you have cells selected, it is possible to see the sum of the cells in the status bar.

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    When cells are selected in a spreadsheet program, such as Microsoft Excel, the sum of those cells can be seen in the status bar. The status bar is located at the bottom of the program window and provides information about the selected cells, including the sum of their values. This feature is useful for quickly calculating the total of a group of cells without needing to use a separate formula or function. Therefore, the statement "If you have cells selected, it is possible to see the sum of the cells in the status bar" is true.

    Rate this question:

  • 8. 

    In Excel, what does the $ do?

    • A.

      It turns numbers into currency,

    • B.

      It locks the cell reference in a function.

    • C.

      It does nothing.

    • D.

      It creates a dollar sign.

    Correct Answer
    B. It locks the cell reference in a function.
    Explanation
    The $ sign in Excel is used to lock the cell reference in a function. When a cell reference is locked, it means that it will not change when the formula is copied to other cells. This is useful when you want to maintain the same reference in a formula, such as when calculating a running total or applying a consistent formatting. By using the $ sign before the column letter, row number, or both, you can ensure that the reference remains fixed.

    Rate this question:

  • 9. 

    True False: The following is an example of a function: =sum(A1+A2+A3)/3

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    This is an equation, not a function

    Rate this question:

  • 10. 

    True False: The following illustrates the dynamic capability of a spreadsheet: =(A1+A2+A3+A4+A5)*3 

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    A built-in function for the average, for example, is generally better than personally defining a formula. With the user-defined formula for the average (where the sum is divided by three), five data points are always required whereas in the built-in AVERAGE formula, the spreadsheet ignores empty cells and nonnumeric cell data

    Rate this question:

  • 11. 

    True False: =SUM(B2:D2) derives the same value as =(B2+C2+D2)

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    The statement is true because both formulas, =SUM(B2:D2) and =(B2+C2+D2), calculate the sum of the values in cells B2, C2, and D2. Therefore, they will derive the same value.

    Rate this question:

  • 12. 

    When an equals (=) sign precedes information entered into a spreadsheet cell, it means which of the following:

    • A.

      Equals (=) sign indicates that a formula is being entered.

    • B.

      Equals (=) sign indicates that two values are of equal quantity.

    • C.

      Equals (=) sign indicates that the cell content are equal to a specified value.

    • D.

      Equals (=) specify the end of a formula entry and the beginning of a data entry.

    Correct Answer
    A. Equals (=) sign indicates that a formula is being entered.
    Explanation
    The equals (=) sign in a spreadsheet indicates that a formula is being entered. This means that the cell will perform a calculation based on the values or functions included in the formula.

    Rate this question:

  • 13. 

    What is the most optimally formed formula?

    • A.

      =SUM(B2:B10)/8

    • B.

      = (8+5+3+2+8)/5

    • C.

      =SUM(B2:B10)/B1

    • D.

      =SUM(B2:B10)/B1

    Correct Answer
    C. =SUM(B2:B10)/B1
    Explanation
    The most optimally formed formula is =SUM(B2:B10)/B1. This formula calculates the sum of the values in cells B2 to B10 and then divides it by the value in cell B1. This formula uses the SUM function to efficiently calculate the sum of multiple cells and then divides it by a specific cell value, making it a more efficient and concise formula compared to the other options provided.

    Rate this question:

  • 14. 

    You are interested in determining if cell N5 contains a number that exceeds 89 and if it does, then cell A5 present the feedback,  “Excellent work!” If N5 is 89 or less, then cell A5 presents “Keep trying!” Select the formula that should be entered in cell A5 to achieve this result.

    • A.

      =IF(N5>89, “Keep trying!”, “Excellent work!”)

    • B.

      =IF(N5>89, “Excellent work!”, “Keep trying!”)

    • C.

      =IF(A5

    • D.

      =IF N5>89, “Excellent work!”, A5, “Keep Trying!”

    Correct Answer
    B. =IF(N5>89, “Excellent work!”, “Keep trying!”)
    Explanation
    The correct answer is =IF(N5>89, “Excellent work!”, “Keep trying!”) because this formula uses the IF function to check if the value in cell N5 is greater than 89. If it is, it will display "Excellent work!" in cell A5. If it is not, it will display "Keep trying!". The other options have incorrect syntax or the messages in cell A5 are reversed.

    Rate this question:

  • 15. 

    In order to multiply items in Excel you would use:

    • A.

      ^

    • B.

      @

    • C.

      *

    • D.

      #

    Correct Answer
    C. *
    Explanation
    To multiply items in Excel, the asterisk (*) symbol is used. This symbol represents the multiplication operation in Excel.

    Rate this question:

  • 16. 

    My name is    __________________________________

    Correct Answer
    N/A

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Mar 18, 2014
    Quiz Created by
    Robmchs
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.