NEW
Font size
WorksheetsCloud Computing and Excel Basics Quiz (61-100)
Total questions: 40
Worksheet time: 20mins
SaaS means
Renting servers
Renting platforms
Subscribing to software online
Buying software
IaaS provides
Applications
Hardware resources
Platforms
Analytics
PaaS is mainly used to
Build applications
Store files
Encrypt data
Run spreadsheets
A major cloud risk is
Scalability
Vendor lock-in
Speed
Cost savings
DNS is
Encryption
The internet’s phone book
Malware
Hardware
HTTPS indicates
Faster speed
Encrypted communication
Free hosting
Public access
Phishing attacks target
Servers
Networks
People
Databases
Malware is
Hardware theft
Harmful software
Encryption
Legal software
DDoS attacks overwhelm systems using
Passwords
Massive traffic
Malware
Encryption
Security failures often result from
Hardware
Human error
Encryption
Software updates
Excel is risky at enterprise scale because it
Is slow
Is error-prone and doesn’t scale
Lacks charts
Is outdated
Pivot tables are used to
Write formulas
Summarize large datasets
Encrypt data
Clean text
Pivot table calculations belong in
Rows
Columns
Filters
Values
The MOST flexible lookup function is
VLOOKUP
HLOOKUP
XLOOKUP
COUNT
Conditional Formatting is used to
Calculate totals
Highlight patterns and outliers
Remove duplicates
Encrypt files
IF functions are used for
Sorting
Decision logic
Visualization
Cleaning
Nested IFs are used when
One condition exists
Multiple conditions exist
Data is large
Charts are needed
Remove Duplicates does what?
Filters rows
Deletes repeated rows
Sorts values
Highlights cells
Excel is best suited for
Enterprise databases
Small-to-medium analysis
Multi-user systems
Secure storage
Databases are preferred because they
Are cheaper
Scale and support many users
Eliminate errors
Require no training
Vendor lock-in occurs when
Prices drop
Switching providers is difficult
Software improves
Data is deleted
Cloud scalability means
Fixed capacity
Resources adjust as needed
Slower performance
Higher cost
IP addresses identify
Files
Devices on a network
Domains
Emails
IPv6 exists because
IPv4 is faster
IPv4 addresses ran out
It is cheaper
It is optional
Zero-party data is
Stolen
Explicitly provided by users
Purchased
Tracked secretly
First-party data is
Bought from brokers
Collected directly by a firm
Shared illegally
Encrypted
Load balancing helps by
Blocking traffic
Distributing requests
Encrypting data
Filtering users
BI dashboards help managers
Program
Make decisions
Encrypt data
Build servers
Data cleaning is important because
Data is expensive
Errors distort analysis
Servers fail
Files are large
Competitive advantage is strongest when it is
Cheap
Hard to copy
Popular
New
CRM primarily increases value by improving
Inventory
Customer retention
Security
Hardware
SaaS reduces costs mainly by
Eliminating hardware ownership
Increasing staff
Reducing users
Slowing updates
Network effects weaken when
Users increase
Congestion increases
Platforms grow
Prices fall
A platform loses value when
Complements increase
Congestion effects rise
Users join
Standards improve
Fast followers succeed by
Being first
Copying and improving
Avoiding innovation
Raising prices
Open-source software is risky mainly due to
Cost
Support and legal issues
Speed
Hardware
ERP failures often result from
Too much data
Poor change management
Low security
Too many users
Data aggregators collect and
Delete data
Sell data
Encrypt data
Hide data
Privacy trade-offs increase most when firms use
Zero-party data
First-party data
Third-party data
Secure servers
When unsure on the CIS final, the BEST choice is the answer that
Uses technical jargon
Emphasizes business value and advantage
Is longest
Mentions hardware
