Font size
Worksheets2024 Digital Literacy Spring Exam Review
Total questions: 100
Worksheet time: 56mins
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
What would you type in the “criteria” box on a query grid in access to find entries that begin with the letter G?
G
G*
*G
*G*
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
In a database, data is stored in
Tables
Forms
Reports
Queries
Which of the following would be used to uniquely identify a record?
Validation
Data type
Primary key
Field size
The best data type to choose for a postcode would be
Number
Text
Date/Time
Currency
A ‘required field’ is a form of
Validation
Verification
Data Entry
Data Output
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
Input Mask
Required Field
Range Check
None
To find a particular set of data in a database you would use a
Table
Form
Query
Report
Besides entering data directly into the table, you could use a
Field
Form
Query
Report
To display the data from a query in a professional format you could use a
Table
Form
Query
Report
What is a complete row of data within a table?
Table
Field
Record
Query
To sort from the smallest to the largest (from A to Z and 0 to 9)
Ascending
Descending
Advanced Sort/Filter
Special effects used to introduce slides in a presentation are called
effects
custom animations
transitions
present animations
What type of software is MS-PowerPoint considered to be?
Word Processing
Spreadsheet
Database
Presentation
What instruction would I give the computer if I wanted to copy the same power-point slide again and again?
New Slide
Delete Slide
Duplicate Slide
Layout Slide
3. What tab do you click to change the background of your slide?
Design
Home
Insert
Transition
What does this button let you do?
Insert a picture
Insert Sound
Insert text
Insert shape
Which button will you click to add photos?
Bar Button
Video Button
Chart Button
Pictures Button
Check the three ways to delete the unnecessary slides.
Press the Delete key on the keyboard.
Select the first Slide.
Press the Backspace key on the keyboard.
Press the Ctrl key while clicking on the slides.
Right-click on the slide and select Delete Slide.
What is the main purpose an Interest Assessment Survey used for by a student in researching for a career?
To evaluate the student's work experience
To determine the student's favorite hobbies
To identify the student's career interests
To assess the student's hard skills
Which of the following is an example of a hard skill?
Teamwork
Motivation
Empathy
Graphic Design
Employers look for which type of the two skills: soft skills and/or hard skills, to be more important in the job application process?
They are superficial and not important
Only soft skills are important
Employers look for a combination of both skills in potential employees
Only hard skills are important
What is the main difference between full-time and part-time employment?
Full-time employment offers more flexibility
Part-time employment includes more benefits
Full-time employment typically includes 40 hours each week
Part-time employment always includes a set salary
What are Career Clusters?
Different levels of education required for different careers
Specific job positions within a career
Categories of careers sorted by similar theme and interest
Types of employment contracts
What are soft skills?
Skills related to physical labor
Social skills, communication skills, personality traits, and emotional intelligence
Technical skills required for a specific job
Job-specific expertise
What is an internship?
A full-time job with benefits
A position of a student or trainee who works in an organization to gain work experience
A position that requires a bachelor's degree
A type of part-time employment
What is the main difference between a bachelor's degree and an associate degree?
Bachelor's degree requires 60 hours of coursework
Associate degree usually takes four years to complete
Bachelor's degree includes general education courses and courses specific to the student's major
Associate degree is a higher level of education than a bachelor's degree
Which of the following is NOT a characteristic of having Emotional Intelligence?
An awareness of personal strengths and limitations.
An ability to identify and describe what people are feeling.
An ability to not get your point of view across.
An ability to let mistakes go.
Give an example of a hard skill.
Programming
Public speaking
Responsibility
Communication
Why are soft skills important?
Soft skills are important because they enable effective communication, collaboration, and problem-solving in the workplace.
Soft skills only benefit individuals, not teams or organizations.
Soft skills are not important in the workplace.
Technical skills are more important than soft skills in the workplace.
How can soft skills be developed?
All of the above
Practice, observation, feedback, role-playing, workshops, mentorship
Watching videos, participating in group discussions, joining clubs
Taking personality tests, attending networking events, seeking professional help
How can hard skills be acquired?
By hanging out with friends.
Through formal education, training programs, on-the-job experience, and self-study.
By watching tv.
None of the above
How can a person improve their soft skills?
By neglecting to develop effective communication skills.
By practicing active listening, developing effective communication skills, honing emotional intelligence, and seeking feedback for continuous improvement.
By not seeking feedback or opportunities for improvement.
By avoiding social interactions and isolating oneself.
Imagine you're in a job interview. Which of these would be considered a soft skill?
Knowing how to use a screwdriver
Knowing how to use excel
Knowing how to use Problem-solving Skills
Knowing how to use a mac computer
Which of the following is NOT a soft skill?
Problem Solving
Flexibility
Teamwork
Degree/Certificate
Which of the following is NOT a hard skill?
Typing speed
Machine operation
Time management
Computer programming
Computer Skills are
Soft Skills
Hard Skills
CPR certification
Soft Skill
Hard Skill
Communication skills are
Soft Skills
Hard Skills
