stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
QUIZ BEE Business Analytics Flashcards | StudBud
Explore
/
QUIZ BEE Business Analytics
QUIZ BEE Business Analytics
25 terms
·
StudBud Administration
·
12 plays
Imported from external platform
Flashcards
25 cards
F
Practice quiz
P
Host live
L
Questions
25
Answers
1
Concern how the organization should achieve the goals and objectives set by its strategy.
Strategic Decisions
Operational Decisions
Tactical Decisions
Any Decisions
2
It is a layout of information arranged in rows and columns in a table.
Spreadsheet
Sheet
Cell
Cell Range
3
If the
price of the Tablet increases by 10%
, what will be the new price? Show your calculation.
=18,000 * 1.10
=SUM(18,000, 10)
=18,000 * .10
=18,000 * 10
4
What formula should be used in
G2
(Net Sales for Laptop) to get the final amount after discount?
=E2(F2*E2)
=E2+F2*E2
=E2-F2*E2
=E2/F2*E2
5
Name the part of the Google Sheet
Name Box
Formula Bar
Shortcut Toolbar
Cell Range
6
It quickly copy and paste content from one cell to any other cells in the same row or column.
Merge
Fill Handle
Cut
Drag
7
Which tab in the toolbar menu you can find cut, copy and paste
Insert
Edit
Format
View
8
Name the encircled part of the function.
Argument
Parenthesis
Function Name
Equal Sign
9
A transportation company uses traffic data to estimate the best route to take.
PR
P and PR
P
D
10
The mathematical operator for Division in Google Sheets
\
%
*
/
11
Write the formula to calculate the
average price of all products
in
C7
.
=AVERAGE(C2,C6)
=AVERAGE(C2), C6
=AVERAGE(C2:C6)
=SUM(C2:C6)/4
12
What formula should be used in
E2
to calculate the total sales based on price and quantity sold?
=C2*D2
=45,000 + 10
=SUM(C2:D2)
=C2+D2
13
An approach in decision making where decision is based on gut-feeling.
RELEVANT DATA
RULE OF THUMB
INTUITION
TRADITION
14
Name the part of the Google Sheet
File Toolbar
Shortcut Toolbar
Sheet Toolbar
Toolbar Menu
15
Provide a forecast or prediction, but do not provide a decision.
Prescriptive
Predictive
Descriptive
All of the choices
16
A fitness app provides a personalized exercise plan based on a user's health data and fitness goals.
P
D
PR
D and P
17
A financial model advises an investor on the best stocks to buy based on current market trends.
D
PR
P
P and PR
18
The most frequent value in the list.
Min
Mode
Median
Mean
19
A survey reveals that 80% of customers prefer shopping online rather than in physical stores.
PR
P
D and P
D
20
The graphical representation of information and data.
Google Sheets
Business Analytics
Central Tendency
Data Visualization
21
A group of cells is known as ?
Charts
Spreadsheet
Sheets
Cell Range
22
Write a formula to find the
total quantity sold
for all products in
D7
.
=SUM(D2:D6)
=D2*D6
=D2+D3+D5+D6
=D2+D6
23
Which symbol should a formula start with?
,
=
()
:
24
A company analyzes past sales data to determine which products sold the most last year.
D, P and PR
D and P
D
D and PR
25
Are the domain of operations managers, who are the closest to the customer.
Tactical Decisions
Any Decisions
Operational Decisions
Strategic Decisions
