Information Systems Fundamentals
Question Bank
Course Introduction
Information Systems Fundamentals introduces the essential concepts, components, and roles of information systems within organizations. Students will explore the interaction between people, technology, and business processes, learning how information systems support decision-making, operations, and strategic goals. Topics include hardware, software, databases, networking, security, and ethical considerations, as well as an overview of system development lifecycles and emerging trends in the field. This course provides a foundation for understanding how information systems drive organizational success and innovation.
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) Microsoft's research indicates that two-thirds of people who open Word documents never,print them.
A)True
B)False
Answer: True
Q2) The default zoom level for viewing a document is ________.
A)25%
B)75%
C)100%
D)200%
Answer: C
Q3) When you selects a line of text and makes changes,the changes are applied to the entire selection.
A)True
B)False
Answer: True
Q4) Backstage view is a centralized space for all of your file management tasks.
A)True
B)False
Answer: True
Page 3
To view all questions and flashcards with answers, click on the resource link above.
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 category axis is also known as the y-axis.
A)True
B)False
Answer: False
Q2) Match each of the following terms to its definition:
i.cell style
II.theme
III.format
IV.Accounting Number Format
v.Comma Style
A)a thousand comma separator,dollar sign,and two decimal places
B)a thousand comma separator,two decimal places,and space at the right of the cell
C)defined set of formatting characteristics
D)change the appearance of cell contents
E)predefined set of features that coordinate for an attractive look
Answer: C,E,D,A,B
Q3) When you select a range of data,the ________ button displays.
Answer: Quick Analysis
To view all questions and flashcards with answers, click on the resource link above.
Page 4
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) When excel enters a current date into a cell,it is accessed from your computer's internal calendar.
A)True
B)False
Answer: True
Q2) Which of the following is FALSE about worksheet tabs?
A)You can change the color of worksheet tabs.
B)You can rename a tab by double-clicking on it.
C)The active worksheet tab displays in red font.
D)A worksheet tab can be copied.
Answer: C
Q3) An Excel ________ is a range of cells converted in Excel used to analyze a group of related data.
Answer: table
Q4) Deleting the ________ of a cell deletes the value or formula,but does not clear formatting of that cell.
Answer: contents
Q5) ________ identify each worksheet in a workbook. Answer: Sheet tabs
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) Goal Seek is a ________ tool in Excel 2016.
Q2) Which of the following resides along the left side of a column chart?
A)The x-axis
B)The plot area
C)The y-axis
D)The legend
Q3) A ________ in a pie chart identifies the pie slices.
A)data series
B)data label
C)data marker
D)data point
Q4) A Major unit value in a line chart determines the range of numbers in the value axis.
A)True
B)False
Q5) To size a chart proportionately,hold down the ________ key and ________.
A)Ctrl;drag a corner sizing handle
B)Shift;drag a left or right sizing handle
C)Shift;drag a top or bottom sizing handle
D)Shift;drag a corner sizing handle
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) Apply styles to cells,such as Headings and Titles and Data and Model,by using the ________ command in the Styles group.
A)Cell Styles
B)Conditional Formatting
C)Format as Table
D)Merge Styles
Q2) Equations that perform calculations on values in a worksheet are referred to as ________.
Q3) In a Lookup formula,the defined range is referred to as the table array.
A)True
B)False
Q4) In the Excel PMT function,the term used to indicate the interest rate for a loan is called ________.
A)Present value (Pv)
B)rate
C)Future value (Fv)
D)payment period
Q5) The Watch Window displays the results of specified cells.
A)True
B)False
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) If you want every one of the comparison criteria that you specify to be true,you would use the ________.
A)Or comparison operator
B)Equals operator
C)And comparison operator
D)Less than operator
Q2) Defining data as a table prior to sorting the data is optional.
A)True
B)False
Q3) Which of the following describes all of the categories of data pertaining to one person,place,thing,event,or idea within a table row?
A)Database
B)Query
C)Field
D)Record
Q4) Fonts are associated with different themes and can be customized by ________.
A)clicking in the default themes option
B)using the predefined themes that come with Office 2016
C)mixing Colors and Fonts from any of the supplied themes
D)using Live Preview
To view all questions and flashcards with answers, click on the resource link above. Page 8
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) To delete a box from a SmartArt organization chart,a ________ border must display around the box.
A)solid line
B)dashed line
C)double line
D)dotted line
Q2) Specific cells in a protected worksheet can be ________ so that data can be entered.
Q3) If you try to enter data in a protected cell,a message displays informing you that the cell is protected and therefore ________.
A)read-only
B)unlocked
C)invalid
D)embedded
Q4) Both charts and SmartArt graphics depend on underlying data in a worksheet.
A)True
B)False
Q5) ________ display alongside each row of data and provide a quick visual trend summary.
Q6) ________ charts can show trends over time. Page 9
To view all questions and flashcards with answers, click on the resource link above.
Page 10
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) A PivotTable report ________ large amounts of data so you can analyze related totals.
A)compares and calculates
B)calculates and combines
C)compares and contrasts
D)combines and compares
Q2) A field that is being removed from the PivotTable report is indicated by a(n)attached to the pointer as you drag ________.
A)no symbol
B)X
C)gray area
D)delete button
Q3) A line chart shows the relationship of each part as a whole.
A)True
B)False
Q4) The filtering button that removes a filter is the ________ button.
Q5) Slicers display as movable objects on your worksheet in the same manner as charts and shapes.
A)True
B)False
11
To view all questions and flashcards with answers, click on the resource link above.
Chapter
Available Study Resources on Quizplus for this Chatper
96 Verified Questions
96 Flashcards
Source URL: https://quizplus.com/quiz/48542
Sample Questions
Q1) If the date formats available in Excel are NOT suitable,you can create a ________ date format.
Q2) In a moving average,the number range that is averaged is constantly changing,dropping off the first number and adding on the most ________ number.
Q3) Solver is located in the ________ group on the Data tab.
Q4) On a line chart,you can change the ________ of the vertical axis to provide more vertical space and a more dramatic slope to the lines.
A)balance
B)degree
C)scale
D)level
Q5) You can use the mathematical operators plus sign (+),minus sign (-),division sign (/),and multiplication sign (*)to build complex formulas.
A)True
B)False
Q6) ________ are elective commands and features that are NOT immediately available that must be installed within Excel before you can use them.
Page 12
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) A ________can include an ActiveX control such as a button or check mark that can be placed on a worksheet to display or enter data.
Q2) When you use someone else's computer,it is proper computer ________ to return it to the condition that you found it.
Q3) The action that causes a macro to run,which may include a combination of keystrokes and the click of a button on the Quick Access Toolbar,is called ________.
A)a sub procedure
B)a module
C)an event
D)a file
Q4) You can ________ that the macro is from a trusted source by using a digital signature.
Q5) When you assign a shortcut key to a macro,it will take precedence over the shortcut keys that are ________.
A)external to Excel
B)built into Excel
C)case sensitive
D)used by all applications
13
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10: Excell: External Data, Database Functions, and
Side-By-Side Tables
Available Study Resources on Quizplus for this Chatper
96 Verified Questions
96 Flashcards
Source URL: https://quizplus.com/quiz/48544
Sample Questions
Q1) Match the following five terms to their meanings:
i.external data
II.database
III.record
IV.field
v.table
A)An arrangement of information stored in rows and columns.
B)Data that resides outside of Excel.
C)An organized collection of facts related to a specific topic or purpose.
D)A horizontal row in a database table that stores all of the data about one database item.
E)A specific type of data that is stored in columns.
Q2) The ________ function returns the specified number of characters from the beginning of a string of characters.
A)FRONT
B)LEFT
C)MID
D)RIGHT
Q3) To insert headers or footers in several worksheets at the same time,you must first ________ the worksheets.
To view all questions and flashcards with answers, click on the resource link above. Page 14
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) When more than one copy of the shared workbook contains marked changes,first ________ the workbooks so that you can view everyone's changes in a single workbook.
A)merge
B)save
C)accept
D)discard
Q2) A faded image or text used as a background of a document is ________.
A)alt-text
B)a watermark
C)a draft
D)an imprint
Q3) Mark as Final signifies the intent of the author that the document is finalized and makes the document ________.
A)password protected
B)read only
C)ready to edit
D)ready to save
Q4) To change the Attributes area in the Properties dialog box of a file,the file must be ________.
To view all questions and flashcards with answers, click on the resource link above. Page 15