Bissoy.com
Doctors Medicines MCQs Q&A

What will the formula = sum(D1:D7) in cell d8 of a Microsoft Excel worksheet result in if the cells from D1 to D6 contain the values 1, 2, 3, 4, 5, 6?

What will the formula = sum(D1:D7) in cell d8 of a Microsoft Excel worksheet result in if the cells from D1 to D6 contain the values 1, 2, 3, 4, 5, 6? Correct Answer 21

The correct answer is 21.

Key Points

  • The SUM function adds values.
  • We can add individual values, cell references or ranges, or a mix of all three.

For example:

   =SUM(A2:A10) Adds the values in cells A2:10.

   =SUM(A2:A10, C2:C10) Adds the values in cells A2:10, as well as cells C2:C10.

  • The sum formula helps in the calculation of the summation of the total selected cells.
  • In the example given above, the cell contains the values 1,2,3,4,5,6 so when the sum formula is used it will give the answer 21.

Hence, the correct answer is 21.

Related Questions

Which of the following statement(s) is/are CORRECT for antigen activated effector T cells?
P. CD4+ cells make contact with macrophages and stimulate their microbicidal activity.
Q. CD4+ cells make contact with B cells and stimulate them to differentiate into plasma cells.
R. CD8+ cells make contact with B cells and stimulate them to differentiate into plasma cells.
S. CD8+ cells make contact with virus infected cells and kill them.
In an MS-Excel sheet, cell A1 contains 5, A2 contains 6, and cell A3 contains the formula = A1 + A2. The formula in cell A3 is copied into cell B3 by dragging. Which of the following will be the result (output) displayed in cell B3?
Suppose the A1 cell of an MS-Excel worksheet contains the formula " =C5+A4". If A1 cell is copied and pasted into D5 cell, then what will be formula in D5?
You use Microsoft Visual Studio 2010 and Microsoft ADO.NET Framework 4 to create anapplication. The application connects to a Microsoft SQL Server 2008 database. You use the ADO.NET LINQ to SQL model to retrieve data from the database. You use stored procedures to return multiple result sets. You need to ensure that the result sets are returned as strongly typed values. What should you do?
In the question two statements are given, followed by two conclusions, I and II. Read all the conclusions and then decide which of the given conclusions logically follow/s from the given statements. Statements: All white blood cells are red blood cells. Some blood cells are red blood cells. Conclusions: I. All blood cells are red blood cells, is a possibility. II. Some red blood cells are not blood cells.
Which of the following statements are correct regarding common differences between plant and animal cells?
1. Plant cells have cellulose cell wall, while animal cells lack it.
2. Plant cells lack plasma membrane, while animal cells have it.
3. Mature plant cell have a large vacuole, while animal cells have numerous small vacuoles.
Which of the following statements are correct regarding the general difference between plant and animal cells? 1. Plant cells have cellulose cell walls while animal cells do not. 2. Plant cells do not have a plasma membrane, unlike animal cells which do. 3. Mature plant cell has one large vacuole whilst animal cell has many small vacuoles. Select the correct answer using the code given below:
Consider the following statements regarding the Structure of cells: 1. Both Animal & Plant cells comprise amyloplast within the cell membrane. 2. Plant cells have plasmodesmata channels whilst animal cells do not. 3. Vacuoles in both plant cells & animal cells are always filled with solid substances. Which of the statement given above is/are not correct? 
Consider three software items: Program-X, Control Flow Diagram of Program-Y and Control Flow Diagram of Program-Z as shown below Program-X: Control Flow Diagram of Program-Y sumcal (int maxint, int value) {       int result=0, i=0;       if (value <0)       {           Value = -value;       }       while ( (i
A solid-oxide fuel cell is fed with carbon monoxide and reacts with air to produce CO2. This reaction will produce 2 electrons which are used to power an electric circuit external to the fuel cell. The reaction equation is shown below: 2CO(g) + O2(g) -> 2CO2(g) ΔHr° = -565.96 kJ/mol This reaction does not occur for other types of fuel cells which use a catalyst, such as polymerelectrolyte membrane or phosphoric-acid fuel cells. The presence of carbon monoxide on the anode side of these types of fuel cells will cause catalyst poisoning, reducing the efficiency and voltage of the fuel cell. Determine the rate of enthalpy change for a carbon dioxide production rate of 208 mol/hr. The extent of the reaction occurring in the fuel cell can be obtained by the following equation: where: