NEW
Font size
S
M
L
XL
WorksheetsDAR Objective Final Review
Total questions: 44
Worksheet time: 37mins
Name
Class
Date
1.
Each _____________ on the Ribbon is a collection of groups, and each group contains related items.
a)
Area
b)
Unit
c)
Tab
d)
Dialog Box
2.
What is it called when you combine two or more cells in to one?
a)
Merge
b)
Combine
c)
Join
d)
Union
3.
What is the tool that formats cells based on certain criteria to make data stand out and easier to read?
a)
Criterion Highlighter
b)
Conditional formatting
c)
Cut blast
d)
Sha Sha Shader
4.
What is the tool used to keep a range of selected rows or columns visible as the rest of the worksheet scrolls?
a)
Freeze Pane
b)
Peek-a-book
c)
Show/Hide
d)
Reveal Cells
5.
The dark screen square in the bottom right corner of the active cell.
a)
Phil Handley
b)
Fill Handle
c)
Option rotator
d)
Square link
6.
The ___________ provides quick access to frequently used commands.
a)
Shortcut Menu
b)
Start Menu
c)
Mini Toolbar
d)
Quick Access Toolbar
7.
Which of the following extensions applies to a Word 2016 document?
a)
*.dot
b)
*.dotx
c)
*.doc
d)
*.docx
8.
In order to show nonprinting characters, select the Show/Hide button on the Home tab.
a)
TRUE
b)
FALSE
9.
You have accidentally activated the Caps Lock key and typed three paragraphs in uppercase. Which option in the Change Case menu will convert the text back to normal paragraph format?
a)
Sentence case
b)
lowercase
c)
Uppercase
d)
Sorry, you have to retype everything!PreviousNext
10.
What is a snapshot of your computer screen called?
a)
snapshot
b)
Clip Art
c)
screenshot
d)
photo
11.
How do you remove unwanted areas on the horizontal and/or vertical edges of a picture?
a)
resize
b)
scale
c)
crop
d)
rotate
12.
How do you remove unwanted areas on the horizontal and/or vertical edges of a picture?
a)
resize
b)
scale
c)
crop
d)
rotate
13.
After applying a picture border, to what does “weight” refer?
a)
heaviness of the drop shadow
b)
thickness of the border
c)
thickness of the bottom compared to the top
d)
amount of color saturation
14.
The hollow circles around the clip art called sizing handles.
a)
TRUE
b)
FALSE
15.
To ___ cells is to combine two or more cells into one.
a)
number
b)
merge
c)
combine
d)
split
16.
What command changes paragraphs of text into a table?
a)
Convert Text to Table
b)
Convert Table to Text
c)
Create Table
d)
Merge Table
17.
What command does Word use to arrange data in alphabetical, numerical, or chronological order?
a)
sort
b)
filter
c)
alphabetize
d)
order
18.
What button must be used to enter a calculation into a table?
a)
formula button
b)
font button
c)
enter button
d)
bold button
19.
The inside address is who the letter is written to.
a)
TRUE
b)
FALSE
20.
The letterhead is what the letter is written about or the purpose of the letter.
a)
TRUE
b)
FALSE
21.
What is the term for a text or graphic displayed lightly behind document text?
a)
watermark
b)
text box
c)
page background
d)
pulled quotePreviousNext
22.
When beginning to type a letter, which style should you select to ensure proper spacing?
a)
Heading 1
b)
Subtle Emphasis
c)
Normal
d)
No Spacing
23.
Word documents can be divided into ______________, that can represent different formatting, headers, footers, etc.
a)
objects
b)
sections
c)
views
d)
palettes
24.
A ________________ is text that prints at the bottom of each page.
a)
view
b)
grid
c)
header
d)
footer
25.
The format painter lets you copy the format of text and apply those attributes to different text.
a)
TRUE
b)
FALSE
26.
A __________ is a location, a reference point, or a selection of text identified for future reference.
a)
footnote
b)
endnote
c)
bookmark
d)
source
27.
The _____ is the small black square located in the lower-right corner of the heavy border around the active cell in Excel.
a)
selection handle
b)
sizing handle
c)
fill handle
d)
copy handlePreviousNext
28.
A(n) _____ chart is drawn on the same worksheet as the data.
a)
embedded
b)
emboldened
c)
embodied
d)
empowered
29.
The _____ function displays the highest value in a range.
a)
MIN
b)
SUM
c)
MAX
d)
AVERAGE
30.
The _____ function determines the lowest number in a range.
a)
MAX
b)
AVERAGE
c)
SUM
d)
MIN
31.
I totally messed up what I was working on. I need to press ________ to Undo what I did.
a)
Ctrl + Z
b)
Ctrl + U
c)
Ctrl + Y
d)
Ctrl + R
32.
To alert Excel that you are entering a formula and not text, type a(n) ____________ preceding the formula.
a)
&
b)
=
c)
#
d)
*
33.
#### means you entered a formula incorrectly.
a)
True
b)
False
34.
What is Access?
a)
The database application used to keep a list of multiple fields.
b)
A spreadsheet program.
c)
A typing program
d)
The word place where we practice typing.
35.
Which of the following formulas contains an absolute cell reference?
a)
=$B4
b)
=B$4
c)
=$B$4
d)
=B4
36.
The 7 x 7 rule states that your slides should have no more than 7 pictures.
a)
TRUE
b)
FALSE
37.
In Access, a unique identifier also is called a record key.
a)
TRUE
b)
FALSE
38.
In Access, the rows in a table are called records.
a)
TRUE
b)
FALSE
39.
A small picture of a slide is called
a)
thumbnail
b)
slide library
c)
template
d)
layout
40.
The _______ is a viewing mode in which there are NO colors, only shades of gray.
a)
blue scale
b)
color scale
c)
grayscale
d)
black and white
41.
Bulleted text can be converted to SmartArt easily
a)
True
b)
False
42.
What Presentation View turns the slide deck into a speaker script?
a)
notes page
b)
Normal
c)
Outline
d)
Slide Sorter
43.
What shortcut key do I use to select everything on the screen?
a)
Ctrl + E
b)
Ctrl + A
c)
Ctrl + T
d)
None of the Above
44.
By right-clicking in the Ribbon tab, you can click Customize Ribbon to choose what tabs will be visible on the ribbon.
a)
TRUE
b)
FALSE
Reset
