Business Information Systems
Exam Solutions
Course Introduction
Business Information Systems explores the role of information technology in modern organizations, focusing on how businesses design, implement, and utilize information systems to improve efficiency, decision-making, and competitiveness. Students gain an understanding of key concepts such as system development, database management, e-commerce, enterprise resource planning, and the strategic alignment of IT with business goals. Emphasis is placed on both technical and managerial aspects, including the ethical and security challenges associated with information systems in a rapidly evolving digital landscape.
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) When you copy a selection of cells using drag and drop,which appears before you release the mouse button?
A) an outline of the new location of the selected range
B) the range
C) a cell reference of the old location
D) shortcut tip
Answer: A
Q2) 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
Q3) The formula used to multiply cell A1 by cell C1 is ____.
A) =A1*C1
B) C1*A1
C) =A1/C1
D) A1*C1
Answer: A
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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43585
Sample Questions
Q1) A conditional format applies formatting to a cell when its value meets a specified condition._________________________
A)True
B)False
Answer: True
Q2) The ____________________ tab in the Format Cells dialog box in Excel provides options for creating and applying background colors and patterns to cells. Answer: Fill
Q3) Text and numbers are displayed vertically within cells._________________________
A)True
B)False
Answer: False
Q4) One of the benefits of conditional ____________________ is that it helps you analyze data by highlighting significant trends in data. Answer: formatting
Q5) To remove conditional formatting in Excel,click ____________________ after clicking the Conditional Formatting button. Answer: Clear Rules
To view all questions and flashcards with answers, click on the resource link above. Page 4
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) The numbers,text,or cell references used by the function to return a value are called
A) expressions
B) arguments
C) data
D) values
Answer: B
Q2) Ellen is expecting to get a 3% raise next year. She enters .03 in cell D2 so that she can predict her monthly income for the next year.What function key will make D2 an absolute reference?
A) F2
B) F4
C) F6
D) F1
Answer: B
Q3) A lookup table organizes numbers or text into categories._____________
A)True
B)False
Answer: True
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) A chart that combines two or more chart types into a single graph is called a(n)____________________ chart.
Q2) The FV function stands for ____.
A) function value
B) future value
C) financial value
D) formulated value
Q3) 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
Q4) You can quickly change the appearance of the entire chart by selecting a different chart style in the Chart Design gallery._________________________
A)True
B)False
Q5) The range of values,or ___________________,of an axis is based on the values in the data source.
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) You cannot change data directly in the PivotTable.Instead,you must edit the Excel table,and then ____,or update,the PivotTable to reflect the updated data.
A) reset
B) refresh
C) renew
D) change
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 ____ condition requires that all of the selected criteria be true for the record to be displayed.
A) Or
B) Nand
C) And
D) If
Q4) The entry 20000 is the ____________________ for the first condition.
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) Contains the information when two files are linked
A)3-D
B)hyperlink
C)worksheet group
D)source
E)destination
F)link
Q2) A(n)template is a workbook with labels,formats,and formulas already built into it with data removed._________________________
A)True
B)False
Q3) To ungroup worksheets,you can click a sheet ____ of a sheet not in the group.
A) index
B) panel
C) tab
D) pane
Q4) Using multiple worksheets makes it more difficult for you to group your data.
A)True
B)False
Q5) ____________________ 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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43590
Sample Questions
Q1) 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
Q2) You can turn off the macro recorder by clicking the Stop Recording button in the Code group on the _____ tab.
A) Insert
B) Developer
C) Layout
D) Macro
Q3) When you _____ a workbook,you control the ability users have to make changes to the file.
A) ensure
B) protect
C) secure
D) seal
Q4) 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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43591
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) On a lark,for a year-end trivia contest,your boss wants you to calculate the length of service in complete days.What is the correct formula?
A) =DATEDIF(C2, $AE$2, "today")
B) =DATEDIF($AE$2, C2, "dy")
C) =DATEDIF($AE$2, C2, "day")
D) =DATEDIF(C2, $AE$2, "d")
Q3) A(n)____________________ IF function is when one IF function is placed inside another IF function to test an additional condition.
Q4) When using VLOOKUP,the _____argument is optional.
A) lookup_value
B) table_array
C) range_lookup
D) col_index
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) Seymour tells Charles to search all of the error values until he reaches one that lacks something,and that is the source of the error values in the dependent cells.What does that error value lack?
A) contingencies
B) dependencies
C) antecedents
D) precedents
Q2) At higher rates of return,the net present value of the investment goes up._________________________
A)True
B)False
Q3) Describe the steps to interpolate a series of values between starting and ending values.
Q4) The fv argument is required in the PMT function.
A)True
B)False
Q5) If you don't include a pv value,Excel assumes a future value of 1._________________________
A)True
B)False
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) {=SUM(B1:B10*C1:C10)} is an example of a(n)_______.
A) array formula
B) TABLE function
C) scenario
D) input value
Q2) Once you enter an array formula,Excel will enclose the formula in a set of _______.
A) parentheses
B) curly braces
C) brackets
D) quotation marks
Q3) A(n)mixed expense is an expense that is part variable and part fixed._________________________
A)True
B)False
Q4) A(n)_______ is a limit that is placed on a Solver problem's solution.
A) max
B) target
C) constraint
D) adjustment
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) A question you ask about the data in a database
A)delimiter
B)database
C)record
D)field
E)table
F)query
G)common field
Q2) Power Map data is placed in tables,which are superimposed on the map.
A)True
B)False
Q3) Excel can save a workbook as a text file,preserving only the data values,without any of the formats applied to it.
A)True
B)False
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) Where in the Excel Options dialog box would Chloe find the setting to turn off AutoComplete for cell values?
A) Advanced options, Display section
B) Advanced options, Editing options section
C) Save options
D) Formulas options
Q2) The contents of the _______ log can be reviewed either in the form of comments attached to the edited cells,or within a list displayed in a separate worksheet.
A) tracking
B) recording
C) mapping
D) documenting
Q3) Shared workbooks are usually stored in shared folders located on either a local network or the _______.
A) sky
B) cloud
C) external drive
D) satellite
Q4) Describe the steps to review tracked changes in a shared workbook.
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) The PROPER function replaces existing text with new text.
A)True
B)False
Q2) Compatibility Mode keeps the workbook in the older file format with the .xsl file extension.
A)True
B)False
Q3) The Trim function removes all characters from a string except for single spaces between words.
A)True
B)False
Q4) The UPPER function converts all letters of each word in a text string to uppercase.
A)True
B)False
Q5) Text can contain:
A) Uppercase only
B) Lowercase only
C) Upper and lowercase
D) Numbers only
To view all questions and flashcards with answers, click on the resource link above. Page 15