Word Processing and Data Basics Quiz

You are formatting a long report and need to create a table of contents that updates automatically as you add or remove sections. Which feature in a word processor should you use to achieve this?

• Headers and Footers

• Table of Contents Generator

• Text Box

• Page Layout

A teacher requests a document that contains the same header on all pages except the first one. What tool in the word processor allows this?

• Page Break

• Section Break

• Header Settings

• Margins

While editing a group project, one student changes the font size inconsistently across the document. Which tool can be used to standardize font size and style throughout?

• Find and Replace

• Format Painter

• Paragraph Alignment

• Spell Check

You are creating a multi-page brochure and need to use both portrait and landscape orientations in the same document. Which feature allows you to do this?

• Orientation Options

• Section Breaks

• Page Layout

• Custom Margins

A document contains a large amount of text, and you want to make it more visually appealing by breaking it into columns. Which feature in the word processor helps you achieve this?

• Text Wrap

• Columns

• Table Format

• Page Setup

You are tracking monthly expenses in a spreadsheet and want to calculate the total. Which function would you use?

• SUM

• COUNT

• AVERAGE

• MAX

A spreadsheet contains hundreds of rows of data. How can you quickly identify rows where the value in one column exceeds a certain number?

• Sort by Column

• Use Conditional Formatting

• Apply Data Validation

• Use Filter

You are creating a chart in a spreadsheet to compare sales over the past year. Which chart type is most suitable for showing trends over time?

• Pie Chart

• Line Chart

• Bar Chart

• Scatter Plot

A team member accidentally deletes a formula in your spreadsheet. Which feature can you use to restore the original formula?

• Undo

• AutoRecover

• Formula Bar History

• Paste Special

You need to analyze sales data for multiple regions stored in separate sheets. Which function allows you to summarize data across these sheets?

• VLOOKUP

• CONCATENATE

• SUMIF

• 3D References