Excel review lesson 4

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

An operator is a constant or cell reference used in formulas

FALSE

Write an example of a formula that contains a mixed cell reference

=B$3+B$4

Operand

A constant ( text or number ) or cell reference used in a formula

Operator

A symbol that indicates the type of calculation to perform on operands

What type of cell reference will not adjust to its new location when it is copied or moved to another cell

Absolute Cell references

Relative cell Reference

Adjusts to its new location when copied or moved

Point-and-Click method

Allows you to point and click each cell in a formula rather then typing cell references

Absolute Cell reference

An absolute cell reference remains the same when the formula is copied

Formula

An equation that's performs mathematical calculation on values in a worksheet

Mixed Cell reference

Call reference that contains both relative and absolute references

In a worksheet formula, which operator has the highest priority in the order of evaluation

Exponential

In a formula, operations within parentheses are performed after operations outside Parentheses

FALSE

The equation used to calculate values based on numbers entered in cells is called a(n) _____

Formula

Sum Button

Makes adding long columns or rows of numbers simple to do

______ calculation lets you control when excel calculates the formula in a worksheet

Manual

Manual calculation

Manual calculation lets you determine when excel calculates the formulas

The sequence used to calculate the value of a formula is called the ____

Order of evaluations

The cell reference D4 is and example of a(n) ___ cell reference

Relative

Default summary calculation for a selected range appear in the _____

Status Bar

How do you display formulas instead of formula results in a worksheet

Status bar

An absolute reference does not change when the formula is copied or moved to another cell

TRUE

In a formula, multiplication is performed before subtraction

TRUE

Manila Calculation lets you control when excel calculates formula results

TRUE

Order of evaluation

The sequence used to calculate the value of a formula


Kaugnay na mga set ng pag-aaral

ACCT 3110 Intermediate Financial 1 Chapter 3 SB

View Set

International Marketing - Test 3 QuestionsFDI occurs when a firm

View Set

Lesson 109 - Conductor Types, Ampacity, Overcurrent Protection, Type NM Cables, and Common Voltage Systems Homework

View Set

Chapter 1 Humans in the World of Biology Dynamic Study Module

View Set

Effective supervisory Practices Chp 11

View Set

Constitutional Law Learning Questions Set 7

View Set

100 FACTS OF TEMPOROMANDIBULAR JOINT

View Set