DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
exponentiation
|
|
|
addition & subtraction
|
|
|
parenthesis
|
|
|
multiplication and division
|
Detailed explanation-1: -Parentheses are added by typing () on both sides of numbers, like (1+2) .
Detailed explanation-2: -When evaluating a formula, Excel follows a standard math protocol called “order of operations". 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-3: -Use the SUM function to sum numbers in a range.
Detailed explanation-4: -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.