Technology for Business Test Questions
Course Introduction
Technology for Business explores the crucial role of modern technology in shaping and driving business operations and strategies. This course examines key technological tools and systems such as information management, cloud computing, data analytics, cybersecurity, and digital communication platforms focusing on how they optimize efficiency, enhance decision-making, and foster innovation within organizations. Students will also analyze emerging trends and ethical considerations, gaining practical insights into how businesses leverage technology to maintain competitive advantages in a rapidly evolving digital 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) The worksheet is organized into individual cells.
A)True
B)False
Answer: True
Q2) In ____,the ribbon increases in height,the buttons are bigger,and more space appears around each button so you can more easily use your finger or a stylus to tap the button you need.
A)Touch Mode
B)Click Mode
C)Tap Mode
D)Normal Mode
Answer: A
Q3) Keyboard ____ can help you work faster and more efficiently because you can keep your hands on the keyboard.
A)KeyTips
B)ScreenTips
C)ShortTips
D)shortcuts
Answer: D
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) In Excel,to merge cells A1,B1,C1,D1,and E1,_____ is the correct reference for the merged cell.
A)A1!E1!
B)A1
C)E1
D)A1-E1
Answer: B
Q2) Because Excel stores dates and times as _____,you can apply different formats without affecting the date and time value.
A)numbers
B)text
C)universal numbers
D)Greenwich Mean Time
Answer: A
Q3) In the accompanying figure,the number 1 displays _____.
A)alignment buttons
B)centered text
C)indented text
D)borders above and below cell content
Answer: A
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) Goal Seek automates the trial-and-error process by allowing you to specify a value for a calculated item,which Excel uses to determine the input value needed to reach that goal._________________________
A)True
B)False
Answer: True
Q2) When a formula includes a cell reference,Excel interprets that cell reference as being located relative to the position of the \(\underline { \text { current } }\) cell._________________
A)True
B)False
Answer: True
Q3) The ____________________ organizes all of the functions by category and allows you to search for functions that perform particular calculations.
Answer: Insert Function dialog box
Q4) TODAY is an example of a(n)____________________ function.
Answer: date
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) In the figure above,the biggest slice is the cases of _______.
A)Riesling
B)Chardonnay
C)Pinot Grigio
D)Ruby Cabernet
Q2) Excel supports all of the following types of sparklines EXCEPT ____.
A)A win/loss sparkline for highlighting positive and negative values
B)A column sparkline used for column charts
C)A line sparkline for highlighting trends
D)a true/false sparkline for help making decisions
Q3) Referring to the figure above,the rectangular area to the right of the pie chart is the ____.
A)perspective
B)plot area
C)legend
D)data marker
Q4) Each value from a data series is represented by a ________.
Q5) A chart that combines two or more chart types into a single graph is called a(n)____________________ chart.
Page 6
Q6) An _______ chart takes up less space than a chart sheet.
To view all questions and flashcards with answers, click on the resource link above.
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 delete records that are incorrect,out of date,or no longer needed,select a cell in each record you want to delete,click the Delete button arrow in the Cells group on the ____ tab,and then click Delete Table Rows.
A)HOME
B)INSERT
C)VIEW
D)DATA
Q2) ____ order arranges labels in reverse alphabetical order,from A to Z
A)Reverse
B)Major
C)Ascending
D)Descending
Q3) The ____________________ criteria filter requires that the records displaying begin with the specified text string.
Q4) The fields you use to order your data are called sort ____.
A)values
B)fields
C)tags
D)tools
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) Click the button marked ____ in the accompanying figure to fix broken links.
A)Break Link
B)Update Values
C)Check Status
D)Change Source
Q2) Jared wants to create a hyperlink to a location in his current workbook.He clicks the Hyperlink button in the Links group on the INSERT tab.What option should he select from the Link to list?
A)Existing File
B)Place in This Document
C)Create New Document
D)E-mail Address
Q3) Formulas created using the point-and-click method contain ____ references.
A)absolute
B)mixed
C)relative
D)relational
Q4) After you have saved a template,you can access the template from the New screen in ____________________ view.
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
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21377
Sample Questions
Q1) Property that determines whether or not changes can be made to a 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
Q2) What are the steps for creating a validation rule?
Q3) A _____ can be destructive and can modify or delete files that may not be recoverable.
A)digital signature
B)macro virus
C)comment virus
D)micro virus
Q4) Describe the four macro security settings.
Q5) A digital ____________________ is typically issued by a certificate authority.
Page 9
To view all questions and flashcards with answers, click on the resource link above.
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 difference between two dates and shows the result in months,days,or years.
Q2) Two common categories of formula errors in Excel are syntax errors and logic errors.
A)True
B)False
Q3) Which of the following is an effective alternative for the use of extensive nested IF functions?
A)compare table
B)function table
C)lookup table
D)case table
Q4) To change the background fill color of duplicate values,in the _____ group on the HOME tab,click the Conditional Formatting button,and then click Manage Rules.
A)Format
B)Options
C)Styles
D)Tools
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) If active cell D12 contains the formula =D10+D11,cells D10 and D11 are _______ cells for D12.
A)feeder
B)dependent
C)precedent
D)formula
Q2) Calculates the amount of a loan payment used to pay off the interest
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
Q3) Does the NPV function in Excel correspond to the financial definition of net present value? Explain your answer.
Q4) The PMT value is also known as the ____________________ payment.
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) In two-variable tables,you must always place a reference to the result cell in the _______ corner of the table at the intersection of the row values and the column values.
A)upper-right
B)upper-left
C)lower-right
D)lower-left
Q2) 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
Q3) To select nonadjacent changing cells,press and hold the _______ key as you click each cell.
A)Alt
B)Shift
C)Esc
D)Ctrl
Q4) The item marked 2 in the accompanying figure is the scenario
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) A _______ delimiter is often the best way of separating text columns because text delimited this way can include spaces or commas within each column.
A)space
B)comma
C)tab
D)dash
Q2) The item marked 2 in the accompanying figure is the column or \(\underline { \text { record } }\) in a database table._________________________
A)True
B)False
Q3) The item marked 1 in the accompanying figure is the row or \(\underline {\text { field } }\) in a database table._________________________
A)True
B)False
Q4) A(n)____________________ is a collection of data arranged in rows and columns.
Q5) Each piece of data in an XML document is contained within a(n)____________________.
Q6) Data ____________________ can be databases,text files,or other Excel workbooks.
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) 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
Q2) A(n)\(\underline {\text { linked object }}\) is stored within the destination file and remains connected to the source file._________________________
A)True
B)False
Q3) A(n)\(\underline { \text { source } }\) file contains the object that is displayed in the destination file._________________________
A)True
B)False
Q4) Data ____________________ can be databases,text files,or other Excel workbooks.
Q5) The different versions of the workbook can be ____________________ so that the changes in the copies can be compared and conflicting edits can be resolved.
Q6) Describe the steps to review tracked changes in a shared workbook.
14
To view all questions and flashcards with answers, click on the resource link above.
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) top of the file hierarchy
A)backslash
B)Large icons
C)Clipboard
D)root directory
E)SkyDrive
F)extension
G)folder
H)archive
I)Details
J)library
Q2) The hard disk is assigned to drive ____.
A)A
B)C
C)D
D)F
Q3) Windows 8 automatically saves files after every update or change,so manually saving is no longer necessary.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 15