wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Computer Applications Best 1

Total questions: 71

Worksheet time: 24mins

Name
Class
Date
1.

  ## means in Spreadsheets

a)

means there is a problem with formula you entered

b)

the number is too big for the space given and to correct it, increase the size of the column

c)

means there is a problem with the formula or function, such as the computer does not recognize the text entered

d)

means you cannot divide by 0

2.

#NAME means in Spreadsheets

a)

means there is a problem with formula you entered

b)

means you cannot divide by 0

c)

means there is a problem with the formula or function, such as the computer does not recognize the text entered

d)

means the number is too big for the space given and to correct it, increase the size of the column

3.

Which of the following allows users to copy formatting and apply it to another location in a document?


a)

Format Eraser

b)

Format Group on the Home Tab

c)

Format Palette

d)

Format Painter

4.

Columns are identified

a)

a letter and they go up and down

b)

are identified by a number and they go across the page

c)

shows scattered points across the page.

d)

is the intersection point between a column and a row

5.

Identified by a number and they go across the page

a)

Rows

b)

Columns

c)

Formula

d)

Cell Reference

6.

is the intersection point between a column and a row

a)

Formula

b)

Cell reference

c)

Cell

d)

Bar chart

7.

What is B2:D6

a)

Cell

b)

Cell indicator

c)

Cell Range

d)

Cell Group

8.

Input Devices, Memory, Microprocessors, and OUTPUT devices are main components of what?

a)

Software


b)

Verizon

c)

Internet

d)

Hardware

9.

A predetermined formula set up in the computer, such
as =SUM, =AVERAGE, =COUNT, =MAX and =MIN

a)

Pie Chart

b)

Function

c)

Cell Reference

d)

Cell Range

10.

A website is listed by what?

a)

An URL Address


b)

A USE Address


c)

A UPI Address


d)
  • A URI Address

11.

  License is used when an author wants to give people the right to share, use, and build upon a work that they have created.

a)

Creative commons

b)

Copyright

c)

Public Domain

d)

Plagiarism

12.

Public Domain works published after 1977 will not fall into the public domain until 70 years after the death of author, or, for corporate works, anonymous works, or works for hire

a)

Plagiarism

b)

Copyright

c)

American with Disabilities Act

d)

Public Domain

13.

Copying another person's ideas, words or writing and pretending that they are one's own work

a)

Public Domain

b)

Creative commons

c)

Trademark

d)

Plagiarism

14.

A brand name. Includes any word, name, symbol, device or any combination.

a)

Trademark

b)

Copyright

c)

American with Disabilities Act

d)

Creative commons

15.

A form of intellectual property law, protects original works of authorship including literary, dramatic, musical and artistic works, such as poetry, novels, movies, songs.

a)

Copyright

b)

Trademark

c)

Creative commons

d)

Public Domain

16.

Used to determine your individual individual likes and dislikes

a)

Workplace Rules

b)

Work Experience

c)

Self assessments

d)

Dress code

17.

Education Level- Graduated from a 2 year college

a)

Associate Degree

b)

Bachelor Degree

c)

Master Degree

d)

PhD Degree

18.

Graduated from a 4 year college

a)

Bachelor degree

b)

PhD degree

c)

Master Degree

d)

Graduated high school

19.

Graduated from an additional 1 to 2 years of graduate school.

a)

PhD degree

b)

Associate Degree

c)

Master Degree

d)

High School Diploma

20.

Which type of degree is offered by community and junior colleges?


a)

Master's degree

b)

Associate degree

c)

Bachelor's degree

d)

Doctoral degree

21.

Being on time, having a
positive attitude, and being a team player

a)

Workplace Rules

b)

Dress code

c)

Mannerisms

d)

Education Level

22.

Use this shortcut to take away your last action (undo)

a)

Ctrl + I

b)

Ctrl + P

c)

Ctrl + Z

d)

Ctrl + C

23.

Use this type of list if you don’t need to have your items in order.

a)

Bulleted

b)

Numbered

c)

Rows

d)

