stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Excel Formulas Flashcards | StudBud
Explore
/
Excel Formulas
Excel Formulas
33 terms
·
StudBud Administration
·
33 plays
Excel formulas and keyboard shortcuts
Flashcards
33 cards
F
Practice quiz
P
Host live
L
Questions
33
Answers
1
Sales value for 2015 is 120. If trend line is Sales = 100.5t + 50, the 2018 sales increases by:
100
301.5
201
150
2
When you insert an excel file into a word document, the data are
Hyperlinked placed in a word table
Linked
Embedded
Used in the word menu bar and toolbars
3
Chart used when depicting hierarchical data
Surface
Sunburst
TreeMap
Radar
4
You can use the format painter multiple times before you turn it off by
Pressing Ctrl key and clicking the format painter button
Pressing Alt key and clicking the format painter button
Double clicking the format painter button
Formatting painter button only one time when you click it
5
Tab where you will find Create Macros
Developer
Data
Formulas
Add-ins
6
Field of study that gives computers the ability to learn without being explicitly programmed
Machine learning
Business Intelligence
Data analytics
Artificial intelligence
7
Keyboard to Insert new worksheet
Shift F11
Alt F8
ALT N P
ALT N T
8
Break even in pesos is
(Fixed Cost / (Unit SP - Unit VC)) * Unit SP
Fixed Cost / (Unit SP - Unit VC)
Fixed Cost * Unit SP/ Unit SP - Unit VC
Fixed Cost / (Unit VC + Unit SP)
9
A circular reference is
A formula that directly or indirectly depends on itself
Always erroneous
A cell that points to a drawing object
Geometric modeling tool
10
Which of the following is not one of Excel's What-If function
Scenario Manager
Goal Seek
Solver
Auto Outline
11
If you press ……, the cell accepts your typing for an array formula
Ctrl+Enter
Ctrl+Tab+Enter
Insert
Ctrl+Shift+Enter
12
Machine learning tool used to determine buying patterns of individuals
Tableau
Power BI
MBA
Power Pivot
13
Keyboard shortcut to insert a chart in a new worksheet
F11
Alt F11
Alt N R
Insert-Recommended Chart
14
Seeing a High, Low, Open and Close values will most probably be a _____ chart
Sunburst
Radar
Surface
Stock
15
When you see a cell with a red triangle in the top right corner, what does this signify?
The font color for text in the cell is red
There is an error in the cell
A formula cannot be entered into the cell
There is a comment associated with the cell
16
A function inside another function is called a ….. function.
HyperLink
Interior
Nested
Round
17
Which of the following is a correct order of precedence in a formula calculation?
Addition, positive and negative values, exponentiation
Multiplication, positive and negative values, addition
Parenthesis, exponentiation, multiplication, addition
Parenthesis, Multiplication, exponential, + and - values
18
Keyboard formula for Filtering
Alt A Q
Ctrl Shift L
Alt N V
Alt B M
19
Chart that helps in understanding cumulative effect of sequentially introduced + or - values
Box and Whisker
TreeMap
Bubble
Waterfall
20
In-memory data modelling component that enables compressed data storage and fast calculation
Power BI
Business Analytics
Data Model
Power Pivot
21
Keyboard formula for Advanced Filtering
Alt A Q
Alt N V
Alt B M
Ctrl Shift L
22
Chart to use if you want to track the progress of the stock market on a daily basis.
Pie chart
Column chart
Row chart
Line chart
23
Self-service ETL (Extract, Transform, Load) tool which runs as an Excel add-in
Power Query
Power View
Power Pivot
Power BI
24
Two common wildcard characters that Excel recognizes are
^ and /
* and ?
+ and -
< and >
25
A chart depicting the Cow, Dog, Star and Question Mark products of a company will use
Sunburst chart
Bubble chart
Stacked Column
Waterfall chart
26
Form of BI where staff are enabled to perform queries & generate reports with min IT support
Unaided Query
Data analytics
SSBI
Individual Query
27
Which formula will give you an answer of 4?
=SQRT(36)
=MOD(46,4)
=AVERAGE(4,4,3,5,5)
=2*(LOG(10)+LOG(10))-1
28
How can you quickly apply professional formatting to your sales forecast worksheet?
Apply a selected background color
Apply an Auto Format Style
Apply special attributes using Format Painter
All of above
29
You can group noncontiguous worksheets with
The group button on the standard toolbar
The shift key and the mouse
The alt+enter key
The ctrl key and mouse
30
What function displays row data in a column or column data in a row?
Hyperlink
Transpose
Index
Rows
31
Which of the following is not a valid data type in excel
Date/time
Label
Character
Number
32
3-D reference in a formula
Spans worksheets
Limits the formatting options
Only appears on summary worksheets
Can not be modified
33
Insert a New Data Query
ALT A PN
ALT A PS
ALT A PT
ALT A PR
