FINALTERM EXAMINATION
Spring 2009
CS001- VU-Computer Proficiency License

Marks: 75

Question No: 1 ( Marks: 1 ) - Please choose one
In excel the intersection of a row and a column is called:

  • data
  • a field.
  • a cell.
  • an equation.


Sponsored Links


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
What is the format of a spreadsheet?

  • Round
  • Rows and Columns
  • Square
  • Wide


Question No: 4 ( Marks: 1 ) - Please choose one
Which is an absolute address?

  • $C$4
  • 10700 - 105 Ave.
  • C4
  • None of these


Question No: 5 ( Marks: 1 ) - Please choose one
Which one is a relative address?

  • $C$4
  • 256
  • C4
  • None of these


Question No: 6 ( Marks: 1 ) - Please choose one
What displays the contents of the active cell?

  • Name Box
  • Row Headings
  • Formula Bar
  • Task Pane


Question No: 7 ( Marks: 1 ) - Please choose one
Which function calculates the largest value in a set of numbers?

  • Average
  • Count
  • Min
  • Max


Question No: 8 ( Marks: 1 ) - Please choose one
What do you use to create a chart?

  • Chart Wizard
  • Pie Wizard
  • Excel Wizard
  • Data Wizard


Question No: 9 ( 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: 10 ( Marks: 1 ) - Please choose one
The ____ assigns and controls top-level domains.

  • DNS server
  • Internet Corporation for Assigned Names and Numbers (ICANN)
  • World Wide Web Consortium (W3C)
  • National Science Foundation


Question No: 11 ( Marks: 1 ) - Please choose one
____ is the transmission of messages and files via the Internet.

  • FTP
  • Video conferencing
  • E-mail
  • Instant messaging


Question No: 12 ( Marks: 1 ) - Please choose one
____ are shortcuts to a location on a Web server to which users publish documents and other files.

  • Chat rooms
  • Newsgroups
  • Video conferences
  • Web folders



Question No: 13 ( Marks: 1 ) - Please choose one
____ refers to the amount of data, instructions, and information that can travel over a
communications channel.

  • Latency
  • Transfer rate
  • Bandwidth
  • Broadband


Question No: 14 ( Marks: 1 ) - Please choose one
A network that uses the same lines that bring electricity into a house is called a(n) ____

  • Ethernet network
  • Powerline cable network
  • Phoneline network
  • HomeRF network


Question No: 15 ( Marks: 1 ) - Please choose one
The private combination of characters associated with a user name that allows access to
certain computer resources is called a(n) ____

  • audit trail
  • password
  • possessed object
  • biometric device


Question No: 16 ( Marks: 1 ) - Please choose one
An assault on a computer whose purpose is to disrupt access to the Web is called a ____

  • virus
  • DoS attack
  • worm
  • DDoS attack


Question No: 17 ( Marks: 1 ) - Please choose one
A device that contains surge protection circuits and one or more batteries that can provide
  • power during a temporary or permanent loss of power is called a(n) ____
  • surge protector
  • generator
  • surge suppressor
  • uninterruptible power supply (UPS)


Question No: 18 ( Marks: 1 ) - Please choose one
To safeguard personal information, ____

  • write your telephone number on credit receipts
  • use shopping club and buyer cards
  • do not reply to spam for any reason
  • complete all requested information on registration forms


Question No: 19 ( Marks: 1 ) - Please choose one
_____Edits the active cell and positions the insertion point at the end of the cell in Excel
Sheet
.
  • F2
  • F3
  • F1
  • F4


Question No: 20 ( Marks: 1 ) - Please choose one
Pressing the key once and releasing it is called a

  • Key stroke
  • Key strike
  • Key action
  • None of these


Question No: 21 ( Marks: 1 ) - Please choose one
To go to the end of the document used following keys

  • Ctrl + home
  • Shift + Home
  • Shift + End
  • Ctrl + end


Question No: 22 ( Marks: 1 ) - Please choose one
To view properties of a folder

  • Press F4
  • Right click on folder and select properties
  • Double click on folder
  • None of the above


Question No: 23 ( Marks: 1 ) - Please choose one
Start button resides at the left side of the

  • Menu bar
  • Tool bar
  • Status bar
  • Task bar


Question No: 24 ( Marks: 1 ) - Please choose one
An unsolicited e-mail message sent to many recipients at once is known as ____.


  • Email-spyware
  • E-mail spam
    c. junk mail
    d. a Web bug
  • Junk mail
  • a Web bug


Question No: 25 ( Marks: 1 ) - Please choose one
In Word which of the following shortcut key combination, Moves the cursor to the
beginning of the document.

  • Ctrl + Backspace
  • Ctrl + Page Up
  • Ctrl + Home
  • Ctrl + End


Question No: 26 ( Marks: 1 ) - Please choose one
In Word which of the following shortcut key combination, Open the Task Pane.

  • Ctrl + F1
  • Ctrl + F2
  • Ctrl + F3
  • Ctrl + F4


Question No: 27 ( Marks: 1 ) - Please choose one
In Word which of the following shortcut key combination, Repeat the last action
performed (Word 2000+)

  • F4
  • F5
  • F6
  • F7


Question No: 28 ( Marks: 1 ) - Please choose one
Which formula can add the all the numeric values in a range of cells, ignoring those
which are not numeric and place the result in a different cell ?

  • Count
  • Average
  • Sum
  • None of these


Question No: 29 ( Marks: 1 ) - Please choose one
SMS stands for:

  • Short mail service
  • Short management system
  • Digital Angel
  • Short message service


Question No: 30 ( Marks: 1 ) - Please choose one
The act of defecting or destroying computer equipment is known as ____

  • hardware vandalism
  • software piracy
  • hardware theft
  • information theft


Question No: 31 ( Marks: 1 )
What is meaning of #Value if shown as error in MS Excel?

Question No: 32 ( Marks: 1 )
In PowerPoint which shortcut key is used to save a presentation file?

Question No: 33 ( Marks: 2 )
How we can insert clip art in PowerPoint presentation.

Question No: 34 ( Marks: 2 )
How we can display a bookmarked Web page

Question No: 35 ( Marks: 3 )
How we can Insert a picture, image, drawn object into a master slide

Question No: 36 ( Marks: 3 )
Describe the function of the following short cut keys in PowerPoint,

001.JPG

Question No: 38 ( Marks: 5 )
a. Write down the procedure of searching any information on web.
b. How we can use book marks in web navigation.

Question No: 39 ( Marks: 5 )
Lets say, you have a presentation in powerpoint of around 20 slides. Write steps
to find word "Powerpoint" from the text and than replace it with new word "MS
Power Point".

Question No: 40 ( Marks: 10 )
What is slide? Explain 4 different views of presentation in your own words.

Question No: 41 ( Marks: 10 )
Define Excel's max function. Write steps to find the min from the cells C1 to C6
with data 114,165,178,143,130,167 using Max formula.