EDU 7266 Excel Review

Reviewed by Editorial Team

The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.

Learn about Our Editorial Process

| By Robmchs

Robmchs

Community Contributor

Quizzes Created: 2 | Total Attempts: 342

| Attempts: 274

Questions

Feedback

During the Quiz End of Quiz

Difficulty

Sequential Easy First Hard First

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

1/16 Questions

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

About This 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.

2.

On an Excel sheet the active cell is indicated by ____.
- A dark wide border
- A dotted border
- A blinking border
- 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?
- Select the last two cells and drag the fill handle over the range you want, for instance 18 more rows.
- Select the range you want, including the three cells, point to Fill on the Edit menu, and then click Down.
- 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?
- The list is sorted by city, with New York first.
- The rows where the location is New York are written to another worksheet.
- The rows where the location is not New York are deleted.
- The rows where the location is not New York are hidden.
Correct Answer

A. 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?
- F11
- F5
- F7
- F4
Correct Answer

A. 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.
- True
- 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?
- It turns numbers into currency,
- It locks the cell reference in a function.
- It does nothing.
- It creates a dollar sign.
Correct Answer

A. 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
- True
- False
Correct Answer

A. 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
- True
- False
Correct Answer

A. 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)
- True
- 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:
- Equals (=) sign indicates that a formula is being entered.
- Equals (=) sign indicates that two values are of equal quantity.
- Equals (=) sign indicates that the cell content are equal to a specified value.
- 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?
- =SUM(B2:B10)/8
- = (8+5+3+2+8)/5
- =SUM(B2:B10)/B1
- =SUM(B2:B10)/B1
Correct Answer

A. =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.
- =IF(N5>89, “Keep trying!”, “Excellent work!”)
- =IF(N5>89, “Excellent work!”, “Keep trying!”)
- =IF(A5
- =IF N5>89, “Excellent work!”, A5, “Keep Trying!”
Correct Answer

A. =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:
- ^
- @
- *
- #
Correct Answer

A. *

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 (Updated): Mar 21, 2023 +

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

Edu 7266 Excel Review

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

Quiz Preview

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

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?

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

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?

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

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

In Excel, what does the $ do?

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

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

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

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

What is the most optimally formed formula?

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.

In order to multiply items in Excel you would use:

My name is __________________________________