WorksheetsDigital Literacy - Final review May 2019
Total questions: 70
Worksheet time: 35mins
Rows in a worksheet are identified by numbers.
True
False
Which of the following is the intersection of a row and column?
range
cell
active cell
no answer is correct
A small green square in the lower right corner of a cell is the _______________.
active cell
cell pointer
fill handle
no answer is correct
The _______________ box shows the active cell.
formula
name
cell
no answer is correct
A1:F8 is an example of a(n) . . .
cell reference
cell range
active cell
no answer is correct
A cell that is outlined by a bold (green) rectangle is called a(n) . . .
fill handle
active cell
cell reference
no answer is correct
Overflow characters in a cell show in adjacent cells whether or not there is information in the adjacent cell.
True
False
______________ is where you set a column's width so you can see all of the information in the column.
AutoSum columns
Merging cells
The boundary
No answer is correct
What character (or symbol) begins a formula?
pound sign/hash tag ( # )
equal sign ( = )
the letter E
no answer is correct
Information typed in a cell also shows in the name box.
True
False
The cell that you input text or numbers in is called a(n) . . .
current cell
active cell
highlighted cell
open cell
Combining two or more cells together is called . . .
merge and center
combing
merging
no answer is correct
If a cell shows ########## in it, what do you need to do?
expand the column
expand the row
change the formula
delete the formula
What is a fill handle?
a small green square in the left corner of the active cell
a small green square in the right corner of the active cell
a small green square in the right corner of a cell
a highlighted green box
What icon do you click to add all numbers in a cell range?
Sum
AutoSum
AutoFit
no answer is correct
The symbol to apply Accounting Number Format and Comma Style number format is the same.
True
False
Which is the correct way to display a cell range?
A1,F8
A1:F8
A1.F8
no answer is correct
In a cell reference, such as A2, what does the number refer to?
the column
the row
the cell
the active cell
Text or data can be entered in the formula bar.
True
False
What allows you to fill a series of numbers, dates, or text to adjacent cells?
Fill handle
Active cell
AutoFit
AutoFill
To use the fill handle, the mouse pointer needs to be a solid cross/number sign ( + ).
True
False
What keys do you press to begin a new line in the same cell?
ctrl + enter
alt + enter
alt + shift
no answer is correct
In Excel, what is the symbol to multiply?
= (equal sign)
x (multiplication sign)
* (asterisk)
/ (forward slash)
What Excel function determines the highest value of a range of cells?
Highest
Max
Min
AutoSum
Low is the Excel function that determines the lowest value of a range of cells.
True
False
Which number style does not apply a dollar sign to a number?
Accounting style
Comma style
Currency style
All apply a dollar sign to a number
The _______________ function adds a range of cells and divides by the number of entries.
min
max
sum
no answer is correct
Which of the following starts a formula?
/ (forward slash)
* (asterisk)
# (number sign, hash tag)
no answer is correct
A _______________ is a prewritten formula that is built into Excel.
function
feature
calculation
task
Which Tab on the ribbon do you click to change the Theme of a worksheet?
Home
Insert
Page Layout
File
When you Sum the range B3 to B9, what formula will show in the formula bar?
=SUM(B3:B9)
SUM(B3:B9)
=SUM(B3+B9)
=SUM B3:B9
Which symbol starts a formula?
# (number sign/hash tag)
= (equal sign)
( ) (parentheses)
none of the answers are correct
How many spaces will information in a cell be indented when the increase indent button is pressed twice?
2
3
4
6
A/An _______________ is a simple way to create a date stamp.
insert date function
IF function
NOW function
no answer is correct
$A$1 is an example of a/an . . .
cell reference
relative cell reference
absolute cell reference
no answer is correct
The ctrl + accent mark (~) keys are pressed when you want to see the formulas in a worksheet.
True
False
What does it mean when ###### shows in a cell?
there is an error
the width of the cell is not wide enough
the height of the cell is not tall enough
no answer is correct
What function key do you press to change the cell reference?
F1
F2
F3
F4
With an absolute cell reference, there is a dollar sign ($) before both the column and the row.
True
False
An IF Function can have two results?
True
False
In a database, a row is called a ____________________.
field
record
primary key
no answer is correct
A database and a table are the same thing.
True
False
To sort from the smallest to the largest (from A to Z and 0 to 9)
Ascending
Descending
Advanced Sort/Filter
What software do you use to make databases?
Access
Excel
PowerPoint
Word
Which of the following is NOT a data type?
Date/Time
Short Text
Long Text
Formula
Which of the following is NOT a valid database object?
Table
Form
Report
File
In a database, a column is called a ____________________.
record
field
primary key
no answer is correct
Each record in a database has one piece of information from each field.
True
False
A data type can be text, a number, or a date.
True
False
Microsoft Publisher is a . . .
Web Browser
Operating System
Desktop Publisihing Program
Word Processor
Which of the following should Publisher not be used for?
designing a flyer
creating a holiday card
designing a newsletter
calculating money
Which of the following can you not create with Publisher?
brochure
greeting cards
spreadsheet
flyer
all can be created using Publisher
Publisher and Word do not have similar ribbons?
True
False
If you want to type text in Publisher, you must first . . .
create a word wrap
insert a picture
insert a graphic
insert a text box
What company created Publisher?
Apple
Microsoft
HP
Documents created in Publisher are called ____________________.
spreadsheets
databases
publications
no answer is correct
In Publisher, the workspace that you can use for storing or working with graphics or text boxes is called the ____________________.
scratch area
landscape
portrait
selection handles
In Excel, what function adds all of the numbers in a range of cells?
Calculate
Compute
Sum
Max
MS Publisher has many pre-created documents that you can edit which are called ____________________.
thumbnails
templates
slides
images
How can you resize a picture or shape?
delete the picture and insert it again
change the font size of the picture
use the cut and paste commands
use the sizing handles around the picture when the picture is selected
After inserting a text box, you can change . . .
the size and style of text
the color and alignment of text
the line spacing and appearance of text
all answers are correct
Which other software that we have used/learned is similar to Publisher?
Access
Excel
Word
PowerPoint
Who is the developer of Publisher?
Microsoft
Apple
IBM
Which of the following would you use to send out a colorful message about an upcoming company picnic?
create a flyer in Publisher
create a flyer in PowerPoint
create a tri fold brochure in Publisher
create a flyer in Excel
Which of the following allows you to organize information into rows and columns?
cells
tables
rows
columns
Susan wants her neighborhood babysitting clients to remember her and have quick access to her phone number whenever they are in need of a babysitter.
Which publication should she use?
brochure
business card
newsletter
flyer
Jay wants to send monthly updates to members of his Boy Scout troop and their parents about recent activities, honors members have received, and upcoming events.
Which publication should he use?
newsletter
business card
letterhead
flyer
Publisher has hundreds of templates
True
False