Columns

24.

Tool used to find similar words to use

a)

Grammar

b)

Spelling

c)

Thesaurus

d)

Dictionary

25.

Tool used by right clicking on the red underline

a)

Thesaurus

b)

Spelling

c)

Grammar

d)

Dictionary

26.

Which component of a computer controls the entire system and is often called the brains of the computer?

a)

RAM

b)

Output device

c)

Input device

d)

CPU

27.

In Excel, an expression created by you, such as =2*2 or =F16+B3

a)

Cell range

b)

Cell

c)

Formula

d)

Cell reference

28.

The name of a website that comes after the "www." in a web address

a)

LAN

b)

WAN

c)

Domain name

d)

IP address

29.

Use this when you are trying to save new work.

a)

Save

b)

Clipboard

c)

Save As

d)

Cursor

30.

Italics, underline, and bold are types of this

a)

Font styles

b)

Formatting

c)

Save

d)

Portrait

31.

In Excel, The act of changing the visual appearance in a cell without changing the value of the cell

a)

Alignment

b)

Worksheet

c)

Sum

d)

Formatting

32.

Function in Excel that adds all of the values of the cells in the argument

a)

Average

b)

Count

c)

Sum

d)

Graph

33.

Function in Excel that calculates the sum of the cells and then divides that value by the number of cells in the argument

a)

Average

b)

Sum

c)

Count

d)

Max

34.

Function in Excel that finds the lowest cell value

a)

Max

b)

Min

c)

Average

d)

Sum

35.

A program that allows you to use rows and columns of data to manage, predict, and present information.

a)

Spreadsheet

b)

Word Processor

c)

Database

d)

Web page

36.

A specified appearance for a specific text

a)

Font Style

b)

Font

c)

Font effect

d)

Font size

37.

Use this Microsoft application for presentations

a)

PowerPoint

b)

Word

c)

Excel

d)

Outlook

38.

What is the short-term storage for your computer called?

a)

Storage

b)

RAP

c)

RAM

d)

ROM

39.

Type of computer storage containing non-volatile, permanent data that, normally, can only be read, not written to. It receives data and permanently writes it on a chip, and it lasts even after you turn off your computer.

a)

RAM

b)

ROM

c)

RAP

d)

RON

40.

 Computers connected to the internet are identified and found by this

a)

Home Address

b)

IP Address

c)

Internet

d)

Intranet

41.

A software that is used in areas where calculations, graphs and charts need to be produced. One good example is a teacher monitoring the progress of their students by entering marks into this software.

a)

Databases

b)

Word processors

c)

Spreadsheets

d)

Presentation

42.

A program that allows you to use rows and columns of data to manage, predict, and present information.

a)

Spreadsheet

b)

Word Processor

c)

Database

d)

Web page

43.

LAN

a)

local area network

b)

local agent network

c)

local at network

d)

remember the middle word

44.

In Excel, this describes how your text and/or numbers are positioned in the cell

a)

Formatting

b)

Workbook

c)

Alignment

d)

Operator

45.

A temporary storage for copied information

a)

Clipboard

b)

Clipart

c)

Clippings

d)

Storage

46.

Used to move information permanently from one place to another

a)

Cut

b)

Paste

c)

Cut and paste

d)

Clipoard

47.

A predefined combination of colors, fonts, effects, and layouts that can applied to a presentation.

a)

Design

b)

Theme

c)

Template

d)

Style

48.

Which of the following can not have a copyright on it?

a)

Books

b)

Movies

c)

Ideas

d)

Play

49.

On the Ribbon, each set of primary commands is identified by a(n) ____

a)

Tab

b)

Ribbon

c)

Group

d)

Toolbar

50.

Professionalism

a)

Ability to recover from setbacks quickly.


b)

Willingness to adapt to new situations.


c)

Conveying messages without words, using body language.


d)

Exhibiting conduct and attitude appropriate for work.


51.

Hanging indents

a)

graduated from a 4-yr college

b)

graduated from a 2-yr college

c)

used for Bibliography and Work Cited entries

 

