NEW
Font size
WorksheetsComputer Apps Final Exam Review
Total questions: 43
Worksheet time: 14mins
Data columns in a database table are called
records.
fields.
databits.
data points.
Justified text in a paragraph is aligned
to the left.
to the right.
centered.
symmetrical on both the left and the right.
In Google Sheets, the button shown is used to
create a line break inside of a cell.
turn on the gridlines.
apply borders to cells.
insert a page break.
The reference for a range of cells that starts in cell D3 and includes all cells over to column H and down to row 21 is _____________.
D3.H21
D3:H21
D3;H21
D3-H21
In Microsoft Word or Google Docs, the format painter is used to
initially format selected text.
copy formatting from one location to another.
erase formatting from selected text.
view the formatted settings of selected text.
The effect in Microsoft PowerPoint that looks like the new slide is fading in while the old one is fading out is an example of a
new slide.
master slide.
slide transition.
slide animation.
In Google Sheets or Microsoft Word, a single cell that is created by combining two or more selected cells is considered a:
Cell range.
Cell group.
Cell wrap.
Merged cell
In Microsoft Access, data is stored where?
in a table.
in a form.
in a query.
in a report.
In Microsoft Word or Google Docs, the ruler can not be used to add tab stops and change indents.
True
False
The primary goal for your slide design in Power Point or Google Slides should be
to incorporate many exciting movements.
to coordinate with your company logo and color scheme.
to make the information easy to read.
to use a variety of colors.
To protect yourself when using a computer, you should never
use application software.
open multiple applications at the same time.
click on suspicious hyperlinks sent to you.
surf the Internet.
The intersection of a row and a column in Google Sheets is a
cell address.
row or column header.
range.
data point.
What do you call a single row of data in a database?
field.
query.
record.
table.
In Google Slides or PowerPoint, or any program learned in this class for that matter, to remove the vertical or horizontal edges off an object, such as a picture is called
cutting.
trimming.
scaling.
cropping.
In Any Microsoft Office or Google application learned in class, a footer will print at the
very bottom of the document.
beginning of the document.
end of the document.
area above the bottom margin in the document.
Effects you apply to slide text, pictures, or other content to move them in unique ways on the slide are called.
special effects.
transitions.
animations.
designs.
This type of system software coordinates all of the activities on a computer. The computer will not function without this type of software.
Operating System
Application System
Communications System
Network System
In Google Docs or Microsoft Word, data can best be separated by
using tabs.
justification.
using the show/hide button.
inserting indents.
=D10-E12*B13 is an example of
a cell label.
a function.
a formula.
a cell range.
Sorting in ascending order means to sort data
Z to A, largest to smallest.
Z to A, smallest to largest.
alphabetically, smallest to largest.
alphabetically, largest to smallest.
Where is data stored permanently on a computer?
RAM
Memory
Hard Drive
Flash Drive
SUM, MAX, MIN, COUNT, IF would be examples of this.
function
formula
operand
operator
A query in Access is used to
present professional looking output of data.
search for and retrieve specific data.
delete insignificant data.
reset data types based on questions.
An absolute cell reference
allows a cell reference to change when copied or sorted.
locks a cell address so it will not change when copied or sorted.
refers to a group of cells.
is the intersection of a row and column.
Presentation software is primarily used to support a speech of present information to an audience in the form of a slide show.
True
False
Presentation software essentially helps the speaker with visual access to their ideas, and helps the audience with visual illustrations and information which complements the ______________.
teacher
audience
business
speaker
An effect you can apply to text, objects, graphics, or pictures to make those objects move during a slide show.
Live Preview
Transition
Animation
Reading View
A slide show is a series of slides. Which choice refers to the way each new slide appears on the screen.
Transition
Slide Tab
Slide Sorter View
Live Preview
A predefined set of slides is called a
Documents
Theme
Template
Transition
This is the:
Horizontal Ruler
Vertical Ruler
Group
None of the above
All are examples of possible highly effective presentational hooks except:
telling a story.
using a prop.
introducing yourself.
asking questions.
What does this allow you to do in Microsoft Word?
Change the font
Change the line spacing
Move the text
Delete the text
Which of the following methods do you use to accept a spelling change?
Right-click the misspelled word, then select the desired suggested spelling.
Right-click the misspelled word, then press ENTER.
Right-click the misspelled word, then select Ignore All.
Right-click the misspelled word, then select Add to Dictionary.
Which of the following options allows you to align text so that it is fully flush with both margins?
align left
align right
center
justify
Josh needs stylized text in his document to be normal, unformatted text. He should do which of the following?
press the format painter button
apply the heading 1 style
press the clear all formatting button
apply the strong style
What does PDF stand for?
Portable Document Files
Printed Document Files
Put Dem Far
Portable Document Format
To add a picture go to the ________ tab.
add
home
format
insert
What do you do to remove a portion of a picture that you don't want?
cut
paste
crop
scaling
If I want to find an average of cells A1 through A25, which formula would I use?
=average(A1:A25)
=avg(A1:A25)
=average(A1-A25)
=avg(A1-A25)
To enter data into a worksheet, you must select a ___________ in the worksheet to make it active.
file
function
font
cell
Which of the following is the best example of a device that is part of the Internet of Things (IoT)?
a. A desktop computer used for word processing
b. Tracking your steps and sending data to your phone.
c. A video game console connected to a television
d. A printer connected directly to a computer with a USB cable
Which of the following is a common example of a phishing attempt?
a. A tech newsletter you knowingly subscribed to
b. A pop-up advertisement claiming you’ve won a free prize
c. A system notification prompting a software update
d. An email posing as the IRS telling you to click a link to pay a tax penalty
Which of the following is the most effective way to create a positive online presence?
a. Posting often without reviewing what you share
b. Searching for you name online
c. Sharing content that is respectful, helpful, and accurate
d. Not responding to comments or messages from others
