Computer Applications in Business
Final Exam
Course Introduction
Computer Applications in Business explores the fundamental role of computer technologies in modern business environments. The course covers essential software applications such as word processing, spreadsheets, databases, and presentations, emphasizing their practical uses in solving business problems, managing information, and supporting decision-making processes. Students will also gain an understanding of internet technologies, e-commerce tools, and cloud-based solutions, along with the ethical and security considerations relevant to digital business operations. Through hands-on exercises and real-world case studies, students develop the practical skills necessary to effectively leverage technology in various business functions.
Recommended Textbook
Succeeding in Business with Microsoft Excel 2013 by Frank Akaiwa
Available Study Resources on Quizplus
10 Chapters
1500 Verified Questions
1500 Flashcards
Source URL: https://quizplus.com/study-set/709 Page 2
Chapter 1: Applying Fundamental Excel Skills and Tools in Problem Solving
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/13819
Sample Questions
Q1) Some of the most common formatting options available in the Format Cells dialog box are also available on the HOME tab and on the Mini toolbar.
A)True
B)False
Answer: True
Q2) A function is always structured beginning with the function address and an opening parenthesis mark. _________________________
A)True
B)False
Answer: False
Q3) The ____ Style button formats numbers as percentages, displayed to the nearest percent, with no decimal places.
A) Currency
B) Comma
C) Percent
D) all of the above
Answer: C
Q4) A(n) ____________________ in Excel always begins with an equal sign (=).
Answer: formula
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Solving Problems with Statistical Analysis Tools
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/13820
Sample Questions
Q1) The ____ symbol(s) indicate(s) the location where text should be inserted in cells formatted with a custom format.
A) ,
B) *
C) ""
D) @
Answer: D
Q2) To specify that a value should be precisely stored to the nearest hundredth, use the ____________________ function.
Answer: ROUND Round round
Q3) The Paste option button option called ____ pastes the formulas and formatting from the original cell(s), but not the format of the cell borders.
A) Keep Source Formatting
B) No Borders
C) Document Theme
D) Destination Formatting
Answer: B
To view all questions and flashcards with answers, click on the resource link above.
Page 4
Chapter 3: Determining Effective Data Display with Charts
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/13821
Sample Questions
Q1) The values in a bubble chart type are indicated by the distance from a center point.
A)True
B)False
Answer: False
Q2) The ____ is the descriptive text that identifies the chart's contents.
A) chart title
B) chart legend
C) x-axis label
D) y-axis label
Answer: A
Q3) A management console shows a visual summary of various performance data that a company's managers use on a regular basis. _________________________
A)True
B)False
Answer: False
Q4) The groundbreaking book by Edward R. ____________________, The Visual Display of Quantitative Information, gave advice such as "Above all else show the data."
Answer: Tufte
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Applying Logic in Decision Making
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/13822
Sample Questions
Q1) Relational expressions begin with a(n) ____.
A) equal sign
B) quotation mark
C) question mark
D) parenthesis
Q2) By nesting levels of ____ functions, multiple sets of criteria can be sequentially analyzed until a final value is returned.
A) IF
B) AND C) OR
D) NOT
Q3) Note that a(n) ____ construct always has a positive condition to be evaluated AND a negative condition to be evaluated.
A) only
B) not C) or D) and
Q4) Note that an only construct always has a positive condition to be evaluated and a(n) ____________________ condition to be evaluated.
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Retrieving Data for Computation, Analysis, and Reference
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/13823
Sample Questions
Q1) The ____ function is designed to return the relative position (such as 1, 2, or 3) of an item in a list.
A) MATCH
B) RELATIVE
C) POSITION
D) LIST
Q2) In a(n) ____ table, Excel searches one dimension, such as the columns, and then searches another dimension, such as the rows, to find the value at the intersection of a single row and column.
A) one-dimensional
B) two-dimensional
C) three-dimensional D) none of the above
Q3) In a(n) ____ table, Excel can search a row or column to find key data, and then use that data to locate the correct value.
A) one-dimensional
B) two-dimensional
C) three-dimensional D) none of the above
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Evaluating the Financial Impact of Loans and Investments
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/13824
Sample Questions
Q1) The syntax of the FV function is =FV(rate,nper,pmt,[pv],[type]).
A)True
B)False
Q2) In the SLN function, the _____ argument is the value at the end of depreciation.
A) end
B) life
C) salvage
D) sell
Q3) The function =-ROUND(Taxrate*C16,0) will round taxes to the nearest ____.
A) dollar
B) dime
C) penny
D) none of the above
Q4) The payback period is the time it will take to ____.
A) pay the loan back
B) earn sufficient profits so that the loan can be paid back
C) depreciate an item
D) none of the above
Page 8
Q5) The RATE function syntax is as follows: =RATE(nper,pmt,pv,fv,____________________,[guess]).
To view all questions and flashcards with answers, click on the resource link above.
Chapter 7: Organizing Data for Effective Analysis
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/13825
Sample Questions
Q1) When you add a schema to a workbook, Excel generates an ____ to create mapped ranges of data, and define the relationships between these ranges and the elements in the XML schema.
A) XML map
B) XML diagram
C) XML linked table
D) XML flow chart
Q2) A PivotChart report represents source data as a(n) graphic.
A)True
B)False
Q3) The CONCATENATE function combines the values in a range of cells into ____ in a new cell.
A) one text item
B) one numeric item
C) multiple text items
D) multiple numeric items
Q4) Many DBMSs are called ____________________ database management systems because the data is stored in tables that are related to each other through a common field in a process called normalization.
Page 9
To view all questions and flashcards with answers, click on the resource link above.
Chapter 8: Using Data Tables and Excel Scenarios for What
If Analysis
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/13826
Sample Questions
Q1) As one of the final steps of creating a scenario, you create the scenario by naming it and then entering ____ into the Scenario Manager.
A) data
B) file names
C) worksheet names
D) formulas
Q2) You use the Simulation Manager to define and save sets of values as scenarios, and then you view and change them as necessary to produce and compare different results.
A)True
B)False
Q3) Gabriel plans to use the Scenario Manager to add a scenario. He opens the Scenario Manager by clicking the DATA tab on the ribbon, and then clicking the ____.
A) What-If analysis button in the Data Tools group
B) Scenario Manager button in the Data Tools group
C) What-If analysis button in the Scenario Manager group
D) Scenario Manager button in the Scenario Manager group
Q4) The Scenario Manager refers to input cells as ____________________ cells.
Page 10
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Enhancing Decision Making with Solver
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/13827
Sample Questions
Q1) Ava is ready to fill in the By Changing Variable Cells box. She would choose the cells containing the ____.
A) minimum number of onyx and topaz pendants to produce
B) range representing the number of onyx and topaz pendants produced
C) unit cost for both the onyx and topaz pendants
D) total cost to produce each pendant
Q2) When solving problems with nonlinear objective functions, you must enter a variety of starting points to ensure that the answer that Solver reports is actually the optimal solution.
A)True
B)False
Q3) The _______________ function sums a series of products in ranges of identical sizes, called arrays, that are parallel to each other in a worksheet.
A) SUMPRODUCT
B) SUMPROD
C) ADDPRODUCT
D) ADDPROD
Q4) When you cannot describe a function in linear terms, it is called a(n) ____________________ function.
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Troubleshooting Workbooks and Automating Excel Applications
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/13828
Sample Questions
Q1) To help prevent a user from entering data that doesn't satisfy the validation rule for a cell, you can display a(n) ____ message that identifies the kind of data the user should enter.
A) input
B) error
C) data
D) data table
Q2) A(n) digital certificate should contain a digital signature, which confirms that the signer created the macro and that the macro has not been changed since its digital certificate was created. _________________________
A)True
B)False
Q3) If a cell contains an error-indicator triangle in its upper-left corner, you can click the cell to display the ____ button.
A) Error Alert
B) Error Help
C) Error Wizard
D) Error Warning
Q4) A(n) ____________________ cell contains a formula that refers to other cells.
Page 12
To view all questions and flashcards with answers, click on the resource link above.