d)

bars that go across the page

52.

Allows one to format text, documents, paragraphs and lists as well as check spelling and grammar (used to write a report, essay, etc.)

a)

Database

b)

Presentations

c)

Word processing

d)

Spreadsheets

53.

Used to calculate numbers and equations (used to forecast or calculate equations)

a)

Presentations

b)

Word Processing

c)

Spreadsheets

d)

Database

54.

Used as a visual aide for communicating ideas to a group of people (used to show ideas)

a)

Presentations

b)

Spreadsheets

c)

Database

d)

Word Processing

55.

A form of intellectual property law, protects original works of authorship including literary, dramatic, musical, and artistic works, such as poetry, novels, movies, songs, computer software, and architecture

a)

Creative commons

b)

Plagiarism

c)

Trademark

d)

Copyright

56.

Copyright licenses that enable the free distribution of an otherwise copyrighted work (key word free)

a)

Creative Commons

b)

Trademark

c)

Plagiarism 

d)

Copyright

57.

Which of the following defines employability?

a)

A specific style of behavior in the workplace

b)

Arriving at work on-time and successfully completing the tasks assigned

c)

Recognizing the questions which relate to goals, purpose and needs

d)

Positive work behaviors and personal qualities which make individuals more likely to gain employment and succeed in their chosen career

58.

Which of the following is considered the most important skill in the workplace?

a)

Knowledge of technology

b)

Certifications or licensures

c)

Effective communication

d)

Leadership strategies

59.

Involves skills which are needed to be effective in any job market or workplace, examples include:

a)

Teamwork

b)

Employability

c)

Effective Communication Skills

d)

Ethical Skills

60.

Problem-solving

a)

Ability to recover from setbacks quickly.


b)

Collaborating with others towards a common goal.


c)

Expressing ideas through spoken words.


d)

Being on time for commitments and meetings.


61.

Margins are...

a)

a border


b)

the space between paragraphs


c)

the edges of a document


d)

text alignment

62.

Which of the following does NOT describe the cloud?

a)

Global network of remote servers

b)

Stores and manages data

c)

Private network used by organizations

d)

Runs application software

63.

Federal civil rights law for people with disabilities. It covers employment, state and local government services, public accommodations, and telecommunications for the deaf

a)

American with Disabilities Act

b)

Hyperlink

c)

Columns are identified by a letter and they go up and down

d)

·Rows are identified by a number and they go across the page

64.

Hyperlink

a)

it aligns the text in the center of the page


b)

A link from a file or document to another location or file, typically activated by clicking on a highlighted word or image on the screen


c)

the bar at the top of the screen that displays the name of the current window


d)

Horizontal and vertical measures that help you position objects on a slide.


65.

Which one of these is not a paragraph alignment option?

a)

Left

b)

Center

c)

Right

d)

Italized

66.

A website is listed by a URL (Uniform Resource Locator

a)

123 School Way

b)

424 School Way

c)

Internet Browser


67.

“Drag and drop” describes what operation?


a)

Deleting Text

b)

Moving text with the mouse

c)

Copying text to the clipboard

d)

Moving text using keyboard shortcuts

68.

Go across the page to show the results of the data

a)

Line chart uses a line across the page to show the results of the data

b)

Column chart has columns that go up and down

c)

Bar Chart

d)

Pie chart is a circle divided into pieces

69.

Used to determine your individual likes and dislikes

a)

Self Assessment

b)

Cell Range is a group of cells, such as “B4:B10

c)

Cell Reference is a single cell, such as D5

d)

Software is the operating system, such as Windows 10 or Mac OSX

70.

Used to add visually appealing effects to text in text box

a)

Comments

b)

Shapes

c)

Word Art

d)

Text box

71.

You want to implement a protocol on your network that allows computers to find the IP address of a host from a logical name. Which protocol should you implement?

a)

used to for complex diagrams, like flow charts, organizational charts, etc.

Drawing Tools

b)

Domain Name System

c)

Insertion point

d)

pastes what has been copied