Coa August 2023 Qa

1 https://cceindia.
india.in COA Theory Book , Record Guide & Practical Record Note with Full Free Video Classes Available
2652
August 2023
(Maximum Marks: 100)
Time-Two Hours
[N.B: Answer all Questions.]
I. Fill in the blanks: Marks: 10x1=10
1. The second-generation computers were developed by using transistors
2. A Network interface card (NIC) is a computer hardware component that connects a

computer to a computer network.
3. Operating System (OS) is a program that acts as an interface between the user and the
hardware.
4. A dialog box is a temporary window that an application creates to retrieve user input.
5. A line spacing is the distance between two lines in MS Word.
6. AutoCorrect is a feature used mainly to make automatic corrections during document

typing in Writer.
7. Spreadsheet is a collection of cells organized in rows and columns in Calc.
8. The default extension of OpenOffice Base file is. .odb.
9. In PowerPoint, the object on the slide used to hold the text are called as text boxes.
10. BCC in email stands for Blind Carbon Copy.
II. Match the following: Marks: 10x1=10

1. Supercomputer a. Website address (10)
2. Input device b. Redo (5)
3. RTOS c. $A$1 (6)
4. Rmdir d. Oil and gas exploration (1)
5. Ctrl+Y e. Database (7)
6. Absolute cell reference f. Bing (9)
7. Base g. Robot (3)
8. OpenOffice Impress h. Graphics tablet (2)
9. Search Engine i. Remove directory (4)

1
10. URL j. Presentation software(8)
Creative Computer Education | COA Theory Book, Practical Guide & Practical Record Note order Now https://cceindia.in
2 https://cceindia.in COA Theory Book , Record Guide & Practical Record Note with Full Free Video Classes Available
III. Choose the best answer: Marks: 10x1=10

1. Which memory device or storage medium that stores information temporarily?
a. RAM b. ROM C. PROM d. EPROM
2. 1024 Bytes is equal to
a. 1 GB b. 1 MB c. 1 KB d. 1 TB
3. Which of the following is an area at the bottom of a primary window that displays information
about the current window's state?
A. STATUS BAR b. scroll bar c. menu bar d. title bar
4. Which command is used to move a file or a directory from one location to another in Linux?
a. move B. MV C. CP d. wc
5. Where the ruler is located in MS-Word?
A. VIEW b. review c. design d. insert
6. Which of the following means the page is oriented horizontally in OpenOffice Writer?
A. LANDSCAPE b. Portrait c. Margin d. Indent
7. Which shortcut key is used to go to the formula tab in MS Excel?
A. ALT+M b. Alt+F c. Ctrl+F d. Ctrl+M
8. In OpenOffice Calc, colon represents which of the following. operator.
a. Arithmetic operator B. RANGE REFERENCE OPERATOR
c. Text operator d. Relational operator
9. In a presentation of PowerPoint, the special effects used to introduce slides are known as?
a. Animations b. Effects C. TRANSITION d. Annotations
10. Which of the following is not a social networking site?
a . Youtube b. Whatsapp c. Linkedin D. AOL
IV. Say TRUE or FALSE: Marks: 10x1=10
1. Versatility refers to the capability of a computer to perform different kinds of works with
same accuracy and efficiency. (True)
2. EEPROM stands for Electrically erasable programmable read only memory. (True)
3. cp command is used to change the current directory. (False)
4. Booting is the process of starting a computer. (True)
5. Regular is not a font style in MS Word. (False)
6. Ctrl+H is a keyboard shortcut key to center cell contents in Excel. (False)
2
7. Formula should begin with an = sign in Calc. (True)
8. In Base, a field is an attribute of a record in a database table. (True)
9. Blank slide is the default standard layout in PowerPoint. (False)
10. A tablet is a portable computing device with a larger screen than a smartphone. (True)
V. Write short answers for any Fifteen Questions from the following: Marks: 15x2=30
1. List out the from the applications of computer?
Communication: Computers enable seamless communication through email, instant
messaging, and video conferencing, connecting people globally.
Information Retrieval: Computers facilitate quick access to vast amounts of information
via the internet, aiding research and knowledge acquisition.
Automation: Computers streamline tasks in industries like manufacturing, allowing efficient
production and reduced human intervention.
2. Write the difference between XT and AT systems?
XT and AT systems refer to two generations of IBM-compatible personal computers:
Form Factor: XT (eXtended Technology) systems were introduced in the 1980s with a
larger chassis and a more limited architecture, while AT (Advanced Technology) systems,
introduced later, featured a more compact form factor and improved expandability.
Processor and Performance: XT systems typically used the Intel 8088 processor with
slower clock speeds, while AT systems adopted the more powerful Intel 80286 processor,
offering enhanced multitasking capabilities and overall performance.
Expansion and Interfaces: AT systems introduced the AT bus, providing better expansion
options and support for peripherals compared to the XT's limitations, making AT systems
more versatile for professional and business use.
3. Write about device management of operating system?
Device management in an operating system involves controlling and coordinating
hardware resources such as I/O devices. It includes driver management for efficient
communication, allocation of devices to processes, and handling device errors to ensure stable
and reliable system operation. Proper device management enhances system performance and
user experience.
4. What are the types of booting?
 Cold Boot: Starting a computer from a powered-off state.
 Warm Boot: Restarting a computer without turning off the power.
 Dual Boot: Choosing between two different operating systems during startup.
 Network Boot: Booting an operating system over a network connection.
 Fast Boot: Optimizing startup by saving system state during shutdown.
 Safe Mode Boot: Starting with minimal drivers and services for troubleshooting.
 Recovery Boot: Accessing recovery options after encountering a system failure.
5. What is the purpose of wall command in Linux?
The wall command in Linux serves to broadcast messages or notifications to all currently
3 logged-in users on a system simultaneously, making it useful for system-wide announcements,
alerts, or coordination. It allows administrators to quickly convey important information and ensure
that all users receive the message in real-time. This command is especially valuable in urgent
situations or when immediate attention is needed from all users.
6. Write the steps to change page size in MS word?
To change page size in MS Word:

Open Page Setup: Click on the "Layout" or "Page Layout" tab in the Ribbon, then click
"Size" and choose "More Paper Sizes."
Select New Size: In the Page Setup dialog, pick a predefined size from the list or specify
custom dimensions, adjusting width and height as needed.
Apply Changes: Click "OK" to apply the new page size to your document, adjusting
content and layout accordingly.
7. What is the use of clipboard in MS word?
The clipboard in MS Word serves as a temporary storage space for copied or cut content,
such as text, images, or objects. It allows users to easily move or duplicate content within the
document or between different documents. By providing a way to temporarily hold data, the
clipboard facilitates efficient editing, formatting, and rearranging of content without the need for
repeated copying and pasting.
8. How to add styles to document in Writer?
To add styles to a document in LibreOffice Writer:
Open Styles Pane: Go to the "Styles and Formatting" pane (F11) or use the "Styles" option
in the sidebar, displaying available styles.
Apply Styles: Select the desired text or element, then click on a style (e.g., Heading,
Paragraph) to apply it. Alternatively, right-click and choose "Update Style" to modify a style
based on the selected content.
Create Custom Styles: To create custom styles, modify an existing style, right-click on it,
and choose "New." Adjust formatting attributes like font, alignment, and spacing, then name
and save the new style for consistent document formatting.
9. Mention the simplest method of copy paste in MS Excel?

The simplest method of copy-paste in MS Excel:
1. Select Content: Highlight the cells or content you want to copy.
2. Copy: Right-click and choose "Copy" or use the keyboard shortcut Ctrl + C.
3. Paste: Right-click on the destination cells and select "Paste" or use the keyboard shortcut
Ctrl + V to paste the copied content.
10. Write the simple steps to create pivot table in MS Excel?

To create a pivot table in MS Excel:
1. Select Data: Highlight the data range you want to analyze.
4 2. Insert PivotTable: Go to the "Insert" tab, click "PivotTable," choose the data range, and
specify where you want to place the pivot table.
3. Customize PivotTable: Drag and drop fields into the "Rows" and "Values" areas, and
apply functions like sum or count. Excel automatically generates a pivot table, summarizing
and analyzing your data with flexibility.
11. What is the purpose of text operator in Calc?

The text operator '&' in LibreOffice Calc serves to concatenate or combine text strings from
different cells or sources. It allows users to merge text content while preserving formatting and
spacing. By using '&' between text elements or cell references, users can create meaningful and
customized strings for labels, headings, or data representation within spreadsheets.
12. How to create a new table in a new database in MS Access?
To create a new table in a new database in MS Access:
1. Open Access: Launch Microsoft Access and click "Blank Database," specifying a name
and location for the new database file.
2. Navigate to Tables: In the new database, go to the "Tables" tab in the navigation pane and
click "Table Design" to open the table designer.
3. Design Table: Add fields with their data types, set primary keys, define relationships, and
save the table. The new table is now part of the newly created database.
13. What is dynamic report in Base?

A dynamic report in LibreOffice Base is a responsive and adaptable document that pulls
data from a database, enabling real-time customization of content, filters, sorting, and grouping.
This empowers users to generate versatile reports without altering the original data, enhancing
data analysis and presentation capabilities. Dynamic reports offer a dynamic and interactive
approach to effectively communicate insights and information.
14. How to change slide layout in MS PowerPoint?
To change slide layout in MS PowerPoint:
1. Select Slide: Right-click on the slide thumbnail in the slide pane or use the "Slides" tab on
the left to choose the slide you want to modify.
2. Change Layout: Go to the "Slide" tab in the Ribbon, click "Layout," and select a new layout
from the dropdown menu.
3. Apply Changes: The slide's content will adjust to the new layout while preserving existing
content, allowing quick and easy design modifications.
15. How text can be added to the presentation in PowerPoint?

To add text to a presentation in PowerPoint:
1. Click Text Box: From the "Insert" tab, select "Text Box," then click on the slide where you
want to add text.
2. Type or Paste: Enter or paste your desired text into the text box. Use formatting options in
the Ribbon to style the text.
3. Resize and Position: Adjust the text box's size and position as needed, and use the
5
handles to resize or reposition it, ensuring effective content placement in your presentation.
16. How to create slide masters in Impress?

To create slide masters in LibreOffice Impress:
1. Access Master View: Click "View" and select "Master Slide" to enter Master View, where
you can manage slide layouts.
2. Modify Master Slide: Customize elements like background, fonts, and placeholders on the
master slide, affecting all slides using that layout.
3. Apply and Save: Exit Master View to apply changes to your presentation. Save the file to
retain the modified slide master for consistent design across your slides.
17. Define web browser?
The web browser is an application software to explore www (World Wide Web). It provides
an interface between the server and the client and requests to the server for web documents and
services. It works as a compiler to render HTML which is used to design a webpage. Whenever
we search anything on the internet, the browser loads a web page written in HTML, including text,
links, images, and other items such as style sheets and JavaScript functions. Google Chrome,
Microsoft Edge, Mozilla Firefox, Safari are examples of web browsers.
18. What is WAN?

A Wide Area Network (WAN) is a network that covers a broad geographical area, often
spanning multiple cities, countries, or continents. It connects various local networks (LANs) and
remote devices, enabling data and communication exchange over long distances through leased
lines, satellites, or public networks. WANs play a vital role in facilitating global connectivity and
efficient information sharing among widely dispersed locations.
VI. Write answers for either (a) or (b) of all questions in detail: Marks: 6x5=30
1. a. Explain about Motherboard and SMPS.

Motherboard: A motherboard is the main circuit board of a computer, serving as a central
hub for connecting various hardware components. It houses the CPU, RAM, storage devices, and
provides slots, connectors, and sockets for peripherals like graphics cards, sound cards, and
more. The motherboard facilitates communication and data transfer between these components,
acting as the backbone of a computer system.
SMPS (Switched-Mode Power Supply): An SMPS is a power supply unit that converts
and regulates electrical power from an external source (e.g., wall outlet) into the appropriate
voltage levels required by a computer's internal components. It uses switching regulators to
efficiently provide power to the motherboard, CPU, drives, and other hardware. SMPS units are
crucial for delivering stable and reliable power to ensure the proper functioning of the computer
system while minimizing heat generation and energy wastage.
(Or)
b. Explain connecting ports in computer.
Connecting Port
 The LPT Port which stands for Line Printer Port

 Parallel Port uses a 25-pin connector (Type DB-25) and is used to connect printers,
computers and other devices that need relatively high bandwidth.
 The Serial Port which may also be called a mouse port
 The USB Port which stand for Universal Serial Bus
 The Game Port which can be used for a joy stick
1. A) Write the steps to add header and footer in a word document in MS Word.
Certainly! Here's a detailed step-by-step guide on how to add a header and footer in a Word
document in MS Word:
Open Your Document:
Launch Microsoft Word and open the document you want to add a header and footer to.
Access the Header/Footer Area:
Click on the "Insert" tab in the Ribbon at the top of the window.
In the "Header & Footer" group, you'll find the "Header" and "Footer" options. Click on either
"Header" or "Footer," depending on where you want to add content.
7
Choose a Header/Footer Template:
A dropdown menu will appear with a selection of built-in header and footer templates. You
can choose from options like "Blank," "Simple," "Elegant," and more. Select the template that best
suits your needs.

Edit Header/Footer Content:
Once you've selected a template, you'll be taken to the header/footer area of the document.
Here, you can see a dotted line indicating the boundary of the header/footer.
Click within the header/footer area to start adding content. You can type text, insert images,
add page numbers, dates, and other elements.
Formatting and Customization:
Use the "Header & Footer Tools" Design tab that appears on the Ribbon when you're in the
header/footer area. This tab provides various options for formatting and customizing your
header/footer content.
You can change font styles, sizes, colors, add borders, adjust alignment, and more.
Different First Page or Odd/Even Pages:
If you want different headers/footers for the first page, odd pages, or even pages, you can
check the respective options in the "Header & Footer Tools" Design tab.
Insert Page Numbers:
To insert page numbers, click the "Page Number" button in the "Header & Footer" group on
the
"Insert" tab. You can choose where you want the page numbers to appear within the
header/footer.
Save and Close Header/Footer:
Once you're satisfied with your header/footer content and formatting, you can simply
double-click outside the header/footer area or click the "Close Header and Footer" button on the
"Header & Footer Tools" Design tab.
Preview Header/Footer:
You can switch to "Print Layout" view or use "Print Preview" to see how your header/footer
will appear when printed.
Save Your Document:
Don't forget to save your document after adding and customizing the header/footer.
Your document now has a header and footer that will be applied to each page, adding a
professional and consistent touch to your content.
(Or)
2. b). Explain about creating tables in OpenOffice Writer.
8 Certainly! Here's a detailed step-by-step guide on how to create tables in LibreOffice Writer, which
is similar to OpenOffice Writer:
Open LibreOffice Writer:
Launch LibreOffice and open a new or existing document in Writer where you want to create a
table.
Insert Table:
Place the cursor at the location in the document where you want to insert the table.
Go to the "Table" menu in the top menu bar and select "Insert"  "Table."
Specify Table Size:
In the "Insert Table" dialog box that appears, specify the number of rows and columns you want
for your table. You can also set the table width and enable options like "AutoFormat" if desired.
Click "OK" to create the table.
Add Data to Cells:
The table will be inserted into your document. Click inside a cell to start adding text or data. Press
Tab to move to the next cell or Enter to move to the next row.
Formatting and Customization:
Use the options in the "Table" menu and the "Table Format" toolbar to format and customize your
table. You can change cell borders, background colors, alignment, and more.
You can also access advanced table formatting options by right-clicking on the table and selecting
"Table."
Inserting Rows and Columns:
To insert a new row above the current row or a new column to the left of the current column, right-
click on a cell and choose "Insert"  "Rows Above" or "Insert"  "Columns Left."
You can also use the "Table" menu for these options.
Merging and Splitting Cells:
To merge cells, select the cells you want to merge, right-click, and choose "Merge Cells."
To split cells, select a cell or cells, right-click, and choose "Split Cells."
Deleting Rows and Columns:
To delete a row or column, select the row or column, right-click, and choose "Delete Rows" or
"Delete Columns."
Adjusting Table Properties:
Right-click on the table and select "Table Properties" to access additional settings like table
borders, spacing, and alignment.
Save Your Document:
Don't forget to save your document after creating and formatting your table.
9 Creating tables in LibreOffice Writer allows you to organize and present data in a structured
manner within your documents.
3. a) Write the steps to apply border and shading to table in MS Excel.?

detailed step-by-step guide on how to apply borders and shading to a table in MS Excel:
Open Excel and Create Table:
Launch Microsoft Excel and open the worksheet containing the table you want to format.
If you don't have a table yet, create one by entering data in rows and columns.
Select the Table:
Click anywhere within the table to select it. Alternatively, you can click on a cell within the table
and then use the keyboard shortcut Ctrl + A to select the entire table.
Open the Border Options:
Go to the "Home" tab in the Ribbon at the top of the Excel window.
In the "Font" group, you'll find the "Borders" button (it looks like a square with lines around it). Click
on the drop-down arrow next to it.
Choose Border Style:
A menu will appear with various border style options. Select the style you want for your table. You
can choose from options like "All Borders," "Outside Borders," or customize borders for individual
cells.
Apply Border:
After selecting the desired border style, move your cursor over the edge of the table to see a
preview of the border.
Click to apply the selected border style to the entire table or the selected cells.
Open the Fill Color Options:
If you also want to apply shading to the table cells, click the "Fill Color" button next to the "Borders"
button in the "Font" group.
Choose Fill Color:
A color palette will appear. Select the color you want to use as shading for the table cells. The
selected color will be applied as background to the cells.
Apply Shading:
After selecting the fill color, the shading will be applied to the selected cells in the table.
Fine-Tune Border and Shading:
If you want to customize the border or shading further, you can right-click on the table and choose
"Format Cells."
In the "Format Cells" dialog box, go to the "Border" or "Fill" tabs to adjust line styles, colors, and
1 shading options.
0 Click OK and Save:
Once you're satisfied with the border and shading settings, click the "OK" button in the "Format
Cells" dialog box to apply the changes.
Don't forget to save your Excel worksheet.

Your table will now have the applied borders and shading, enhancing the visual presentation of
your data.
(Or)
3. b). How to work with multiple sheets in Calc.

Working with multiple sheets in LibreOffice Calc allows you to organize and manage data
effectively within a single spreadsheet file. Here's a detailed guide on how to work with multiple
sheets:
Open LibreOffice Calc:
Launch LibreOffice and open a new or existing spreadsheet document.
Adding New Sheets:
By default, a new Calc document starts with one sheet named "Sheet1." To add more sheets:
Click the "+" button at the bottom-left corner of the sheet tabs. This creates a new sheet with a
default name like "Sheet2," "Sheet3," and so on.
Right-click on an existing sheet tab, select "Insert Sheet," and choose the position where you want
the new sheet to be inserted.
Renaming Sheets:
Double-click on a sheet tab to activate the renaming mode, then enter the desired name for the
sheet and press Enter.
Navigating Between Sheets:
Click on the tabs at the bottom of the window to switch between different sheets.
You can also use the keyboard shortcut Ctrl + Page Up or Ctrl + Page Down to navigate to the
previous or next sheet, respectively.
Copying and Moving Sheets:
Right-click on a sheet tab and choose "Move/Copy Sheet" to move or copy a sheet within the
same document or to another document.
Use the options in the "Move/Copy Sheet" dialog box to specify the target location and whether
you want to copy or move the sheet.
Grouping Sheets:
To perform actions on multiple sheets simultaneously, you can group them:
Hold down the Ctrl key and click on the sheet tabs you want to group.
Right-click on one of the selected tabs and choose "Group Sheets."
1 Actions like formatting, entering data, or applying formulas will affect all grouped sheets.
1
Linking Cells Between Sheets:
You can reference cells from one sheet in another sheet using cell references. For example, to
refer to cell A1 in "Sheet2" from "Sheet1," type Sheet2.A1 in a cell on "Sheet1."
Using Formulas Across Sheets:

To calculate across multiple sheets, include the sheet name in formulas. For instance,
SUM(Sheet2.A1:Sheet2.A10) will sum cells A1 to A10 in "Sheet2."
Hiding and Unhiding Sheets:
Right-click on a sheet tab and select "Hide Sheet" to hide a sheet. Hidden sheets are still
accessible but not visible.
To unhide a sheet, right-click on any visible sheet tab, select "Unhide Sheets," and choose the
sheet you want to unhide.
Save Your Document:
After making changes to multiple sheets, don't forget to save your Calc document.
Working with multiple sheets in LibreOffice Calc allows you to efficiently manage and analyze data
across different sections of a single spreadsheet file.
4. a). Write the steps to create queries in Base
Creating queries in LibreOffice Base allows you to retrieve and manipulate data from your
database tables. Here's a detailed guide on how to create queries:
Open LibreOffice Base:
Launch LibreOffice and open the database file you want to work with.
Open the Query Design View:
In the main Base window, click on the "Queries" icon in the left-hand panel.
Click on the "Create Query in Design View" option.
Add Tables:
In the "Add Table" dialog that appears, select the tables you want to include in your query and
click "Add."
Close the dialog when you're done.
Arrange Tables and Fields:
You'll now see the Query Design View with the selected tables shown as boxes. Drag and drop
fields from the tables onto the design grid.
Join tables by connecting related fields with a line (click and drag from one field to another).
Specify Query Criteria:
In the criteria row below each field, specify the conditions for your query. For example, you can
1 use operators like "=", "<>", ">", "<", etc., along with values.
2
For more complex criteria, use the "Expression" field to create calculations or combine multiple
conditions.
Add Sorting:
To sort the query results, click in the "Sort" row below the field you want to sort by. Select
ascending or descending order.
Choose Output Fields:
In the "Output" row, mark the checkbox for each field you want to appear in the query results.
Run the Query:
Click the "Run Query" button (looks like a green checkmark) to execute the query. The results will
be displayed in a new tab.
Save the Query:
To save the query, go to "File"  "Save" in the Query Design View. Give your query a name and
choose a category if desired.
Modify and Refine:
You can always go back to the Query Design View to modify or refine your query. Make changes
to criteria, sorting, and output fields as needed.
Close and Use Query:
Close the Query Design View when you're satisfied with the query results.
You can now use this query to retrieve specific data from your database whenever needed.
Save the Database:
Don't forget to save your database file after creating and saving the query.
Creating queries in LibreOffice Base helps you retrieve and analyze data efficiently, enabling you
to extract meaningful insights from your database.
(Or)
4. b. Explain in detail about adding transition effect to the presentation in MS PowerPoint.
Adding transition effects to a presentation in MS PowerPoint enhances the visual appeal
and professionalism of your slides during a slide show. Here's a detailed guide on how to add
transition effects:
Open PowerPoint and Create Slides:
Launch Microsoft PowerPoint and open the presentation you want to work on.
Create or edit the slides where you want to apply transition effects.
Access Slide Transition Options:
Go to the "Transitions" tab in the Ribbon at the top of the PowerPoint window.
1
3 Choose a Transition Effect:
In the "Transition to This Slide" group, you'll see a variety of transition effect thumbnails.
Click on a thumbnail to preview the effect on the currently selected slide.
Customize Transition Options:

After selecting a transition effect, click on the "Effect Options" button in the "Transition to This
Slide" group.
A menu will appear with options to customize the chosen effect. For example, you can adjust the
direction, speed, or sound associated with the transition.
Apply Transition to All Slides (Optional):
If you want to apply the same transition effect to all slides, click the "Apply to All Slides" button in
the "Transition to This Slide" group.
Add Sound to Transition (Optional):
To add a sound effect to the transition, click on the "Sound" dropdown menu in the "Timing" group.
Choose a sound effect or select "Other Sound" to use a custom sound file.
Preview Transition Effects:
To preview the transition effects, click the "Preview" button in the "Preview" group. This allows you
to see how the transitions will appear during the slide show.
Slide Advance Timing:
In the "Advance Slide" group, you can set the timing for slide advancement. Choose options like
"On Mouse Click" or "After" and specify the time duration.
Apply Different Transition to Individual Slides (Optional):
You can apply different transition effects to individual slides. Select a slide, choose a transition
effect, and customize its options.
Save and Play the Slide Show:
Once you've added transition effects to your slides, save your PowerPoint presentation.
Click the "Slide Show" button in the bottom-right corner to start the slide show and see the
transition effects in action.
Advance Slides in Slide Show:
During the slide show, advance the slides by clicking the mouse, pressing the spacebar, or using
arrow keys, depending on the slide advance setting you've chosen.
Exit Slide Show:
To exit the slide show, press the Esc key or right-click and choose "End Show."
Adding transition effects to your PowerPoint presentation creates engaging visual transitions
between slides, making your presentation more dynamic and captivating for your audience.
1 5. a). Explain the operations that can be performed on an e-mail.

4 Operations that can be performed on an email include:
1. Go to the Gmail website.
2. At the bottom of the sign in screen, click the link.
3. On the account creation screen, fill out all the fields (A) and then click Next (B)
4. On the next screen, fill out your birth date and gender (A) and any other information
you are comfortable with, then click Next (B).
5. Read Google's Privacy and Terms, then click the button.
6. Click the button until you've moved through the features menu.
7. Click the button, allowing you to access your new account.
Composing and Sending Email
Before sending an email, we need to compose a message. When we are composing
an email message, we specify the following things:
● Sender‘s address in To field
● Cc (if required)
● Bcc (if required)
● Subject of email message
● Text
● Signature
You should specify the correct email address; otherwise it will send an error back to
the sender.
Once you have specified all the above parameters, It‘s time to send the email. The
mailer program provides a Send button to send email, when you click Send, it is sent
to the mail server and a message mail sent successfully is shown at the above.
Addressing with cc and bcc
CC and BCC are two fields that sit next to or below the ―To field at the top of any new message
you compose in your inbox. CC stands for ―Carbon Copy and BCC stands for
―Blind Carbon Copy . All are used to add the email addresses of the people you wish
to send your message to. However, they differ significantly in their usage.
To CC BCC
Primary contact/s Secondary contact/s Tertiary contact/s
Used for emailing Used for emailing individual Used for emailing
individual or or individual or
multiple contacts multiple contacts multiple contact
Email addresses viewable Email addresses viewable Email addresses viewable
by by all only
All by the sender
2. Add Signatures: Include a custom signature at the end of your emails.

3. Receive: Retrieve incoming emails from the server into your email client's inbox.
4. Reply: Respond to an email you received by sending a message back to the original
sender.
5. Reply All: Respond to an email and include all recipients of the original email.
6. Forward: Share an email with other recipients, not in the original conversation.
1 7. Delete: Remove unwanted emails from the inbox.
5
8. Move: Organize emails by moving them to folders or labels.
9. Attach Files: Include files as attachments in your email.
10. Download Attachments: Save files attached to received emails.

