NEW
Font size
WorksheetsDigital Apps Final Exam Review
Total questions: 72
Worksheet time: 36mins
Which of the following is NOT a personal computer?
laptop
mainframe
desktop
all of these
One of the most important components of personal computer hardware is ____, which stores instructions and data.
memory
the processor
the cloud
optical storage
An example of an output device is a ____.
printer
keyboard
mouse
touchpad
Antivirus software protects against which of the following types of malware?
viruses
phishing scams
firewalls
spoofed sites
An electronic ____ is an application you use to perform numeric calculations and to analyze and present numeric data.
database
dataform
spreadsheet
project
In Excel, the electronic spreadsheet you work in is called a ____.
tablet
numeric sheet
databook
worksheet
In Excel, a worksheet is contained in a file called a ____.
workbook
notbook
workpad
datapad
You can use predesigned, formatted files called ____ to create new worksheets quickly
formatsheets
templates
layouts
screens
You can use a spreadsheet to ____ by using variable values to investigate and sample different outcomes.
represent values graphically
create what-if data scenarios
organize data
perform calculations
____ below the worksheet grid let you switch from sheet to sheet in a workbook.
Cell pointers
Scroll bars
Sheet tabs
Mode indicators
All Excel formulas begin with the ____.
plus sign (+)
asterik (*)
equal sign (=)
slash (/)
The Excel operator for exponent is ____.
/
\
^
%
The Excel operator for division is ____.
\
/
%
^
If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1/A2, what would cell A3 show on the worksheet?
=A1/A2
=10/2
=5
5
If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1^A2, what would cell A3 show on the worksheet?
=A1^A2
10^2
20
100
A(n) ____ is a built-in formula that uses arguments to calculate information.
label
function
template
indicator
To quickly jump to the first cell in a worksheet press ____.
[Alt][Page Up]
[Page Up]
[Shift][Home]
[Ctrl][Home]
Possible paper orientations for printing a worksheet are landscape and ____.
preview
normal
portrait
page break
The ____ option helps fit the data on a single page without making changes to individual margins.
scale to fit
page break view
squeeze
paginate
You can use the ____ slider on the status bar to enlarge your view of specific areas of your worksheet.
Preview
Orientation
Zoom
Layout
In the formula =D1+C1/F3, which calculation will be performed first?
C1/F3
D1/F3
D1+F3
D1+C1
All functions begin with the formula prefix ____.
@ (at symbol)
= (equals sign)
# (number symbol)
+ (plus sign)
In Excel, MAX and AVERAGE are examples of ____.
functions
lists
arguments
buttons
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.
%
$
&
@
Which of the following items can you import into a presentation?
photographs
text
numerical data
All of these
The default view that PowerPoint opens in is called ____ view.
Slide
Normal
Standard
Edit
On the Ribbon, each set of primary commands is identified by a(n) ____.
ribbon
tab
group
toolbar
The blinking vertical line that indicates where your text will appear when you type is called the ____.
cursor
insertion point
pointer
placeholder point
When you are typing in a text placeholder, which feature decreases the font size in order to fit the text in the placeholder?
AutoFit Options button
Text Options button
AutoFit Text button
AutoFont Options button
With PowerPoint, you can import text, photographs, numerical data, and facts from files created in such programs as ____.
Microsoft Word
Microsoft Excel
Microsoft Access
All of the Above
A content placeholder can be used to insert all of the following EXCEPT ____.
pictures
tables
charts
apps
Themes are found on the ____ tab.
LAYOUT
DESIGN
THEME
STYLE
____ view displays your presentation on the whole computer screen.
Slide Sorter
Slide Show
Outline
Notes Page
Which of the following views has no View Shortcuts button?
Normal view
Outline View
Reading View
Slide Show View
Tom wants to change the overall look of the slides, so he chooses a new ____.
design
theme
style
color scheme
The Header and Footer dialog box has which of the following tabs?
Notes and Handouts
Outline
Reading
Options
Which element of the Word program window is used to quickly enlarge and decrease the size of the document?
Zoom slider
view buttons
vertical ruler
scroll bar
Which Word feature causes red and green wavy lines to appear under words as you type?
ScreenTips
Spelling and grammar checking
AutoComplete
AutoCorrect
Which key is used to remove the character before the insertion point?
[Tab]
[Delete]
[Backspace]
[Enter]
Which feature in Word automatically corrects typos, minor spelling errors, and capitalization as you type?
AutoComplete
AutoCorrect
Spelling and grammar
Auto Type
The first time you save a document, which screen appears?
Save screen
Save As screen
Save File screen
Save Document screen
“Drag and drop” describes what operation?
Copying text to the Clipboard
Moving text using the mouse
Deleting text
Moving text using keyboard shortcuts
What is the keyboard shortcut for saving a document?
[Ctrl][A]
[Ctrl][S]
[Ctrl][X]
[Ctrl][C]
What is the keyboard shortcut for pasting text?
[Ctrl][C]
[Ctrl][X]
[Ctrl][P]
[Ctrl][V]
What is the keyboard shortcut for cutting text?
[Ctrl][Q]
[Ctrl][X]
[Ctrl][A]
[Ctrl][C]
Which command do you use to display two open documents at the same time?
Split
New Window
Arrange All
Switch Windows
Which feature would you use to correct words that you frequently misspell as you type?
Spelling and Grammar
Find and Replace
AutoCorrect
AutoComplete
Which feature can you use to find and insert a synonym for an overused word?
AutoCorrect
Find and replace
Spelling and Grammar
Thesaurus
A discussion in which a group of people communicate by typing messages to each other online simultaneously.
Chat group
Hacker
File
Bluetooth
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.
File
FireWALL
monitor
Hacker
The technology that makes it possible for you to send and receive messages through the Internet.
Electronic Mail (email)
Bluetooth
internet
Chat group
The TV-like peripheral device that displays the output from the computer.
Monitor
Mouse
Bluetooth
Hacker
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
Firewall
Hacker
Internet
People who create malicious computer programs sometimes to steal or damage your data or hardware or assume your identity.
Hacker
File
Monitor
Bluetooth
A network of connected computers and computer networks located around the world; the largest network in the world.
Internet
Firewall
Monitor
Hacker
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.
Internet
Bluetooth
Firewall
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.
Mouse
Web cam
Optical Storage device
Spam
The peripheral computer component that produces a hard copy of text or graphics processed by the computer onto a sheet of paper.
Printer
Smartphone
Web cam
Wi-Fi
Unwanted email that arrives from unsolicited sources. Also called junk email.
Spam
Mouse
Netbook
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.
Wifi
Printer
Mouse
Netbook
A type of sub-notebook computer that is primarily designed to allow users to access the internet and check email.
Netbook
Smartphone
Spam
Mouse
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.
Netbook
Smartphone
Webcam
Spam
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.
Optical storage device
netbook
Spam
Smartphone
A camera that captures digital video images using a computer.
Mouse
Webcam
smartphone
Netbook
Aligns the selected text or line to justify the screen
CTRL + J
CTRL + A
CTRL + V
CTRL + I
Copy the selected text
CTRL + V
CTRL + X
CTRL + C
CTRL + A
Italic highlighted selection
CTRL + I
CTRL + B
CTRL + V
CTRL + A
Insert hyperlink
CTRL + K
CTRL + J
CTRL + I
CTRL + F
Bold highlighted selection
CTRL + B
CTRL + C
CTRL + V
CTRL + I
Open find box
CTRL + F
CTRL + B
CTRL + A
CTRL + V
Select ALL contents of the page
CTRL + K
CTRL + J
CTRL + B
CTRL + A
Paste
CTRL + B
CTRL + A
CTRL + X
CTRL + V
