Business Computer Applications
Final Exam
Course Introduction
Business Computer Applications is a foundational course designed to introduce students to essential computer technologies and software used in modern business environments. The course covers the practical use of word processing, spreadsheet analysis, database management, and presentation software, emphasizing their integration to solve real-world business problems efficiently. Students will develop hands-on skills in Microsoft Office Suite (Word, Excel, PowerPoint, and Access) and explore internet research strategies, email communication, and collaborative tools. By the end of the course, students will be equipped with the digital competency required for effective communication, data management, and decision-making in a professional business setting.
Recommended Textbook
New Perspectives on Microsoft Excel 2010 Comprehensive 1st Edition by June
Available Study Resources on Quizplus 14 Chapters
2100 Verified Questions
2100 Flashcards
Source URL: https://quizplus.com/study-set/1597 Page 2
Jamrich Parsons
Chapter 1: Getting Started With Excel
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31705
Sample Questions
Q1) The cell reference for the active cell appears in the ____________________ located in the upper-left corner of the worksheet.
Answer: Name Box
Q2) To change a column width,you can click ____ on the Column submenu to make the column(s)as wide as the longest entry of the cells in the column.
A) QuickFit
B) AutoFit
C) FullColumn
D) Longest
Answer: B
Q3) The AutoComplete feature automatically completes an entry based on previous entries in a column.
A)True
B)False
Answer: True
Q4) Referring to the figure above,the Zoom control is set at 100%.
A)True
B)False Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Formatting a Workbook
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31706
Sample Questions
Q1) A ____________________ formats the entire table as a single unit. Answer: table style
Q2) If contents do not fit across the Excel page,change the orientation to Portrait orientation._________________________
A)True
B)False
Answer: False
Q3) Background images do not print in Excel.
A)True
B)False
Answer: True
Q4) A ____________________ is a collection of formatting that specifies the fonts,colors,and graphical effects used throughout the workbook. Answer: theme
Q5) Formatting changes only the appearance of data - it does not affect the data itself. A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Working With Formulas and Functions
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31707
Sample Questions
Q1) The FV function stands for ____.
A) function value
B) future value
C) financial value
D) formulated value
Answer: B
Q2) Which function is used to change 3,162.50 to 3,163? ____
A) RAND
B) ROUND
C) DROP
D) ROUNDUP
Answer: B
Q3) The Function Library is a group on the Ribbon.
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: Enhancing a Workbook With Charts and Graphs
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31708
Sample Questions
Q1) If you select a chart's series and look at the formula bar,the formula being displayed uses the ____ function.
A) CHART
B) DATA
C) RANGE
D) SERIES
Q2) On a 3-D chart,the ____ represents the object's depth.
A) x-axis
B) y-axis
C) z-axis
D) none of the above
Q3) When data bars are used with negative values,the date bars originate from the center of the cell with negative bars extending to the left and positive bars extending to the right.
A)True
B)False
Q4) In cases where a label placed outside a pie might appear farther from its slice than is easily readable,a(n)____________________ might be added to connect the data to its corresponding slices.
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Working With Excel Tables, Pivot-tables, and Pivot-charts
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31709
Sample Questions
Q1) A dark,horizontal line appears ____ the column headers to indicate which row is frozen.
A) above
B) below
C) both a.and b.
D) neither a.nor b.
Q2) With the Last Quarter criteria filter,quarters are defined as,for example,____.
A) April,May,June
B) March,April,May
C) May,June,July
D) March,April,May,June
Q3) What are the steps for sorting data using multiple fields?
Q4) PivotTable data can be a(n)____.
A) an Access database file
B) an Excel table in the current workbook
C) an Excel range in the current workbook
D) any of the above
Q5) What is a PivotTable? Describe its use in Excel,including the definition of value fields and category fields.
Q6) What are the guidelines for creating an effective structured range of data? Page 7
To view all questions and flashcards with answers, click on the resource link above.
Page 8
Chapter 6: Managing Multiple Worksheets and Workbooks
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31710
Sample Questions
Q1) When creating and saving a custom template,you may find it helpful to replace variable data values with ____________________,which will help you recognize the cells in which to enter new data.
Q2) ____ are usually represented by colored words with underlines or images.
A) Indices
B) Hyperlinks
C) Templates
D) Icons
Q3) A link is a connection between two ____ allowing information to be transferred from one to the other.
A) cells
B) ranges
C) columns
D) files
Q4) You can view,but cannot edit,workbooks in the Excel Web App.
A)True
B)False
Q5) In the figure above,cell A8 contains a hyperlink._________________________
A)True
B)False
9
To view all questions and flashcards with answers, click on the resource link above.
Chapter 7: Using Advanced Functions and Conditional Formatting
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31711
Sample Questions
Q1) The following formula is used to determine Dean's List status.Assuming that B1 contains 12 and B2 contains 3.25,then =AND(B1>=12,B2>3.25),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
Q2) The table that stores the data you want to retrieve is called a lookup table,and it organizes the data you want to retrieve into different ____,such as by product ID.
A) tabs
B) categories
C) cells
D) properties
Q3) The ____ function calculates the difference between two dates and shows the result in months,days,or years.
A) nested IF
B) CALIF
C) DATEDIF
D) DATE
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 8: Developing an Excel Application
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31712
Sample Questions
Q1) Now it's a year later and Joe is taking coursework to become a VBA programmer.He is working on developing an application that contains macros.Which 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
Q2) Every cell in a workbook has a(n)____ property that determines whether or not changes can be made to that cell.
A) ensured
B) locked
C) security
D) changeable
Q3) You can allow users to insert new rows or columns into a sheet,even if the sheet is protected.
A)True
B)False
Q4) In the Allow list box in the Data Validation dialog box,the ____________________ option means that the cell will accept any value entered into the cell.
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 9: Working With Financial Tools and Functions
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31713
Sample Questions
Q1) To calculate a declining balance depreciation,use the DVB function.
A)True
B)False
Q2) After you select a cell with an error indicator,you can click the Error Alert ____ to display additional information about the possible error and determine if further action is needed.
A) button
B) icon
C) ScreenTip
D) menu
Q3) To calculate a series of values from a starting point without a defined ending point,you have to ____ the values.
A) interpolate
B) extrapolate
C) asses
D) plot
Q4) At higher rates of return,the net present value of the investment goes up._________________________
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 10: Performing What-If Analyses
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31714
Sample Questions
Q1) Increasing the price of an object by 10% decreases demand by 20%.This is an example of what kind of elasticity,according to your tutor?
A) Relatively inelastic
B) Perfectly inelastic
C) Relatively elastic
D) Perfectly elastic
Q2) Aside from Solver,other Excel ____ provide the ability to perform statistical analyses,generate business reports,and retrieve financial data from the Internet.
A) parameters
B) add-ins
C) helper applications
D) constraint applications
Q3) When using Goal Seek,select the ____ cell in the Set cell box,and then specify its value (goal)in the To value box.
A) changing
B) result
C) input
D) value
To view all questions and flashcards with answers, click on the resource link above.
13
Chapter 11: Connecting to External Data
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31715
Sample Questions
Q1) In order to override Excel so that it always enables data sources and refreshes the connection to the source without prompting,you should define the location of the data sources as ____.
A) new locations
B) trusted sites
C) trusted locations
D) enabled locations
Q2) The Text Import Wizard's attempt to define the number and location of columns is always correct.
A)True
B)False
Q3) When you want to look only at specific information from a database,you create a(n)____.
A) index
B) matrix
C) register
D) query
Q4) A(n)____________________ file contains only text and numbers without any formulas,special fonts,graphics,or formatted text.
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 12: Expanding Excel With Visual Basic for Applications
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31716
Sample Questions
Q1) To hide a macro's actions as it runs,insert the command Application.ScreenUpdating = ____________________ at the beginning of the sub procedure.
A)True
B)False
Q2) The macro recorder writes the most efficient code and records only those commands and actions you want in the finished project.
A)True
B)False
Q3) What would you tell Rebecca to use if she wants to refer to a workbook that is named "Hilton Hotels"?
A) Workbooks("Hilton Hotels")
B) Excel("Hilton Hotels")
C) Book("Hilton Hotels")
D) Worksheets("Hilton Hotels")
Q4) What are the seven comparison operators in VBA?
Q5) VBA is a(n)object-linked programming language._________________________
A)True
B)False
Q6) It is a good coding practice to write code in ____________________ text. Page 15
To view all questions and flashcards with answers, click on the resource link above.
Page 16
Chapter 13: Managing Your Files
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31703
Sample Questions
Q1) When you ____ a file in a folder window,Windows starts the appropriate program and opens the file.
A) hover over
B) right-click
C) click
D) double-click
Q2) Folders contained within other folders are called ____________________.
Q3) To use keyboard shortcuts to move files,click the file you want to move,press ____ to cut the file,navigate to a new location,and then press Ctrl+V to paste the file.
A) Ctrl+T
B) Ctrl+X
C) Ctrl+C
D) Ctrl+P
Q4) When you ____ a file,you create an uncompressed copy of the file in a folder you specify
A) batch
B) extract
C) expand
D) zip
To view all questions and flashcards with answers, click on the resource link above. Page 17
Chapter 14: Getting Started With Microsoft Office 2010
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31704
Sample Questions
Q1) Filenames can include a maximum of 128 characters._________________________
A)True
B)False
Q2) ____ buttons appear on the right side of a program window's title bar.
A) Ribbon
B) Zooming
C) Sizing
D) Orientation
Q3) You select settings in a dialog box using option buttons,check boxes,____________________,and lists to specify how you want to perform a task.
Q4) You use the Shutdown command to exit a program and close an open file in one step.
A)True
B)False
Q5) You can close a file by clicking Close in Backstage view._________________________
A)True
B)False
Q6) You find the Save As command in the ____________________ bar of Backstage view.
Q7) Microsoft Excel is often called a(n)____________________ program. Page 18
To view all questions and flashcards with answers, click on the resource link above.
Page 19