1.
Can an Excel spreadsheet be used as the
"data source" for a Word Mail Merge ?
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.
2.
On an Excel sheet the active cell is indicated
by ____.
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.
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.
4.
What's a quick way to extend these numbers to a longer sequence, for instance 23 through 40?
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.
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?
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.
6.
What function key will convert cell reference to absolute, if you are in the formula bar with the cell reference selected?
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.
7.
If you have cells selected, it is possible to see the sum of the cells in the status bar.
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.
8.
In Excel, what does the $ do?
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.
9.
True False: The following is an example of a function: =sum(A1+A2+A3)/3
Correct Answer
B. False
Explanation
This is an equation, not a function
10.
True False: The following illustrates the dynamic capability of a spreadsheet:
=(A1+A2+A3+A4+A5)*3
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
11.
True False: =SUM(B2:D2) derives the same value as =(B2+C2+D2)
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.
12.
When an equals (=) sign precedes information entered into a spreadsheet cell, it means which of the following:
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.
13.
What is the most optimally formed formula?
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.
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.
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.
15.
In order to multiply items in Excel you would use:
Correct Answer
C. *
Explanation
To multiply items in Excel, the asterisk (*) symbol is used. This symbol represents the multiplication operation in Excel.
16.
My name is __________________________________
Correct Answer
N/A