Business Computing
Exam Materials
Course Introduction
Business Computing explores the application of information technology within business environments, focusing on how computer systems and software solutions can be leveraged to improve business processes, decision-making, and overall organizational efficiency. Students will learn to analyze business needs, design and implement information systems, and utilize tools such as spreadsheets, databases, and enterprise applications. The course emphasizes practical skills in integrating technology with business operations, addressing current trends, challenges, and ethical considerations in the business computing 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 active cell is highlighted with a thick green border,its cell reference appears in the ____________________,and the corresponding column and row headings are highlighted.
Answer: Name Box
Q2) Every function follows a set of rules,or \(\underline { \text { syntax } }\),which specifies how the function should be written._________________________
A)True
B)False
Answer: True
Q3) Whenever you click the Save button on the Quick Access Toolbar or press the ____ keys,the workbook file is updated to reflect the latest content.
A)Ctrl + V
B)Ctrl + G
C)Ctrl + C
D)Ctrl + S
Answer: D
Q4) ____________________ enters text based on patterns it finds in the data.
Answer: Flash Fill
To view all questions and flashcards with answers, click on the resource link above.
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) The ____________________ tab in the Format Cells dialog box in Excel provides options for how data is aligned within a cell.
Answer: Alignment
Q2) 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
Q3) One of the benefits of conditional ____________________ is that it helps you analyze data by highlighting significant trends in data.
Answer: formatting
Q4) In the accompanying figure,the _____ indicates the font is 11pt.
A)Font arrow
B)Font size box
C)Font color
D)Font graphic
Answer: B
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) ____ arguments may provide more control over the returned value.
A)Relative
B)Required
C)Optional
D)Absolute
Answer: C
Q2) In the formula =IF(A1=B1,C1,C2),the result will be C2 if ____.
A)A is equal to B
B)A does not equal B
C)A1+B1 is equal to C1
D)A1>B1 is equal to C2
Answer: B
Q3) Using AutoFill,what would be the extended series of the initial entry Jan? ___
A)uary
B)Feb, Mar, Apr
C)Kan, Lan, Man, Nan
D)Jan1, Jan2, Jan3,
Answer: B
Q4) The ____________________ is the middle value from a sample.
Answer: median
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) It's difficult to read the exact scale on some of Simon's data.Adding ____ would make it easier to read.
A)a legend
B)major tick marks
C)colors
D)more numbers
Q2) ____provide descriptive text for the individual data markers,such as pie slices
A)Asset labels
B)Legend values
C)Data labels
D)Leader lines
Q3) You can choose Center,Inside End,Outside End,or Best Fit for the data label positions in the in the ____ pane.
A)Format Data Labels
B)Format Legend
C)Format Chart Area
D)Format Axis
Q4) To compare values from several categories with a sequential order,such as dates and times occurring at evenly spaced intervals,you would use a(n)____________________ 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) A(n)____________________ list indicates the sequence in which you want data ordered.
Q2) On the far right,in the figure above,there is the PivotTable field list.The items listed there,such as "Day" and "Segment" are ____ in the table.
A)columns
B)rows
C)chart data labels
D)field values
Q3) Each column in a range represents a(n)____________________ that describes some attribute or characteristic of a person,place,or thing.
Q4) To get to the screen shown in the figure above,you would click the INSERT tab on the Ribbon,and then,in the ____ group,click the PivotTable button.
A)Tables
B)PivotTables
C)Tools
D)Data
Q5) When you want to see all the data in a filtered table,you can ____________________,or remove,the filters.
Page 7
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
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21376
Sample Questions
Q1) After Brook has helped Simon to resolve his original problem,Simon asks her about another linked workbook he has received.The source files for this workbook have not been included,but Simon would like to use the workbook with the most recent values from the source files.What should Brooke tell him?
A)He can open the workbook and click the Continue button in the Edit Links dialog box.
B)He can open the workbook and click the Break button in the Edit Links dialog box.
C)He can open the workbook and click the Change Source button in the Edit Links dialog box.
D)He will not be able to use the workbook until he obtains copies of the source files.
Q2) Click the button marked ____ in the accompanying figure to replace the link to a source file with the current values for the linked cells.
A)Break Link
B)Update Values
C)Check Status
D)Change Source
Q3) ____________________ 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) Protecting the ____________________ of a workbook prohibits users from moving,resizing,closing,or hiding parts of the Excel window.
Q2) After the comments,in VBA code the next item is the _____ of the macro.
A)module
B)body
C)procedure
D)command
Q3) As Ted gets more comfortable with Excel,he thinks that he might be able to decide whether or not to run a macro on a case-by-case basis.What should his option be in the Trust Center?
A)Disable all macros without notification
B)Cancel all macros
C)Disable all macros with notification
D)Disable all macros except digitally signed macros
Q4) Usually,you will want to protect a worksheet but leave some cells _____.
A)open
B)empty
C)clear
D)unlocked
Q5) What are the steps for creating a validation rule?
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) The ____________________ function is a logical function that returns a TRUE value if any of the logical conditions are true and a FALSE value if the logical conditions are false.
Q2) Assuming that B1 contains 15 and B2 contains 3.5,then _______.
A)the formula indicates that the student is on the Dean's List B)the formula indicates that the student is NOT on the Dean's List
C)the formula returns a value of 0
D)the formula returns an error message
Q3) If any logical condition listed in the function is true,the \(\underline{\text { AND }}\) function returns a TRUE value._________________________
A)True
B)False
Q4) The major difference between HLOOKUP and VLOOKUP functions is the way the lookup tables are _____.
A)named
B)organized
C)saved
D)opened
Q5) What are the guidelines to keep in mind when creating fields in an Excel table?
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) The ____________________ function calculates the number of payment periods in an investment or loan.
Q2) As shown in the accompanying figure,in a(n)_______ trend,the values do not change by a constant amount.
A)periodic
B)growth
C)orthogonal
D)linear
Q3) A(n)____________________ cash flow occurs whenever money is flowing out of the account.
Q4) Most Excel financial functions require a particular _______ to the cash flow to return the correct value.
A)index
B)valence
C)orientation
D)direction
Q5) The financial definition of ____________________ is the difference between the present value of future cash flows and the current cost of the initial investment.
Q6) 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) A(n)____________________ expense is an expense that must be paid regardless of sales volume.
Q2) The item marked 2 in the accompanying figure is the _______ point.
A)variable
B)fixed
C)break-even
D)absolute
Q3) Click the Scenario PivotTable ____________________ option button to create a PivotTable describing the scenarios.
Q4) To activate Solver,click Solver Add-In in the _______.
A)Add-Ins dialog box
B)Solver dialog box
C)Analysis group
D)Data Tools group
Q5) What are the steps to create a one-variable data table?
Q6) The default convergence value in Solver is _______.
12
To view all questions and flashcards with answers, click on the resource link above.
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) After opening a workbook,Audra wants to update all of the external data ranges in the workbook.What button should she click in the Connections group on the DATA tab?
A)Refresh
B)Refresh All
C)Update
D)Update All
Q2) In addition to specifying the format of data using the Text Import Wizard,you can also indicate which columns you want to import.
A)True
B)False
Q3) The general form of a URL for a file located on your computer will be _______.
A)file:///drive:/path/filename
B)file://drive://path/filename
C)file://drive:/path//filename
D)file:///drive:///path///filename
Q4) A database is divided into separate tables.
A)True
B)False
Q5) A(n)____________________ is a collection of data arranged in rows and columns.
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) A question you ask about the data in a database
A)delimiter
B)database
C)record
D)field
E)table
F)query
G)criteria
H)common field
I)element
J)Rich Text
Q2) 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
Q3) To determine whether a workbook contains sensitive or personal information,you use the ____________________ to search the workbook to locate data and text that you may want removed.
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) a container for files
A)backslash
B)Large icons
C)Clipboard
D)root directory
E)SkyDrive
F)extension
G)folder
H)archive
I)Details
J)library
Q2) An example of sorting in ascending order is ____.
A)Z to A
B)9 to 0
C)latest to earliest date
D)A to Z
Q3) When you move a folder,you also move all of the files contained in the folder.
A)True
B)False
Q4) Describe some of the text's best practices for determining where to save files.
To view all questions and flashcards with answers, click on the resource link above. Page 15