CLICK HERE FOR VARIOUS NEW JOBS 
CLICK HERE FOR VARIOUS EDUCATIONAL NEWS 
CLICK HERE FOR NEW SCHOLARSHIPS 
CLICK HERE FOR ADMISSION NOTICES 
Click And Follow On Google+ To Get Updates
Please Wait 10 Seconds... OR You CanSkip

ADMISSION NOTICES
Scholarships

Scholarship-300x291

BUDGET 2014-15
budget_2014-2015
New Date Sheets
VU SOLVED ASSIGNMENTS
Recent Posts

Posts Tagged ‘CS001- VU-Computer Proficiency License’

CS001- VU-Computer Proficiency License MIDTERM Solved/Unsolved Papers Spring 2010

CS001- VU-Computer Proficiency License MIDTERM Solved/Unsolved Papers Spring 2010

MID TERM  EXAMINATION

Spring 2010

CS001- VU-Computer Proficiency License

Ref No: 1540848

Time: 90 min

Marks: 58

Student Info
Student ID: ZS100200179
Center: Kuwait OPKST
Exam Date: 9th august 2010

 

 

For Teacher’s Use Only

Q No.

1

2

3

4

5

6

7

8

Total

Marks

      

      

      

      

      

      

      

      

      

Q No.

9

10

11

12

13

14

15

16

 

Marks

      

      

      

      

      

      

      

      

      

Q No.

17

18

19

20

21

22

23

24

 

Marks

      

      

      

      

      

      

      

      

      

Q No.

25

26

27

28

29

30

31

32

 

Marks

      

      

      

      

      

      

      

      

      

Q No.

33

34

35

36

 

 

 

 

 

Marks

      

      

      

      

      

      

      

       

      

 

 

 

 

 

Question No: 1      ( Marks: 1 ) – Please choose one

 

 

There are three types of data found in a spreadsheet.

 

 

       ► data, words, numbers

 

 

       ► equations, data, numbers

 

 

       ► words, numbers, labels

 

 

ü      numbers, formulas, labels

 

 

 

 

Question No: 2      ( Marks: 1 ) – Please choose one

 

 

A constant is another name for this type of data:

 

 

ü      number

 

 

       ► equation

 

 

       ► formula

 

 

       ► description

 

 

 

 

Question No: 3      ( Marks: 1 ) – Please choose one

 

 

Which is an absolute address?

 

 

ü      $C$4

 

 

       ► 10700 – 105 Ave.

 

 

       ► C4

 

 

       ► None of these

 

 

 

 

Question No: 4      ( Marks: 1 ) – Please choose one

 

 

What program do you use to create a spreadsheet?

 

       ► Word

 

ü      Excel

 

       ► Access

 

       ► PowerPoint

 

 

 

Question No: 5      ( Marks: 1 ) – Please choose one

 

 

Which button on the standard toolbar gives you quick access to the Sum, Average, Count, Min, and Max functions?

 

ü      AutoSum

 

       ► Insert Function

 

       ► AutoFill

 

       ► Paste

 

 

 

Question No: 6      ( Marks: 1 ) – Please choose one

 

 

What do you use to create a chart?

 

ü      Chart Wizard

 

       ► Pie Wizard

 

       ► Excel Wizard

 

       ► Data Wizard

 

 

 

Question No: 7      ( Marks: 1 ) – Please choose one

 

 

Which type of chart shows the pattern or relationships between sets of data points?

 

       ► Line

 

ü      Pie

 

       ► Area

 

       ► XY (Scatter)

 

 

 

Question No: 8      ( Marks: 1 ) – Please choose one

 

 

On an Excel sheet the active cell is indicated by ____.

 

 

       ► a dark wide border

 

 

       ► a dotted border

 

 

       ► a blinking border

 

 

ü      All of these

 

 

 

 

Question No: 9      ( Marks: 1 ) – Please choose one

 

 

A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this ?

 

 

       ► Go to FILE – SAVE AS – SAVE AS TYPE – Excel 4.0 Work Sheet

 

 

ü      Right click on the spreadsheet tab and select DELETE

 

 

       ► Right click on the spreadsheet and select INSERT – ENTIRE COLUMN

 

 

       ► None of these

 

 

 

 

Question No: 10      ( Marks: 1 ) – Please choose one

 

 

The World Wide Web (WWW) is…

 

 

