Keyboard Computer Science for Class 7 (Complete Solutions)
-------------------------------------------------------------------------------------------------------------------------



Unit # 01Formulas in MS Excel

Q1:                        Fill in the blanks with the correct words.
                 
A
B
C
D
E
EQUAL
FUNCTIONS
NAME
ENTER
FORMULA

Q2:            Write T for the true statement and F for the false ones.
     
A
B
C
D
E
F
F
T
F
T

Q3:                        Name the following.

A
B
C
D
E
POINT
PRECEDENCE
+
CONCATENATION
GCD

Q4:      Answer the following.

A.     What are the two ways of entering a formula in Microsoft Excel?
Ans:     The two ways of entering a formula in Microsoft Excel are:
1.      To enter the formula in the cell.
2.      To enter the formula in the Formula Bar.

B.      What do you do to view the result of a formula?
Ans:     To view the result of a formula, we press Enter.

C.      What is pointing?
Ans:     Pointing:
Pointing is a method of adding a cell reference to a formula by clicking on the cell instead of typing the cell address.

D.     In which two places is the AutoSum Button located?
Ans:     The Auto-sum button is located in two places on the Ribbon:
·         In the editing group on the Home tab
·         In the Function Library group on the Formulas tab.

E.      How would you copy a formula entered in cell G2 to G3:G7?
Ans:    
1.      Select cell G2.
2.      Point the cursor to the fill handle (the small black square in the lower-right corner) of cell G2. It will change to a small black cross.
3.      Keeping the left mouse button pressed, drags the fill handle to cell G7.

F.       What is the order of evaluation of arithmetical operations (+, -, /, *, ^) in a Microsoft Excel?
Ans:     The order of evaluation is:
1.      ^ (Exponent)
2.      * (Multiplication)/(Division)
3.      + (Addition)
4.      – (Subtraction)

G.     When does a formula give you an error result?
Ans:     A formula gives an error result when the formula has a problem and Excel cannot           evaluate it.

H.     What are the different error values that a formula can display?
Ans:     The different error values that a formula can display are:#DIV/0!,#N/A, and #VALUE!

Q5:            Circle the correct option.
           
A
B
C
D
E
F
G
iii
i
iv
iii
iii
iv
ii

---------------------------------------------------------------------------------------------------------------------

Unit # 02Advanced Features of MS Excel

Q1:                        Fill in the blanks with the correct words.
                 
A
B
C
D
E
DATA
SORT
FILTER
CONDITIONAL
HOME

Q2:            Write T for the true statement and F for the false ones.
     
A
B
C
D
E
T
F
T
T
T

Q3:                        Name the following.

A
B
C
D
E
SORT
FILTERING
CLEAR
REAPPLY
CLEAR RULES

Q4:                        Answer the following.

A.     What is meant by sorting data?
Ans:     Sorting data means rearranging the data in cells in a specified order.

B.      Can you sort Excel data by more than one column? If so, which command would you use?
Ans:     Yes, Excel data can be sorted by more than one column. This can be done by selecting Sort in the Sort and Filter group in the Data tab.

C.      What is meant by filtering data?
Ans:     Filtering means selectively blocking data according to the conditions specified by the user.

D.     What are the different ways filter criteria?
Ans:     To remove the filter, any one of the following can be used:
1.      Click on Clear in the Sort and Filter group on the Data tab.
2.      Click on the arrow next to the column heading and select Clear Filter from “column heading” or Select All in the drop-down menu.

E.      What is conditional formatting?
Ans:     Conditional Formatting is a feature that allows you to set a cell’s format according to the conditions you specify.

F.       List three conditional formatting criteria.
Ans:     The three conditional formatting criteria are:
1.      Greater Than.
2.      Less Than.
3.      Equal To.
G.     Name the tool you use to copy conditional formatting.
Ans:     The Format Painter tool is used to copy conditional formatting.

Q5:            Circle the correct option.
           
A
B
C
D
E
F
G
H
iv
i
ii
iv
i
iv
i
ii

 ---------------------------------------------------------------------------------------------------------------------
  
Unit # 03Creating Charts in MS Excel

Q1:                        Fill in the blanks with the correct words.
                 
A
B
C
D
E
CHART
LINE
CATEGORY
PLOT
LABELS

Q2:            Write T for the true statement and F for the false ones.
     
A
B
C
D
E
T
F
F
F
T

Q3:                        Name the following.

A
B
C
D
E
SCATTER
CHART AREA
DATA SERIES
GRIDLINES
LEGENDS

