stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Caliber Round 1 Flashcards | StudBud
Explore
/
Caliber Round 1
Caliber Round 1
25 terms
·
StudBud Administration
·
11 plays
Imported from external platform
Flashcards
25 cards
F
Practice quiz
P
Host live
L
Questions
25
Answers
1
What is the primary purpose of Tableau?
Database Management
Data Visualization
Software Development
Email Marketing
2
Which of the following is a widely used cloud computing platform?
AWS
Oracle Database
Excel
MS Word
3
Which Excel feature allows you to summarize and analyze large datasets dynamically?
Conditional Formatting
Data Validation
Pivot Table
Goal Seek
4
Which function is used to find the highest value in a range?
MIN()
AVERAGE()
COUNT()
MAX()
5
The philips curve illustrates the relationship between
GDP Growth & government spending
Unemployment & Inflation
Money supply & exchange rates
Inflation & Interest rates
6
Which language is primarily used in Power BI for data modeling?
Python
DAX
SQL
R
7
Which type of AI is designed to perform a specific task and lacks general intelligence?
General AI
Strong AI
Narrow AI
Super AI
8
What is the default file extension for an Excel workbook that supports macros?
.xlsm
.xlsx
.csv
.xlsb
9
Which of the following is NOT a benefit of an ERP system?
Enhanced collaboration
Real-time insights
Improved data accuracy
Increased data silos
10
Why is the =COUNTIF function in Excel used?
Counts cells with numbers in a range
Counts blank cells in a range
Returns values based on a TRUE or FALSE condition
Counts cells as specified
11
What does SQL stand for?
Structured Query Language
Structured Question Language
Sequential Query Language
System Query List
12
What type of join is required to combine two datasets with different granularity levels in Tableau?
Inner Join
Full Outer Join
Data Blending
Left Join
13
BlueSky Statistics is primarily used for which type of analysis?
Text Editing
Image Processing
Web Development
Statistical Data Analysis
14
What is the key feature of cloud-based ERP solutions?
Only for financial management
Accessibility from anywhere with an internet connection
On-premises installation
Requires physical servers at the company location
15
Which Power BI visualization allows you to see the cumulative contribution of different components to the total?
Waterfall Chart
Scatter Plot
Stacked Bar Chart
Line Chart
16
Which type of regression analysis is NOT directly available in BlueSky Statistics?
Logistic Regression
Multiple Regression
Neural Networks
Linear Regression
17
Which shortcut key is used to create a new sheet in Excel?
Ctrl + Shift + S
Ctrl + N
Alt + Enter
Shift + F11
18
What is the main difference between COUNT and COUNTA in Excel?
They are the same function
COUNT counts only numbers, while COUNTA counts all non-empty cells
COUNT includes text, while COUNTA does not
COUNT works only on filtered data
19
Which country recently hosted the 2024 Summer Olympics?
USA
France
Australia
Japan
20
Which framework is commonly used for analyzing a company’s competitive position in an industry?
Porter’s Five Forces
BCG Matrix
SWOT Analysis
Ansoff Matrix
21
What does ‘Repo Rate’ mean?
Rate at which RBI lends money to commercial banks
Rate at which banks lend money to RBI
Rate at which the government borrows money from banks
Rate of return on government securities
22
Which of the following is an example of an open-source ERP system?
Microsoft Dynamics
Oracle NetSuite
SAP
Odoo
23
What is the shortcut key for ‘Paste Special’ in Excel?
Ctrl + Alt + V
Ctrl + P
Ctrl + V
Ctrl + Shift + P
24
Which of the following statements about BlueSky Statistics is TRUE?
It is based on the R programming language
It only works with small datasets
It does not support data visualization
It cannot be used for hypothesis testing
25
What does the VLOOKUP function do in Excel?
Searches for a value in a row
Searches for a value in a column and returns a corresponding value
Performs calculations on filtered data
Checks spelling errors
