Font size
WorksheetsHSDE EDPM Diagnostic Test
Total questions: 25
Worksheet time: 35mins
Which of the following is a primary feature of word processing software?
Creating presentations
Database management
Editing text documents
Creating web pages
Which option allows you to format text in a document?
Font toolbar
Spreadsheet function
Slide transition
Sort feature
In a word processing document, which feature helps to check the spelling and grammar?
Word count
Spell check
Thesaurus
Page layout
Which of the following best describes a spreadsheet?
Software used for creating and editing text
A grid of rows and columns for data entry
A tool for managing slides in presentations
A program to send emails
Which of the following is a commonly used function in spreadsheets?
SUM
ALIGN
BOLD
FOOTER
What type of chart is typically used to display trends over time in a spreadsheet?
Bar chart
Pie chart
Line chart
Scatter plot
Which key combination is used to copy selected text in word processing?
Ctrl + A
Ctrl + X
Ctrl + C
Ctrl + V
In a spreadsheet, what does the formula =AVERAGE(B2:B10) calculate?
The total sum of values in cells B2 to B10
The highest value in the range B2 to B10
The mean value of the range B2 to B10
The lowest value in the range B2 to B10
Which of the following is an example of a secondary storage device?
RAM
Hard drive
ROM
CPU
In word processing, what is a 'header'?
The first paragraph in a document
Text or graphics at the top of each page
A way to insert page numbers
A feature for footnotes
What is the primary function of 'Mail Merge'?
To merge multiple documents into one
To print envelopes and labels
To send personalized letters to multiple recipients
To edit multiple files at once
In spreadsheet software, which symbol is used to begin a formula?
=
+
-
*
Which command in a word processing application would you use to undo the last action?
Ctrl + S
Ctrl + U
Ctrl + Z
Ctrl + P
In spreadsheet applications, which of the following refers to a vertical set of cells?
Column
Row
Cell
Range
What feature in word processing allows you to add preformatted text styles, such as headings?
AutoCorrect
Styles
Clipboard
Watermark
Which spreadsheet function would you use to count the number of cells that contain numbers?
COUNTIF
COUNT
COUNTA
SUM
In a word processing document, a 'footer' typically appears where?
At the top of every page
At the bottom of every page
In the middle of the page
At the end of the document
Which spreadsheet function returns the largest value in a given range?
MIN
MAX
SUM
IF
Which of the following is NOT a type of data entry in a spreadsheet?
Text
Formula
Picture
Number
What does the 'Word Count' feature in word processing software display?
The number of pages
The number of letters
The number of words and characters
The total document size
Explain how the use of Mail Merge can improve efficiency in business communication.
List three formatting features in word processing software and explain how each one enhances document presentation.
Describe the steps involved in creating a simple budget using a spreadsheet application. Include formulas that may be used to calculate totals.
Identify and explain two advantages of using a spreadsheet to analyze data over manual calculations.
Differentiate between 'Save' and 'Save As' in word processing software, and give one example where each command would be appropriate to use.
