FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Special, predefined formula that provides a shortcut for a commonly used calculation is called a ____
A
Formula
B
Function
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. 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-2: -Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. Functions can be used to perform simple or complex calculations. You can find all of Excel’s functions on the Formulas tab on the Ribbon: Excel function syntax.

Detailed explanation-3: -Returns the smallest number in a set of values.

Detailed explanation-4: -Predefined functions are also called as library functions.

Detailed explanation-5: -Answer: Functions are predefined formulas and are already available in Excel. For example, cell A3 below contains a formula which adds the value of cell A2 to the value of cell A1.

There is 1 question to complete.
Previous
Next