USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Accepts values, performs calculations and displays a chart.
|
|
|
Performs calculations, displays results and accepts numbers.
|
|
|
Accepts values, performs calculations and displays a result.
|
|
|
None of the above
|
Detailed explanation-1: -A function in Excel is a preset formula, that helps perform mathematical, statistical and logical operations. Once you are familiar with the function you want to use, all you have to do is enter an equal sign (=) in the cell, followed by the name of the function and the cell range it applies to.
Detailed explanation-2: -Formulas are equations that perform calculations on values in your sheet. All formulas begin with an equal sign (=). You can create a simple formula by using constant and calculation operator. For example, the formula =5+2*3, multiplies two numbers and then adds a number to the result.
Detailed explanation-3: -In Microsoft Excel, a formula is an expression that operates on values in a range of cells. These formulas return a result, even when it is an error. Excel formulas enable you to perform calculations such as addition, subtraction, multiplication, and division.
Detailed explanation-4: -Formula: A formula is a spreadsheet data type that will calculate a result and display it in the active cell. A formula is written using cell references and must begin with an equal sign “=” to distinguish it from a label.