wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

2024 Digital Literacy Spring Exam Review

Total questions: 100

Worksheet time: 56mins

Name
Class
Date
1.

What software do you use to create a spreadsheet?

a)

Microsoft Word

b)

Microsoft Access

c)

Microsoft Excel

d)

Microsoft PowerPoint

2.

What is the purpose of a PowerPoint presentation?

a)

To inform

b)

To laugh

c)

To think

d)

To cry

3.

Which of the following is not a chart type in MS Excel?

a)

Column

b)

Text

c)

Line

d)

Bar

4.

What is the purpose of MS Excel?

a)

Word Processing

b)

Spreadsheet

c)

Database

d)

Presentation

5.

Which of the following is not a characteristic of a good presenter doing a presentation?

a)

Making eye contact with the audience

b)

Speaking loud

c)

Speaking clearly

d)

Reading the slides

6.

What is the purpose of MS Access?

a)

Word processing

b)

Spreadsheet

c)

Database

d)

Presentation

7.

In PowerPoint, what is the maximum number of lines of text that you should have on a slide?

a)

6

b)

8

c)

4

d)

10

8.

How many times do you space after a period at the end of a sentence.

a)

0

b)

1

c)

2

d)

3

9.

What software do you use to create a database?

a)

Microsoft Word

b)

Microsoft Excel

c)

Microsoft Access

d)

Microsoft PowerPoint

10.

Which of the following is an example of a field in a database?

a)

Text

b)

Chart

c)

Name

d)

Line

11.

How do you set transitions in a PowerPoint presentation?

a)

Home—slide transitions

b)

Insert—slide transitions

c)

Design—slide transitions

d)

Transitions—slide transitions

12.

How do you print handouts in a PowerPoint presentation?

a)

File—print—change to handouts

b)

File—print preview—change to handout

c)

Home—print—change to handouts

d)

File—print—properties

13.

How many times do you space after a period at the end of an abbreviation.

a)

0

b)

1

c)

2

d)

3

14.

Which of the following would be the fastest way to insert a picture into a PowerPoint slide from the Internet?

a)

Insert—Picture

b)

Insert—Online Picture

c)

Design—Picture

d)

Design—Online Picture

15.

In PowerPoint, what is the name of the view that shows a thumbnail size of all slides in a presentation?

a)

Normal

b)

Slide Show

c)

Slide Sorter

d)

Outline

16.

What is not a purpose for creating a form in MS Access?

a)

Entering data

b)

Viewing data

c)

Printing data

d)

Organizing data

17.

What software do you use to create a presentation?

a)

Microsoft Word

b)

Microsoft Excel

c)

Microsoft Access

d)

Microsoft PowerPoint

18.

Describe the process for inserting a chart into Excel?

a)

Insert—Charts

b)

Chart Wizard

c)

Both of these

d)

Neither of these

19.

How many times do you space after a semicolon?

a)

0

b)

1

c)

2

d)

3

20.

How many times do you space after a colon?

a)

0

b)

1

c)

2

d)

3

21.

How many times do you space after a question mark?

a)

0

b)

1

c)

2

d)

3

22.

How many times do you space after a hyphen?

a)

0

b)

1

c)

2

d)

3

23.

Can you change the colors of an Excel chart? 

a)

Yes

b)

No

24.

What would you type in the “criteria” box on a query grid in access to find entries that begin with the letter G?

a)

G

b)

G*

c)

*G

d)

*G*

25.

Which of the following is an example of a cell reference in Excel?

a)

AA

b)

A1

c)

1A

d)

11

26.

How would you copy a formula from one cell to the next in MS Excel?

a)

Highlight—Copy—Paste

b)

Autofill Handle

c)

Both A and B

d)

Neither A nor B

27.

The design template in MS PowerPoint contains ______________

a)

Background Design

b)

Slide Layout

c)

Font Color

d)

All of the Above

28.

If you are centering from top to bottom you are centering horizontally or vertically?

