NEW
Font size
Worksheets2024 Digital Literacy Spring Exam
Total questions: 50
Worksheet time: 1hrs 15mins
What software do you use to create a spreadsheet?
Microsoft Word
Microsoft Access
Microsoft Excel
Microsoft PowerPoint
What is the purpose of a PowerPoint presentation?
To inform
To laugh
To think
To cry
Which of the following is not a chart type in MS Excel?
Column
Text
Line
Bar
What is the purpose of MS Excel?
Word Processing
Spreadsheet
Database
Presentation
Which of the following is not a characteristic of a good presenter doing a presentation?
Making eye contact with the audience
Speaking loud
Speaking clearly
Reading the slides
What is the purpose of MS Access?
Word processing
Spreadsheet
Database
Presentation
In PowerPoint, what is the maximum number of lines of text that you should have on a slide?
6
8
4
10
How many times do you space after a period at the end of a sentence.
0
1
2
3
What software do you use to create a database?
Microsoft Word
Microsoft Excel
Microsoft Access
Microsoft PowerPoint
Which of the following is an example of a field in a database?
Text
Chart
Name
Line
How do you set transitions in a PowerPoint presentation?
Home—slide transitions
Insert—slide transitions
Design—slide transitions
Transitions—slide transitions
How do you print handouts in a PowerPoint presentation?
File—print—change to handouts
File—print preview—change to handout
Home—print—change to handouts
File—print—properties
How many times do you space after a period at the end of an abbreviation.
0
1
2
3
Which of the following would be the fastest way to insert a picture into a PowerPoint slide from the Internet?
Insert—Picture
Insert—Online Picture
Design—Picture
Design—Online Picture
In PowerPoint, what is the name of the view that shows a thumbnail size of all slides in a presentation?
Normal
Slide Show
Slide Sorter
Outline
What is NOT a purpose for creating a form in MS Access?
Entering data
Viewing data
Printing data
Organizing data
What software do you use to create a presentation?
Microsoft Word
Microsoft Excel
Microsoft Access
Microsoft PowerPoint
Describe the process for inserting a chart into Excel?
Insert—Charts
Chart Wizard
Both of these
Neither of these
How many times do you space after a semicolon?
0
1
2
3
How many times do you space after a colon?
0
1
2
3
How many times do you space after a question mark?
0
1
2
3
How many times do you space after a hyphen?
0
1
2
3
Can you change the colors of an Excel chart?
Yes
No
Which of the following is an example of a cell reference in Excel?
AA
A1
1A
11
How would you copy a formula from one cell to the next in MS Excel?
Highlight—Copy—Paste
Autofill Handle
Both A and B
Neither A nor B
The design template in MS PowerPoint contains ______________
Background Design
Slide Layout
Font Color
All of the Above
If you are centering from top to bottom you are centering horizontally or vertically?
Horizontally
Vertically
Which of the following is NOT a good typing technique?
Sit up straight
Feet flat on the floor
Look at your fingers
Wrists elevated off of the desk
A query in MS Access is defined as
A computerized filing system
Used to identify each record in the table with a number
A question used to ask specific information from a table
A feature responsible for controlling the sequence of records
In MS Excel, a formula must start with a(n)
range of cells
average
function
equals sign
In MS Excel, a column runs __________________ and is identified by
horizontal, letters
vertical, numbers
horizontal, numbers
vertical, letters
In MS Excel, multiple worksheets in a file make up a
Worksheet
Workbook
Cell
Title
A collection of tables, reports, forms, and queries is a
Table
Database
Query
Record
In MS Access, the records of tables and forms can be arranged in a specific order by using the ________ feature.
Sort
Table
Editing
Query
What are the home row keys for the left hand in order from left to right?
FDSA
ASDF
JKL;
;LKJ
What are the home row keys for the right hand in order from left to right?
FDSA
ASDF
JKL;
;LKJ
How can you jump directly to a specific cell in MS Excel?
Type the cell reference in the status bar
Type the cell reference in the name box
Type the cell reference in the title bar
Type the cell reference in any cell and hit enter
To combine two or more cells into one cell, use the _________ feature.
Split cells
Merge cells
Cut
Sort
To zoom in on a worksheet, in MS Excel, which tab/ribbon should you use?
Home
Page Layout
Review
View
In MS Excel, which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently?
The formula =B6+B7+B8+B9+B10.
The formula =TOTAL(B6-B10)
The formula =SUM(B6:B10)
The formula +SUM(B6-B10)
In MS Excel, Which of the following can you use to insert a formula using a function? Select all the options that apply.
Type the formula including the function.
Click the AutoSum button.
Click the AutoSum arrow.
All of the Above
In MS Access, which of the following is a difference between Table Design view and Table Datasheet view?
Table Datasheet view does not display data.
Table Design view displays table relationships.
Table Design view does not display data.
Table Datasheet view does not allow changes.
Which formatting command changes text so it is slanted?
Bold
Italic
Underline
Strikethrough
In PowerPoint, which view do you choose if you want to see a thumbnail of each slide in a presentation arranged in a grid?
Normal
Outline
Slide Show
Slide Sorter
What are the small squares that appear in the corners and in the middle of the sides of a selected object's border called?
Magnification handles
Sizing handles
Zoom handles
Object handles
In MS Access, which of the following is NOT a data type option when creating a table?
date
short text
table
currency
When creating PowerPoint presentations, you should always use complete sentences.
True
False
Electronic presentations are computer generated ______________ that can be used to help communicate information.
Pictures
Visual Aides
Text
Graphs
The column doesn't have enough information
The column height is too high
The text is incorrectly spelled
The column width is not wide enough
