GR11 Typo Final Exam notes

What role do computers play in modern life?

Computers assist in various tasks such as document creation, data analysis, and presentations.

What is an Operating System (OS)?

The software that manages computer hardware and software resources, providing an interface between the user and the computer.

Name two functions of an Operating System.

Process Management and Memory Management.

What are key features of MS Excel?

Functions and Formulas, Charts, Sorting and Filtering, Conditional Formatting, and Data Validation.

What does the SUM() function do in Excel?

It adds values in a specified range, e.g., =SUM(B2:B6).

How do you create a pie chart in Excel?

A pie chart represents data as segments of a circle, ideal for showing proportions.

What is conditional formatting in Excel?

A feature that highlights cells based on certain conditions, such as turning negative values red.

What is a key use of MS Word?

To create, edit, and format documents like reports, letters, resumes, and essays.

How do you insert a hyperlink in MS Word?

Select the text or image, go to Insert → Hyperlink or press Ctrl + K, enter the URL or file path, then click OK.

What is Mail Merge in MS Word?

A process that automates sending bulk emails or letters by merging a document with data from a spreadsheet or database.

What features are included in the formatting tools of MS Word?

Font Styles, Paragraph Settings, and Tables.

What is the purpose of MS PowerPoint?

To create engaging presentations that can include multimedia elements.

What are transitions and animations in PowerPoint?

Transitions are effects applied between slides, while animations are effects applied to text and objects.

What is the Central Processing Unit (CPU)?

The brain of the computer that processes instructions and performs calculations.

Name two types of storage devices.

Hard Disk Drive (HDD) and Solid State Drive (SSD).

What is a USB port used for?

Connecting pen drives, external hard drives, and keyboards to the computer.

What is the function of the Control Panel in Windows?

It allows users to manage system settings, including hardware configuration and user accounts.

What is one best practice for maintaining cybersecurity?

Use strong passwords and update them regularly.

What can SmartArt in PowerPoint be used for?

To create professional-looking diagrams to show hierarchies, processes, relationships, and cycles.

What does filtering do in Excel?

Allows users to display only rows that meet specific criteria, helping analyze large datasets.