Computer Applications Revision
61 Questions
0 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What is the purpose of the first session in Semester 2 Computing Skills?

To gauge the level of understanding of the batch of level 1.

What is covered during Session 3 & 4's practical class in Computing Skills - 2?

Creating a file in MS Word with all the basic features covered in Semester 1

Which of the following features of Microsoft Excel is covered in Session 7?

  • Inserting a formula (correct)
  • Freeze panes
  • Creating a pivot table report
  • Typing a table of two columns

In Session 9, cells in Excel are formatted for different types of _____.

<p>data</p> Signup and view all the answers

Match the following topics with their content covered in Session 20:

<p>Data filtering = Creating bar graph Data sorting = Creating pie graph Using ranges = Formatting chart area</p> Signup and view all the answers

Freeze panes, conditional formatting, and creating a formula are topics covered in Session 11.

<p>True (A)</p> Signup and view all the answers

What is the purpose of inserting a comment in a cell in MS Excel?

<p>To understand the purpose of the cell (B)</p> Signup and view all the answers

It is possible to insert a comment in a cell in MS Excel.

<p>True (A)</p> Signup and view all the answers

Email stands for easy mail.

<p>False (B)</p> Signup and view all the answers

What is the purpose of the Find and Replace function in MS Excel?

<p>To find and replace specific text or values in a worksheet</p> Signup and view all the answers

Firefox is a web browser.

<p>True (A)</p> Signup and view all the answers

What is the purpose of Paste Special in MS Excel?

<p>To paste specific aspects of the copied content, such as formulas or formatting</p> Signup and view all the answers

List the types of computers covered in the session 1 recap.

<p>Mainframe, Supercomputer, Personal Computer, Workstation, Server</p> Signup and view all the answers

What is the purpose of adding a comment to a cell in MS Excel?

<p>To provide additional information or documentation about the cell</p> Signup and view all the answers

Define IP address, as mentioned in the session 2 objective.

<p>An Internet Protocol address is a numerical label assigned to each device connected to a computer network that uses the Internet Protocol for communication.</p> Signup and view all the answers

Explain the function of the Taskbar in Windows 10 desktop.

<p>The Taskbar in Windows 10 desktop displays the Start button, shortcuts to various applications, system notifications, and the system clock.</p> Signup and view all the answers

Which of the following are functions typically found on tabs in Microsoft Word?

<p>Formatting text (A), Inserting images (D)</p> Signup and view all the answers

The _______ feature in Microsoft Word helps in finding and replacing text.

<p>Find and Replace</p> Signup and view all the answers

A motherboard is the main circuit of the computer.

<p>True (A)</p> Signup and view all the answers

An operating system is an application software.

<p>False (B)</p> Signup and view all the answers

In MS Office, Ctrl + S is for spell check.

<p>False (B)</p> Signup and view all the answers

Match the following:

<p>Microphone = c. Input device Monitor = a. Output device Ctrl + C = e. Copy 1 byte = b. 8 bits Software = d. Set of interlinked programs</p> Signup and view all the answers

What is the default background color of a cell in MS Excel?

<p>white</p> Signup and view all the answers

How can you merge cells in MS Excel?

<p>Select cells to merge, then click 'Merge &amp; Center' button</p> Signup and view all the answers

What is the purpose of setting fonts in Excel?

<p>To change the appearance of text</p> Signup and view all the answers

What is the purpose of freezing panes in a worksheet?

<p>To keep the headings visible while scrolling through the worksheet.</p> Signup and view all the answers

Conditional formatting can be used to highlight cells with values greater than a particular value.

<p>True (A)</p> Signup and view all the answers

What is the purpose of the 'Top/Bottom Rules' option in conditional formatting?

<p>To highlight the top and bottom values, percentages, and above and below average values.</p> Signup and view all the answers

What is the purpose of the 'Highlight Cells Rules' option in conditional formatting?

<p>To highlight cells with values greater or less than a particular value (D)</p> Signup and view all the answers

What is the purpose of the 'Data Bars' option in conditional formatting?

<p>To indicate values relative to each other by displaying a data bar (A)</p> Signup and view all the answers

What is the purpose of formulas in Excel?

<p>To perform calculations and analysis on data.</p> Signup and view all the answers

Formulas can only use values and text located in the same cell.

<p>False (B)</p> Signup and view all the answers

What is the purpose of the '=' sign in a formula?

<p>To indicate the start of a formula (D)</p> Signup and view all the answers

What does a column chart illustrate?

<p>Comparisons among items (B)</p> Signup and view all the answers

Which type of chart is useful for indicating temperature changes?

<p>Stock chart (C)</p> Signup and view all the answers

What does a surface chart indicate?

<p>Optimum combinations between data sets (B)</p> Signup and view all the answers

How can you edit a chart after creating it?

<p>You can right click on the chart and select 'Select data' to choose new data inputs for the chart.</p> Signup and view all the answers

What is a pivot chart based on?

<p>A pivot table</p> Signup and view all the answers

____________ keeps the headings visible while you are scrolling through the worksheet.

<p>freeze panes</p> Signup and view all the answers

The _________________ feature enables you to format a range of values so that the values outside certain limits are automatically formatted.

<p>conditional formatting</p> Signup and view all the answers

______________________ use a variety of operators and worksheet functions to work with values and text.

<p>Formulas</p> Signup and view all the answers

Formulas must begin with ____ or ____ sign.

<ul> <li>or = (C)</li> </ul> Signup and view all the answers

Write the formula for the following: Sum of cells A1 to A10

<p>=SUM(A1:A10)</p> Signup and view all the answers

Write the formula for the following: Multiply cells B12 with B16

<p>=B12*B16</p> Signup and view all the answers

Write the formula for the following: Find the average of the cell range B10 to B25

<p>=AVERAGE(B10:B25)</p> Signup and view all the answers

Write the formula for the following: Find the weighted average product of the cell range B10 to B25

<p>=SUMPRODUCT(B10:B25)/COUNT(B10:B25)</p> Signup and view all the answers

Which type of cell reference does not change when copying the formula to another cell?

<p>Absolute (B)</p> Signup and view all the answers

Excel functions always need arguments to work properly.

<p>False (B)</p> Signup and view all the answers

What option do you need to use to arrange the data in alphabetical order?

<p>Sort</p> Signup and view all the answers

Write the steps required to display the students with top 20 percent marks from a list of marks scored by 50 students.

<ol> <li>Calculate 20% of 50 (which is 10).</li> <li>Sort the list of marks in descending order.</li> <li>Select the top 10 students based on these marks.</li> </ol> Signup and view all the answers

What function searches for a value vertically down for the lookup table?

<p>VLOOKUP</p> Signup and view all the answers

What does the lookup_value parameter represent in the VLOOKUP function?

<p>The user input</p> Signup and view all the answers

What is the purpose of a Pivot Table in Excel?

<p>To provide a dynamic summary report generated from a database</p> Signup and view all the answers

What is the main benefit of presenting data in a chart?

<p>To make numbers more understandable</p> Signup and view all the answers

Define the function of the COUNTIF function in Excel.

<p>Tests a number of user-defined conditions and returns TRUE if ANY of the conditions evaluate to TRUE or FALSE otherwise.</p> Signup and view all the answers

Differentiate between a relative cell reference and an absolute cell reference in Excel.

<p>Relative cell references change when a formula is copied to another cell, while absolute cell references remain constant.</p> Signup and view all the answers

What is the purpose of data filtering in MS Excel?

<p>Data filtering in MS Excel displays only the rows that meet specific conditions, hiding the other rows.</p> Signup and view all the answers

Explain the concept of sorting data in MS Excel.

<p>Sorting data in MS Excel rearranges rows based on the contents of a selected column.</p> Signup and view all the answers

How can ranges be used in Excel?

<p>Ranges in Excel are groups of cells specified by their upper-left and lower-right cell addresses.</p> Signup and view all the answers

Describe the function of macros in Excel.

<p>Macros in Excel automate tasks by recording user actions and can be edited using VBA code.</p> Signup and view all the answers

How can macros be created in MS Excel?

<p>Macros can be created by recording user actions or by entering VBA code in the Visual Basic Editor.</p> Signup and view all the answers

Study Notes

Computing Skills - 2

Session 1: Theory

  • Gauging the level of understanding of the batch of level 1
  • Revising operating system
  • Recap on basics from Term 1 book:
    • Types of computers
    • Hardware and software
    • Operating system:
      • Windows 10 desktop
      • Icons
      • Background
      • Start menu
      • Search box
      • Task bar
      • Notification area
      • File explorer

Session 2: Theory

  • Revising Internet and purposive surfing
  • Revising Microsoft Word
  • Covering basics from Term 1 book:
    • What is Internet?
    • IP address
    • Domain name
    • Web browsers
  • Definitions of the above terms

Session 3-4: Practical

  • Creating a file in MS Word with all the basic features covered in Semester 1

Session 5: Practical

  • Internet surfing
  • Creating a Google account and email
  • Creating a spreadsheet and entering data in Microsoft Excel
  • Saving, deleting, and moving around in a workbook

Session 6: Theory

  • Recap of Semester 1:
    • Creating a spreadsheet and entering data
    • Saving, deleting, and moving around in a workbook
  • Inserting a formula in Microsoft Excel
  • Excel – copy and paste, paste special, find and replace, and special symbols and characters
  • Adding a comment to a cell

Session 7-8: Practical

  • Typing a table of two columns and inserting simple formulas using * and / in Microsoft Excel
  • Copying and pasting the table in another sheet as such and with values
  • Using the find and replace option
  • Inserting 5 symbols and characters
  • Inserting comments in two cells

Session 9: Theory

  • Formatting cells for different types of data in Microsoft Excel
  • Setting fonts, background color, text alignment, merge cells, wrap text, and shrink to fit
  • Borders and shading

Session 10: Practical

  • Creating a table and showing two font options
  • Changing a background color
  • Setting vertical and horizontal alignment
  • Formatting the table with borders and shading
  • Typing a header and merging it

Session 11: Theory

  • Freezing panes in Microsoft Excel
  • Conditional formatting
  • Creating a formula
  • Copying a formula

Session 12: Practical

  • Creating a table with imaginary data and doing the following:
    • Freezing panes
    • Conditional formatting
    • Creating a formula
    • Copying a formula

Session 13: Theory

  • Cell references in formula
  • Using functions in Microsoft Excel
  • Built-in functions

Session 14: Practical

  • Creating cell references in formula – all types
  • Inserting functions and using one built-in function from each category

Session 15: Theory

  • Data filtering
  • Data sorting
  • Using ranges
  • Using macros

Session 16: Practical

  • Filtering and sorting a list created earlier
  • Creating a macro to make a cell bold, italic, and underline
  • Showing cell ranges

Session 17: Theory

  • Cross referencing – VLOOKUP function
  • Pivot table

Session 18: Practical

  • Creating a pivot table report from a data table
  • Showing the VLOOKUP function

Session 19: Theory

  • Charts
  • Pivot charts
  • List of Excel keyboard shortcuts

Session 20: Practical

  • Creating charts (bar, pie, and formatting)
  • Creating a pivot chart
  • Using keyboard shortcuts (any 10)

Session 21: Theory

  • Introduction to Microsoft PowerPoint
  • Areas in a standard PowerPoint file
  • Creating a presentation

Session 22: Theory

  • Adding new slides
  • Entering text in boxes
  • Adding a text box

Session 23-24: Practical

  • Starting Microsoft PowerPoint
  • Areas in a standard PowerPoint file
  • Creating a presentation
  • Adding new slides
  • Entering text
  • Adding a text box

Session 25: Theory

  • Deleting an existing slide
  • Rearranging slides
  • Working with outlines

Session 26: Theory

  • Sidebars
  • Presentation views

Session 27: Practical

  • Sidebars
  • Presentation views
  • Setting backgrounds
  • Slide orientation

Session 28: Theory

  • Saving presentations
  • Reviewing presentations

Session 29: Theory

  • Running a slideshow
  • Using slide master

Session 30: Theory

  • Saving a design template
  • Adding pictures

Session 31: Practical

  • Running a slideshow
  • Using slide master
  • Adding pictures

Session 32: Theory

  • Adding and previewing animations
  • Adding and previewing transitions

Session 33: Practical

  • Adding and editing pictures/images in PowerPoint
  • Saving and reviewing presentations

Session 34: Practical

  • Adding animations and transitions
  • Editing the above

Session 35-36: Practical

  • Creating a full presentation using features studied in this section

Session 37: Theory

  • Introduction to Cyber laws
  • Categories of Cyber laws

Session 38: Theory

  • Countering cyber crimes
  • Software piracy
  • Code of ethics - Dos and Don'ts

Session 39: Theory

  • Introduction to MS Outlook
  • Creating an account
  • Creating a new mail message
  • Adding an email signature

Session 40: Theory

  • Using the calendar
  • Creating a contact
  • Adding notes/tasks
  • Printing an email message, contact, or calendar item

Session 41: Theory/Practical

  • Introduction to social media
  • Various avenues
  • Practical training

Session 42: Theory

  • Introduction to video conferencing
  • Types of video conference sessions
  • Desktop conferencing
  • Managing video conferencing
  • Live streaming

Sessions 43-45: Practical

  • Based on the vertical

  • Related to the work situation to be conducted; different for each vertical### Microsoft Word

  • Starting MS Word: various tabs, options under each tab

  • Moving in the workbook with a keyboard/mouse

  • Editing text: inserting, selecting, deleting, moving - sentence/paragraph

  • Cut, copy, paste

  • Find and replace

  • Spell check and grammar

  • Formatting text

  • Password protection

  • Types of paragraph alignment

  • Format painter

Computing Skills - Practical Tasks

  • Create a new file, type a paragraph, and perform various tasks:
    • Cut, copy, paste
    • Bold, italic, underline
    • Paragraph alignment
    • Edit/delete text
    • Insert page numbers
    • Insert table
    • Header and footer
    • Check spelling and grammar
    • Word art
    • Change text color/font
    • Bullets and numbering
    • Save file
    • Rename file
    • Password protect the file
    • Other features based on student requests

Internet Surfing and Email

  • Open web browsers
  • Browse for 'top business news of the day', pick up 3 important pages, and save the same
  • Send/reply and forward an email to/from a friend, inviting them for a birthday party, using formatting tools available in Gmail
  • Learn to upload/download files from Google Drive
  • Use Google Talk and transfer files using it

Microsoft Excel

  • Revising basics of MS Excel from Semester 1:
    • Creating a spreadsheet and entering data
    • Saving, deleting a workbook
    • Moving around in the workbook
  • Excel overview: file tab, ribbons, title bar, sheet area, view buttons
  • Entering data
  • Moving on the spreadsheet with the keyboard and mouse
  • Saving a workbook
  • Inserting/hiding sheets
  • What is a cell/row/column

Excel Formulas and Functions

  • Inserting a formula: typing the formula in the formula bar and pressing enter or the navigation key
  • Copying and pasting: using the copy paste option in different ways, including:
    • Method 1: selecting the cells to copy, right-clicking, and selecting paste
    • Method 2: using the Office Clipboard
  • Paste special: options for pasting, including:
    • All
    • Formulas
    • Values
    • Formats
    • Comments
    • Validation
    • All using source theme
    • All except borders
    • Column width
    • Formulas & Number Formats
    • Values & Number Formats
    • Merge Conditional Formatting
    • Transpose

Excel Find and Replace

  • Accessing the Find & Replace feature: using the Home -> Find & Select -> Find option or pressing Control + F key
  • Find and Replace dialogue: options for searching and replacing text, including:
    • Within: specifying the search should be in the sheet or workbook
    • Search By: specifying the internal search method by rows or by columns
    • Look In: specifying if the search should be in the formula as well
    • Match Case: specifying if the search should match the case
    • Match Entire Cell Content: specifying if the search should match the exact cell content

Excel Special Symbols and Characters

  • Inserting special symbols: using the Insert -> Symbols -> Symbol option
  • Viewing available symbols: including Pi, alpha, beta, etc.
  • Inserting special characters: using the Insert -> Symbols -> Special Characters option
  • Viewing available special characters: including Copyright, Registered, etc.

Excel Comments

  • Adding a comment to a cell: using the Review -> Comments -> New Comment option or right-clicking and selecting Insert Comment
  • Modifying a comment: selecting the cell, right-clicking, and selecting Edit Comment### Computing Skills - 2

Formatting a Comment

  • Right-click on a cell to edit a comment, select the comment, right-click on it, and format the comment.
  • Options available for formatting a comment include changing the color, font, size, etc.

Session 8

Confirmation on practicals

  • Tasks include:
    • Typing a table with two columns and inserting simple formulas using * and /
    • Copying and pasting the table in another sheet with values
    • Using the find and replace option
    • Inserting 5 symbols and characters
    • Inserting comments in two cells

Session 9

Session Objectives

  • Format cells for different types of data
  • Set fonts in Excel
  • Change background color
  • Set text alignment
  • Merge cells
  • Wrap text and shrink to fit
  • Apply borders and shading

Formatting Cells

  • Format cells for different types of data, such as numbers, currency, dates, etc.
  • Options available:
    • General: default cell format
    • Number: displays cell as a number with a separator
    • Currency: displays cell as currency with a currency sign
    • Accounting: similar to currency, used for accounting purposes
    • Date: various date formats available
    • Time: various time formats available
    • Percentage: displays cell as a percentage with decimal places
    • Fraction: displays cell as a fraction
    • Scientific: displays cell as an exponential
    • Text: displays cell as normal text
    • Special: special formats for cells, such as Zip code or Phone Number
    • Custom: allows custom formatting using a specific format

Setting Fonts

  • Set fonts in Excel using the Home tab, Font group, or by right-clicking on the cell, selecting Format cells, and then Font Tab
  • Options available:
    • Font style
    • Font size
    • Font color

Changing Background Color

  • Change background color using the Home tab, Font group, or by right-clicking on the cell, selecting Format cells, and then Font Tab
  • Options available:
    • Background color
    • Foreground color

Text Alignment

  • Horizontal alignment options:
    • Left: aligns cell contents to the left side of the cell
    • Center: centers cell contents in the cell
    • Right: aligns cell contents to the right side of the cell
    • Fill: repeats cell contents until the cell's width is filled
    • Justify: justifies text to the left and right of the cell
  • Vertical alignment options:
    • Top: aligns cell contents to the top of the cell
    • Center: centers cell contents vertically in the cell
    • Bottom: aligns cell contents to the bottom of the cell
    • Justify: justifies text vertically in the cell

Merging Cells

  • Merge cells to combine multiple cells into a single cell
  • Options available:
    • Merge & Center: merges cells and centers the contents
    • Merge Across: merges cells across multiple rows
    • Merge Cells: merges cells without applying center attribute
    • Unmerge Cells: unmerges cells

Wrap Text and Shrink to Fit

  • Wrap text to fit the column width
  • Options available:
    • Wrap text
    • Shrink to fit

Borders and Shading

  • Apply borders to cells using the Home tab, Font group, or by right-clicking on the cell, selecting Format cells, and then Border Tab
  • Options available:
    • Border style
    • Border color
  • Apply shading to cells using the Home tab, Font group, or by right-clicking on the cell, selecting Format cells, and then Font Tab
  • Options available:
    • Shading color

Session 10

Confirmation on practicals

  • Tasks include:
    • Creating a table with 5 columns and showing different cell formats for each column
    • Showing two font options in Excel
    • Changing the background color to yellow
    • Applying vertical and horizontal alignment
    • Formatting the table with borders and shading
    • Typing a header and merging it to cover the 5 columns

Session 11

Session Objectives

  • Freeze panes
  • Conditional formatting
  • Creating a formula
  • Copying a formula

Freeze Panes

  • Freeze panes to keep row or column headings visible when scrolling
  • Options available:
    • Freeze Panes: to freeze area of cells
    • Freeze Top Row: to freeze the first row of the worksheet
    • Freeze First Column: to freeze the first column of the worksheet

Conditional Formatting

  • Use conditional formatting to highlight cells that meet certain conditions
  • Options available:
    • Highlight Cells Rules: to highlight cells that contain certain values, text, or dates
    • Top/Bottom Rules: to highlight top and bottom values, percentages, and above and below average values
    • Data Bars: to indicate cell values relative to each other using data bars
    • Color Scales: to indicate cell values relative to each other using color scales
    • Icon Sets: to indicate cell values relative to each other using icons
    • New Rule: to define a custom conditional formatting rule
    • Clear Rules: to remove conditional formatting rules
    • Manage Rules: to edit and delete conditional formatting rules

Studying That Suits You

Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

Quiz Team

Related Documents

Computing Skill II - PDF

Description

This quiz covers topics from computer applications, including operating systems, internet surfing, and Microsoft Word. It's ideal for students revising for their semester 1 exams.

More Like This

Microsoft Word và PowerPoint
40 questions
Microsoft Word 2013 Overview
42 questions

Microsoft Word 2013 Overview

IncredibleTriangle6818 avatar
IncredibleTriangle6818
Use Quizgecko on...
Browser
Browser