a)

Horizontally

b)

Vertically

29.

Which of the following is NOT a good typing technique?

a)

Sit up straight

b)

Feet flat on the floor

c)

Look at your fingers

d)

Wrists elevated off of the desk

30.

A query in MS Access is defined as

a)

A computerized filing system

b)

Used to identify each record in the table with a number

c)

A question used to ask specific information from a table

d)

A feature responsible for controlling the sequence of records

31.

In MS Excel, a formula must start with a(n)

a)

range of cells

b)

average

c)

function

d)

equals sign

32.

In MS Excel, a column runs __________________ and is identified by

a)

horizontal, letters

b)

vertical, numbers

c)

horizontal, numbers

d)

vertical, letters

33.

In MS Excel, multiple worksheets in a file make up a

a)

Worksheet

b)

Workbook

c)

Cell

d)

Title

34.

A collection of tables, reports, forms, and queries is a

a)

Table

b)

Database

c)

Query

d)

Record

35.

In MS Access, the records of tables and forms can be arranged in a specific order by using the ________ feature.

a)

Sort

b)

Table

c)

Editing

d)

Query

36.

What are the home row keys for the left hand in order from left to right?

a)

FDSA

b)

ASDF

c)

JKL;

d)

;LKJ

37.

What are the home row keys for the right hand in order from left to right?

a)

FDSA

b)

ASDF

c)

JKL;

d)

;LKJ

38.

How can you jump directly to a specific cell in MS Excel?

a)

Type the cell reference in the status bar

b)

Type the cell reference in the name box

c)

Type the cell reference in the title bar

d)

Type the cell reference in any cell and hit enter

39.

To combine two or more cells into one cell, use the _________ feature.

a)

Split cells

b)

Merge cells

c)

Cut

d)

Sort

40.

To zoom in on a worksheet, in MS Excel, which tab/ribbon should you use?

a)

Home

b)

Page Layout

c)

Review

d)

View

41.

In MS Excel, which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently?

a)

The formula =B6+B7+B8+B9+B10.

b)

The formula =TOTAL(B6-B10)

c)

The formula =SUM(B6:B10)

d)

The formula +SUM(B6-B10)

42.

In MS Excel, Which of the following can you use to insert a formula using a function? Select all the options that apply.

a)

Type the formula including the function.

b)

Click the AutoSum button.

c)

Click the AutoSum arrow.

d)

All of the Above

43.

In MS Access, which of the following is a difference between Table Design view and Table Datasheet view?

a)

Table Datasheet view does not display data.

b)

Table Design view displays table relationships.

c)

Table Design view does not display data.

d)

Table Datasheet view does not allow changes.

44.

Which formatting command changes text so it is slanted?

a)

Bold

b)

Italic

c)

Underline

d)

Strikethrough

45.

In PowerPoint, which view do you choose if you want to see a thumbnail of each slide in a presentation arranged in a grid?

a)

Normal

b)

Outline

c)

Slide Show

d)

Slide Sorter

46.

What are the small squares that appear in the corners and in the middle of the sides of a selected object's border called?

a)

Magnification handles

b)

Sizing handles

c)

Zoom handles

d)

Object handles

47.

In MS Access, which of the following is NOT a data type option when creating a table?

a)

date

b)

short text

c)

table

d)

currency

48.

When creating PowerPoint presentations, you should always use complete sentences.

a)

True

b)

False

49.

Electronic presentations are computer generated ______________ that can be used to help communicate information.

a)

Pictures

b)

Visual Aides

c)

Text

d)

Graphs

50.

In a database, data is stored in

a)

Tables

b)

Forms

c)

Reports

d)

Queries

51.

Which of the following would be used to uniquely identify a record?

a)

Validation

b)

Data type

c)

Primary key

d)

Field size

52.

The best data type to choose for a postcode would be

a)

Number

b)

Text

c)

Date/Time

d)

Currency

53.

A ‘required field’ is a form of

