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</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</p> Signup and view all the answers

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

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

    Email stands for easy mail.

    <p>False</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</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</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</p> Signup and view all the answers

    An operating system is an application software.

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

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

    <p>False</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</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</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</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</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</p> Signup and view all the answers

    What does a column chart illustrate?

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

    Which type of chart is useful for indicating temperature changes?

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

    What does a surface chart indicate?

    <p>Optimum combinations between data sets</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 =</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</p> Signup and view all the answers

    Excel functions always need arguments to work properly.

    <p>False</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

    Computer Science Lab: Word Processing Basics
    8 questions

    Computer Science Lab: Word Processing Basics

    GodlikeBongos avatar
    GodlikeBongos
    Introduction to Microsoft Word
    16 questions

    Introduction to Microsoft Word

    EvocativeRecorder avatar
    EvocativeRecorder
    Microsoft Word và PowerPoint
    40 questions

    Microsoft Word và PowerPoint

    GenialKindness avatar
    GenialKindness
    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser