(1) It is a powerful spreadsheet program. Formula and Functions in MS Excel Class 6 MCQ with Answers and Explanations: Students get here all Important MCQ on Formula and Functions in MS Excel Class 6. When you arrive at: =COUNTIF( instead of typing A1:C2, simply select the range A1:C2.Formula and Functions in MS Excel Class 6 MCQ: CBSE Board Class 6 Computer MCQ Questions and Answers with elaborate explanation. Note: instead of using the Insert Function feature, simply type =COUNTIF(A1:C2,">5"). The COUNTIF function counts the number of cells that are greater than 5. Click in the Range box and select the range A1:C2.Ħ. The 'Function Arguments' dialog box appears.ĥ. For example, choose COUNTIF from the Statistical category. Search for a function or select a function from a category.
The 'Insert Function' dialog box appears.ģ. To insert a function, execute the following steps. Fortunately, the Insert Function feature in Excel helps you with this. It's not easy to remember which function and which arguments to use for each task. This function adds the values in cells A1, A2, A3 and A4. The part between the brackets (arguments) means we give Excel the range A1:A4 as input. The formula in cell B4 references the values in column B.Įvery function has the same structure. This is much easier and gives the exact same result! Select cell A4, click on the lower right corner of cell A4 and drag it across to cell B4. You can also drag the formula to cell B4. next, select cell B4, right click, and then click Paste under 'Paste Options:' (or press CTRL + v).Ģb. Select cell A4, right click, and then click Copy (or press CTRL + c). Enter the formula shown below into cell A4.Ģa. To understand this, execute the following steps.ġ. When you copy a formula, Excel automatically adjusts the cell references for each new cell the formula is copied to. Next, it multiplies this result by the value of cell A1. Next, Excel adds the value of cell A3 to this result.įirst, Excel calculates the part in parentheses (A2+A3). See the example below.įirst, Excel performs multiplication (A1 * A2).
Once this is complete, Excel will add and subtract the remainder of your formula. It then performs multiplication or division calculations. If a part of the formula is in parentheses, that part will be calculated first. To edit a formula, click in the formula bar and change the formula.Įxcel uses a default order in which calculations occur. When you select a cell, Excel shows the value or formula of the cell in the formula bar.ġ. This is one of Excel's most powerful features! Edit a Formula Tip: instead of typing A1 and A2, simply select cell A1 and cell A2.Įxcel automatically recalculates the value of cell A3. To let Excel know that you want to enter a formula, type an equal sign (=). To enter a formula, execute the following steps.Ģ. For example, cell A3 below contains the SUM function which calculates the sum of the range A1:A2.
0 kommentar(er)
