FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
In this formula, which calculation is performed first? =12*A3*(25-13)
A
12*A3
B
25-13
C
A3*(25-13)
D
None of the above
Explanation: 

Detailed explanation-1: -Calculation order A formula in Excel always begins with an equal sign (=). Excel interprets the characters that follow the equal sign as a formula.

Detailed explanation-2: -A function is a predefined formula that performs calculations using specific values in a particular order. All spreadsheet programs include common functions that can be used for quickly finding the sum, average, count, maximum value, and minimum value for a range of cells.

Detailed explanation-3: -For simple formulas, simply type the equal sign followed by the numeric values that you want to calculate and the math operators that you want to use-the plus sign (+) to add, the minus sign (-) to subtract, the asterisk (*) to multiply, and the forward slash (/) to divide.

There is 1 question to complete.