wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Digital Apps Final Exam Review

Total questions: 72

Worksheet time: 36mins

Name
Class
Date
1.

Which of the following is NOT a personal computer?

a)

laptop

b)

mainframe

c)

desktop

d)

all of these

2.

One of the most important components of personal computer hardware is ____, which stores instructions and data.

a)

memory

b)

the processor

c)

the cloud

d)

optical storage

3.

An example of an output device is a ____.

a)

printer

b)

keyboard

c)

mouse

d)

touchpad

4.

Antivirus software protects against which of the following types of malware?

a)

viruses

b)

phishing scams

c)

firewalls

d)

spoofed sites

5.

An electronic ____ is an application you use to perform numeric calculations and to analyze and present numeric data.

a)

database

b)

dataform

c)

spreadsheet

d)

project

6.

In Excel, the electronic spreadsheet you work in is called a ____.

a)

tablet

b)

numeric sheet

c)

databook

d)

worksheet

7.

In Excel, a worksheet is contained in a file called a ____.

a)

workbook

b)

notbook

c)

workpad

d)

datapad

8.

You can use predesigned, formatted files called ____ to create new worksheets quickly

a)

formatsheets

b)

templates

c)

layouts

d)

screens

9.

You can use a spreadsheet to ____ by using variable values to investigate and sample different outcomes.

a)

represent values graphically

b)

create what-if data scenarios

c)

organize data

d)

perform calculations

10.

____ below the worksheet grid let you switch from sheet to sheet in a workbook.

a)

Cell pointers

b)

Scroll bars

c)

Sheet tabs

d)

Mode indicators

11.

All Excel formulas begin with the ____.

a)

plus sign (+)

b)

asterik (*)

c)

equal sign (=)

d)

slash (/)

12.

The Excel operator for exponent is ____.

a)

/

b)

\

c)

^

d)

%

13.

The Excel operator for division is ____.

a)

\

b)

/

c)

%

d)

^

14.

If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1/A2, what would cell A3 show on the worksheet?

a)

=A1/A2

b)

=10/2

c)

=5

d)

5

15.

If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1^A2, what would cell A3 show on the worksheet?

a)

=A1^A2

b)

10^2

c)

20

d)

100

16.

A(n) ____ is a built-in formula that uses arguments to calculate information.

a)

label

b)

function

c)

template

d)

indicator

17.

To quickly jump to the first cell in a worksheet press ____.

a)

[Alt][Page Up]

b)

[Page Up]

c)

[Shift][Home]

d)

[Ctrl][Home]

18.

Possible paper orientations for printing a worksheet are landscape and ____.

a)

preview

b)

normal

c)

portrait

d)

page break

19.

The ____ option helps fit the data on a single page without making changes to individual margins.

a)

scale to fit

b)

page break view

c)

squeeze

d)

paginate

20.

You can use the ____ slider on the status bar to enlarge your view of specific areas of your worksheet.

a)

Preview

b)

Orientation

c)

Zoom

d)

Layout

21.

In the formula =D1+C1/F3, which calculation will be performed first?

a)

C1/F3

b)

D1/F3

c)

D1+F3

d)

D1+C1

22.

All functions begin with the formula prefix ____.

a)

@ (at symbol)

b)

= (equals sign)

c)

# (number symbol)

d)

+ (plus sign)

23.

In Excel, MAX and AVERAGE are examples of ____.

a)

functions

b)

lists

c)

arguments

d)

buttons

24.

You can create an absolute cell reference by placing a ____ in front of both the column letter and the row number of the cell address.

a)

%

b)

$

c)

&

d)

@

25.

Which of the following items can you import into a presentation?

a)

photographs

b)

text

c)

numerical data

d)

All of these

26.

The default view that PowerPoint opens in is called ____ view.

a)

Slide

b)

Normal

c)

Standard

d)

Edit

27.

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

a)

ribbon

b)

tab

c)

group

d)

toolbar

28.

The blinking vertical line that indicates where your text will appear when you type is called the ____.

a)

cursor

b)

insertion point

c)

pointer

d)

placeholder point

29.

When you are typing in a text placeholder, which feature decreases the font size in order to fit the text in the placeholder?

a)

AutoFit Options button

b)

Text Options button

c)

AutoFit Text button

d)

AutoFont Options button

30.

With PowerPoint, you can import text, photographs, numerical data, and facts from files created in such programs as ____.

a)

Microsoft Word

b)

Microsoft Excel

c)

Microsoft Access

d)

All of the Above

31.

A content placeholder can be used to insert all of the following EXCEPT ____.

a)

pictures

b)

tables

c)

charts

d)

apps

32.

Themes are found on the ____ tab.

a)

LAYOUT

b)

DESIGN

c)

THEME

d)

STYLE

33.

____ view displays your presentation on the whole computer screen.

a)

Slide Sorter

b)

Slide Show

c)

Outline

d)

Notes Page

34.

Which of the following views has no View Shortcuts button?

a)

Normal view

b)

Outline View

c)

Reading View

d)

Slide Show View

35.

Tom wants to change the overall look of the slides, so he chooses a new ____.

a)

design

b)

theme

c)

style

d)

color scheme

36.

The Header and Footer dialog box has which of the following tabs?

a)

Notes and Handouts

b)

Outline

c)

Reading

d)

Options

37.

Which element of the Word program window is used to quickly enlarge and decrease the size of the document?

a)

Zoom slider

b)

view buttons

c)

vertical ruler

d)

scroll bar

38.

Which Word feature causes red and green wavy lines to appear under words as you type?

a)

ScreenTips

b)

Spelling and grammar checking

c)

AutoComplete

d)

AutoCorrect

39.

Which key is used to remove the character before the insertion point?

