DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
12*A3
|
|
25-13
|
|
A3*(25-13)
|
|
None of the above
|
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.