a)

Validation

b)

Verification

c)

Data Entry

d)

Data Output

54.

A postcode is usually written in the same format e.g. LLNN NLL (L=letter, N=number). The most suitable type of validation to use in this instance would be

a)

Input Mask

b)

Required Field

c)

Range Check

d)

None

55.

To find a particular set of data in a database you would use a

a)

Table

b)

Form

c)

Query

d)

Report

56.

Besides entering data directly into the table, you could use a

a)

Field

b)

Form

c)

Query

d)

Report

57.

To display the data from a query in a professional format you could use a

a)

Table

b)

Form

c)

Query

d)

Report

58.

What is a complete row of data within a table?

a)

Table

b)

Field

c)

Record

d)

Query

59.

To sort from the smallest to the largest (from A to Z and 0 to 9)

a)

Ascending

b)

Descending

c)

Advanced Sort/Filter

60.
If you see a series of "######" in a cell, that means the following:
a)
You keyed in an incorrect number
b)
The row height is too high
c)
The text is incorrectly spelled
d)
The column width is not wide enough
61.
You can only work in one cell at a time. The actual cell that you are working in is called what?
a)
Column
b)
Name Box
c)
Active Cell
d)
Row
62.
When entering text in Excel, it is automatically (by default):
a)
Left Justified
b)
Right Justified
c)
Center Justified
d)
Full Justified
63.
Columns in a spreadsheet are:
a)
Vertical
b)
Horizontal
c)
Upside down
d)
right side
64.
Rows in a spreadsheet are:
a)
Vertical
b)
Horizontal
c)
Upside Down
d)
Right Side
65.
When entering numbers in  Excel, they are automatically (by default):
a)
Left Justified
b)
Right Justified
c)
Center Justified
d)
Full Justified
66.
What is the term used where a column and row intersect?
a)
Toolbar
b)
Cell
c)
Name Box
d)
Formula Bar
67.
Cells are identified by the following:
a)
Column Letter followed by their Row Number
b)
Row Number followed by their Column Letter
c)
Row Number Only
d)
Column Letter Only
68.
Microsoft Excel is what type of software?
a)
Word Processing
b)
Spreadsheet
c)
Presentation
d)
Drawing
69.
What tab allows us to insert pictures?
a)
insert
b)
home
c)
design
d)
animation
70.

Special effects used to introduce slides in a presentation are called

a)

effects

b)

custom animations

c)

transitions

d)

present animations

71.

What type of software is MS-PowerPoint considered to be?

a)

Word Processing

b)

Spreadsheet

c)

Database

d)

Presentation

72.
When things move on an individual slide (like a picture zooming in), that's called:
a)
Movement
b)
Transitions
c)
Zooming
d)
Animations
73.

What instruction would I give the computer if I wanted to copy the same power-point slide again and again?

a)

New Slide

b)

Delete Slide

c)

Duplicate Slide

d)

Layout Slide

74.

3. What tab do you click to change the background of your slide?

a)

Design

b)

Home

c)

Insert

d)

Transition

75.

What does this button let you do?

a)

Insert a picture

b)

Insert Sound

c)

Insert text

d)

Insert shape

76.

Which button will you click to add photos?

a)

Bar Button

b)

Video Button

c)

Chart Button

d)

Pictures Button

77.

Check the three ways to delete the unnecessary slides.

a)

Press the Delete key on the keyboard.

b)

Select the first Slide.

c)

Press the Backspace key on the keyboard.

d)

Press the Ctrl key while clicking on the slides.

e)

Right-click on the slide and select Delete Slide.

78.
What is the feature to change the color scheme on a slide?
a)
Animation
b)
Slide design
c)
Outline
d)
Transition
79.
Which slide introduces the audience to the presentation?
a)
 End
b)
Name
c)
Start
d)
Title
80.

What is the main purpose an Interest Assessment Survey used for by a student in researching for a career?

a)

To evaluate the student's work experience

