Question 1

Excel is a spreadsheet application software. Select the Excel function listed below that you would use if you wanted to calculate the average of selected cells.

Accepted Answer

A)   MIN
B)   AVERAGE
C)   TRIM
D)   IFE) None of the above
F) A) and D)

Question 2

Businesses typically have many systems, some internally developed, some purchased, and others acquired. Businesses want these systems to communicate with one another and provide users with easier access to data. There are three systems configurations that consolidate and coordinate data across multiple locations. These three include centralized systems, decentralized systems, and distributed systems. Each configuration has advantages and disadvantages. Which of the following is an advantage of distributed systems?

Accepted Answer

A)   Cost is lower, as there is only one central location to be maintained.
B)   Reduction in processing bottlenecks as employees aren't competing for processing power.
C)   Communication among the users is increased since they are all connected.
D)   If one system fails, the other systems can still process transactions.E) C) and D)
F) B) and D)

Question 3

Which system is used by senior management to determine regions of the world for new investment?

Accepted Answer

A)   Executive support system
B)   Decision support system
C)   Management information system
D)   Transaction processing systemE) B) and C)
F) A) and D)

Question 4

RAM Manufacturing LLC is a rapidly growing manufacturer of parts for the automotive industry. RAM Manufacturing maintains a lot of inventory and uses NetSuite to manage its inventory. RAM Manufacturing recently acquired Top Automotive LLC. Top Automotive uses Sellbrite to manage its inventory. If RAM Manufacturing decides to allow the Top Automotive operations to continue to run Sellbrite at Top Automotive's facility, which systems integration approach has RAM Manufacturing taken?

Accepted Answer

A)   Shut down both systems
B)   Run both systems in parallel
C)   Lift and shift, then integrate
D)   Immediate integrationE) A) and D)
F) A) and B)

Question 5

Excel is a spreadsheet application software. Choose from the list below one of the business functions that Excel typically supports.

Accepted Answer

A)   Advertising
B)   Recruiting
C)   Supply chain management
D)   BudgetingE) B) and C)
F) A) and B)

Question 6

An online analytics processing system (OLAP)  processes:
I. Transactions
II. Reports and analytics

Accepted Answer

A)   I
B)   II
C)   both I and II
D)   neither I nor IIE) B) and D)
F) A) and C)

Exam 4: Software and Systems

Excel is a spreadsheet application software. Choose from the list below one of the business functions that Excel typically supports.

Correct Answer
verified

An online analytics processing system (OLAP) processes: I. Transactions II. Reports and analytics

Correct Answer
verified

Correct Answer
verified

Excel is a spreadsheet application software. Select the Excel function listed below that you would use if you wanted to calculate the average of selected cells.

Correct Answer
verified

Correct Answer
verified

Which system is used by senior management to determine regions of the world for new investment?

Correct Answer
verified

Exam 4: Software and Systems

Excel is a spreadsheet application software. Choose from the list below one of the business functions that Excel typically supports.

Correct AnswerverifiedShow Answer

An online analytics processing system (OLAP) processes: I. Transactions II. Reports and analytics

Correct AnswerverifiedShow Answer

Correct AnswerverifiedShow Answer

Excel is a spreadsheet application software. Select the Excel function listed below that you would use if you wanted to calculate the average of selected cells.

Correct AnswerverifiedShow Answer

Correct AnswerverifiedShow Answer

Which system is used by senior management to determine regions of the world for new investment?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified