HSDE EDPM Diagnostic Test

Which of the following is a primary feature of word processing software?

• Creating presentations

• Database management

• Editing text documents

• Creating web pages

Answer explanation

The primary feature of word processing software is editing text documents. This software is specifically designed to create, modify, and format text, making it essential for document preparation.

Which option allows you to format text in a document?

• Font toolbar

• Spreadsheet function

• Slide transition

• Sort feature

Answer explanation

The Font toolbar is specifically designed for formatting text in a document, allowing users to change font style, size, and color. The other options, like spreadsheet functions and slide transitions, do not pertain to text formatting.

In a word processing document, which feature helps to check the spelling and grammar?

• Word count

• Spell check

• Thesaurus

• Page layout

Answer explanation

The 'Spell check' feature in word processing documents is specifically designed to identify and correct spelling and grammar errors, making it the correct choice for this question.

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

Answer explanation

A spreadsheet is best described as a grid of rows and columns for data entry, allowing users to organize, analyze, and manipulate data effectively. The other options refer to different types of software.

Which of the following is a commonly used function in spreadsheets?

• SUM

• ALIGN

• BOLD

• FOOTER

Answer explanation

The SUM function is commonly used in spreadsheets to add a range of numbers. ALIGN, BOLD, and FOOTER are formatting options, not functions for calculations.

What type of chart is typically used to display trends over time in a spreadsheet?

• Bar chart

• Pie chart

• Line chart

• Scatter plot

Answer explanation

A line chart is ideal for displaying trends over time, as it connects data points with lines, making it easy to visualize changes. In contrast, bar charts and pie charts are better for comparisons, while scatter plots show relationships.

Which key combination is used to copy selected text in word processing?

• Ctrl + A

• Ctrl + X

• Ctrl + C

• Ctrl + V

Answer explanation

The correct key combination to copy selected text in word processing is Ctrl + C. Ctrl + A selects all text, Ctrl + X cuts the selected text, and Ctrl + V pastes it.

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

Answer explanation

The formula =AVERAGE(B2:B10) calculates the mean value of the numbers in cells B2 to B10 by summing them and dividing by the count of those numbers, making 'The mean value of the range B2 to B10' the correct choice.

Which of the following is an example of a secondary storage device?

• RAM

• Hard drive

• ROM

• CPU

Answer explanation

A hard drive is a secondary storage device used to store data permanently, unlike RAM and ROM, which are types of memory. RAM is volatile, and ROM is non-writable in normal use, while the hard drive retains data even when powered off.

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

Answer explanation

A 'header' in word processing refers to text or graphics that appear at the top of each page, providing consistent information like titles or chapter names, distinguishing it from other options like footnotes or page numbers.