Keyboard Computer Science for Class 7 (Complete Solutions)
-------------------------------------------------------------------------------------------------------------------------
Unit # 01 – Formulas 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 # 02 – Advanced 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 # 03 – Creating 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 # 04 – The 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
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
|
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
|
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
|
---------------------------------------------------------------------------------------------------------------------
0 Comments
Your feedback is highly appreciated and will help us to improve our ability to serve you.