To boost your skills in Microsoft Excel, you’ll have to practice a lot, either by trying to answer the questions given by the examiner in your workbook or by practicing yourself by taking an Excel quiz or test. Currently, there are dozens of quizzes with Excel formulas that you can take online.
Of course, you’ll find plenty of formulas in Excel to calculate or produce a specific value—the function “CONCATENATE.” Due to too many Excel tests scattered online, the question about what formula would produce the value in cell C25 is one of the questions you may find.
If you happen to take the quiz and are seeking its answer, you can find the formula and the correct answer below.
What Formula Would Produce the Value in Cell C25? Here’s the Answer!
This is one of the questions on an Excel test found on StudyLib.net that was uploaded by Jamilah Jill Tuazon. And now, let’s see what the correct answer is!
Question: “What formula would produce the value in cell C25?”
| A | B | C | |
| 22 | Item | Type | Result |
| 23 | Door | F | Door F |
| 24 | Table | C | |
| 25 | Chair | C | |
| 26 | Desk | F |
With multiple choices as follows;
- =RIGHT(B23,C26)
- =CONCATENATE(ITEM,” “,TYPE)
- =LEFT(B23,C23)
- =CONCATENATE(B23,C23)
- =CONCATENATE(B23,” “,C23)
Correct answer: e. =CONCATENATE(B23,” “,C23)
To know the value in cell C25, we can use the function “CONCATENATE,” as you can see on the previous value in cell C23 that says “Door F.” Of course, the cell C25 should produce “Chair C,” and that’s the formula we have to use.
What is the Function of CONCATENATE in Excel?
The word “concatenate” literally means to combine or join. Likewise, with Excel functions, the formula CONCATENATE is used to combine the text from different cells into one cell. It can also be used to join up to 30 text items and return the result as text, as follows:
“=CONCATENATE (text1, text2, [text3], …)”
The following are some functions of CONCATENATE to produce a value:
1. To concatenate the values of different cells
If you want to find the value of two or more cells, for example, cells C1 and D1, you can use the formula as follows:
“=CONCATENATE(C1,D1)”
You can combine the values without any delimiters. If you want to separate the values with a space, you can use “ ”. For example, =CONCATENATE(C1,“ ”,D1).
2. To concatenate a text string and a cell value
Actually, the function of CONCATENATE is not limited to joining cell values. Well, you can use it to combine a cell value and a string as well. For example, =CONCATENATE(A2, “ ”,B2, “Animal Zoo”)
| A | B | C | |
| 1 | Text 1 | Text 2 | Result |
| 2 | Welcome | To | =CONCATENATE(A2, “ ”,B2, “Animal Zoo”)
The result will be: “Welcome to Zoo Animal” |
3. To concatenate a text string and formula calculated value
The function CONCATENATE can also be used to combine a test string and a formula calculated value. For example, =CONCATENATE(“Today is “,TEXT(TODAY(), “dd-mmm-yy”)).
| A | B | C | |
| 1 | TEXT1 | TEXT2 | Result |
| 2 | =CONCATENATE(“Today is “,TEXT(TODAY(), “dd-mmm-yy”))
The result will be: Today is 20-Dec-2023 |
Well, those are some functions of the CONCATENATE formula that you can use in Excel.
Another Quiz: What Formula Would Produce the Value in Cell C25?
You can also find the question “What formula would produce the value in Cell C25?” in the Software and Technology Exercise found in the book Beginning Project Management. This exercise requires the participants to apply the formulas of earned value (EV) analysis to the John’s Move project, which is shown in Excel.
You may find the question when taking an online test, and let’s see how to answer it!
Figure 9.11 of the EV Analysis for John’s Move
To get the value in cell 25, you can use the formula “=C4+C7+I10+L12.” Then, you can press “Enter.” Now, we find the sum of the budgeted amounts for each task, i.e., the budget at completion (BAC).
Well, you need to click cell C25 to select it. If necessary, you can click the “Increase Decimal” button two times in the Number Group to show two decimal places.
More Questions and Answers in an Excel Quiz or Test
To make it easier for you to answer the questions you may find in some Excel quizzes or tests, we’ll show more for you. Let’s take a look!
Question 1: If the formula in Cell D49 is copied to Cells E49:F49, what values would be generated in Cells D49:F49?
| D | E | F | |
| 42 | Conference Room | Location | Staff ID |
| 43 | D | East | 19106 |
| 44 | C | North | 19122 |
| 45 | A | South | 19107 |
| 46 | E | South | 19104 |
| 47 | B | South | 19147 |
| 48 | |||
| 49 | =$D$44 | C | C |
- C, North, 19122
- C, South, South
- C, A, E
- C, South, 19104
- C, C, C
Answer: e. C, C, C
Question 2: Based on the values in Cells B77:B81, which function would automatically return the value in Cell C77?
| A | B | ||
| 2 | Sales | ||
| 3 | $794 | $721 | =MIN(A2:A6) |
| 4 | $721 | ||
| 5 | $854 | ||
| 6 | $912 | ||
| 7 | $1,020 |
- =Min()
- =Bottom()
- =Smallest()
- =Lowest()
- =Floor()
Answer: a. =Min()
Question 3: What is the correct keyboard shortcut to cut a cell value?
- CTRL + P
- CTRL + X
- CTRL + B
- CTRL + C
- CTRL + V
Answer: b. CTRL + X
Question 4: Based on the values in Cells B77:B81, what function can automatically return the value in Cell C77?
| A | |||
| 8 | Sales | ||
| 9 | $794 | $1,020 | =MAX(A9:A13)’ |
| 10 | $721 | ||
| 11 | $854 | ||
| 12 | $912 | ||
| 13 | $1,020 |
- =Top()
- =Max()
- =Ceiling()
- =Biggest()
- =Highest()
Answer: b. =Max()
Question 5: What value would be returned based on the formula in Cell A49?
| A | ||
| 43 | npab | |
| 44 | npce | |
| 45 | npfo | |
| 46 | npbb | |
| 47 | norp | |
| =COUNTIF(B9:B13,”NP*”)’ | ||
- 0
- 1
- 2
- 3
- 4
Answer: e. 4
Question 6: What value would be returned based on the formula in Cell D49?
| D | E | F | ||
| 42 | Room | Location | Staff ID | |
| 43 | D | East | 19106 | |
| 44 | C | North | 19122 | |
| 45 | A | South | 19107 | |
| 46 | E | South | 19104 | |
| 47 | B | South | 19147 | |
| 48 | =COUNTIFS(C30:C34,”South”,D30:D34,”19104″) | |||
- 0
- 1
- 2
- 3
- #ERROR
- #VALUE
Answer: b. 1
Question 7: Based on the values in Cells A51:A55, what formula can you copy and paste into Cells B51:B55 to return the values shown?
| A | B | |
| 51 | Red | Yes |
| 52 | Red | Yes |
| 53 | Red | Yes |
| 54 | Blue | No |
| 55 | Red | Yes |
- =IFNA(A51=”Red”,”Yes”,”No”)
- =SHOWIF(A51=”Red”,”Yes”,”No”)
- =COUNTIF(A51=”Red”,”Yes”,”No”)
- =SUMIF(A51=”Red”,”Yes”,”No”)
- =IF(A51=”Red”,”Yes”,”No”)
Answer: e. =IF(A51=”Red”,”Yes”,”No”)
Question 8: You must divide the number of cars by the number of people to calculate cars per person on Day 1. What formula can you type in Cell D92 to get the value?
| A | B | C | D | |
| 91 | Day | Cars | People | Cars per Person |
| 92 | 1 | 10 | 3 | 3.33 |
| 93 | 2 | 20 | 4 | 5.00 |
| 94 | 3 | 30 | 5 | 6.00 |
| 95 | 4 | 40 | 6 | 6.67 |
- =3*1
- =B93/C92
- =A92/B92
- =10*3
- =B92/C92
Answer: e. =B29/C92
Question 9: In a new worksheet, what’s the correct formula to reference Cell A1 from the ALPHA worksheet?
- =ALPHA?A1
- =A1
- =ALPHA!A1
- =”ALPHA”A1
- =’ALPHA’A1
Answer: c. =ALPHA!A1
Question 10: What’s the correct sorting function to list Colors in alphabetical order (A to Z)
| Color | Number | |
| Blue | 120 | A to Z = ASCENDING |
| Green | 85 | Z to A = DESCENDING |
| Orange | 112 | EQUAL to A to Z |
| Red | 100 | |
| Yellow | 90 |
- A to Z = ASCENDING
- Z to A = DESCENDING
- EQUAL to A to Z
Answer: a. A to Z = ASCENDING
Okay, those are some questions regarding Excel that you can practice. Of course, there are still many quizzes about Excel online that you can find. Now, let’s start to practice!
A bookworm and researcher especially related to law and citizenship education. I spend time every day in front of the internet and the campus library.
