Bissoy.com
Doctors Medicines MCQs Q&A

When working on an MS Excel sheet, to enter a formula in a cell, what should come before the formula? A. @ B. = C. * D. &

When working on an MS Excel sheet, to enter a formula in a cell, what should come before the formula? A. @ B. = C. * D. & Correct Answer B

The Correct Answer is "B".

Key Points 

  • Typing a formula in a cell or the formula bar is the most straightforward method of inserting basic Excel formulas.
  • The process usually starts by typing an equal sign, followed by the name of an Excel function.

Additional Information

  • Select a cell.
  • Type the equal sign =.
  • [ alt="9e253c9b-9e7f-4b7b-a05e-559bf5466fdf" cell ms.cmpgrp="content" ms.interactiontype="500" ms.pgarea="Body" src="https://support.content.office.net/en-us/media/9e253c9b-9e7f-4b7b-a05e-559bf5466fdf.png" style="border-width: initial; border-style: none; max-width: 100%;">
  • select cell
  • Enter an operator. For example, – for subtraction.
  • Select the next cell, or type its address in the selected cell.
  • next cell
  • [ alt="d1045dba-c030-4816-a99a-d153cbfad5c0" cell ms.cmpgrp="content" ms.interactiontype="500" ms.pgarea="Body" src="https://support.content.office.net/en-us/media/d1045dba-c030-4816-a99a-d153cbfad5c0.png" style="border-width: initial; border-style: none; max-width: 100%;">
  • Press Enter. The result of the calculation appears in the cell with the formula.

Related Questions

Consider the 5 × 5 matrix \[{\text{A}} = \left[ {\begin{array}{*{20}{c}} 1&2&3&4&5 \\ 5&1&2&3&4 \\ 4&5&1&2&3 \\ 3&4&5&1&2 \\ 2&3&4&5&1 \end{array}} \right
Select from the alternatives that combination of numbers, which will form a meaningful word if given letters are arranged accordingly. \(\begin{matrix} \ \ \ \text{A} & \rm R & \rm W & \rm L & \rm E & \rm K \\\ \downarrow & \downarrow & \downarrow & \downarrow & \downarrow & \downarrow \\\ \ \ 1 & 2 & 3 & 4 & 5 & 6 \end{matrix}\)
Eigen values of the matrix \[\left[ {\begin{array}{*{20}{c}} 0&1&0&0 \\ 1&0&0&0 \\ 0&0&0&{ - 2i} \\ 0&0&{2i}&0 \end{array}} \right
Let A be an m × n matrix and Ban n × m matrix. It is given that determinant ($$I$$m + AB) = determinant ($$I$$n + BA), where $$I$$k is the k × k identity matrix. Using the above property, the determinant of the matrix given below is
\[\left[ {\begin{array}{*{20}{c}} 2&1&1&1 \\ 1&2&1&1 \\ 1&1&2&1 \\ 1&1&1&2 \end{array}} \right
In a coded language “ADETP” is coded as “$&$&&” and “DTPQUV” is coded as “&&&&$&”? What is the code word for “&&$$&$”?
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?
For what value of x, y and z matrices A and B are equal \(A = \begin{bmatrix} 2 & 0 & x+3 \\\ y-4 & 4 & 6 \end{bmatrix} ; \ \ B = \begin{bmatrix} 2 & 0 & 6 \\\ -2 & 4 & 2z \end{bmatrix}\)
In the following question, select the number which can be placed at the sign of question mark (?) from the given alternatives. \(\begin{array}{*{20}{c}} 5&1&3\\ 9&9&4\\ 6&?&7\\ {29}&{22}&{18} \end{array}\)
A, B, C, D, K, L, M and O are researchers and are working in three different institutes, X, Y and Z. They are working in three different areas namely, solar energy, sustainable development, and rainwater harvesting for agricultural purpose. Not less than two or more than three researchers are working in the same area and not more than three of them are working the same institute. K is researching in the sustainable development in the institute Y with B who is doing research in rainwater harvesting. A and M are doing research in the same area but not in sustainable development and are not working in the institute Y. C is researching in solar energy in the institute Z, only with D who is working in sustainable development. L is researching in rainwater harvesting area and not working in the institute where A works. O is not doing research in the solar energy. Choose option for answering question, In which of the institute/institutes at least one researcher is working in the area of solar energy ?
What is the total number of employees in the company? Which of the following option is sufficient alone to find the answer? A) In the company, employees like either tea or coffee or cold drink. Out of the total employees, 25% like tea and 40% like coffee. Out of remaining employees, 20% like cold drink and remaining employees don’t like any of these drinks. B) Out of total employees 18% working in the marketing departments, 35% working in IT departments. From the remaining employees 25% working in HR departments and 45% working in content departments and remaining 141 are working in other departments. C) Employees working in the company is form state X, Y and Z. 20% of employees working in the company is from state X and from remaining 60% employees is from state Z and the remaining employees is from the state Y. D) 60% of the employees in the company are married and remaining employees are unmarried. The ratio of male and female unmarried employees is 4 : 5 and ratio of married male and female employees is 3 : 4.