Business Information Systems
Pre-Test Questions
Course Introduction
Business Information Systems explores the integration of information technology with business operations, focusing on how organizations use computer-based systems to support decision-making, improve efficiency, and gain a competitive advantage. Students will study the fundamentals of information systems, database management, system development processes, and the role of technologies such as enterprise resource planning (ERP) and e-commerce. The course emphasizes real-world applications of IT in areas such as marketing, finance, and supply chain management, preparing students to analyze, design, and implement effective business solutions 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) Which of the following takes precedence over multiplication?
A) division
B) exponentiation
C) addition
D) subtraction
Answer: B
Q2) A(n)____________________ includes a series of questions that help you think about the purpose of the workbook and how to achieve your desired results.
Answer: planning analysis sheet
Q3) ____________________ removes the data from the row or column as well as removes the row or column itself.
Answer: Deleting
Q4) Every function follows a set of rules,or syntax,which specifies how the function should be written._________________________
A)True
B)False
Answer: True
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) In a workbook's theme,_____ colors are designated for text and background,_____ colors are used for accents and highlights,and _____ colors are used for hyperlinks.
A) Four, two, six
B) Two, four, six
C) Four, six, two
D) Six, four, two
Answer: C
Q2) Formatting changes only the appearance of data-it does not affect the data itself._________________________
A)True
B)False
Answer: True
Q3) Options to rotate cells in Excel are available using the _____ button in the Alignment group on the Home tab.
A) Format
B) Orientation
C) Sorter
D) Alignment
Answer: B
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) Which of the following is a Statistical function? _____
A) INT
B) RAND
C) ROUND
D) AVERAGE
Answer: D
Q2) A logical function is a function that works with values that are either ____.
A) right or wrong
B) absolute or relative
C) positive or negative
D) true or false
Answer: D
Q3) When a formula includes a cell reference,Excel interprets that cell reference as being located relative to the position of the current cell._________________
A)True
B)False
Answer: True
Q4) A(n)____________________ reference contains both relative and absolute references.
Answer: mixed
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) Mya has decided she needs to move her chart so that it appears below her data source. Before she can move or resize her chart she must ______.
A) select the chart
B) hold down the SHIFT key
C) adjust the sizing handles
D) move the mouse pointer to the center of the chart.
Q2) 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
Q3) To resize an embedded chart,____.
A) select the chart and drag the corner sizing handle of the selection box
B) right click the chart and then click Resize on the shortcut menu
C) select the chart and press Tab
D) both a and b
Q4) By default,Excel inserts a chart as an embedded chart._________________________
A)True
B)False
Q5) An _______ chart takes up less space than a chart sheet.
Page 6
To view all questions and flashcards with answers, click on the resource link above.
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) The first sort field in a sort is called the major sort field.____________________
A)True
B)False
Q2) The ____________________ command automatically inserts a subtotal line into the range for each group of data.
Q3) A table name cannot include ____.
A) numbers
B) spaces
C) underscores
D) letters
Q4) You select the ____ option button in the Custom AutoFilter dialog box if you want to display rows that meet both of two criteria.
A) Or
B) Both
C) And
D) Either
Q5) A(n)____________________ list indicates the sequence in which you want data ordered.
To view all questions and flashcards with answers, click on the resource link above.
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) A connection between two files allowing information to be transferred from one file to the other
A)3-D
B)hyperlink
C)worksheet group
D)source
E)destination
F)link
Q2) Receives the information when two files are linked
A)3-D
B)hyperlink
C)worksheet group
D)source
E)destination
F)link
Q3) In order to reference data located in one workbook in another workbook,you have to create a(n)dialog between the two workbooks._________________________
A)True
B)False
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) When you _____ a workbook,you control the ability users have to make changes to the file.
A) ensure
B) protect
C) secure
D) seal
Q2) A digital ____________________ is often used to identify the author of a workbook that contains macros.
Q3) Input messages appear as ____________________ next to the active cell.
Q4) As Ted does more even work in Excel,he has begun to develop a collection of publishers whom he trusts to deliver macros that are problem-free.What should his option be in the Trust Center?
A) Enable all trusted macros
B) Enable all macros
C) Disable all macros except digitally signed macros
D) Disable a macro with notification
Q5) Validation rules come into play only during data entry.
A)True
B)False
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) If you edit a cell in a calculated column so it is no longer consistent with the other formulas in the column,a _____ appears in the upper-left corner of the cell.
A) red circle
B) blue square
C) red square
D) green triangle
Q2) The _____ function calculates the average of values in a range that match criteria you specify.
A) AVERAGEAS
B) AVERAGEOR
C) AVERAGEAND
D) AVERAGEIF
Q3) For a separate service recognition program,you need to calculate the length of service in complete years.What is the correct formula?
A) =DATEDIF(C2, $AE$2, "yr")
B) =DATEDIF($AE$2, C2, "year")
C) =DATEDIF($AE$2, C2, "yr")
D) =DATEDIF(C2, $AE$2, "y")
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) Calculates the amount of a loan payment applied to the principal
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
Q2) In a(n)_______ trend,the values change by a constant amount.
A) linear
B) growth
C) periodic
D) orthogonal
Q3) The function DDB is used to calculate a(n)declining balance depreciation._________________________
A)True
B)False
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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43593
Sample Questions
Q1) In traditional what-if analysis,you change result values in worksheet cells._________________________
A)True
B)False
Q2) A scenario summary report's _______ layout makes it simpler to compare the results of each scenario,and the automatic formatting makes it useful for reports and meetings.
A) portrait
B) tabular
C) row-based
D) columnar
Q3) An array argument performs multiple calculations on one or more sets of values and then returns either a single value or multiple values._________________________
A)True
B)False
Q4) The result cells are the cells containing the values you want to examine._________________________
A)True
B)False
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) The connection between a workbook and a data source can be lost when one or the other is moved to a new location.
A)True
B)False
Q2) One advantage of forecast sheets is that they can be used to analyze annual data in which the values follow a periodic pattern throughout the calendar year.
A)True B)False
Q3) 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)common field
Q4) Power Map data is placed in tables,which are superimposed on the map.
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) The wide collection of file hosting sites that allow document sharing supported by the Internet include _______.
A) Symphony
B) Google Docs
C) Sortbox
D) FaceDocs
Q2) A file format developed by Adobe Systems for displaying formatted documents containing text,graphics,and complicated layouts
A)linked object
B)embedding object
C)PDF (Portable Document Format)
D)Standard properties
E)Custom properties
F)Object linking and embedding (OLE)
G)Encryption
H)digital certificate
I)certificate authority (CA)
J)source file
K)shared workbook
Q3) 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) Which of the following is not one of the four commonly used formats?
A) Zip code
B) Phone number
C) Social Security
D) Birth date
Q2) Custom formats use _______ codes ,which are a series of symbols.
A) Custom
B) Format
C) Text
D) None of the above
Q3) To help users edit and correct the text values in their workbooks,Excel provides _____ functions.
A) Text
B) Proof
C) Design
D) Symbol
Q4) The four most commonly used formats are called special formats.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 15