Information Systems Fundamentals
Final Exam
Course Introduction
Information Systems Fundamentals introduces students to the core concepts and components of information systems within organizations. The course explores the role of information technology in supporting business processes, decision-making, and competitive advantage. Key topics include hardware and software, data management, networking, internet technologies, system development life cycles, and the ethical and societal issues surrounding information systems. Through case studies and practical exercises, students will gain an understanding of how information systems are designed, implemented, and managed to meet the strategic needs of modern enterprises.
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) A common business practice is to include a worksheet named \(\underline { \text { Documentation } }\) that contains a description of the workbook,the name of the person who prepared the workbook,and the date it was created._________________________
A)True
B)False
Answer: True
Q2) Samantha has entered several formulas in her worksheet.All of a sudden,she realizes that the cells that once displayed the formula results are now displaying the formulas and all of the columns are wider.She must have switched to ____.
A)editing mode by double-clicking the results cell
B)formula view by pressing Ctrl + Alt
C)editing mode by pressing Ctrl + Alt
D)formula view by pressing Ctrl + `
Answer: D
Q3) The ____________________ function will not include any cell in the range containing a non-numeric value in the final tally.
Answer: COUNT
To view all questions and flashcards with answers, click on the resource link above.
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) What is conditional formatting and why would you apply it? Give two examples of conditional formats,and explain a method for applying conditional formatting.
Answer: Conditional formatting applies formatting only when a cell's value meets a specified condition.A conditional format could make negative numbers red and positive numbers black.
Excel has four conditional formats-data bars,highlighting,color scales,and icon sets. Students should explain one of the following two methods for applying conditional formatting.
Select the range or ranges to which you want to add data bars.
In the Styles group on the Home tab,click the Conditional Formatting button,point to Data Bars,and then click a data bar color. or
Select the range in which you want to highlight cells that match a specified rule. In the Styles group,click the Conditional Formatting button,point to Highlight Cells Rules or Top/Bottom Rules,and then click the appropriate rule.
Select the appropriate options in the dialog box,and then click the OK button.
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) Which of the following is a Math & Trig function? ____
A)INT
B)COUNT
C)MIN
D)AVERAGE
Answer: A
Q2) To display the current date and time,which is updated each time the workbook is reopened, use the TODAY function.
A)True
B)False
Answer: False
Q3) ____ references are seldom used other than when creating tables of calculated values such as a multiplication table in which the values of the formula or function can be found in the initial rows and columns of the table.
A)Absolute
B)Relative
C)Mixed
D)Matched
Answer: C
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) The columns and pie slices in the charts above are ____.
A)data markers
B)chart areas
C)major tick marks
D)minor tick marks
Q2) The FV function stands for ____.
A)function value
B)future value
C)financial value
D)formulated value
Q3) You can choose Center,Inside End,Outside End,or Best Fit for the data label positions in the in the ____ pane.
A)Format Data Labels
B)Format Legend
C)Format Chart Area
D)Format Axis
Q4) A column chart turned on its side is called a bar chart,with the length of the bar determined by the data value.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21375
Sample Questions
Q1) A collection of related fields that are grouped together
A)custom list
B)field
C)record
D)freeze
E)criteria filter
F)data definition table
G)filter
H)PivotTable
I)field name
J)sort
Q2) The ____________________ command automatically inserts a subtotal line into the range for each group of data.
Q3) An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A buttons.
A)True
B)False
Q4) In addition to data fields,a PivotTable uses ____________________ fields to group values such as department,model,year,and vehicle type in an automobile-related sheet,for example.
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
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21376
Sample Questions
Q1) A formula can include a reference to another workbook (called an ____ reference),which creates a set of linked workbooks.
A)internal
B)external
C)import
D)export
Q2) To delete a hyperlink,right-click the hyperlink cell and then click Clear \(\underline { \text { Value } }\)._________________________
A)True
B)False
Q3) When the destination file is ____________________,and the source files are closed,the complete file path is included as part of the external reference formula that appears in the formula bar.
Q4) The general format of a 3-D cell reference is ____.
A)CellRange!WorksheetRange
B)WorksheetRange!CellRange
C)WorkbookRange!CellRange
D)CellRange!WorkbookRange
Q5) ____________________ appear whenever you place the pointer over a hyperlink.
8
To view all questions and flashcards with answers, click on the resource link above.
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) For cell and range names,names of 5 to 15 characters are considered practical,although names can be up to 255 characters.
A)True
B)False
Q2) A(n)____________________ is a text box that is attached to a specific cell in a worksheet.
Q3) Word or string of characters associated with a single cell or a range
A)Stop
B)Warning
C)Information
D)locked
E)macro
F)VBA
G)defined name
H)input message
I)validation rule
J)digital certificate
Q4) A(n)____________________ is a series of stored commands that can be run whenever you need to perform a task.
Q5) Input messages appear as ____________________ next to the active cell.
Page 9
To view all questions and flashcards with answers, click on the resource link above.
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) The major difference between HLOOKUP and VLOOKUP functions is the way the lookup tables are _____.
A)named
B)organized
C)saved
D)opened
Q2) You can edit existing conditional formatting rules from the Conditional Formatting _____ dialog box.Click the Edit Rule button and make the appropriate changes.
A)Rules Editor
B)Rules Manager
C)Editor
D)Manager
Q3) If all of the logical conditions are true,the AND function returns the logical value _____.
A)FALSE
B)ON
C)TRUE
D)OFF
Q4) What are the guidelines to keep in mind when creating fields in an Excel table?
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) The FV function calculates the \(\underline {\text { full } }\) value of an investment or loan._________________________
A)True
B)False
Q2) Calculates the amount of a loan payment used to pay off the interest
A)PPMT function
B)rate of return
C)IPMT function
D)IRR
E)PV function
F)RATE function
G)PMT function
H)XIRR function
I)FV function
J)NPER function
Q3) In a(n)_______ trend,the values change by a constant amount.
A)linear
B)growth
C)periodic
D)orthogonal
To view all questions and flashcards with answers, click on the resource link above. Page 11
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) A(n)\(\underline { \text { mixed } }\) expense is an expense that is part variable and part fixed._________________________
A)True
B)False
Q2) _______ analysis expresses the relationship between a company's expenses,its volume of business,and the resulting profit.
A)MVP
B)ABC
C)CVP
D)CBP
Q3) The item marked 3 in the accompanying figure indicates the _______ expenses.
A)fixed
B)mixed
C)variable
D)absolute
Q4) How many different types of reports can Solver create? What are the characteristics of these report types,and which is the most useful?
Q5) A(n)____________________ expense is an expense that must be paid regardless of sales volume.
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) A(n)____________________ is a data location that Excel will access without prompting you to confirm that the connection is secure.
Q2) To prevent other users from updating a data source without permission,what should Audra do?
A)Define the data source.
B)Remove the connection.
C)Require a password.
D)Nothing-Excel cannot prevent data from being refreshed.
Q3) A _______ delimiter is often the best way of separating text columns because text delimited this way can include spaces or commas within each column.
A)space
B)comma
C)tab
D)dash
Q4) A(n)____________________ is a collection of data arranged in rows and columns.
Q5) Columns in delimited text files are always vertically aligned as they would be in a spreadsheet.
A)True
B)False
13
To view all questions and flashcards with answers, click on the resource link above.
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) The \(\underline {\text { Standard }}\) option optimizes the PDF for use with online publishing and printing._________________________
A)True
B)False
Q2) A(n)_______ is stored within the destination file and remains connected to the source file.
A)embedded object
B)linked object
C)inserted object
D)copied object
Q3) To begin Rebecca needs to share her workbook.She will create a shared folder.What would be the best way to distribute the workbook to others?
A)Placing the file on the local drive
B)Placing the file on the cloud
C)Placing the file on flash drive
D)Placing the file on a CD-ROM
Q4) A shared Excel workbook ____________________ the changes made by different people so everyone can examine when and where each change was made.
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 file means making an uncompressed copy of a compressed file.
Q2) Extracting a file means to compress a file into an archive.
A)True
B)False
Q3) If you are currently working in the F: directory,you are most likely working with folders and files ____.
A)on the hard disk
B)on a USB drive
C)on a floppy drive
D)in the cloud
Q4) Windows Vista,Windows 7,and Windows 8 were all designed for touch-screen computers such as tablets.
A)True
B)False
Q5) An example of sorting in ascending order is ____.
A)Z to A
B)9 to 0
C)latest to earliest date
D)A to Z
To view all questions and flashcards with answers, click on the resource link above. Page 15