ü      a part of the Internet

 

 

       ► the Internet

 

 

       ► not a part of the Internet

 

 

       ► All of these

 

 

 

 

Question No: 11      ( Marks: 1 ) – Please choose one

 

 

Uniform Resource Locator (URL) are…

 

 

       ► the same as Search Engines

 

 

ü      the addresses of specific documents and resources on the WWW

 

 

       ► never more than 11 characters long

 

 

       ► All of these.

 

 

 

 

Question No: 12      ( Marks: 1 ) – Please choose one

 

 

The ____ standard defines how data transmits across telephone lines or other means.

 

       ► TCP/IP

 

       ► EDI (Electronic Data Interchange)

 

       ► Electronic funds transfer (EFT)

 

ü      Ethernet

 

 

 

 

Question No: 13      ( Marks: 1 ) – Please choose one

 

 

A(n) ____ line typically costs $1,000 or more per month.

 

       ► ISDN

 

 

       ► T3

 

 

       ► ATM

 

 

ü      T1

 

 

 

 

Question No: 14      ( Marks: 1 ) – Please choose one

 

 

A ____ is a Web site that uses encryption techniques to secure its data.

 

ü      digital certificate

 

       ► secure HTTP (S-HTTP)

 

       ► wallet program

 

       ► secure site

 

 

 

 

Question No: 15      ( Marks: 1 ) – Please choose one

 

 

The process of converting readable data into unreadable characters to prevent unauthorized use is called ____

 

       ► normalization

 

       ► decryption

 

       ► validation

 

ü      encryption

 

 

 

 

Question No: 16      ( Marks: 1 ) – Please choose one

 

 

_______Repeats the last command or action, if possible in excel.

 

 

       ► F1

 

       ► F2

 

       ► F3

 

ü      F4

 

 

 

Question No: 17      ( Marks: 1 ) – Please choose one

 

 

Which of the following is primary storage?

 

 

       ► Hard disk

 

       ► Floppy disk

 

ü      RAM

 

       ► Optical disk

 

 

 

Question No: 18      ( Marks: 1 ) – Please choose one

 

 

The device used to store data is called

 

 

       ► Input device

 

       ► Out put device

 

       ► None of these

 

ü      Storage device

 

 

 

Question No: 19      ( Marks: 1 ) – Please choose one

 

 

Which of the following is intangible?

 

 

ü      Software

 

       ► Hard disk

 

       ► Optical disk

 

       ► Computer Mouse

 

 

 

Question No: 20      ( Marks: 1 ) – Please choose one

 

 

Tab key is a

 

       ► Non-typing key

 

ü      Typing key

 

       ► Toggle key

 

       ► Application key

 

 

 

Question No: 21      ( Marks: 1 ) – Please choose one

 

 

What is the keyboard shortcut (button or buttons to be pressed) for creating a Chart from the selected cells ?

 

 

       ► F3

 

 

       ► F4

 

 

ü      F5

 

 

       ► F6

 

 

 

 

Question No: 22      ( Marks: 1 ) – Please choose one

 

 

In Word which of the following shortcut key combination, Inserts link

 

 

       ► Ctrl + P

 

 

       ► Ctrl + F

 

 

       ► Ctrl + I

 

 

ü      Ctrl + K

 

 

 

 

Question No: 23      ( Marks: 1 ) – Please choose one

 

 

In Word which of the following shortcut key combination, decreases selected font -1pts if 12pt or lower, if above 12 decreases font by +2pt.

 

 

ü      Ctrl + Shift + <

 

► Ctrl + Shift + >

 

► Ctrl + ]

 

