Microsoft Excel is a spreadsheet which is developed by Microsoft. People use it for calculation because it offers a lot of formulas that can make users easy to calculate in their business. In Microsoft Excel, the cells are arranged in numbered-rows and letter-named columns. So, organizing data will be easier.
Talking about cells in Microsoft Excel, when you are learning this program, you may have a question about the value that would be returned based on the formula in cell D49. Or now, you may be studying it and you find this question in your workbook. What is the answer for the question? Let’s find out the answer for the question below together with some other examples of questions about excel.
The Answer for the Question: What Value Would be Returned Based on the Formula in Cell D49
Now, you may be trying to answer this question in your workbook. If so, you are able to find the answer below.
Question: What value would be returned based on the formula in Cell D49?
|
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 | =COUNTIFS(E42:E47,”South”,F42:F47,”19104”) | ||
- 0
- 1
- 2
- 3
- #ERROR
- #VALUE
Answer: 1
About COUNTIFS Formula
There are a lot of formulas that can be used in Excel. COUNTIFS is one of the formulas. What is the COUNTIFS formula? As explained on the Microsoft Support, the COUNTIFS function applies criteria to cells across multiple ranges and calculates the number of times all criteria which are met.
The syntax of the formula is:
COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)
Criteria_range1 and criteria1 are required. Meanwhile, criteria_range2, criteria2, … are optional. It is important to note that every additional range needs to have the similar number of rows and columns as the criteria_range1 argument and the ranges do not need to be adjacent to each other.
Some Other Questions and Answers About Excel
Here are some examples of questions and answers about Microsoft Excel from some sources, such as GFC Global, Proprofs, and Scribd that you can study.
- What value would be returned based on the formula that you can see 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
- Based on the values in Cells B77:B81, what function is automatically able to 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()
- What is the right keyboard shortcut for cutting a cell value?
- CTRL + P
- CTRL + X
- CTRL + B
- CTRL + C
- CTRL + V
Answer: b. CTRL + X
- What does clicking the + sign below do?
- Adds a new Worksheet
- Adds a new Row
- Adds a new Chart
- Adds a new Function
- Adds a new Column
Answer: a. adds a new Worksheet
- What is the correct sorting function to list colors in alphabetical order (A to Z)?
|
Color |
Number |
| Blue | 120 |
| Green | 85 |
| Orange | 112 |
| Red | 100 |
| Yellow | 90 |
- A to Z = ASCENDING
- Z to A = DESCENDING
- EQUAL to A to Z
Answer: a. A to Z = ASCENDING
- The intersection of a row and a column is called a …
- Chart
- Sum
- Worksheet
- Cell
Answer: d. Cell
- A group of cells is called a …
- Cell cluster
- Multicell
- Cell range
- Chart
Answer: c. Cell range
- Which of the options below is an absolute cell reference?
- A2
- #A2
- $A$2
- A:2
Answer: c. $A$2
- What value would Excel return for this formula? =(82-32)/5+8*2
- 36 c. 7.69
- 91.6 d. 26
Answer: d. 26
- What is the main advantage of choosing the Mark as Final option?
- It discourages other users from editing the workbook.
- It ensures that the workbook is free of errors.
- It prevents other users from editing the workbook.
- It prevents other users from viewing the workbook.
Answer: a. It discourages other users from editing the workbook.
- What feature begins with a desired result, then calculates the input value that will give that result?
- Goal seek c. SmartArt
- Reverse formula d. Data validation
Answer: a. Goal seek
- In Excel, what is a workbook?
- A type of chart
- A sheet of paper with printed data on it
- A collection of files in a folder
- A file that stores one or more worksheets
Answer: d. a file that stores one or more worksheets
- What do you do to choose multiple cells at once in Excel?
- Click and drag over the cells you want to select.
- Hold down the Shift key while clicking the cells you want to select.
- All of these ways
- Hold down the CTRL key while clicking the cells you want to select.
Answer: c. all of these ways
- What do you do to resize a column or row in Excel?
- Double-click the border of the column or row
- Click and drag the border of the column or row
- Use the Format Cells dialog box
- None of these ways
Answer: b. Click and drag the border of the column or row
- What is the meaning of ######?
- You’ve entered a number wrong.
- You’ve misspelled something.
- The cell is not wide enough.
- The cell has the wrong data.
Answer: c. The cell is not wide enough.
- What formula can add all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
- Count c. Sum
- Average d. Addition
Answer: c. Sum
- On an Excel sheet, the active cell is indicated by …
- A wide dark border c. a blinking border
- A dotted border d. none of the above
Answer: a. a wide dark border
- What do you do to merge two or more cells in Excel?
- Use the Format Cells dialog box
- Right-click the cells you want to merge and then choose “Merge Cells” from the context menu.
- Choose the cells that you want to merge, and then click the “Merge & Center” button that can be found on the Home tab.
- None of these ways
Answer: c. choose the cells that you want to merge, and then click the “Merge & Center” button that can be found on the Home tab.
- When you operate Excel, what number format can you use?
- Percentage c. fraction
- Decimal d. all of these formats
Answer: d. all of these formats
- What is the aim of grouping worksheets in Excel?
- To perform calculations across multiple worksheets at once
- To move or copy data between multiple worksheets at once
- To apply formatting changes to multiple worksheets at once
- All of these functions
Answer: d. all of these functions
That’s all a number of questions and answers about Excel that you can use for practice. There are still a lot of other questions and answers about Excel in some other sources that you are able to find for your learning.
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.
