280 Information Systems Review for Exam 1

Question 1

Excel is a spreadsheet program used for data organization and analysis.

Accepted Answer

True

Question 2

You can use conditional formatting in Excel to change the cell color

Accepted Answer

True

Question 3

True or false: Information systems are static and unchanging.

Accepted Answer

False

Question 4

What is a common tool in information systems?

Accepted Answer

Database software

Question 5

What is the main purpose of a database?

Accepted Answer

Store information

Question 6

use CONCATENATE function to combine text from multiple cells into one cell

Accepted Answer

True

Question 7

Which of these is a type of information system?

Accepted Answer

Management Information System

Question 8

Which role is crucial in information systems?

Accepted Answer

Data analyst

Question 9

Which four highlights does Leavittt's Diamond model have?

Accepted Answer

People, Technological infrastructure, Processes, Structure

Question 10

Process - Takes an input, adds value, creates an output

Accepted Answer

True

Question 11

True or false: Information systems are only for large companies.

Accepted Answer

False

Question 12

Which of these is a function of information systems?

Accepted Answer

Data processing

Question 13

What is a key feature of information systems?

Accepted Answer

Data security

Question 14

What does ERP stand for?

Accepted Answer

Enterprise Resource Planning

Question 15

True or false: Information systems only store data.

Accepted Answer

False

Question 16

The COUNTA function counts only the cells that contain numerical values

Accepted Answer

False

Question 17

The cell reference B2 refers to column 2 and row B

Accepted Answer

False

Question 18

True or false: Information systems can be automated.

Accepted Answer

True

Question 19

Which is a type of information system?

Accepted Answer

Transaction Processing System

Question 20

What is a common use of information systems?

Accepted Answer

Data analysis

Question 21

True or false: Information systems can improve decision-making.

Accepted Answer

True

Question 22

True or false: Cloud computing is part of information systems.

Accepted Answer

True

Question 23

What is a key component of information systems?

Accepted Answer

Hardware

Question 24

Which of the following is not part of the Technology Infrastructure?

Accepted Answer

Breakroom

Question 25

Which of these is a benefit of information systems?

Accepted Answer

Increased efficiency

Question 26

There are two parts to exam 1 = Excel practical and test questions

Accepted Answer

True

Question 27

In Excel, The formula to add two numbers is written as '=SUM(A1,A2)'

Accepted Answer

True

Question 28

You can use Excel to create charts and graphs

Accepted Answer

True

Question 29

Which of these is a challenge for information systems?

Accepted Answer

Cybersecurity threats

Question 30

VLOOKUP can only search for values in the first column in a table array

Accepted Answer

True

280 Information Systems Review for Exam 1

Questions 30

280 Information Systems Review for Exam 1

Questions 30