► Ctrl + [

 

 

 

Question No: 24      ( Marks: 1 ) – Please choose one

 

 

Which will select all the cells in a document ?

 

 

       ► Clicking three times with the right mouse button in the spreadsheet

 

 

       ► Using the Edit – Select All menu item

 

 

ü      Pressing CTRL + A on the keyboard

 

 

       ► None of these

 

 

 

 

Question No: 25      ( Marks: 1 ) – Please choose one

 

 

___________ will insert a new worksheet.

 

ü      ALT+SHIFT+F1

 

 

       ► ALT+SHIFT+F2

 

 

       ► ALT+SHIFT+F3

 

 

       ► None of these.

 

 

 

Question No: 26      ( Marks: 1 ) – Please choose one

 

 

E-mail stands for

 

 

ü      electronic mail

 

 

       ► the print out from a fax machine

 

 

       ► a letter printed from a computer

 

 

       ► All of these

 

 

 

 

Question No: 27      ( Marks: 2 )

 

 

What is the difference between closing and exiting?

 

Solution:

Closing removes the particular part of the program if it is used on the main screen or window.

Whereas, exit means to close the file and also to exit the application.

 

Question No: 28      ( Marks: 2 )

 

 

How we can print more than one slide per page in PowerPoint

 

 

 

Question No: 29      ( Marks: 2 )

 

 

How we can Bookmark a Web page

 

Solution:

To Bookmark a Web page in internet explorer select the “Bookmarks” options and clicking “Save” in the drop down menu. Save, edit or add a bookmark to a web browser to find a site quickly on the Internet. It is located in the location bar of the internet explorer.

 

Question No: 30      ( Marks: 2 )

 

 

Define standard and status bars.

 

Solution:

Standard Bar:

A standard bar contains icons for functions such as file management, printing, editing, formatting and calculating. It is located just below the menu bar in an application window.

 

Status Bar:

A horizontal line of information displayed at the bottom of an application window. It reports information about the current status of the program or the data contents in the window.

 

Question No: 31      ( Marks: 3 )

 

 

Here is the data for the sales of Apples for year 2007, using excel apply the formula to calculate the Harmonic Mean of sales using HARMEAN function (Statistics Category) and give the result in the answer area,     

 

 

Peaches
January

5902.44

February

7234.12

March

5110

April

3521.87

May

1276.34

June

1227.30

July

1199.99

August

1242.09

September

1189.73

October

1195.42

November

1213.14

December

1887.49

 

 

 

 

Question No: 32      ( Marks: 3 )

 

 

Describe the function of the following short cut keys in PowerPoint,

 

Description Column B
To redo an action that has just been undone CTRL+Y
It creates a new presentation window CTRL+N
This is to opens a search browser to open a saved file in the computer CTRL+O

 

 

 

Question No: 33      ( Marks: 3 )

 

 

 

How we can change the Web browser Home Page/Start page

 

Question No: 34      ( Marks: 5 )

 

 

  1. a.         What is electronic mailing? Give its basic concept and usage.

Electronic mail, also written as E-mail, is an electronic transmission of messages, letters and documents. It includes point to point services in which text file, that is, sent or received can be edited. The basic concept of E-mail is to send and receive messages as quickly as possible with the addition of sounds, graphics, links and etc, which can never be possible through the old postage system as that took long and also has to go through countries borders.

E-mail typically is used for conversations that are not urgent and for dialogues that are expected to continue over a period of time. The structure of e-mail eliminates interruptions associated with telephone conversations or electronic pagers. It also permits asynchronous communication, which can benefit both the sender and the recipient in our busy society.

  1. b.         What are Computer Viruses?

 

Solution:

A computer virus is a computer program that can copy itself and infect a computer. The term “virus” is also commonly but mistakenly used to refer to other types of malware, including but not limited to adware and spyware programs that do not have the reproductive ability. Viruses can increase their chances of spreading to other computers by infecting files on a network file system or a file system that is accessed by another computer.

Example: Trojan horses.

 

Question No: 35      ( Marks: 5 )

 

 

What is slide layout? Is there any way to change the default layout of the slide? If yes, than explain in your own words.

 

Solution:

The slide layout in PowerPoint is the arrangement of all the items that make up your slide, such as title, graphics or text boxes. Yes we can change the default layout.

To modify the layout, first you will need to go into the view tab and then click on the slide master button. Then click on the first slide, and changes that you make to this slide will be used by the other layout slides shown below the slide master. Use all of the tools on the tab to set the dimensions, theme and background styles for your slides.

When you have finished this, click in the title text box and use the tools in the drawing tools format tab and the home tab in order to modify the style of your text. Next click on the contents text box and change the styles for the different levels of text.

 

Question No: 36      ( Marks: 5 )

 

 

How we can modify column widths and row heights?

 

Solution:

By placing the mouse on the edge of the grid of the column or row. The pointer will change its shape and drag the pointer then to adjust its width.

CS001- VU-Computer Proficiency License MIDTERM Solved/Unsolved Papers Spring 2010

ALL NEW RESULTS
Educational News

Updated Educational News

Categories
POSTS BY DATE
December 2016
M T W T F S S
« Sep    
 1234
567891011
12131415161718
19202122232425
262728293031