Edu 7266 Excel Review
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.
- 1.
Can an Excel spreadsheet be used as the "data source" for a Word Mail Merge ?
- A.
Yes
- B.
No
Correct Answer
A. YesExplanation
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 borderExplanation
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)/5Explanation
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. F4Explanation
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. TrueExplanation
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. FalseExplanation
This is an equation, not a functionRate 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. FalseExplanation
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 dataRate this question:
-
- 11.
True False: =SUM(B2:D2) derives the same value as =(B2+C2+D2)
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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)/B1Explanation
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, 2023Quiz Edited by
ProProfs Editorial Team -
Mar 18, 2014Quiz Created by
Robmchs
Back to top