Font size
WorksheetsData Entry Operations (Full)
Total questions: 70
Worksheet time: 2hrs 15mins
A browser is also known as (a)
The intersection of a row and a column in Excel is know as a (a)
HTML consists of certain keywords called (a)
____ is the extension of a powerpoint file
.xlsx
.mdb
.ppt
.pptx
The program written by the programmer in high level language is called _____.
Source program
Object program
=ROUND(78.4164, 2) will return ______
78.42
78
78.4
Page breaks can be inserted with the shortcut key (a)
Write the steps to add page numbers to a document in MS-Word
What are two ways to select the entire document?
Using keyboard: Ctrl + A
Using mouse: Right click --> Select All
Using keyboard: Ctrl + S
Using mouse: Double Click
Using keyboard: Hold Shift key and select the full page using arrow keys
Using mouse: Hold down mouse button and drag till the end of the first page
Using keyboard: Ctrl + Shift + A
Using mouse: Triple Click
Describe any four slide layouts in Powerpoint
123.121.93.2 is a valid IP address.
True
False
Spreadsheet software is a generalized package.
True
False
FORTRAN is a popular object oriented programming language.
True
False
Format painter is used to color the text.
True
False
Text can be easily inserted into the slides using:
Normal view
Outline view
Slide Sorter view
Normal view and Outline view
How do you move from one slide to another slide?
Using Scroll bars
Using Next Slide and Previous slide buttons
Using outline pane
All of the above
F12 is the shortcut key for (a) .
Define: Peripheral devices
Write a short note on: Application software
Give two differences between: Sum() function and Sumif() function
Write the steps to hide rows in MS-Excel. What is the use of this feature?
Give two differences between: TCP and IP
Identify the tab stops and write their names in the given sequence:
How will you protect a document as read-only?
Windows 98 is not a GUI-based operating system.
True
False
The binary system has only two values: ___ and ___.
(Write the answer as '_ and _')
(a)
=ABS(–4567) it will return ____.
-4567
4567
Ctrl+K is used to ____.
Create web hyperlink
Make text All caps
Go to previous cell
Write a formula to display the maximum marks in Science in cell B6
If the active cell contains a formula, it will be shown on _____
Formula Bar
Name box
Nowhere
Active Cell
CRT stands for (a)
We cannot retrieve files, even if they are deleted from Recycle Bin.
True
False
Ruler Bar is used to set the tab Stop.
True
False
Define: Control Unit
Write a short Note on: Pivot table
Write a short Note on: Assembler
How can text in Microsoft Word be presented in points using bulleted and numbered lists?
Write a function to calculate the total marks for each student in column D.
Write a formula to calculate the average for each student and display in
column E.
Write a formula to display the minimum marks in Maths in cell C7.
Machine language and (a) are low-level languages
In Windows XP start menu, ____ displays a list of music/songs used by the current user.
My Music
My Recent Documents
Control Panel
Help and Support
Run command in the Start menu can be used to start an application program or execute a DOS command
True
False
When you merge the main document with data source, (a) is produced.
.gov is the domain name code for ____.
Government organizations
Non-profit organizations
Educational institutions
Commercial entities
Geographical domains are country specific domains
True
False
What is a Browser? Give two examples
Every page on Web has a unique address, called (a) of the page
All the calculations in a computer are performed by memory.
True
False
Windows XP is the only operating system in use.
True
False
Define: End-of-document marker in MS-Word
Write a short note on: Taskbar
Write a short note on: Formulas in MS-Excel
Give two differences between: Outline view and Slide sorter view in PowerPoint
Give two differences between: ISDN and Leased connection
How will you hide ruler in MS Word?
How will you modify the password given to a document?
Write a short note on: Title Case
Write a short note on: SMTP
Give two differences between: Area Charts and Surface Charts
Give two differences between: Bar Charts and Pie Charts
Give two differences between: Uploading and Downloading of a file
Give two differences between: ALU and CPU
What is Page Formatting?
List any 3 features/ options used for page formatting and explain any 2 features/ options in detail.
Answer:
(i) (C1/2*D1)/A1
(ii) A2+(D2/2+C3)
(iii) (A4+C4)/((C4/2)-5)
(iv) ((A1-B4)+C1)/((C4/2)+B4)
SMTP stands for
Simple Mail Transfer Protocol
Standard Mail Transfer Protocol
Simple Mixed Trail Protocol
Internet e-mail addresses typically have two main parts:
User ID and Domain Name/ Host Name
At sign (@) and dot sign (.)
Write the steps to send a new email.
AltaVista is a search engine
True
False
The cell address B4 denotes column 4 and row B.
True
False
