stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
CSHS Advanced Excel - Lesson 7 Flashcards | StudBud
Explore
/
CSHS Advanced Excel - Lesson 7
CSHS Advanced Excel - Lesson 7
10 terms
·
StudBud Administration
·
156 plays
Requirement: Qualifying score of 85% or higher to proceed to next lesson.
Flashcards
10 cards
F
Practice quiz
P
Host live
L
Questions
10
Answers
1
A built-in calculation used to add a range of values together is:
COUNT Funtion
ADD Function
SUM Function
TOTAL Function
2
In the Order of Precedence, who goes third?
Parentheses
Multiplication & Divison
Exponentation
Addition & Subtraction
3
What is the symbol utilized for the Auto Sum Function?
Ʃ
Ɛ
§
Ȝ
4
The order in which Excel performs the mathematical operations specified in a formula.
Order of Precedence
Order of Excel
Order of Formula
Order of Protocol
5
Symbols used in mathematical operations are called:
Arithmetic Orders
Excel Symbols
Excel Formulas
Arithmetic Operators
6
What are the symbols used as Arithmetic Operators?
+, -, ^, /, ( )
=, *, -, ^, +
+, -, /, *, ^
=, +, -, /, *. ^
7
Which formula is correct?
B3+(C8:F24)
=b3:F24
=B3:+(C8:F24)
=B3+(c8:F24)
8
What "F" key do you use to create a quick "Edit" in a cell?
F3
F4
F7
F2
9
An instruction Excel uses to calculate a result.
Excel Order
Formula
Function
Excel Guide
10
What is the easiest method to duplicate a formula to other cells?
Copy & Paste
Duplicate Edit
Drag & Drop
Fill Handle
