Computer Applications in Business Practice Exam - 1319 Verified Questions

Computer Applications in Business Practice Exam

Course Introduction

Computer Applications in Business provides an overview of the essential computer technologies and software tools used in modern business environments. The course covers fundamental concepts such as office productivity software (word processing, spreadsheets, databases, and presentations), business-specific applications (accounting, payroll, inventory management), and the integration of information systems to enhance organizational efficiency. Students learn how to apply these tools for data analysis, electronic communication, and problem-solving in real-world business scenarios. The course also introduces emerging trends in digital business solutions, ensuring students develop both practical skills and a theoretical understanding of how computer applications drive business operations and decision-making.

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) According to the order of operation in Excel:

A)Excel performs exponentiation, then multiplication and division, then addition, and subtraction.

B)Excel performs multiplication, then exponentiation, then division, then addition, and then subtraction.

C)Excel performs exponentiation, then multiplication, then division, then subtraction, and then addition.

D)Excel performs multiplication, then division, then exponentiation, then addition, and then subtraction.

Answer: A

Q2) To make A1 the active cell,you should press which of the following keys?

A)Page Up

B)Page Down

C)Home

D)Ctrl + Home

Answer: D

Q3) 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) Header and footer elements such as worksheet name,current date,and time are _____ elements.

A)descriptive

B)dynamic

C)impact

D)required

Answer: B

Q2) Each worksheet will contain a specific class with the students' grades for the entire term.In order to determine the current student grade,Antoinette would have to use the _____ function.

A)SUM

B)AVERAGE

C)COUNT

D)MEDIAN

Answer: B

Q3) A(n)____________________ is a selection of formatting options using a specific font and color from the current theme.

Answer: style

Q4) A(n)____________________ is text printed in the top margin of each page.

Answer: header

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) Some cell references are called ____________________ references because they are always interpreted in relation to the location of the cell containing the formula.

Answer: relative

Q2) 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

Q3) 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) Referring to the figure above,if you were to create a Wine Production Chart pie chart using the information in B28:C34,the data source for that chart would be ____.

A)B28:C34

B)B29:C33

C)B28:B34

D)B29:C34

Q2) 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

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) Each value from a data series is represented by a ________.

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) To freeze a row,select the cell below the row(s)you want to freeze,click the ____________________ button in the Window group and then click Freeze Top Row.

Q2) Ted wants to use his PivotTable to show the total value of the motorcycles for a series of motorcycle dealerships but he wants to filter the display to show only those dealers whose total stock of motorcycle is greater than $1 million.How would he accomplish this?

A)He would develop a PivotTable using the aggregate filter.

B)He would develop a PivotTable using the report filter.

C)He would develop a PivotTable using the category filter.

D)He would develop a PivotTable using the value filter.

Q3) You can use a table's sizing handle to add columns or rows to a table.

A)True

B)False

Q4) 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

Q5) The second sort field in a sort is called the ____________________ field.

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) Contains text,formats,and formulas already built into it for your use

A)3-D

B)template

C)A

D)source

E)destination

F)link

G)M

H)worksheet group

I)hyperlink

J)Tiled

Q2) A(n)\(\underline { \text { asterisk } }\)separates the worksheet reference from the cell or range reference._________________________

A)True

B)False

Q3) After you have saved a template,you can access the template from the New screen in ____________________ view.

Q4) You can use the ____________________ dialog box to break links between workbooks.

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) 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.

Q2) Validation rules come into play only during data entry.

A)True

B)False

Q3) 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

Q4) What are the steps for creating a validation rule?

Q5) Each macro must have a unique name that begins with a letter.

A)True

B)False

Q6) Protecting the ____________________ of a workbook prohibits users from moving,resizing,closing,or hiding parts of the Excel window.

Q7) The ____________________ alert,by default,rejects the invalid data,but allows you to override the rejection.

Q8) List three advantages to using defined names instead of cell references.

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) Assuming that B1 contains 12 and B2 contains 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) _____ references make it easier to create formulas that use portions or all of an Excel table because the names of headers are usually simpler to identify than cell addresses.

A)Indexed

B)Structured

C)Key

D)Logical

Q3) 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.

Q4) The ____________________ function searches horizontally across a lookup table and is used when the compare values are stored in the first row of the lookup table.

Q5) To retrieve a particular value from a lookup table,a(n)____________________ needs to match the compare values.

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) Calculates the payment in each period required to pay off a loan or reach an investment goal

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

Q2) Describe the steps to interpolate a series of values between starting and ending values.

Q3) The item marked 2 in the accompanying figure is the _______ value.

A)sum

B)declining balance

C)initial asset

D)salvage

Q4) How do you determine which method of depreciation is most appropriate?

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 Solver,a(n)____________________ cell is a cell that you want to maximize,minimize,or change to a specific value.

Q2) At the break-even point,revenue equals expenses.

A)True

B)False

Q3) You can include an analysis of the constraints and conditions by which Solver arrived at its solution by creating a(n)_______ report.

A)analysis

B)answer

C)condition

D)constraint

Q4) Solver is an add-in,a program that adds customized commands and features to Microsoft Office programs such as Excel.

A)True

B)False

Q5) ____________________ cells are cells containing values you want to modify in what-if analysis cells.

Q6) ____________________ constraints always show a slack of 0.

Q7) What are the steps to create a one-variable data table?

Page 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) One way to structure text files is to use a(n)_______.

A)index

B)matrix

C)delimiter

D)register

Q2) Most software programs can both save and retrieve data in a(n)_______ file format.

A)HTML

B)text

C)spreadsheet

D)picture

Q3) When using a website as a data source,a(n)____________________ specifies how data should be retrieved from the webpage and indicates exactly which parts of the webpage should be included and which parts should not be included.

Q4) Columns in delimited text files are always vertically aligned as they would be in a spreadsheet.

A)True

B)False

Q5) 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 13

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) Chloe has decided to hide the worksheet gridlines and the vertical scroll bar.What does Henry tell her to use to do this?

A)Customization dialog box

B)Screen Elements dialog box

C)Excel Options dialog box

D)Display Options dialog box

Q2) An attachment to a document that authenticates the source of the signature

A)linked object

B)embedding object

C)PDF (Portable Document Format)

D)Standard properties

E)Custom properties

F)Object linking and embedding (OLE)

G)Encryption

H)digital certificate

I)certificate authority (CA)

J)source file

Q3) Database tables can be inserted directly into PivotCharts and

Q4) Data ____________________ can be databases,text files,or other Excel workbooks. To view

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) The default view of all folders except those in the Pictures Library is ____.

A)Details

B)Tiles

C)Large icons

D)Wallet

Q2) If you are currently working in the F: directory,you are most likely working with folders and files ____.

A)on the hard disk

B)on a USB drive

C)on a floppy drive

D)in the cloud

Q3) 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

Q4) When working in any view besides Details view,you sort by using the ____________________ tab on the ribbon.

Q5) You can open a file using File Explorer by ____________________ it in the right pane of File Explorer.

To view all questions and flashcards with answers, click on the resource link above. Page 15