Introduction to Information Systems
Mock Exam
Course Introduction
Introduction to Information Systems provides a comprehensive overview of the role and impact of information systems in contemporary organizations. The course explores fundamental concepts such as data management, system components, and the ways in which information technology supports business operations, decision-making, and strategic objectives. Students will examine the types of information systems used in businesses, including transaction processing systems, management information systems, and decision support systems, while considering current trends such as cloud computing, cybersecurity, and digital transformation. Through case studies and practical examples, the course emphasizes how organizations leverage information systems to gain a competitive advantage, improve efficiency, and adapt to changing environments.
Recommended Textbook
GO with Microsoft Excel 2016 Comprehensive 1st edition by Shelley Gaskin
Available Study Resources on Quizplus
12 Chapters
1128 Verified Questions
1128 Flashcards
Source URL: https://quizplus.com/study-set/2442 Page 2
Chapter 1: Introduction to Microsoft Office 2016 Features
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/48546
Sample Questions
Q1) If a file is set to Read-Only,the file must be saved as a new file with a new name before you can edit it.
A)True
B)False
Answer: True
Q2) You must hide formatting marks before printing in order for them not to print on the document.
A)True
B)False
Answer: False
Q3) Depending on which Office program you are using,the Open,Save and Save As dialog boxes will look slightly different.
A)True
B)False
Answer: False
Q4) To enable the Format Painter to remain active for multiple selections,________-click on the Format Painter icon.
Answer: double
To view all questions and flashcards with answers, click on the resource link above.
Page 3
Chapter 1: Excell: Creating a Worksheet and Charting Data
Available Study Resources on Quizplus for this Chatper
97 Verified Questions
97 Flashcards
Source URL: https://quizplus.com/quiz/48535
Sample Questions
Q1) The ________ gallery displays a set of predefined characteristics that change the overall visual look of a chart.
Answer: Chart Styles
Q2) A chart value that originates in a worksheet cell is referred to as ________.
A)a data point
B)a data marker
C)a data series
D)the x-axis
Answer: A
Q3) The ________ command joins two or more selected cells together into one cell.
Answer: Merge & Center
Q4) A cell style often includes font,font size,font color,and cell borders.
A)True
B)False
Answer: True
Q5) You can use the Switch/Row Column command to move a chart from a set of rows on one worksheet to a set of columns on another.
A)True
B)False
Answer: False
4
To view all questions and flashcards with answers, click on the resource link above.
Chapter 2: Excell: Using Functions, Creating Tables, and Managing Large Workbooks
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/48536
Sample Questions
Q1) A(n)________ is a worksheet where totals from other sheets are displayed. Answer: summary sheet
Q2) Deleting the ________ of a cell deletes the value or formula,but does not clear formatting of that cell.
Answer: contents
Q3) The keyboard shortcut to enter the current date is Ctrl + #.
A)True
B)False
Answer: False
Q4) If the result of a logical test is false,Excel will always display YES in the cell. A)True
B)False
Answer: False
Q5) The ________ command divides a window into multiple panes. Answer: Split
Q6) You can leave the year off entirely when typing a date into a cell. A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 3: Excell: Analyzing Data With Pie Charts, Line
Charts, and What-If Analysis Tools
Available Study Resources on Quizplus for this Chatper
79 Verified Questions
79 Flashcards
Source URL: https://quizplus.com/quiz/48537
Sample Questions
Q1) A line that serves as a frame of reference for measurement in a chart is a(n)________.
Q2) Match each of the following terms to its definition:
i.fund
II.general fund
III.enterprise fund
IV.data series
v.axis
A)money set aside for the normal operating activities of a city
B)border a chart plot area
C)set of data that is represented by data markers
D)sum of money set aside for a specific purpose
E)money for municipal services for which a fee is charged
Q3) Consecutive operators with the same level of precedence are calculated from right to left.
A)True
B)False
Q4) Goal Seek is a what-if analysis tool.
A)True B)False
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 4: Excell: Use Financial and Lookup Functions,
Define Names, Validate Data, and Audit Worksheets
Available Study Resources on Quizplus for this Chatper
99 Verified Questions
99 Flashcards
Source URL: https://quizplus.com/quiz/48538
Sample Questions
Q1) ________ functions look up a value in a defined range of cells located in another part of the workbook to find a corresponding value.
A)Financial
B)Lookup
C)Statistical
D)Logical
Q2) When you use a(n)________ in a formula,the result is the same as if you typed the cell reference.
Q3) Data tables make it easy to calculate multiple versions in one operation,and then to view and compare the results of all the different variations.
A)True
B)False
Q4) Cells that are referred to by a formula in another cell are called ________.
A)dependent cells
B)precedent cells
C)Trace dependents
D)Trace precedents
Q5) ________ is the process of examining a worksheet for errors in formulas.
Q6) Cells containing formulas that refer to other cells are called ________ cells.
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 5: Excell: Managing Large Workbooks and Using Advanced Sorting and Filtering
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/48539
Sample Questions
Q1) To publish a document and ensure that the appearance of the document is the same no matter what computer it is displayed on,save the document in ________ format.
Q2) Subtotaled rows that are totaled and summarized are referred to as ________ data.
Q3) Hyperlinks can be attached to which of the following items?
A)Page breaks
B)Text and graphics
C)An instructor
D)Another hyperlink
Q4) By using a(n)________ filter,you can apply complex criteria to a single column.
Q5) If the file to which a hyperlink refers to is moved or renamed,or a webpage to which a hyperlink refers has a new address,which of the following do you need to do to the hyperlink to make it work correctly?
A)Leave the hyperlink as is
B)Modify the hyperlink to reflect the change
C)Call the webmaster to fix the link
D)Delete the hyperlink altogether
Page 8
Q6) A sort on a group of numbers that is sorted from highest to lowest is known as a(n)________ sort.
To view all questions and flashcards with answers, click on the resource link above.
Page 9
Chapter 6: Excell: Creating Charts, Diagrams, and Templates
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/48540
Sample Questions
Q1) A(n)________ is a special workbook that can include formatting,formulas,and other elements and that can be used as a pattern for creating other workbooks.
Q2) When you open a template from the Templates folder in Backstage view,a new copy of the template opens as a workbook.
A)True
B)False
Q3) A chart is a graphic representation of data.
A)True
B)False
Q4) The Text Pane includes ________ in which you can type text into a SmartArt graphic.
A)cells
B)legends
C)placeholders
D)objects
Q5) Specific cells in a protected worksheet can be ________ so that data can be entered.
To view all questions and flashcards with answers, click on the resource link above. Page 10
Q6) ________are tiny charts that fit within a cell and give a visual trend summary alongside your data.
Chapter 7: Excell: Creating Pivottables and Pivotcharts
Available Study Resources on Quizplus for this Chatper
91 Verified Questions
91 Flashcards
Source URL: https://quizplus.com/quiz/48541
Sample Questions
Q1) If you change the underlying data on which a PivotTable report is based,you must also ________ or update the PivotTable to reflect the new data.
A)refresh
B)list
C)save
D)reopen
Q2) A Microsoft ________ database stores data in rows and columns.
Q3) The PivotTable report with data graphically represented in a PivotChart is that PivotChart's ________ PivotTable report.
Q4) A ________ chart is used to illustrate the relationship of each part to a whole.
Q5) You cannot update or refresh PivotTable report data.
A)True
B)False
Q6) You can apply a ________ to the entire PivotTable report.
A)PivotStyle
B)PivotTable Style
C)PivotReport Style
D)PivotChart Style
Q7) Filters applied to a PivotChart report will be reflected in the ________ report.
Page 11
To view all questions and flashcards with answers, click on the resource link above.
Chapter
8: Excell: Using the Data Analysis, Solver, and Scenario Features, and Building Complex Formulas
Available Study Resources on Quizplus for this Chatper
96 Verified Questions
96 Flashcards
Source URL: https://quizplus.com/quiz/48542
Sample Questions
Q1) When using Solver,which of the following will NOT be identified during the process?
A)Objective cells
B)Constraint cells
C)Decision variable cells
D)Result cells
Q2) Business owners expect that,at some future point,the business will become
A)profitable
B)adverse
C)useful
D)negative
Q3) To show trends over time,use a ________ chart.
A)bar
B)pie
C)column
D)line
Q4) The curves and directions of lines on a line chart make ________ noticeable to the user.
Page 12
Q5) You can use a ________ chart to display trends over a period of time.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Excell: Using Macros and Visual Basic for Applications
Available Study Resources on Quizplus for this Chatper
97 Verified Questions
97 Flashcards
Source URL: https://quizplus.com/quiz/48543
Sample Questions
Q1) If you want to change the same property for a group of objects,you can select all objects and change the property.
A)True
B)False
Q2) To access the ________ window,click the Debug button within the Microsoft Visual Basic dialog box.
Q3) On the Categorized tab,the same properties are listed,but they are organized by ________ groups.
A)sorted
B)logical
C)related
D)alphabetized
Q4) An ActiveX Control can be added that inserts a ________ button to control when code can be attached and initiates an action when clicked.
Q5) Unauthorized macro code is called a ________.
A)warning code
B)virus code
C)malicious code
D)macro virus
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter
Tables
Available Study Resources on Quizplus for this Chatper
96 Verified Questions
96 Flashcards
Source URL: https://quizplus.com/quiz/48544
Sample Questions
Q1) Information stored in rows and columns is referred to as ________.
A)a record
B)a table
C)a chart
D)an array
Q2) In Excel,you can insert a table beside another table in the same worksheet,and then work with the data in each table separately.
A)True
B)False
Q3) To easily compare similar sets of data in the same worksheet,use side-by-side
Q4) When creating custom headers and footers,you can insert text but NOT pictures or the date.
A)True
B)False
Q5) Data can be imported from a text file into Excel.
A)True
B)False
Q7) Data stored in a format of rows and columns is known as a ________. Page 14
Q6) The ________ Wizard assists you with steps to import a text file into Excel.
To view all questions and flashcards with answers, click on the resource link above.
Page 15
Chapter 11: Excell: Collaborating With Others and Preparing a
Workbook for Distribution
Available Study Resources on Quizplus for this Chatper
95 Verified Questions
95 Flashcards
Source URL: https://quizplus.com/quiz/48545
Sample Questions
Q1) The read-only property CANNOT be set while the file is ________.
A)deleted
B)read
C)open
D)saved
Q2) Encryption is more than simple password protection;it prevents users from ________.
A)saving the file
B)deleting the file
C)editing the file
D)opening the file
Q3) The ________ Checker finds any potential issues and creates a report so that you can resolve the issues to make your file easier for those with disabilities to use.
Q4) When you activate the Track Changes feature,the workbook automatically becomes a ________ workbook.
Q5) Collaboration refers to the process of working together with others to view. A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 16
Q6) A ________ line specifies that an individual must digitally sign the document.