Introduction to Information Systems
Exam Solutions
Course Introduction
Introduction to Information Systems provides a foundational understanding of how information technology is used to help organizations manage data, streamline processes, and make informed decisions. The course explores the core components of information systems, including hardware, software, data, people, and procedures, and examines how these elements work together to support business operations and strategy. Students will analyze real-world scenarios to understand the role of information systems in solving organizational challenges, driving innovation, and maintaining a competitive edge. Topics also include systems development, cybersecurity, database management, and ethical considerations in the digital age.
Recommended Textbook
New Perspectives Microsoft Office 365 and Excel 2016 Comprehensive 1st Edition by June Jamrich
Available Study Resources on Quizplus
13 Chapters
935 Verified Questions
935 Flashcards
Source URL: https://quizplus.com/study-set/2189 Page 2
Chapter 1: Getting Started With Excel
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43584
Sample Questions
Q1) "AZ" is an example of a ____.
A) column heading
B) row heading
C) cell reference
D) Name box
Answer: A
Q2) The AutoComplete feature automatically completes an entry based on previous entries in a column._________________________
A)True
B)False
Answer: True
Q3) Which of the following takes precedence over multiplication?
A) division
B) exponentiation
C) addition
D) subtraction
Answer: B
Q4) A(n)____________________ is a named operation that replaces the arithmetic expression in a formula.
Answer: function
Page 3
To view all questions and flashcards with answers, click on the resource link above.
Chapter 2: Formatting Workbook Text and Data
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43585
Sample Questions
Q1) Italic,bold,bold italic,and underline are examples of _____.
A) font themes
B) font styles
C) graphics
D) character settings
Answer: B
Q2) One of the benefits of conditional ____________________ is that it helps you analyze data by highlighting significant trends in data.
Answer: formatting
Q3) In Excel,to merge cells A1,B1,C1,D1,and E1,_____ is the correct reference for the merged cell.
A) A1!E1!
B) A1
C) E1
D) A1-E1
Answer: B
Q4) A footer appears at the top of each printed page._________________________
A)True
B)False
Answer: False
4
To view all questions and flashcards with answers, click on the resource link above.
Chapter 3: Performing Calculations With Formulas and Functions
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43586
Sample Questions
Q1) In the formula =IF(A1=B1,C1,C2),the result will be C2 if ____.
A) A is equal to B
B) A does not equal B
C) A1+B1 is equal to C1
D) A1>B1 is equal to C2
Answer: B
Q2) The ____ function returns the maximum value in the range.
A) TOP
B) FIRST
C) MAX
D) MOST
Answer: C
Q3) Which of the following is not a comparison operator? ____
A) =
B) <=
C) <<
D) <>
Answer: C
Q4) TODAY is an example of a(n)____________________ function.
Answer: date
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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43587
Sample Questions
Q1) The range of values or _______,of an axis is based on the values in the data source.
A) scale
B) defined range
C) series
D) length
Q2) 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
Q3) To add and remove chart elements,you can use the Add Chart Element button in the Charts Layout group on the ____ tab.
A) CHART TOOLS LAYOUT
B) CHART TOOLS DESIGN
C) INSERT
D) HOME
Q4) By default,Excel inserts a chart as an embedded chart._________________________
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Working With Excel Tables, Pivottables, and Pivotcharts
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43588
Sample Questions
Q1) To create a custom list,in the Sort & Filter group on the Home tab,click the Sort button.Click the Order arrow,and then click Custom List.____________________
A)True
B)False
Q2) The ____ criteria filter requires the records displayed to have the specified text string anywhere.
A) Has
B) Is
C) Contains
D) Matches
Q3) Ted wants to be able to analyze date data in his PivotTable by month.What must he do with the date field in his PivotTable?
A) He must aggregate the data by the date field.
B) He must cluster the data by the date field.
C) He must sort the data by the date field.
D) He must group the data by the date field.
Q4) Each column in a range represents a(n)____________________ that describes some attribute or characteristic of a person,place,or thing.
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Managing Multiple Worksheets and Workbooks
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43589
Sample Questions
Q1) When Ryder goes to save the workbooks,what is the required file extension?
A).wxls
B).xlww
C).xlsx
D).xlwx
Q2) What is an example of when you would use a template? Name at least three benefits of using a workbook template.
Q3) Finally,Simon asks Brooke what steps (if any)need to be taken to keep a destination file up-to-date if he updates a value in one of the source files.Which of the following statements by Brooke would be correct?
A) If a destination file is open when a source file is changed, the destination file will be updated automatically.
B) Source files cannot be updated unless the corresponding destination file is open.
C) It is not possible to choose whether a destination file should reflect changes made to the source files.
D) If a destination file is open when a source file is changed, you need to update the destination file manually so that it reflects the changes.
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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43590
Sample Questions
Q1) The Name dialog box lists all of the names currently defined in the workbook,including Excel table names._________________________
A)True
B)False
Q2) A(n)____________________ is a series of stored commands that can be run whenever you need to perform a task.
Q3) Based on what she has learned,which of the following would Rina say is a true statement about digital signatures?
A) Adding a digital signature is the first step before you distribute a file.
B) A digital signature is often used to identify the author of a workbook that contains macros.
C) Before you can add a digital ID to a workbook, you need to obtain a digital signature.
D) Digital certificates are usually issued by Microsoft.
Q4) A digital ____________________ is often used to identify the author of a workbook that contains macros.
Q5) Protecting the ____________________ of a workbook prohibits users from moving,resizing,closing,or hiding parts of the Excel window.
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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43591
Sample Questions
Q1) The _____ function calculates the difference between two dates and shows the result in months,days,or years.
A) nested IF
B) CALIF
C) DATEDIF
D) DATE
Q2) You could test two or more conditions and determine whether all conditions are true using the _____ function.
A) OR
B) IF
C) AND
D) THIS
Q3) An error value begins with a(n)number sign followed by an error name,which indicates the type of error._________________________
A)True
B)False
Q4) A(n)____________________ specifies the type of condition,the type of formatting when that condition occurs,and the cell or range the formatting is applied to.
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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43592
Sample Questions
Q1) Most Excel financial functions require a particular _______ to the cash flow to return the correct value.
A) index
B) valence
C) orientation
D) direction
Q2) The major advantage of the payback period is that it takes into account the time value of money.
A)True
B)False
Q3) A(n)dependent cell is one whose value depends on the values of other cells in the workbook._________________________
A)True
B)False
Q4) Which of the following shows the syntax of the NPER function?
A) =NPER(pmt, pv, [fv=0], [type=0])
B) =NPER(rate, pmt, [fv=0], [type=0])
C) =NPER(rate, pmt, pv [, fv=0] [, type=0])
D) =NPER(pmt, rate, pv, [fv=0], [type=0])
Q5) How do you determine which method of depreciation is most appropriate?
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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43593
Sample Questions
Q1) A limits report allows you to quantify the reliability of a solution produced by Solver.
A)True
B)False
Q2) In two-variable tables,you must always place a reference to the result cell in the _______ corner of the table at the intersection of the row values and the column values.
A) upper-right
B) upper-left
C) lower-right
D) lower-left
Q3) When creating a one-variable Data Table,which of the following should you NOT do?
A) Enter a formula that references the input cell in the upper-left cell of the table.
B) Enter input values in either the second row or the first column.
C) Enter input values in either the first row or the first column.
D) Select the table excluding any row or column headings.
Q4) How does Goal Seek differ from traditional what-if analysis?
Q5) What are the steps to create a one-variable data table?
To view all questions and flashcards with answers, click on the resource link above.
Page 12
Chapter 11: Analyzing Data With Business Intelligence
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43594
Sample Questions
Q1) Power Map data is placed in tables,which are superimposed on the map.
A)True
B)False
Q2) One way to interact with a database is with a query language.The most popular query language is _______.
A) ODC
B) UDC
C) OLE
D) SQL
Q3) Stores information about a specific characteristic of a person,place,or thing
A)delimiter
B)database
C)record
D)field
E)table
F)query
G)common field
Q4) The source editor is an office tool used to write queries.
A)True
B)False
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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43595
Sample Questions
Q1) _______ properties are properties associated with documents in a document library on a website or in a public network folder.
A) Custom
B) Document library
C) Organization
D) Automatically Updated
Q2) The Document Inspector will remove comments,annotations,document properties,and personal information from a shared workbook.
A)True
B)False
Q3) _______ displays and stores an object within the destination file.
A) Copy and Paste
B) Linking
C) Embedding
D) Inserting
Q4) Excel tracks the changes made to a shared workbook,recording the name of the user who made the changes and when the changes were saved.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 13: Working With Text Functions
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/43583
Sample Questions
Q1) You can use the LEN and LEFT functions nested in a(n)____ function to convert all of the zip codes to the shorter form.
A) IF
B) MID
C) Text
D) PROPER
Q2) A workbook will convert to Compatibility Mode if it was created in Excel 2003 or earlier.
A)True
B)False
Q3) Compatibility Mode keeps the workbook in the older file format with the .xsl file extension.
A)True
B)False
Q4) The Trim function removes all characters from a string except for single spaces between words.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 15