a)

[Tab]

b)

[Delete]

c)

[Backspace]

d)

[Enter]

40.

Which feature in Word automatically corrects typos, minor spelling errors, and capitalization as you type?

a)

AutoComplete

b)

AutoCorrect

c)

Spelling and grammar

d)

Auto Type

41.

The first time you save a document, which screen appears?

a)

Save screen

b)

Save As screen

c)

Save File screen

d)

Save Document screen

42.

“Drag and drop” describes what operation?

a)

Copying text to the Clipboard

b)

Moving text using the mouse

c)

Deleting text

d)

Moving text using keyboard shortcuts

43.

What is the keyboard shortcut for saving a document?

a)

[Ctrl][A]

b)

[Ctrl][S]

c)

[Ctrl][X]

d)

[Ctrl][C]

44.

What is the keyboard shortcut for pasting text?

a)

[Ctrl][C]

b)

[Ctrl][X]

c)

[Ctrl][P]

d)

[Ctrl][V]

45.

What is the keyboard shortcut for cutting text?

a)

[Ctrl][Q]

b)

[Ctrl][X]

c)

[Ctrl][A]

d)

[Ctrl][C]

46.

Which command do you use to display two open documents at the same time?

a)

Split

b)

New Window

c)

Arrange All

d)

Switch Windows

47.

Which feature would you use to correct words that you frequently misspell as you type?

a)

Spelling and Grammar

b)

Find and Replace

c)

AutoCorrect

d)

AutoComplete

48.

Which feature can you use to find and insert a synonym for an overused word?

a)

AutoCorrect

b)

Find and replace

c)

Spelling and Grammar

d)

Thesaurus

49.

A discussion in which a group of people communicate by typing messages to each other online simultaneously.

a)

Chat group

b)

Hacker

c)

File

d)

Bluetooth

50.

An electronic collection of information, such as a letter, video, or app, stored on your computer that has a unique name, which distinguishes it from other files.

a)

File

b)

FireWALL

c)

monitor

d)

Hacker

51.

The technology that makes it possible for you to send and receive messages through the Internet.

a)

Electronic Mail (email)

b)

Bluetooth

c)

internet

d)

Chat group

52.

The TV-like peripheral device that displays the output from the computer.

a)

Monitor

b)

Mouse

c)

Bluetooth

d)

Hacker

53.

Hardware or software that prevents other computers on the internet from accessing a computer or prevents a program on a computer from accessing the internet

a)

Firewall

b)

Hacker

c)

Internet

d)

email

54.

People who create malicious computer programs sometimes to steal or damage your data or hardware or assume your identity.

a)

Hacker

b)

File

c)

Monitor

d)

Bluetooth

55.

A network of connected computers and computer networks located around the world; the largest network in the world.

a)

Internet

b)

Firewall

c)

Monitor

d)

Hacker

56.

A wireless technology standard that allows electronic devices to use short range radio waves to communicate with one another or connect to the internet; the radio waves can be transmitted around corners and through walls.

a)

Internet

b)

Bluetooth

c)

Firewall

d)

email

57.

A pointing device that has a rolling ball on its underside and two or more buttons for clicking commands; you control the movement of the pointer by moving the entire mouse around on your desk.

a)

Mouse

b)

Web cam

c)

Optical Storage device

d)

Spam

58.

The peripheral computer component that produces a hard copy of text or graphics processed by the computer onto a sheet of paper.

a)

Printer

b)

Smartphone

c)

Web cam

d)

Wi-Fi

59.

Unwanted email that arrives from unsolicited sources. Also called junk email.

a)

Spam

b)

Email

c)

Mouse

d)

Netbook

60.

Alliance to describe networks connected using a standard radio frequency established by the Institute of Electrical and Electronics Engineers; frequently referred to as Wi-fi.

a)

Wifi

b)

Printer

c)

Mouse

d)

Netbook

61.

A type of sub-notebook computer that is primarily designed to allow users to access the internet and check email.

a)

Netbook

b)

Smartphone

c)

Spam

d)

Mouse

62.

A handheld computer used to make and receive phone calls, maintain an address book, electronic appointment book, calculator, and notepad, play music, take photos, or video and perform some of the functions as a PC such as word processing.

a)

Netbook

b)

Smartphone

c)

Webcam

d)

Spam

63.

Uses laser technology to store data in the form of tiny pits or bumps on the reflective surface of spinning polycarbonate disc. To access the data, a laser illuminates the data path while a read head interprets the reflection.

a)

Optical storage device

b)

netbook

c)

Spam

d)

Smartphone

64.

A camera that captures digital video images using a computer.

a)

Mouse

b)

Webcam

c)

smartphone

d)

Netbook

65.

Aligns the selected text or line to justify the screen

a)

CTRL + J

b)

CTRL + A

c)

CTRL + V

d)

CTRL + I

66.

Copy the selected text

a)

CTRL + V

b)

CTRL + X

c)

CTRL + C

d)

CTRL + A

67.

Italic highlighted selection

a)

CTRL + I

b)

CTRL + B

c)

CTRL + V

d)

CTRL + A

68.

Insert hyperlink

a)

CTRL + K

b)

CTRL + J

c)

CTRL + I

d)

CTRL + F

69.

Bold highlighted selection

a)

CTRL + B

b)

CTRL + C

c)

CTRL + V

d)

CTRL + I

70.

Open find box

a)

CTRL + F

b)

CTRL + B

c)

CTRL + A

d)

CTRL + V

71.

Select ALL contents of the page

a)

CTRL + K

b)

CTRL + J

c)

CTRL + B

d)

CTRL + A

72.

Paste

a)

CTRL + B

b)

CTRL + A

c)

CTRL + X

d)

CTRL + V