stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Excel Basic Formulas Flashcards | StudBud
Explore
/
Excel Basic Formulas
Excel Basic Formulas
11 terms
·
StudBud Administration
·
222 plays
Imported from external platform
Flashcards
11 cards
F
Practice quiz
P
Host live
L
Questions
11
Answers
1
What type of rules must you follow when building formulas in Excel?
Geometric
Algebraic
Trignometric
Calculative
2
How would you pull data from one cell into another cell?
"=" then click on the other cell
type the letter & number of the other cell
"=" then the cell letter & number
click on the other cell
3
What key do you use to multiply in a formula?
/
x
*
X
4
On Sports Sales, what is the average sales for Tennessee?
54000
11520
45000
11250
5
On Sports Sales, what would your formula look like to count all of the cells with numbers?
=COUNT(ALL)
=CONT(B4:E10)
=COUNT(B4:E10)
=COUNT(A1:E10)
6
On Sports Sales, find the SUM for all of the sales.
349500
114000
103500
86000
7
On Sports Sales, what is the AVERAGE for Basketball?
12642.86
14785.71
28500
10214.29
8
There are two ways to start a new formula in an empty cell:
select the Function button
type "shift+N+F"
type an "=" sign
type "new formula"
9
On Sports Sales, what do the cells add up to? C4, E10, B9
37000
36000
38000
39000
10
What formula would you use to return today's date?
=TODAY()
=NOW
=TODAY(1)
+TODAY()
11
On Sports Sales, find the average for Football Sales & Round to 0 decimals.
12642
12462.9
12643
12642.9
