Sub Code: - 1600303
2019(ODD)
Time : 3Hrs
Semester
III(New)
ISP
Full Marks : 70
Pass marks : 28
Group A
Choose the most suitable answer from the following options: - (1*20=20)
(i) MS Excel is used for creating:
(a) Presentation
(b) Documents
(c) Sending Mails
(d) Spreadsheets
(ii) In Excel, Charts are creating using:
(a) Pie chart
(b) Pivot chart
(c) Bar chart
(d) Chart wizard
(iii) All macro, keyboard shortcuts include the ________ key
(a) Alt
(b) Ctrl
(c) F11
(d) Shift
(iv) MS Excel is a ___________
(a)Language
(b) System software
(c) Package
(d) None
(v) A worksheet can have a maximum of _________ number of rows in MS excel 2000
(a) 256
(b) 1024
(c) 32000
(d) 65535
(vi) Short cut key to save a spread sheet?
(a) Ctrl + S
(b) Alt + S
(c) F11 + S
(d) Shift + S
(vii) Which tool bar allows changing of fonts and their size in MS Word.
(a) Standard
(b) Formatting
(c) Print preview
(d) None of these
(viii) From which menu you can insert Header and Footer?
(a) Insert menu
(b) View menu
(c) Format menu
(d) Tools menu
(ix) What is the short cut key you can press to create a copyright symbol?
(a) Alt+ Ctrl+ C
(b) Alt+ C
(c) Ctrl + C
(d) Ctrl+ Shift+ C
(x) What is the smallest and largest font size available in font size tool on formatting tool bar?
(a) 8 and 72
(b) 8 and 62
(c) 12 and 72
(d) None of the above
(xi) Which of the following is not a valid data type in excel
(a) Number
(b) Character
(c) Label
(d) Date/ Time
(xii) Which menu option can be used to split windows into two?
(a) Format -> Window
(b) View -> Window -> Split
(c) Window -> Split
(d) View -> Split
(xiii) Which of the following formulas will excel not be able to calculate
(a) = Sum (Sales) – A3
(b) = Sum (A1 : A5) * .5
(c) =Sum (A1: A5)/ (10 -10)
(d) =Sum (A1: A5) -10
(xiv) To drag a selected range of data to another worksheet in the same workbook, use the ____
(a) Tab key
(b) Alt key
(c) Shift Key
(d) Ctrl Key
(xv) In a worksheet you can select ________
(a) The entire worksheet
(b) Rows
(c) Columns
(d) All of the above
(xvi) An excel workbook is a collection of
(a) Workbooks
(b) Works sheets
(c) Charts
(d) Work sheets
(xvii) Excel files have a default extension of?
(a) xls
(b) xlw
(c) Wki
(d) 123
(xviii) Which of the following in not one power points view?
(a) Slide show view
(b) Slide view
(c) Presentation view
(d) Outline view
(xix) Which short cut key inserts a new slide in current presentation?
(a) Ctrl + N
(b) Ctrl + M
(c) Ctrl + S
(d) All of the above
(xx) From which menu you can access picture, text box, chart etc?
(a) File
(b) Edit
(c) Insert
(d) View
Group:-"B"
➥ Answer all
Five Questions: -
(5*4=20)
OR
How is table inserted into the
word document? Describe the procedure.3. What is absolute cell addressing in a worksheet?
OR
What are the major components of
MS word 2000? Describe them.4. Describe the use of the formula bar.
OR
How do you think that MS Power
Point is useful justify.5. How picture is inserted into the word document? Describe the procedure.
OR
Write the steps to create a
macro in MS- Word 20006. Explain the use of auto sum feature in MS-Excel with suitable example.
OR
Write the steps for sorting and
filtering in MS-Excel.
Group:- "C"
➥ Answer all
Five Questions: -
(5*6=30)
OR
What are the two important
aspects to perform the mail merge function?8. Write the steps of creating a power point presentation and also explain various main elements of office button.
OR
Describe in detail functions of
the vertical and horizontal scroll bars?9. Explain the available formatting tools of MS-Office.
OR
Explain the steps for creating
header and footer in MS-word.10. Discuss the merit and limitations of word processing and spread-sheet software of computer?
OR
What are different categories of
charts? Write the steps to create a chart in MS-Excel11. Write short notes on:
a. Working and manipulating data with Excel
b. Use of Dragging and moving
OR
What is mail merge? Write down its advantages and disadvantages and steps
for creating mail merge.
No comments:
Post a Comment
Please do not enter any spam link in the comment box and use English and Hindi language for comment.