Word Processing & Spreadsheet Software Basics

1. What is a pivot table used for in spreadsheet software?

Summarizing and analyzing large data sets

Creating charts only

Deleting rows and columns

Encrypting sensitive data

2. In spreadsheets, what is the purpose of data validation?

To restrict cell entries to specific types or ranges

To automatically fix spelling errors

To create backup files

To sort data alphabetically

3. Which feature protects a word processing document with a password?

File > Protect Document

Format > Security

Insert > Lock

Review > Restrict

4. What does the CONCATENATE function do in a spreadsheet?

Combines text from multiple cells

Separates text into columns

Removes spaces from text

Counts characters in a cell

5. In word processing, what is the purpose of the outline view?

To organize and structure document content hierarchically

To view only images in a document

To print preview the document

To count pages automatically

6. What is the VLOOKUP function primarily used for in spreadsheets?

Searching for values in a table column

Creating line graphs

Validating email addresses

Merging multiple sheets

7. Which word processing feature is used to create footnotes or endnotes?

References menu

Insert menu

Format menu

Review menu

8. What does the IF function do in spreadsheet formulas?

Performs conditional logic based on criteria

Multiplies values together

Converts text to uppercase

Deletes empty cells

9. In a spreadsheet, what is the purpose of freezing panes?

To keep certain rows or columns visible while scrolling

To prevent accidental data deletion

To reduce file size

To speed up calculations

10. Which feature in word processing allows you to automatically generate a document outline?

Navigation pane with heading styles

Spelling and grammar check

Find and replace function

Page break insertion

11. Which keyboard shortcut saves a document in most word processing applications?

Ctrl+S

Ctrl+D

Ctrl+P

Ctrl+N

12. In word processing, what does the Track Changes feature allow you to do?

Monitor edits made by different users

Count total words in a document

Change font size automatically

Create table of contents

13. What is the purpose of conditional formatting in spreadsheets?

To highlight cells based on specific criteria

To lock cells from editing

To create backup copies

To convert text to numbers

14. Which menu option is typically used to insert a table in word processing software?

Insert

Format

Review

References

15. What does the AVERAGE function do in a spreadsheet?

Calculates the mean of selected values

Rounds numbers to the nearest integer

Removes duplicate entries

Sorts data in ascending order

16. In Excel or Calc, a formula always begins with which symbol?

=

+

@

#

17. What is mail merge used for in word processing?

Creating personalized letters using data from a spreadsheet

Combining multiple documents into one

Sending emails directly from the application

Backing up document versions

18. Which feature allows you to organize data into rows and columns in a spreadsheet?

Cells

Hyperlinks

Comments

Macros

19. In spreadsheet software, what does the SUM function calculate?

The total of selected cells

The average of selected cells

The maximum value only

The cell count

20. What is the primary purpose of using styles in word processing software?

To apply consistent formatting across a document

To encrypt document content

To increase file size

To prevent document editing

Tech+ Word Processing and Spreadsheet Software Basics Quiz