Technology in Business Practice Exam
Course Introduction
Technology in Business explores the pivotal role that digital innovation and information systems play in modern organizational operations and strategy. The course introduces students to core business technologies such as enterprise resource planning (ERP), customer relationship management (CRM) systems, data analytics, cloud computing, and e-commerce platforms. Emphasis is placed on understanding how such technologies drive efficiency, improve decision-making, and create competitive advantage. Through case studies and practical applications, students gain insights into emerging trends, ethical considerations, cybersecurity, and effective digital transformation strategies that shape the contemporary business landscape.
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) \(\underline { \text { Normal } }\) view shows how the worksheet will appear when printed._________________________
A)True
B)False
Answer: False
Q2) Keyboard ____________________ can help you work faster and more efficiently because you can keep your hands on the keyboard. Answer: shortcuts
Q3) In the figure above,Box 2 points to a formula in ____ multiplying the values in cells F13 and G13.
A)cell F13 B)cell H13., C)cell G13, D)cell H13.
Answer: B
Q4) ____________________ view shows how the worksheet will appear when printed.
Answer: Page Layout
Q5) Changing the page orientation affects only the ____________________ sheet. Answer: active
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
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21372
Sample Questions
Q1) To add a _____ to a sheet tab,right-click a sheet tab,point to Tab Color on the shortcut menu,and then click a color.
A)fill color
B)tab setting
C)format color
D)formatting style
Answer: A
Q2) A(n)____________________ is a selection of formatting options using a specific font and color from the current theme.
Answer: style
Q3) To set a page break in Excel,select the _____.
A)first cell below the row where you want to insert a page break
B)first cell above the row where you want to insert a page break
C)row above where you want to insert a page break
D)row below where you want to insert a page break
Answer: A
Q4) 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: 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) Indicate that some part of formula is preventing Excel from returning a calculated value.
A)NOW
B)error value
C)COUNTA
D)<
E)MEDIAN
F)Mon, Tues, Wed, Thurs, Fri
G)F4
H)absolute
I)nested
J)mixed
Answer: B
Q2) The ____ function returns the maximum value in the range.
A)TOP
B)FIRST
C)MAX
D)MOST
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) Excel supports ____________________ types of charts into 10 categories..
Q2) 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.
Q3) \(\underline { \text { Interest } }\) is the amount added to the principal by the lender._________________________
A)True
B)False
Q4) The ____ CHART TOOLS contextual tabs appear on the Ribbon when you select a chart.
A)INSERT and DESIGN
B)DESIGN and FORMAT
C)INSERT and FORMAT
D)FORMAT and PRINT
Q5) Each data source is a collection of ____________________,which is a range of values plotted as a single unit on a chart.
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) You have a lot of familiarity with ranges from an earlier Excel class,but you know that there is an alternative that will give you access to additional features that you do not have with a cell range.What is that option?
A)Convert the range to a table.
B)Convert the range to an index.
C)Convert the range to a PivotChart.
D)You are wrong; the range has as many features as any Excel alternative.
Q2) Every ____ consists of an object that contains a button for each unique value in that field.
A)piece
B)slicer
C)section
D)part
Q3) You can click the More Functions command on the Total arrow button list to open the ____ dialog box and select any available function.
A)Display Function
B)Insert Function
C)Add Function
D)New Function
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) In order to reference data located in one workbook in another workbook,you have to create a(n)\(\underline { \text { dialog } }\)between the two workbooks._________________________
A)True
B)False
Q2) A collection of two or more selected worksheets
A)3-D
B)template
C)A
D)source
E)destination
F)link
G)M
H)worksheet group
I)hyperlink
J)Tiled
Q3) ____________________ a worksheet duplicates all the values,formulas,and formats into the new worksheet,leaving the original worksheet intact.
Q4) ____________________ 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
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21377
Sample Questions
Q1) Each macro must have a unique name that begins with a letter.
A)True
B)False
Q2) Clicking the Edit button in the accompanying figure opens the New Name dialog box in which you can modify the selected defined name.
A)True
B)False
Q3) Appears when the cell becomes active and can be used to specify the type of data the user should enter in that cell
A)Stop
B)Warning
C)Information
D)locked
E)macro
F)VBA
G)defined name
H)input message
I)validation rule
J)digital certificate
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) You implement the VLOOKUP formula at your colleague's suggestion,but you get the #VALUE! error as the result of the formula.Which of the following is likely true?
A)You might have entered a table name for the table_array value instead of the cell reference of the lookup table.
B)You might have indicated that the compare values are a range of values instead of an exact match.
C)You might have entered a number for the col_index_num instead of a letter.
D)You might have entered a letter for the col_index_num instead of a number.
Q2) Adds the values in a range
A)SUMIF
B)VLOOKUP
C)COUNTIF
D)conditional formatting
E)DATEDIF
F)AVERAGE
G)HLOOKUP
H)TRANSPOSE
I)logical condition
J)SUM
To view all questions and flashcards with answers, click on the resource link above.
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) Use the XNPV and XIRR functions for cash flows that appear _______.
A)with a regular pattern
B)at unevenly spaced intervals
C)at evenly spaced intervals
D)to be cyclical
Q2) To calculate the annual rate,you must _______ the value returned by the RATE function by the number of payments per year.
A)add
B)subtract
C)multiply
D)divide
Q3) The _______ function returns the amount of a particular payment that is used to pay the interest on the loan.
A)PMT
B)IPMT
C)INPMT
D)NPMT
Q4) A(n)____________________ cash flow occurs whenever money is flowing into the account.
Q5) A(n)____________________ is also known as a profit and loss statement.
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) To perform a what-if analysis with more than two input cells,you _______.
A)hide all references
B)use only exchange values
C)apply additional constraints
D)create scenarios
Q2) The item marked 2 in the accompanying figure is the scenario ____________________.
Q3) _______ are important because they ensure a realistic solution to your problem.
A)Constraints
B)Parameters
C)Targets
D)Optimals
Q4) _______ analysis is an important business decision-making tool because it predicts the effect of cutting overhead or raising prices on net income.
A)CVP
B)MVP
C)EVP
D)AVP
Q5) ____________________ constraints always show a slack of 0.
Q6) What are the steps to create a one-variable data table?
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) Format that allows for text formatting styles including boldface,italic,and color
A)delimiter
B)database
C)record
D)field
E)table
F)query
G)criteria
H)common field
I)element
J)Rich Text
Q2) Data ____________________ can be databases,text files,or other Excel workbooks.
Q3) The _______ formatting option retrieves all simple as well as advanced HTML formatting features,including hyperlinks.
A)Full
B)Full HTML
C)Rich text
D)Default
Q4) A(n)____________________ is a collection of data arranged in rows and columns.
Page 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) In the accompanying figure,item _______ displays the location of the edit.
A)1
B)2
C)3
D)4
Q2) Database tables can be inserted directly into PivotCharts and ____________________.
Q3) Workbook viruses are often signaled by a hidden worksheet or hidden code attached to the \(\underline { \text { HTML } }\)code in the file._________________________
A)True
B)False
Q4) Describe the steps to review tracked changes in a shared workbook.
Q5) Now that Rebecca has saved her workbook in a secure area,she can share the workbook with others.To share the workbook,Rebecca will use the _______.
A)Share Workbook dialog box
B)Trust Center dialog box
C)Proofing dialog box
D)Comments dialog box
Q6) Data ____________________ can be databases,text files,or other Excel workbooks.
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) When working in any view besides Details view,you sort by using the ____________________ tab on the ribbon.
Q2) The ____________________ appears when you point to the upper-right or lower-right corner of the screen,and displays buttons for interacting with Windows 8 and accessing applications.
Q3) ____ is a Microsoft service that provides up to 7 GB of online storage space for your files at no charge.
A)Picasa
B)Flickr
C)SkyDrive
D)Mozilla
Q4) In most cases,a file deleted from a USB drive ____.
A)goes to the Recycle Bin
B)is deleted permanently
C)is moved to the C:/Users folder
D)is moved to the cloud
Q5) A duplicate copy of important files is known as a(n)____________________.
Q6) Extracting a file means to compress a file into an archive.
A)True
B)False
Page 15
To view all questions and flashcards with answers, click on the resource link above.