Intro to Business Computer Applications Final Review

Which of the following best describes Microsoft Excel?

• Database Management System

• Spreadsheet System

• Word Processor

• Presentation Program

Answer explanation

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. Excel forms part of the Microsoft Office suite of software.

Which of the following will add up the values in a column in Google Sheets and Microsoft Excel?

• =A1*B1

• =Sum(A1:A10)

• =Row Value

• =Sum Value

Answer explanation

In Google Sheets and Microsoft Excel, Columns in a Spreadsheet are identified by

• letters

• numbers

• cells

• rows

Answer explanation

Which of the following is the name of a cell in Microsoft Excel and Google Sheets?

• A1\:C1

• =A1xB1

• B1

• =Sum(A1\:A10)

Answer explanation

The act of copying or sharing copyrighted material without permission is

• an extension

• the role of an ISP

• Piracy

• Web browser

Answer explanation

Online piracy is the practice of downloading and distributing copyrighted content digitally without permission, such as music or software.

The physical devices that make up your computer system such as the mouse, the keyboard, memory, and the printer are classified as

• storage devices

• hardware

• input devices

• software

Answer explanation

A program intentionally designed to cause annoyance or damage to computer hardware or software.

• Ethics

• Ergonomics

• Technology

• a Virus

Answer explanation

A computer virus is a type of computer program that, when executed, replicates itself by modifying other computer programs and inserting its own code. If this replication succeeds, the affected areas are then said to be "infected" with a computer virus, a metaphor derived from biological viruses.

The use of science to solve practical problems is called

• Ethics

• Ergonomics

• Technology

• a Virus

Answer explanation

What is the name of this course?

• Competency Level

• Introduction to Business Computer Applications

• Computer Literacy

• Business Computer Applications

Which of the following CANNOT be copied by the format painter?

• Text

• Bold

• Font Color

• Font Size

Answer explanation

The Format Painter tool is used to copy and paste character and paragraph formats to existing text. This tool, used in conjunction with styles, can make organizing and reformatting documents easier and more efficient.