TOPIC 2: BASIC OPERATION FORMULAS

THE CONCEPT OF EXCEL FORMULA An Excel formula is a mathematical expression used to perform calculations, simplifying complex or repetitive tasks. These formulas enable automation and efficient processing of operations like addition, subtraction, multiplication, percentages, and conditional logic. It is saving time and reducing manual effort.

Flashcards4 cardsFPractice quizPHost liveL

Questions 4

Answers

1
The operator for the following formula is subtraction
False
True
2
What is the formula for the given picture
A1-A2
A1/A2
A1+A2
A1*A2
3
The operator for the given formula is multiplication.
True
False
4
Following are the basic arithmetic operators except
#
*
+
-

TOPIC 2: BASIC OPERATION FORMULAS

4 termsStudBud Administration

THE CONCEPT OF EXCEL FORMULA An Excel formula is a mathematical expression used to perform calculations, simplifying complex or repetitive tasks. These formulas enable automation and efficient processing of operations like addition, subtraction, multiplication, percentages, and conditional logic. It is saving time and reducing manual effort.

Flashcards4 cardsFPractice quizPHost liveL

Questions 4

Answers

1
The operator for the following formula is subtraction
False
True
2
What is the formula for the given picture
A1-A2
A1/A2
A1+A2
A1*A2
3
The operator for the given formula is multiplication.
True
False
4
Following are the basic arithmetic operators except
#
*
+
-