Q4:                        Answer the following.

A.     What is a chart?
Ans:     A chart is a pictorial representation of data.

B.      What is a difference between a column chart and a bar chart?
Ans:    
Column Chart
Bar Chart
A column chart shows changes in data over a period of time or illustrates comparisons between items,
A bar chart illustrates comparisons among individual items.

C.      What is the similarity between a pie chart and a doughnut chart?
Ans:     A doughnut chart and a pie chart show the relationship of parts to the whole.

D.     How is a scatter chart different from a line chart?
Ans:    
Scatter Chart
Line Chart
A Scatter chart shows the relationships between numeric values or plots points between x and y values.
A Line chart shows change over time intervals

E.      What tab has the commands to insert charts in Microsoft Excel?
Ans:     The Insert tab in the Charts group has the commands to insert charts in Microsoft Excel.



F.       List the names and write the definitions of four excel charts components?
Ans:     The following are the four chart components:
1.      Axis Title: This is the title given to an axis.
2.      Plot area:  This is the rectangular area bounded by the two axis.
3.      Legend:     This identifies the data series.
4.      Y- Axis:      This is the vertical axis of the chart and is also known as value axis.

G.     How would you move a chart to a new worksheet?
Ans:     To move a chart to a new worksheet, the steps are as follows:
1.      Click Move Chart in the Location group on the Design tab. The Move Chart dialog box appears.
2.      Click New sheet and type a name for the new sheet.

H.     Name the three chart tools tabs that appears when a chart is selected?
Ans:     The three Chart Tools tabs are:
1.      Design.
2.      Layout.
3.      Format.

Q5:            Circle the correct option.
           
A
B
C
D
E
F
G
H
iv
i
i
iii
iii
iii
ii
iii

--------------------------------------------------------------------------------------------------------------------- 
  
Unit # 04The Computer Viruses

Q1:                        Fill in the blanks with the correct words.
                 
A
B
C
D
E
E-MAIL
MACRO
WORM
ANTIVIRUS
DEFINITION

Q2:            Write T for the true statement and F for the false ones.
     
A
B
C
D
E
F
T
T
T
F

Q3:                        Name the following.

A
B
C
D
E
PROGRAM VIRUS
MACRO VIRUS
TROJAN HORSE
MALWARE
VIRUS DEFINITION

Q4:                        Answer the following.

A.     What is a Computer Virus?
Ans:     A software program that has the ability to make copies of it-self, and that can attached itself to other applications or files is known as a computer virus.   

B.      What can a Computer Virus do to your computer?
Ans:    
·         A computer virus can infect executable program files such as word processors, spreadsheets, and operating systems.
·         It can infect disks by attaching itself to special programs called boot records on the hard-disk.
·         It can infect files that are attached to email messages or copied to discs and pen drives. In this manner it can spread from one computer to another.

C.      Name the three types of viruses based on target. Give one example of each type.
Ans:     The three types of viruses based on target are
1.      Program Virus.
2.      Boot Virus.
3.      Macro Virus.

The examples of each are:
1.      Program virus :–        Acid Rain
2.      Boot virus: –               Disk killer
3.      Macro virus: –                        Melissa

 D.     Differentiate between Program Virus and Boot Virus.
Ans:    
Program Virus
Boot Virus
Program viruses infect program files that have extensions such as .com, .exe, .sys, .dll, .ovl, and .scr.
Boot viruses infect the boot records of hard disks.

E.      How does a computer virus spread from one computer to another?
Ans:     Computer viruses:
Computer viruses Spread from one computer to another by the transfer of infected data through the e-mail, pen drives, or other sources.

F.       List four precautions for protecting your computer from virus infection.
Ans:     Four precautions for protecting your computer from virus infections are:
·         Restrict access to your system, both off line and online.
·         Install and use antivirus software and keep it updated.
·         Scan files that you download from the Internet.
·         Never click on a link or attachment in an e-mail, unless the email is from a trusted source.
           
G.     List five different types of Malware?
Ans:     Five different types of malware are:
1.      Computer Viruses.
2.      Worms.
3.      Trojan Horses.
4.      Spyware.
5.      Spam.

H.     What are virus definitions and why is it necessary to update them?
Ans:     Virus definitions:
Virus definitions are the database of viruses for which antivirus software scans.
It is necessary to update the definitions regularly so that the antivirus software can detect new viruses.

Q5:      Circle the correct option.
           
A
B
C
D
E
F
G
H
iv
ii
iii
iii
iv
iii
ii
iii

 ---------------------------------------------------------------------------------------------------------------------

  Unit # 05QBasic Looping Statements

