Excel: Arithmetic Operatorss

Ace your homework & exams now with Quizwiz!

Arithmetic Operators

A group of symbols, used by Excel, to perform basic mathematical operations such as addition, subtraction, or multiplication. Produces numeric results.

: (colon)

A range operator that helps you shorten your formula elements. For example, instead of entering B1+B2+B3+B4+B5+B6+B7, just enter B1:B7. The colon allows you to identify the 'range' of cells.

Reference Operator

Combines ranges of cells for calculations with the following operators.

Order of operation

Excel calculates the formula from left to right according to a specific order for each operator in the formula.

Calculation Operator

Separates the elements that follow the equal sign which are to be calculated.

Equal sign

The symbol that begins ALL excel formulas.

* (asterisk)

The symbol used for multiplication. For example, 5*5.

% (percent sign)

The symbol used for percentages. For example, 30%.

+ (plus sign)

The symbol used for represents addition. For example, 2+2.

- (minus sign)

The symbol used for subtraction. For example, 5-2.

/ (forward slash)

The symbol used to represent division. For example, 9/3.


Related study sets

Ch. 31: The Nurse in the Schools

View Set

Difference between reducing valve and regulator, operation of flow restrictors, Bourdon gauges, and Thorpe tubes, effects of downstream pressure on meters, laboratory value that increases during hypoxia, clinical signs of mild/moderate and severe hypoxia,

View Set

Chapter 12: Marketing Channels: Delivering Customer Value

View Set

Chapter 18: Marketing in a Global Economy

View Set

POL California Life: Contract Law

View Set

Ch 18 Intraoperative Nursing Management

View Set

AP Gov. Chapter 2 Quiz Questions

View Set

Sleep, Internal Regulation (Exam 3)

View Set

Political science 2302 Test 2 lamar university

View Set

Chapter 68: Management of Patients With Neurologic Trauma

View Set