FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
____ specify the type of calculation that you want to perform on the elements of a formula.
A
parentheses
B
operators
C
comma
D
semi-colon
Explanation: 

Detailed explanation-1: -Operators specify the type of calculation that you want to perform on elements in a formula-such as addition, subtraction, multiplication, or division.

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: -Answer. Answer: operators specify the type of operation you want to perform.

Detailed explanation-4: -To enter an Excel formula into a cell, you start with an equal (=) sign. Excel then knows that the expression that follows should be interpreted as a calculation, not text. After the equal sign, you enter the formula. For example, you can find the sum of the numbers in cells C2 and C3 by using the formula =C2+C3.

There is 1 question to complete.
Previous
Next