Q1:                        Fill in the blanks with the correct words.
                 
A
B
C
D
E
LOOP
FALSE
TRUE
STEP
ONCE

Q2:            Write T for the true statement and F for the false ones.
     
A
B
C
D
E
F
F
T
T
F

Q3:                        Name the following.

A
B
C
D
E
THREE
DO UNTILL…LOOP
FOR…NEXT
ONE
EXIT…FOR

Q4:                  Answer the following.
           
A.     What is a loop in a program?
Ans:     In computer programming, a loop is used to repeat a block of statements a number of times.

B.      What are the looping statements in QBasic?
Ans:     There are three looping statements in QBasic:
1.      WHILE…WEND.
2.      DO…LOOP.
3.      FOR....NEXT.

C.      What is the difference between DO WHILE… LOOP and DO UNTILL… LOOP?
Ans:    
DO WHILE… LOOP
DO UNTILL… LOOP
DO WHILE...Loop is executed as long as the condition is true
DO UNTIL...LOOP is executed as long as the condition is false.

D.     What is the difference between the DO WHILE…LOOP and DO…LOOP WHILE forms of the DO… LOOP?
Ans:    
DO WHILE… LOOP
DO…LOOP WHILE
1.      The DO WHILE…LOOP is executed as long as the condition is true
2.      The condition in the DO WHILE…LOOP appears before the loop starts
1.      DO...LOOP WHILE is executed at least once before the condition is checked.
2.      In DO...LOOP WHILE the condition appears at the end of the loop.

E.      How many times is the loop executed in DO…LOOP WHILE if the condition starts off as false?
Ans:     In DO...LOOP WHILE the loop will execute at least once even if the condition starts off as false.

F.       Which looping statement is preferred if you know the number of repetitions?
Ans:     The FOR...NEXT looping statement is preferred if we know the number of repetitions.

G.     What is the default STEP value in a FOR…NEXT statement?
Ans:     The default STEP value in a FOR...NEXT statement is one.

H.     Can you have a negative value in STEP? If yes, what would be true about the start and end value in the statement?
Ans:     Yes, we can have a negative value in STEP. In this case, the starting value is greater than the ending value.

Q5:      Circle the correct option.
           
A
B
C
D
E
F
G
H
ii
i
iv
iii
ii
iv
iv
iii

 ---------------------------------------------------------------------------------------------------------------------

 Unit # 06Introduction to Visual Basic

Q1:                        Fill in the blanks with the correct words.
                 
A
B
C
D
E
GRAPHICAL
IDE
CONTROLS
DOUBLE-CLICK
DEBUG

Q2:            Write T for the true statement and F for the false ones.
     
A
B
C
D
E
     T
T
F
T
F

Q3:                        Name the following.

A
B
C
D
E
PROJECT
PROPERTY
METHOD
EVENT
F5

Q4:                  Answer the following.

A.     What is meant by GUI?
Ans:     GUI: GUI stands for Graphical User Interface. It is an interface that enables the user to interact with the application by using controls like icons, buttons, menus, dialog boxes, and windows.

B.      What is event-driven programming?
Ans:     Event-driven programming:
Event-driven programming is one in which the program responds to events, which are actions performed by the user.

C.      Write down the steps in the development of a visual basic application.
Ans:     The steps to develop a Visual Basic application are:
1.      Create a form.
2.      Place controls on the form.
3.      Set properties for the controls.
4.      Add code to the controls to handle the events.

D.     What are the file extensions of a form file and a project file?
Ans:     The extension of a form file is .vb and the extension of a project file is .vbproj.

E.      What are the two ways to place a control on a form?
Ans:     The two ways to place a control on the form are:
1.      Double-click on the control in the Toolbox.
2.      Click on the control in the Toolbox and drag it onto the form.

F.       Name any four controls in the Toolbox?
Ans:     Four controls in the Toolbox are:
1.      Label.
2.      Button.
3.      Combo Box.
4.      ListBox.

G.     Name any two properties of textbox and Labels?
Ans:     Two properties of TextBox and Label are Font and Text.

H.     Write down two ways to run a Visual Basic application.
Ans:     Two ways to run a Visual Basic application are:
1.      Press F5.
2.      Click Debug then Start Debugging.

Q5:      Circle the correct option.
           
A
B
C
D
E
F
G
H
iii
iii
ii
iv
ii
ii
ii
iv


---------------------------------------------------------------------------------------------------------------------