PC Packages

1.    What is the Graphical User Interface? Discuss the use of status bar, title bar and menu bar in detail?  

2.    What is a mail merge? Discuss mail merge concepts with a suitable example.  

3.    Explain the following operations with an example. 

Copy a text and place in another position

ANS  

Create table with 5 rows and 3 columns

 
Adding a page numbers in the center of the page

Set the margins.  

4.    (a) What is worksheet? How does it differ from spreadsheet? What are the data types placed in a cell? Explain.

(b) Discuss the facilities available to format the data in the cell with an example.  

5 .    (a)What is a chart? Discuss step by step to create various types of chart using the given set of data.

(b) Discuss various operations in MS - ACESS with an example. 

ANS 
 (c) Delete a field

(d) Insert a record

(e) Sorting the records

(f) Creating and printing reports  

Assignment B

QUESTIONS

(a) List the benefits for PowerPoint facility in MS-OFFICE 

(b) Give a suitable operational sequence to do the following: 

Insert a picture in the slide

Add an excel sheet

Add date and time in all the slides.   

2. Write short notes on:

Find and replace a text in Word

Functions in Excel

Creating table with constraints
Format the slides in PowerPoint.   

a) Explain the uses of finding files/folders option and run command.

b) What are the steps involved in indenting, paging and changing margins in word document?

c) How will you perform a spell check and auto text in word?

ANS 
Open Microsoft Word, FrontPage, or Outlook, and the document you want to edit.
Press the F7 key.
or
Open Microsoft Word, FrontPage, or Outlook, and the document you want to edit.
Click Tools
Click Spelling and Grammar

d) State the procedure for using chart wizard. How would you choose the appropriate chart?

e) How to change the ‘column-width’ and use ‘paste’ function in Excel?

f) Explain creating and using Auto forms in Access.

g) State the steps for the creation and sizing of an organizational chart in PowerPoint?

h) Explain the Calendar views available in MS outlook.
i) What are the functions and uses of title bar, status bar, menu bar and toolbars in Windows?

j) Explain the steps involved in inserting, moving and resizing of pictures and their printing.

ANS   
k) What are the uses of formula function? Explain with examples the uses of “sum” function in Excel.

l) Discuss the creation, entering and editing a ‘Table’ in Access.   

Assignment C

Question 1 
To keep track of different editions of a document which feature we will use?

versions
editions
traces
tracks
 
Question 2 
What is the use of bookmarks?

To jump to a specific location in the document
To ignore spelling mistakes
To save alignments as it is.
To correct the spellings.
 
Question 3 
How to insert a sound file in word document?

From insert -> subject menu option
From insert -> object menu option
From insert -> sound menu option
From insert -> file menu option
 
Question 4 
How many maximum number of columns can be inserted in the word document?

45
50
55
65
 
Question 5 
What is the default font size of a new Word document based on Normal template?

10 pt
12 pt
8 pt
14pt
 
Question 6 
A list of instructions used by a computer is called

Output
Program
CPU
Text

Question 7 
On an excel sheet the active cell in indicated by?

By italic text
A blinking border
A dark wide border
A dotted border
 
Question 8 
A value used in a formula that does not change is called a?

Varaible
Constant
Cell address
Static
 
Question 9 
Which among following is not associated with spelling dialogue box?

Change
Ignore All
Ignore
Edit
 
Question 10 
Which among following is associated with excel?

Word Processor
Presentation
Graphic program
Spreadsheet
 
Question 11 
Macros can be executed from the which of the following menu?

Format
Tools
Insert
Home
 
Question 12 
How is data organized in a spreadsheet?

Rows and columns
Lines and spaces
Height and width
Layers and planes
 
Question 13 
VLOOKUP function used to?

Check if two cells are identical
"Looks up text that contain ""v"""
Finds related records
None of above

Question 14 
Which among following wildcard characters are recognized by excel?

< and >
*and?
+ and -
! and ^
 
Question 15 
Which function in excel counts the numbers of characters in a cell?

LENGHT
LEN
LT
LGT
 
Question 16 
Shortcut to edit the selected cell?

F3
F5
F2
F6
 
Question 17 
How many recent files you can display on File menu at maximum?

15
7
3
9
 
Question 18 
Which function will you use to enter current time in a woksheet cell?

=time()
.=now()
.=nowtime()
.=currentTime()

Question 19 
We can cancel marquee by pressing?

Ctrl + Esc
Shift + Esc
Esc
Alt + Esc
 
Question 20 
The intersection of row and column is called a?

data
set
dataset
cell
 
Question 21 
Which of the following is not one of PowerPoint view?

Slide show view
Outline view
Presentation view
Slide view
 
Question 22 
Which PowerPoint view works best for adding slide transitions?

Slide sorter view
Slide show view
Slide view
Notes view
 
Question 23 
"To preview a motion path effect using the custom animation task pane, we should:"

click the show effect button
click the play button
double click the motion path
none of above
 
Question 24 
Which of the following will not advance the slides in a slide show view?

The enter key
The space bar
The esc key
The mouse button
 
Question 25 
Which option can be used to set custom timings for slides in a presentation?

Slide Show Setup
Rehearsal
Slider Timings
Slider Timer
 
Question 26 
Which key can be used to view Slide show?

F9
F5
F6
F2
 
Question 27 
How can we view slide show repeated continuously?

none
loop more
repeat continuously
loop continuously until Esc
 
Question 28 
Which key do you press to check spelling?

F5
F7
F3
F9
 
Question 29 
"The spelling dialog box can be involved by choosing spelling from ____ menu,”

tools
insert
view
file
 
Question 30 
Power Point can display data from which of the following add-in software of MS Office?

Equation Editor
Photo Album
All of above
Organization Chart
 
Question 31 
How can we stop a slide show?

Press Escape
Press the right arrow
Press Ctrl + A
Press Ctrl + S
 
Question 32 
How we can put a Chart in the presentation using PowerPoint?

Insert -> Pictures -> Chart
View -> Chart
Edit -> Chart
Insert -> Chart
 
Question 33 
Which file is responsible to start MS Word?

Win.exe
Word.exe
Wordwin.exe
Winword.exe
 
Question 34 
Which key will open an Open dialogue box?

Alt + F12
#REF!
F12
Ctrl + F12
 
Question 35 
What is the Short cut key for line break?

Alt + Enter
CTRL + Enter
Space + Enter
Shift + Enter
 
Question 36 
Which of the following is not available on the Ruler of MS Word screen?

Left Indent
Center Indent
Tab stop box
Right Indent
 
Question 37 
Background color on a document is not visible in?

Reading View
Web layout view
Print Preview
Print Layout view
 
Question 38 
Landscape is?

Page Layout
Paper Size
A font style
Page Orientation
 
Question 39 
Which is not a font style?

Bold
Regular
Italic
Superscript
 
Question 40 
The processor which performs arithmetical and logical operations is called

Cache Memory
Register
Control
ALU