FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which response best completes the following statement:A formula is used to
A
perform calculations or other actions.
B
find averages.
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -A function is a predefined formula that performs calculations using specific values in a particular order.

Detailed explanation-2: -To enter an Excel formula into a cell, you start with an equal (=) sign. Excel then knows that the expression that follows should be interpreted as a calculation, not text. After the equal sign, you enter the formula. For example, you can find the sum of the numbers in cells C2 and C3 by using the formula =C2+C3.

Detailed explanation-3: -In general, Excel’s order of operation follows the acronym PEMDAS (Parentheses, Exponents, Multiplication, Division, Addition, Subtraction) but with some customization to handle the formula syntax in a spreadsheet.

Detailed explanation-4: -A formula is an equation used to perform calculations in Excel.

There is 1 question to complete.
Previous
Next