stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Excel Formula, Functions and Working with Data Test Prep Flashcards | StudBud
Explore
/
Excel Formula, Functions and Working with Data Test Prep
What method can you use to enter a formula easily?
A more complex formula has?
Excel Formula, Functions and Working with Data Test Prep
34 terms
·
StudBud Administration
·
569 plays
.
Flashcards
34 cards
F
Practice quiz
P
Host live
L
Questions
34
Answers
1
A more complex formula has?
Multiple mathematical operators
One mathematical operator
Parenthesis
Exponents
2
What method can you use to enter a formula easily?
Enter it on the keyboard
Press Windows key + L
Plug and play
Point and click
3
Which of the following operations is done first in the order of operations?
Addition and subtraction
Exponential calculations (3^2, for example)
Multiplication and Division, whichever comes first
Operations enclosed Parentheses
4
What should you reference in a formula to automatically update your spreadsheet values?
Cell address
Value of the cell
Random numbers
Text values
5
If data is organized A-Z that means it is sorted in what order?
Descending
Ascending
Correctly
Incorrectly
6
When entering a formula cell addresses have to be typed in.
True
False
7
The difference between the syntax of a function and a formula is that a function has?
Function name
Equals sign
Plus sign
Parenthesis
8
This function determines the lowest cell value included in the argument.
AVERAGE
MIN
SUM
COUNT
9
The easy way to remember the order of operations is?
PSDEMA
PAMDAS
PEDMAS
PEMDAS
10
You should double check your formula to make sure it is calculating data correctly.
True
False
11
When you use the filter option you are doing what to your data?
Entering
Organizing
Narrowing Down
Alphabetizing
12
If you have ####### in a cell this means that?
Columns widths are too narrow
You typed in 7 pound signs
You entered data correctly
Formula was done incorrectly
13
The formatting option that allows you to alternate row colors of a table is called?
minimum rows
total row
banded rows
banded columns
14
Addition
-
/
+
*
15
This function adds all of the values of the cells in the argument.
SUM
COUNT
MAX
MIN
16
You can edit a formula anytime by?
Double clicking the cell
Deleting the entire contents of the cell
You cannot edit a formula
Clicking the cell
17
What keyboard combination can you use to display the formula you entered instead of the result?
Ctrl + `
Ctrl + C
Ctrl + “
Ctrl + ;
18
The benefit of a function instead of a formula is?
Easier to write and understand
To make things more complicated
Performs multiple tasks more efficiently
Formulas are more beneficial than functions
19
The difference between the syntax of a function and a formula is that a function has?
Equals sign
Function name
Plus sign
parenthesis
20
What type of sort can you choose to be able to sort multiple columns by specific values?
Sort A-Z
Sort Z-A
Filter
Custom Sort
21
What can you select to format all the cells fill and text color to your table with one click?
Format as table
Cells styles
Fill color
Table Styles
22
The data points are connected with lines, making it easy to see whether increases and decreases
Line Charts
Bar Charts
Pie Charts
Surface Charts
23
The formatting option that alternates row colors of a table with one click is called?
Header row
Banded column
Total row
Banded row
24
You have to start a formula or function with?
Cell values
Cell address
Plus sign
Equals sign
25
If you are needed to “backup” (need to get out of a cell in Excel) you press what key?
Equals sign
Enter
Ctrl
Esc
26
What feature in Excel makes you easily visualize comparisons and trends of data?
Macros
Tables
Charts
Word Art
27
Exponents
^
+
-
*
28
The fill handle is not able to be used for formulas
False
True
29
Subtraction
*
-
^
+
30
Multiplication
/
+
*
-
31
On the design tab after clicking in a table what option will remove the formatting of a table?
Insert data
Format data
Convert to range
Convert to data
32
Parenthesis can affect the overall result of a formula.
True
False
33
Division
^
/
+
*
34
Which feature allows you to automatically insert the most common functions into your formula?
AutoFit
AutoCheck
AutoSum
AutoFormat
