# 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? =B4*100+15/3
 A B4*100 B 100+15 C 15/3 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: -A formula always starts with an equal sign (=), which can be followed by numbers, math operators (such as a plus or minus sign), and functions, which can really expand the power of a formula. For example, the following formula multiplies 2 by 3 and then adds 5 to that result to come up with the answer, 11.

Detailed explanation-4: -We can remember the order using PEMDAS: Parentheses, Exponents, Multiplication and Division (from left to right), Addition and Subtraction (from left to right).

There is 1 question to complete.