Information Systems for Business Review Questions
Course Introduction
Information Systems for Business explores the strategic role of information technology within modern organizations. The course examines how businesses leverage information systems to enhance decision-making, streamline operations, and gain a competitive advantage. Key topics include the fundamentals of information systems, data management, systems analysis and design, cybersecurity, and the ethical and social implications of technology in the workplace. Students will also analyze real-world case studies to understand how digital innovations foster business transformation and address complex organizational challenges.
Recommended Textbook
Exploring Microsoft Office Excel 2016 Comprehensive 1st Edition by Mary Anne Poatsy
Available Study Resources on Quizplus
13 Chapters
1286 Verified Questions
1286 Flashcards
Source URL: https://quizplus.com/study-set/1601
Page 2
Chapter 1: Introduction to Excel
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/31798
Sample Questions
Q1) Which of the following is not a valid Cell Style?
A)Heading 5
B)Accent 3
C)Input
D)Calculation
Answer: A
Q2) Besides the Page Setup dialog box,where else can you create headers or footers?
A)Page Layout tab,Text group,Header & Footer
B)Insert tab,Text group,Header & Footer
C)Home tab,Text group,Header & Footer
D)View tab,Text group,Header & Footer
Answer: B
Q3) If you do not need a row or column any more it is best to hide it instead of deleting it in case you change your mind.
A)True
B)False
Answer: False
Q4) The intersection between a column and a row is called a(n)________.
Answer: cell
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Formulas and Functions
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/31799
Sample Questions
Q1) In the HLOOKUP function,the third argument is the column index number.
A)True
B)False
Answer: False
Q2) The inputs in a function are specified by its ________. Answer: arguments
Q3) Functions can be nested inside the arguments in the various lookup functions.
A)True
B)False
Answer: True
Q4) The COUNTA function only counts text entries.It does not count calculable values or blank cells.
A)True
B)False
Answer: False
Q5) Excel assigns date number 1 to January 1,1900.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Charts
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/31800
Sample Questions
Q1) To switch to a different chart type after the chart has been created you use the Switch Chart Type tool.
A)True
B)False
Answer: False
Q2) Which chart type is preferable when the category names are long?
A)Column
B)Bar
C)Pie
D)Stacked column Answer: B
Q3) In rare cases you can chart text entries.
A)True
B)False Answer: False
Q4) To understand a chart you need to include the chart data.
A)True
B)False Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Datasets and Tables
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/31801
Sample Questions
Q1) By how many levels will Excel allow you to sort?
A)16
B)32
C)64
D)128
Q2) Which wildcard character only replaces one character with one other character?
A)Question Mark ?
B)Asterisk *
C)Number sign #
D)Tilde ~
Q3) On which tab will you find options if you have to print a large dataset?
A)Page Layout
B)Print
C)Review
D)Home
Q4) You can manually adjust a page break by pointing to the page break line and waiting for the four-headed arrow to appear,then drag the page break to your desired location.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Subtotals, Pivot-tables, and Pivot-charts
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/31802
Sample Questions
Q1) Which is not true about Slicers?
A)Aggregate values do not respond to slicers.
B)You can filter data by a single value.
C)You can move a slicer so it does not cover a PivotTable.
D)You can filter data by multiple values.
Q2) ________ is the process of analyzing large amounts of data to identify trends and patterns in the data.
Q3) You can apply filters on dates to display summary statistics for data occurring during a particular time period.
A)True
B)False
Q4) You created a PivotTable and later made changes to values in the underlying data.What happens to the PivotTable?
A)The PivotTable updates automatically when you make changes to the dataset.
B)Excel gives an error message that data has changed and the PivotTable may no longer be accurate.
C)Changes in the dataset do not affect the PivotTable until you refresh the PivotTable.
D)Excel deletes the PivotTable automatically so you can recreate it.
To view all questions and flashcards with answers, click on the resource link above.
Page 7
Chapter 6: What-If Analysis
Available Study Resources on Quizplus for this Chatper
92 Verified Questions
92 Flashcards
Source URL: https://quizplus.com/quiz/31803
Sample Questions
Q1) It is a good idea to use a custom format to label the top left corner of a two-variable data table with a readable label.
A)True
B)False
Q2) Scenario Manager is not an Excel Add-in.
A)True
B)False
Q3) A one-variable data table would be the appropriate what-if analysis tool to compare loans with variable time period and interest rates.
A)True
B)False
Q4) Which is not true about Scenario Manager?
A)Is rarely used in business models
B)Defines and manages up to 32 scenarios
C)Provides more variability and details than a data table
D)Used to provide best-case,worst-case,and most-likely scenarios.
Q5) Use Paste Names to document a list of all named ranges in a workbook.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Specialized Functions
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/31804
Sample Questions
Q1) The advanced filter tool can ________.
A)delete duplicate records
B)search for unique records,only
C)not filter multiple arrays
D)filter a limit of 256 rows
Q2) You need the same number of logical tests as outcomes in a nested IF function.
A)True
B)False
Q3) Which database function returns the lowest value from the dataset based on your criteria?
A)DMIN
B)DMAX
C)DLEAST
D)DCOUNT
Q4) The first argument of any database function is ________.
Q5) The criteria range must contain ________ at least rows in Advanced Filtering.
Q6) A MATCH function returns the value of a given position.
A)True
B)False
Q7) The ________ function returns the difference between 2 dates.
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Statistical Functions
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/31805
Sample Questions
Q1) A Forecast worksheet is a business intelligence tool that projects trends based on historical data.
A)True
B)False
Q2) What is F in an ANOVA summary report?
A)Frequency
B)Falling rate
C)F ratio
D)Fallibility reading
Q3) The FORECAST.ETS function returns a confidence interval for a forecast at all future dates.
A)True
B)False
Q4) The ________ function returns a value's rank as a percent between 0% and 100%.
Q5) ________ is a measure of a dataset's dispersion or the difference between the highest and lowest values.
Q6) The ________ is the probability of a population being similarity to a sample.
Q7) The Greek letter mu is the symbol for standard deviation.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Multiple-Sheet Workbook Management
Available Study Resources on Quizplus for this Chatper
89 Verified Questions
89 Flashcards
Source URL: https://quizplus.com/quiz/31806
Sample Questions
Q1) ________ is the dependent cell with this formula in A10: =Sum(A2: A8)
Q2) ________ is the process of dividing a worksheet window into two or four resizable panes so you can view separate parts of a worksheet at the same time.
A)Synchronous Scrolling
B)Splitting
C)View Side by Side
D)Tiling
Q3) A(n)________ is a reference within a formula or function to a different worksheet.
Q4) If all worksheets are grouped,how do you ungroup them?
A)Click any tab.
B)Click Ungroup on the data tab.
C)Right click a sheet tab and select Ungroup Sheets.
D)Select any range of cells.
Q5) A Split Window has three panes by default
A)True
B)False
Q6) The return for =12/0 will be a(n)________ error.
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Imports, xml, and Power Add-Ins
Available Study Resources on Quizplus for this Chatper
88 Verified Questions
88 Flashcards
Source URL: https://quizplus.com/quiz/31807
Sample Questions
Q1) The ________ is the area that contains the dashboard in Power View.
Q2) Right-clicking in an XML area and selecting XML will start the import or refresh process.
A)True
B)False
Q3) What application could be used to create an XML document in its native file format?
A)Photoshop
B)Acrobat
C)iTunes
D)Notepad
Q4) Power Query is ________.
A)installed by default
B)enabled in Options
C)downloadable Excel add-in
D)on the Data tab
Q5) Embedded data has no the link to its original source.
A)True
B)False
Q6) ________are data fields and tables added to the Power View canvas.
Page 12
To view all questions and flashcards with answers, click on the resource link above.
Chapter 11: Collaboration and Workbook Distribution
Available Study Resources on Quizplus for this Chatper
87 Verified Questions
87 Flashcards
Source URL: https://quizplus.com/quiz/31808
Sample Questions
Q1) Documents can have only one author defined in the document properties.
A)True
B)False
Q2) The Quick Access Toolbar cannot be modified.
A)True
B)False
Q3) An Excel template has an .xlxb extension.
A)True
B)False
Q4) A cell that contains a comment is marked with a green triangle.
A)True
B)False
Q5) When a file is created,customizations such as the author's name are saved as ________.
Q6) A comment can be inserted to provide notes or feedback to other users of a workbook.
A)True B)False
Q7) The ________ checks a workbook for personal data.
Q8) ________ is the process of more than one person working together.
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 12: Templates, styles, and Macros
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/31809
Sample Questions
Q1) Start a custom function in a new ________.
Q2) Cell Styles are on the Page Layout tab.
A)True
B)False
Q3) How do you insert a button to run a macro in a worksheet?
A)Add a Form Control button that runs the macro
B)Use the Button Builder on the Code group
C)The button has to be inserted on the Quick Access Toolbar.
D)You must use VBA code to do this.
Q4) The Macro Recorder is on which two tabs?
A)Developer and Formulas
B)View and Insert
C)View and Developer
D)Developer and Insert
Q5) Which of the following is false about recording a macro?
A)Cell selections can be recorded as absolute references.
B)There is a pause button which allows you to remove mistakes as you record.
C)The recorder records everything you do.
D)It is a good idea to plan your steps and practice them before recording.
Q6) Functions are edited in the ________.
Page 14
To view all questions and flashcards with answers, click on the resource link above.
Chapter 13: Office 2016 Common Features
Available Study Resources on Quizplus for this Chatper
91 Verified Questions
91 Flashcards
Source URL: https://quizplus.com/quiz/31797
Sample Questions
Q1) A word usage error is underlined with a(n)________ wavy line.
Q2) The ________ identifies the current file name and the application in which you are working.
A)title bar
B)status bar
C)Quick Access Toolbar
D)Ribbon
Q3) You would use the ________ to temporarily hold selections that you have cut or copied.
Q4) When you ________ a selection,the selection is duplicated and the duplicate is placed in the Clipboard.
Q5) When using Microsoft Office,the default location for saving files is ________.
A)DropBox
B)OneDrive
C)Google Drive
D)iCloud
Q6) You can customize the Quick Access Tool bar.
A)True
B)False
Q7) The mouse shortcut for selecting a word is to ________ the word.
To view all questions and flashcards with answers, click on the resource link above. Page 15