Management Information Systems
Test Bank
Course Introduction
Management Information Systems (MIS) explores the strategic use of information technology and systems in contemporary organizations to improve efficiency, enhance decision-making, and achieve business objectives. This course covers key concepts such as database management, system development, enterprise resource planning, e-commerce, and information security. Students will learn how MIS integrates people, processes, and technology to solve business problems, support operations, and drive innovation. The course combines theoretical frameworks with real-world case studies, equipping students to analyze business requirements, evaluate IT solutions, and contribute to effective management in a digital environment.
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) To switch to ____ mode,you double-click the cell.
A)Insert
B)Copy
C)Edit
D)Paste
Answer: C
Q2) Displays the name of the sheets in the workbook
A)function
B)Name box
C)worksheet
D)range
E)order of operations
F)sheet tabs
G)Ctrl
H)Normal view
I)formula view
J)template
Answer: F
Q3) ____________________ view shows how the worksheet will appear when printed.
Answer: Page Layout
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
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21372
Sample Questions
Q1) To avoid splitting a worksheet in awkward places,you can insert a _____ to specify a specific breaking point.
A)page insert
B)manual page break
C)print area
D)selection
Answer: B
Q2) Header and footer elements such as worksheet name,current date,and time are _____ elements.
A)descriptive
B)dynamic
C)impact
D)required
Answer: B
Q3) The Format Painter does not copy formatting applied to selected text within a cell,and it does not copy data.
A)True
B)False
Answer: True
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) FUNCTION(argument1,argument2,...)is ____.
A)the syntax of writing optional arguments
B)an example of a formula
C)the general syntax of all functions
D)the general syntax of all formulas
Answer: C
Q2) ______ functions find values in tables of data and insert them in another location in the worksheet such as cells or in formulas.
A)Sum
B)Average
C)Lookup
D)Find
Answer: C
Q3) Use ____ references when you want different formulas to refer to the same cell.
A)mixed
B)relative
C)absolute
D)fixed
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) You can move a chart from one worksheet to another,or you can place the chart in its own chart sheet.
A)True
B)False
Q2) Simon wants to change the chart's border.To do this,he should select the CHART TOOLS ____ tab.
A)FORMAT
B)EDIT
C)DESIGN
D)LAYOUT
Q3) The _______ covers the entire background of the chart,whereas the plot area includes only that portion of the chart in which the data markers,such as the columns in a column chart,have been placed or plotted.
Q4) 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?
Q5) Each value from a data series is represented by a ________.
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) To find anyone whose Camp is either Day Camp,or Overnight Camp,or Nature Camp,what should he do?
A)Create a text filter using the Contains operator to display all records that have Nature anywhere in the text value.
B)Create a text filter using the Ends With operator to display all records that have Day as the last characters in the text value.
C)Create a text filter using the Begins With operator to display all records that have Overnight as the first characters in the text value.
D)Create a text filter using the Contains operator to display all records that have Camp anywhere in the text value.
Q2) The ____ report layout displays one column for each field and leaves space for column headers.
A)Outline
B)Design
C)Tabular
D)Headers
Q3) The box that is covering columns A,B,and C in the figure above is the PivotTable ____________________ area.
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) You can create a(n)____ reference by deleting the $ from the row reference in the cell reference $B$6.
A)mixed
B)absolute
C)relative
D)indexed
Q2) To select adjacent worksheets,you use the ____ key.
A)Shift
B)Alt
C)Ctrl
D)F1
Q3) When Ryder goes to save the workbooks,what is the required file extension?
A)wxls
B)xlww
C)xlsx
D)xlwx
Q4) A(n)____________________ group is a collection of two or more selected worksheets.
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) Programming language that allows you to create macros
A)Stop
B)Warning
C)Information
D)locked
E)macro
F)VBA
G)defined name
H)input message
I)validation rule
J)digital certificate
Q2) By digitally signing a workbook that contains a macro that she intends to publicly distribute,Rina assures her audience _____.
A)of the identity of the user of the macro
B)that the macro has not been altered since the digital signature was created
C)that the macro will perform as expected
D)that no data entry errors will stop the macro from running
Q3) A(n)____________________ is a spreadsheet written or tailored to meet the user's specific needs.
Q4) Describe the four macro security settings.
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) The _____ function calculates the average of values in a range that match criteria you specify.
A)AVERAGEAS
B)AVERAGEOR
C)AVERAGEAND
D)AVERAGEIF
Q2) You \(\underline {\text { cannot }}\) nest more than one IF function to test for multiple outcomes._________________________
A)True
B)False
Q3) Given the flowchart in the accompanying figure,the Perf Rating of _____ yields a Bonus value of 0.
A)1
B)2
C)2500
D)7500
Q4) The ____________________ function searches vertically down a lookup table and is used when the compare values are stored in the first column of the lookup table.
Q5) Discuss strategies for checking formulas for matching parentheses.
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 ____________________ function calculates the amount of a loan payment used to pay off the principal of the loan.
Q2) The ____________________ function calculates the number of payment periods in an investment or loan.
Q3) In a(n)_______ trend,the values change by a constant amount.
A)linear
B)growth
C)periodic
D)orthogonal
Q4) The DB function used to calculate the declining balance depreciation has the following syntax: _______.
A)=DB(salvage, life, period [month])
B)=DB(cost, salvage, period [month])
C)=DB(salvage, cost, life, period [month])
D)=DB(cost, salvage, life, period [month])
Q5) The _______ period is a quick method of projecting the value of an investment.
A)investment
B)payback
C)cumulative
D)time-value
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) Binding constraints always show a slack of _______.
A)-0.01
B)0
C)0.01
D)1
Q2) The items marked 1 in the accompanying figure are _______ cells.
A)result
B)constraint
C)input
D)goal
Q3) The item marked 1 in the accompanying figure indicates the profit.
A)True
B)False
Q4) Cells that display the value _______ indicate that all of the values in the worksheet satisfy the Solver constraints.
A)TRUE
B)YES
C)1
D)0
Q5) ____________________ constraints always show a slack of 0.
Page 12
To view all questions and flashcards with answers, click on the resource link above.
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) Displays the collection of characteristics of a particular person,place,or thing
A)delimiter
B)database
C)record
D)field
E)table
F)query
G)criteria
H)common field
I)element
J)Rich Text
Q2) The item marked 2 in the accompanying figure is a _______ in a database table.
A)field
B)register
C)record
D)key
Q3) When no arrow connects a table to any of the other tables in the data model,there is no way to match the records of that table with the other tables.
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
120 Verified Questions
120 Flashcards
Source URL: https://quizplus.com/quiz/21382
Sample Questions
Q1) ____________________ are the conditions that limit the number of records displayed in the results of a query.
Q2) The ____________________ acts like a notary public,verifying signatures and tracking those that have expired or been revoked.
Q3) Conditions you set to limit the number of records a database extracts
A)delimiter
B)database
C)record
D)field
E)table
F)query
G)criteria
H)common field
I)element
J)Rich Text
Q4) A(n)____________________ is a data location that Excel will access without prompting you to confirm that the connection is secure.
Q5) Data ____________________ can be databases,text files,or other Excel workbooks.
Q6) What are the steps to filter data in a query?
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) File Explorer displays the contents of your computer by using ____ to represent drives,folders,and files.
A)colors
B)sound effects
C)hypertext links
D)icons
Q2) ____ a file places a duplicate version of the file in a new location that you specify.
A)Doubling
B)Moving
C)Copying
D)Replicating
Q3) Deleting folders from the root directory of your hard disk could disrupt the system so that you can't restart or run the computer.
A)True
B)False
Q4) In the path "Computer è Removable Disk (G:)è Wizard Widgets è Stock è Staff."jpg" the name of the file is ____________________ .
Q5) Describe some of the text's best practices for determining where to save files.
To view all questions and flashcards with answers, click on the resource link above. Page 15