Search
Create
Log in
Sign up
Log in
Sign up
Excel Lesson 4 Terms
STUDY
Flashcards
Learn
Write
Spell
Test
PLAY
Match
Gravity
Terms in this set (14)
Absolute Cell Reference
Does not change when copied or moved to a new cell
Formula
The equation used to calculate values in a cell
Manual Calculation
Lets you determine when Excel calculates the formulas in a worksheet
Mixed Cell Reference
Cell references that contain both relative and absolute references
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
Order of Evaluation
(Also called Order of Operations) The sequence used to calculate the value of a formula
Relative Cell Reference
Adjusts to its new location when copied or moved
Autosum Button
Creates a formulas that calculates the sum of values in adjacent cells above or to the left of the current cell
* (asterisk)
The symbol used in Excel to indicate multiplication
^ (caret)
The symbol used in Excel to indicate exponentiation
F2
Switches to edit mode to allow you to edit a formula stored in a cell
F4
Switches among relative, absolute, mixed cell references
Ctrl+` (accent key)
Shortcut to show formulas in a worksheet
YOU MIGHT ALSO LIKE...
ASCP MLT/MLS Certification Exam (BOC) Preparation
scottmooredo
$6.99
STUDY GUIDE
Excel Lesson 4
10 Terms
smithdianna
Excel Lesson 4: Entering Worksheet Formulas
10 Terms
stprice
Microsft Excel Vocabulary Lesson 4
10 Terms
151mmk
OTHER SETS BY THIS CREATOR
Advanced Microsoft Word
25 Terms
salyerm
Intro Excel Lesson 5
17 Terms
salyerm
Interpreting Excel Formulas
13 Terms
salyerm
Excel Number Formats
12 Terms
salyerm
THIS SET IS OFTEN IN FOLDERS WITH...
Excel Lesson 3
19 Terms
salyerm
Word L1 and L2 (the things that weren't there)
10 Terms
Ethan_Martz03
PLUS
Selecting Text
7 Terms
Ethan_Martz03
PLUS
Computer Apps Word Lessons 1 & 2
26 Terms
salyerm
;