Introduction to Information Systems Exam
Bank
Course Introduction
Introduction to Information Systems provides students with a foundational understanding of how information technologies are used to support business processes, decision-making, and competitive strategy in organizations. The course explores the key components and types of information systems, including hardware, software, data, people, and procedures. It examines the role of information systems in solving business problems and enhancing productivity, as well as key issues related to security, ethics, and globalization. Students will also learn about emerging trends in the field and gain practical experience with common business applications.
Recommended Textbook
New Perspectives on Microsoft Excel 2013 Comprehensive 1st Edition by June Jamrich Parsons
Available Study Resources on Quizplus
13 Chapters
1319 Verified Questions
1319 Flashcards
Source URL: https://quizplus.com/study-set/1082
Page 2
Chapter 1: Getting Started With Excel
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21371
Sample Questions
Q1) The formula bar displays the value or formula of the active cell.
A)True
B)False
Answer: True
Q2) \(\underline { \text { Normal } }\) view shows how the worksheet will appear when printed._________________________
A)True
B)False
Answer: False
Q3) You can move to the previous or next sheet by pressing the ____ keys.
A)Alt + Page Up or Alt + Page Down
B)Ctrl + Page Up or Ctrl + Page Down
C)Tab + Page Up or Tab + Page Down
D)F4 + Page Up or F4 + Page Down
Answer: B
Q4) An adjacent range is a collection of separate ranges.
A)True
B)False Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Formatting Workbook Text and Data
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21372
Sample Questions
Q1) To add a _____ to a sheet tab,right-click a sheet tab,point to Tab Color on the shortcut menu,and then click a color.
A)fill color
B)tab setting
C)format color
D)formatting style
Answer: A
Q2) Because Excel stores dates and times as _____,you can apply different formats without affecting the date and time value.
A)numbers
B)text
C)universal numbers
D)Greenwich Mean Time
Answer: A
Q3) The ____________________ copies the formatting from one cell or range to another cell or range without duplicating any of the data.
Answer: Format Painter
Q4) A(n)____________________ is text printed in the top margin of each page. Answer: header
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Calculating Data With Formulas and Functions
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21373
Sample Questions
Q1) A(n)____________________ function is a function that works with statements that are either true or false.
Answer: logical
Q2) A date and time function
A)NOW
B)error value
C)COUNTA
D)<
E)MEDIAN
F)Mon, Tues, Wed, Thurs, Fri
G)F4
H)absolute
I)nested
J)mixed
Answer: A
Q3) ____________________ is an Excel function category that returns information about the format,location,or contents of worksheet cells.
Answer: Information
Q4) Functions can also be ____________________ or placed inside another function.
Answer: nested
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Analyzing and Charting Financial Data
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21374
Sample Questions
Q1) When selecting a chart,it's important to choose the right type of chart to represent your data. If choosing between a pie chart and a line chart,what factors would you evaluate in choosing which chart to use? How would each chart differ in representing your data?
Q2) A pie slice is a data marker that represents ____ from a data series.
A)only one value
B)at least one value
C)no more than three values
D)no more than five values
Q3) You can add ___________________ to identify smaller intervals between the major tick marks.
Q4) In the figure above,pv stands for the ____.
A)payments verified
B)principal value of the loan
C)present value of the loan
D)primary interest rate of the loan
Q5) Each value from a data series is represented by a ________.
Q6) Interest is the amount of money being loaned.
A)True
B)False
Page 6
To view all questions and flashcards with answers, click on the resource link above.
Chapter
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21375
Sample Questions
Q1) Ted wants to be able to use his PivotTable to combine items into groups.Which of the following is true?
A)Items that appear as row labels cannot be grouped.
B)Items that appear as column labels can be grouped.
C)If items are dates, they cannot be grouped automatically using the Grouping dialog box.
D)If items are numbers, they cannot be grouped manually using the Ctrl key to select items in a group and then choosing Group from the shortcut menu.
Q2) You can click the More Functions command on the Total arrow button list to open the ____ dialog box and select any available function.
A)Display Function
B)Insert Function
C)Add Function
D)New Function
Q3) You can drag one field to the FILTERS area of the PivotTable Fields pane to change what values are displayed in the PivotTable.
A)True
B)False
Q4) What are the steps for sorting data using multiple fields?
Page 7
To view all questions and flashcards with answers, click on the resource link above.
Chapter 6: Managing Multiple Worksheets and Workbooks
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21376
Sample Questions
Q1) The worksheet range ____ references the worksheets,"Sheet1," "Sheet2," "Sheet3," and "Sheet4."
A)Sheet1_Sheet4
B)Sheet1-Sheet4
C)Sheet1:Sheet4
D)Sheet1/Sheet4
Q2) To remove a worksheet group,you can right-click the sheet tab of a sheet in the group and then click ____ on the shortcut menu.
A)Remove Group
B)No Group
C)Exit Group
D)Ungroup Sheets
Q3) When you save a workbook that contains external reference formulas Excel stores the most recent results of those formulas in the ____ file.
A)source
B) destination
C) both a. and b.
D) neither a. nor b.
Q4) ____________________ appear whenever you place the pointer over a hyperlink.
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Developing an Excel Application
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21377
Sample Questions
Q1) In the accompanying figure,the column labeled "Refers To" is the range's _____.
A)link location
B)location in the workbook
C)target location in the worksheet
D)web name
Q2) When you \(\underline { \text { lock } }\) a workbook,you control the ability users have to make changes to the file._________________________
A)True
B)False
Q3) In the Allow list box in the Data Validation dialog box,the _____ option means that the cell will accept only integers.
A)Integer
B)Decimal
C)Numerical
D)Whole Number
Q4) In addition to referring to cells by their cell references,it is easier to remember where different data is stored by assigning a meaningful,descriptive ____________________ to each cell or range.
Q5) Input messages appear as ____________________ next to the active cell.
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Working With Advanced Functions
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21378
Sample Questions
Q1) A(n)____________________ IF function is when one IF function is placed inside another IF function to test an additional condition.
Q2) You can use a _____ function to return a value from a table that is based on an approximate match lookup.
A)VLOOKUP
B)VAVERAGE
C)VMATCH
D)VAPPROXIMATE
Q3) Which of the following is an effective alternative for the use of extensive nested IF functions?
A)compare table
B)function table
C)lookup table
D)case table
Q4) Assuming that B1 contains 15 and B2 contains 3.5,then _______.
A)the formula indicates that the student is on the Dean's List
B)the formula indicates that the student is NOT on the Dean's List
C)the formula returns a value of 0
D)the formula returns an error message
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Exploring Financial Tools and Functions
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21379
Sample Questions
Q1) When you borrow money,the money you receive represents a _______ cash flow.
A)positive
B)negative
C)fixed
D)neutral
Q2) The fv argument is required in the PMT function.
A)True
B)False
Q3) When you extrapolate a series,the _______ value represents the amount that each value is increased or multiplied as the series is extended.
A)Increase
B)Step
C)Extension
D)Advance
Q4) The tracer arrow provides a visual clue to the source of the error.
A)True
B)False
Q5) Describe the steps to interpolate a series of values between starting and ending values.
Q6) A(n)____________________ is also known as a profit and loss statement.
Page 11
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10: Performing What If Analyses
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21380
Sample Questions
Q1) \(\underline { \text { Nonbinding } }\)constraints always show a slack of 0._________________________
A)True
B)False
Q2) You can include an analysis of the constraints and conditions by which Solver arrived at its solution by creating a(n)_______ report.
A)analysis
B)answer
C)condition
D)constraint
Q3) When creating a(n)____________________ data table,you must identify the row input cell and the column input cell.
Q4) A(n)_______ is a limit that is placed on a Solver problem's solution.
A)max
B)target
C)constraint
D)adjustment
Q5) A(n)____________________ is a customized program that adds commands and features to Microsoft Office programs.
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 11: Connecting to External Data
Available Study Resources on Quizplus for this Chatper
99 Verified Questions
99 Flashcards
Source URL: https://quizplus.com/quiz/21381
Sample Questions
Q1) One of the advantages of using XML as a data source is that it allows you to attach,or _______,elements to specific cells in the workbook.
A)map
B)bind
C)insert
D)pin
Q2) One of the advantages of XML is that the XML author defines what constitutes a valid document. Documents that fail to meet the rules can be rejected by an XML program as invalid,thus ensuring _______.
A)coding
B)data values
C)data integrity
D)external data
Q3) To better understand the structure of an XML document,an XML ____________________ can be created that displays the layout of the elements in a schematic diagram.
Q4) Each row of a database table,called a(n)____________________,displays a collection of characteristics of a particular person,place,or thing.
Q5) A(n)____________________ is a collection of data arranged in rows and columns.
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 12: Collaborating on a Shared Workbook
Available Study Resources on Quizplus for this Chatper
120 Verified Questions
120 Flashcards
Source URL: https://quizplus.com/quiz/21382
Sample Questions
Q1) Workbook viruses are often signaled by a hidden worksheet or hidden code attached to the \(\underline { \text { HTML } }\)code in the file._________________________
A)True
B)False
Q2) The Excel ____________________ includes most of the tools for editing a workbook that are in the Excel desktop application such as the ribbon,sheet tabs,and command buttons.
Q3) Database tables can be inserted directly into PivotCharts and ____________________.
Q4) Define XML and discuss its applications.Define each of the following terms: elements,root element,tag,data map,and schema.
Q5) ____________________ refers to the technology that allows one to copy and paste objects,such as graphics files,cells and ranges,and charts,so that information about the program that created the object is included with the object itself.
Q6) If you cannot obtain a digital certificate from a third party,you can create your own ____________________ certificate,which is a certificate created and signed by the person it certifies.
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 13: Managing Your Files
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21370
Sample Questions
Q1) A(n)____ is an example of a fixed file storage system,permanently housed in a computer.
A)USB drive
B)DVD
C)cloud disk
D)hard disk
Q2) In order to use SkyDrive,you need to have a(n)____________________ account.
Q3) Swiping from the right edge of the screen toward the center ____.
A)drags an object
B)displays thumbnails of open apps
C)displays the Charms bar
D)zooms the screen
Q4) In the accompanying figure,the items pointed to by Box G are ____.
A)folders
B)subfolders
C)files
D)directories
Q5) When you move a folder,you also move all of the files contained in the folder.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 15