b)

To determine the student's favorite hobbies

c)

To identify the student's career interests

d)

To assess the student's hard skills

81.

Which of the following is an example of a hard skill?

a)

Teamwork

b)

Motivation

c)

Empathy

d)

Graphic Design

82.

Employers look for which type of the two skills: soft skills and/or hard skills, to be more important in the job application process?

a)

They are superficial and not important

b)

Only soft skills are important

c)

Employers look for a combination of both skills in potential employees

d)

Only hard skills are important

83.

What is the main difference between full-time and part-time employment?

a)

Full-time employment offers more flexibility

b)

Part-time employment includes more benefits

c)

Full-time employment typically includes 40 hours each week

d)

Part-time employment always includes a set salary

84.

What are Career Clusters?

a)

Different levels of education required for different careers

b)

Specific job positions within a career

c)

Categories of careers sorted by similar theme and interest

d)

Types of employment contracts

85.

What are soft skills?

a)

Skills related to physical labor

b)

Social skills, communication skills, personality traits, and emotional intelligence

c)

Technical skills required for a specific job

d)

Job-specific expertise

86.

What is an internship?

a)

A full-time job with benefits

b)

A position of a student or trainee who works in an organization to gain work experience

c)

A position that requires a bachelor's degree

d)

A type of part-time employment

87.

What is the main difference between a bachelor's degree and an associate degree?

a)

Bachelor's degree requires 60 hours of coursework

b)

Associate degree usually takes four years to complete

c)

Bachelor's degree includes general education courses and courses specific to the student's major

d)

Associate degree is a higher level of education than a bachelor's degree

88.

Which of the following is NOT a characteristic of having Emotional Intelligence?

a)
  • An awareness of personal strengths and limitations.

b)
  • An ability to identify and describe what people are feeling.

c)
  • An ability to not get your point of view across.

d)
  • An ability to let mistakes go.

89.

Give an example of a hard skill.

a)

Programming

b)

Public speaking

c)

Responsibility

d)

Communication

90.

Why are soft skills important?

a)

Soft skills are important because they enable effective communication, collaboration, and problem-solving in the workplace.

b)

Soft skills only benefit individuals, not teams or organizations.

c)

Soft skills are not important in the workplace.

d)

Technical skills are more important than soft skills in the workplace.

91.

How can soft skills be developed?

a)

All of the above

b)

Practice, observation, feedback, role-playing, workshops, mentorship

c)

Watching videos, participating in group discussions, joining clubs

d)

Taking personality tests, attending networking events, seeking professional help

92.

How can hard skills be acquired?

a)

By hanging out with friends.

b)

Through formal education, training programs, on-the-job experience, and self-study.

c)

By watching tv.

d)

None of the above

93.

How can a person improve their soft skills?

a)

By neglecting to develop effective communication skills.

b)

By practicing active listening, developing effective communication skills, honing emotional intelligence, and seeking feedback for continuous improvement.

c)

By not seeking feedback or opportunities for improvement.

d)

By avoiding social interactions and isolating oneself.

94.

Imagine you're in a job interview. Which of these would be considered a soft skill?

a)

Knowing how to use a screwdriver

b)

Knowing how to use excel

c)

Knowing how to use Problem-solving Skills

d)

Knowing how to use a mac computer

95.

Which of the following is NOT a soft skill?

a)

Problem Solving

b)

Flexibility

c)

Teamwork

d)

Degree/Certificate

96.

Which of the following is NOT a hard skill?

a)

Typing speed

b)

Machine operation

c)

Time management

d)

Computer programming

97.
Which of the following is NOT a soft skill?
a)
Professionalism
b)
Communication Skills
c)
Time management skills
d)
Typing skills
98.

Computer Skills are

a)

Soft Skills

b)

Hard Skills

99.

CPR certification

a)

Soft Skill

b)

Hard Skill

100.

Communication skills are

a)

Soft Skills

b)

Hard Skills