CSC134 - Quiz 1

Which feature in Microsoft Word allows you to automatically generate a table of contents for your document?

• Styles

• Track Changes

• Mail Merge

• References

Which of the following tools in Microsoft Word can be used to combine the contents of a database with a document to create personalized letters, labels, or envelopes?

• Template

• Mail Merge

• Macro

• Formulas

What is the primary purpose of using templates in Microsoft Word?

• To provide a starting point with pre-designed formats and structures for various types of documents.

• To record and automate repetitive tasks within a document

• To track changes made by multiple users in a document.

• To ensure that all text in the document is properly aligned and spaced.

What is the primary difference between hardware and software in a computer system?

• Hardware is tangible and physical; software is intangible and consists of code.

• Hardware can be updated easily; software cannot.

• Hardware refers to data; software refers to applications.

• Hardware is the same across all computers; software varies.

Which of the following is a primary function of an operating system?

• Word processing

• Spreadsheet calculations

• • Managing hardware resources

• Web browsing

What is the primary function of the VLOOKUP formula in Microsoft Excel?

• To sum a range of cells

• To find and retrieve data from a specific column in a table

• To count the number of non-empty cells in a range

• To calculate the average of a range of cells

Which feature in Microsoft Excel allows you to create a visual representation of your data using bars, lines, or other shapes?

• Pivot Table

• Conditional Formatting

• Chart

• Data Validation

Which function in Microsoft Excel is used to calculate the total number of cells in a range that meet a specified condition?

• SUMIF

• COUNTIF

• AVERAGEIF

• IFERROR

Which feature in Microsoft Excel allows you to automatically format cells based on the values they contain?

• Pivot Table

• Conditional Formatting

• Data Validation

• Filter

Which of the following views in Microsoft PowerPoint allows you to see all the slides in your presentation as thumbnails?

• Normal View

• Slide Sorter View

• Reading View

• Outline View