Chapter 1
Which of the following is not part of the computer?
A) CPU
B) C Drive
C) Hard disk
D) Scanner
D) Scanner
What is GUI (Graphical User Interface)
GUI (Graphic User Interface) is a set of images and icons seen on the desktop used to operate a program.
The following are the common uses of Word Processing Software except:
A) Document Creation
B) Spell Check and Grammar
C) Editing and Formatting
D) Conditional Formatting
D) Conditional Formatting
What is a psreadsheet?
Developed to do financial computations in a page layout
Similar to a bookkeeper’s ledger
Rows and columns of numerical data
But different
Stores formulas as well
Identify the software which belongs to productivity software.
A) Microsoft Excel
B) Microsoft Teams
C) Google Drive
D) Adobe Photoshop
D)
A) Microsoft Excel
What is Random Access Memory (RAM)?
stores data that is processing.
This type of memory is erased when the computer is turned off.
Notepad is a word processor.
True or False
False. It is a simple text editor.
Which of the is NOT the features of spreasheet (Microsoft Excel or Google Sheets)?
A) Calculate the SUM
B) Filtering the information
C) Merge the cells
D) Merge the mail
D) Merge the mail
Provide any 2 types of Email Clients. Explain one of them.
1. Web-Based Email Clients:
•These allow you to access your emails directly through a web browser.
•Examples include Gmail, Yahoo Mail, and Outlook.com.
•They are convenient as they don't require any software installation and can be accessed from any device with an internet connection
2. Desktop Email Clients:
•These are applications installed on your computer. They often offer more advanced features and offline access.
•Examples include Microsoft Outlook, Mozilla Thunderbird, and Apple Mail
3. Mobile Email Clients:
•Designed specifically for smartphones and tablets, these clients allow you to manage your emails on the go.
•Examples include Gmail app, Outlook app, and Apple Mail app.
4. Command-Line Email Clients:
•These are for users who prefer using the command line interface.
•They are lightweight and efficient, suitable for those comfortable with text commands. Examples include Mutt and Alpine
5. Specialized Email Clients:
•These are designed for specific needs, such as high volumes of email or enhanced security.
•Examples include Spark for managing large volumes of email and ProtonMail for encrypted email communication.
What are peripherals and provide at least 1 example of peripheral.
Peripherals are devices that plug into a computer and are not housed internally.
Examples :
Printers
Scanners
Cameras
Provide TWO (2) Word Processing file formats and explain each of them.
1. .docx - The default Word document format.
2. .pdf - Portable Document Format, useful for sharing documents while preserving formatting.
3. .rtf - Rich Text Format, compatible with many word processors.
4. .txt - Plain Text Format, which contains no formatting.
5. .html - HyperText Markup Language, used for creating web pages.
6. .odt - OpenDocument Text, an open standard for word processing files.
7. .doc - Word 97-2003 Document, compatible with older versions of Word.
8. .docm - Word Macro-Enabled Document, which can contain macros.
9. .dotx - Word Template, used for creating new documents with predefined settings.
10. .dotm - Word Macro-Enabled Template, similar to .dotx but can include macros.
11. .xml - Word XML Document, which saves the document in XML format.
12. .mht / .mhtml - Single File Web Page, which saves the document as a single web page file.
When multiple cells are selected, we can
__________
__________
__________
__________
__________
Change the format for all these cells
Merge these cells
Copy/cut the contents and paste elsewhere
Delete the contents of all these cells
- This the program you use to access the world wide web, eg Microsoft Edge, Firefox, Google Chrome, Safari
- allows you to navigate to sites and access resources.
-contains a text entry line for the URL (web address).
A web browser
Computer chips contain millions of _____________. Fill in the blank.
transistors
I am measured in points. My measure starts from point 8 until 72. Who am I?
Font Size.
Sometimes filling a formula doesn't do what we expect. Why?
A formula contains addresses of other cells.
Normally these are relative addresses which get altered when we fill the formula.
Sometimes we want these to be absolute addresses so that they don't change when we fill the formula. Put $ into addresses.
X - This is the process of organizing, storing, and handling computer files in a way that makes them easy to find, access, and modify.
Name X.
File management
Fast recording and recovery of data
Large storage capacity
Storage for data and programs
Speed is measured in R.P.M (Revolutions Per Minute)
Identify the device which has the above characteristics
Data Storage Device (Hard Drive)
How can you create a structured documents?
•Heading Levels
•Plan your document
•Hierarchy
•Cross-references
•Table of Contents
L - A horizontal group of cells, identified by numbers on the left side of the worksheet.
M - The area above the worksheet where you can enter or edit data or formulas in the selected cell.
N - A graphical representation of data in your worksheet, such as a bar chart or pie chart.
Find the answer.
L - Row
M - Formula Bar
N - Chart