11. Print: Generate a hard copy of the email's content.
12. Forward as Attachment: Send an email as an attachment to another recipient.
These operations enable effective communication, organization, and management of emails in
both personal and professional contexts.
(or)
5. b. Write the applications of Google Sheets and Explain.
Applications of Google Sheets include:
Editing
One of the key features of Google Sheets is that it allows collaborative editing of spreadsheets in
real-time. Rather than emailing one document to multiple people, a single document can be
opened and edited by multiple users simultaneously. Users can see every change made by other
collaborators, and all changes are automatically saved to Google servers. Google Sheets also
includes a sidebar chat feature that allows collaborators to discuss edits in real-time.
Explore
The Explore feature in Google Sheets was first introduced in September 2016, and it uses
machine learning to bring additional functionalities. This feature provides a lot of information based
on the data added to the spreadsheet, and it can auto-update itself depending on the selected
data. With the Explore feature, users can ask questions, build charts, visualize data, create pivot
tables, and format the spreadsheet with different colors.
Offline editing
Google Sheets supports offline editing, and users can edit the spreadsheet offline either on
desktop or mobile apps.
Supported file formats
Google Sheets supports multiple spreadsheet file formats and file types. Users can open, edit,
save or export spreadsheets and document files into Google Sheets. Some of the formats that can
be viewed and converted to Google Sheets include: .xlsx, .xls, .xlsm, .xlt, xltx, .xltxm, .ods, .csv,
.tsv
Integration with other Google products
Google Sheets can be integrated with other Google products such as Google Form, Google
Finance, Google Translate, and Google Drawings. For example, if you want to create a poll or
questionnaire, you can input the questions in Google Forms, and then import the Google Forms
into Google Sheets.
1
6

Coa August 2023 Qa

Uploaded by

Copyright:

Available Formats

Coa August 2023 Qa

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Coa August 2023 Qa

Uploaded by

Copyright:

Available Formats

1 https://cceindia.

2. A Network interface card (NIC) is a computer hardware component that connects a

5. A line spacing is the distance between two lines in MS Word.

6. AutoCorrect is a feature used mainly to make automatic corrections during document

7. Spreadsheet is a collection of cells organized in rows and columns in Calc.

8. The default extension of OpenOffice Base file is. .odb.

10. BCC in email stands for Blind Carbon Copy.

II. Match the following: Marks: 10x1=10

2. Input device b. Redo (5)

3. RTOS c. $A$1 (6)

4. Rmdir d. Oil and gas exploration (1)

5. Ctrl+Y e. Database (7)

6. Absolute cell reference f. Bing (9)

7. Base g. Robot (3)

8. OpenOffice Impress h. Graphics tablet (2)

9. Search Engine i. Remove directory (4)

III. Choose the best answer: Marks: 10x1=10

6. Write the steps to change page size in MS word?

To change page size in MS Word:

9. Mention the simplest method of copy paste in MS Excel?

10. Write the simple steps to create pivot table in MS Excel?

and analyzing your data with flexibility.

11. What is the purpose of text operator in Calc?

13. What is dynamic report in Base?

15. How text can be added to the presentation in PowerPoint?

16. How to create slide masters in Impress?

17. Define web browser?

18. What is WAN?

1. a. Explain about Motherboard and SMPS.

 The LPT Port which stands for Line Printer Port

suits your needs.

3. a) Write the steps to apply border and shading to table in MS Excel.?

Don't forget to save your Excel worksheet.

3. b). How to work with multiple sheets in Calc.

Using Formulas Across Sheets:

4. a). Write the steps to create queries in Base

Customize Transition Options:

1 5. a). Explain the operations that can be performed on an e-mail.

2. Add Signatures: Include a custom signature at the end of your emails.

10. Download Attachments: Save files attached to received emails.

You might also like