Part-II
BASIC COMPUTER SKILL
SECTION-A: 80 Marks
Instructions: Each question under this section carries Two marks. Please read each question carefully and answer them by selecting the right one out of the multiple answers given below each as A, B, C, and D.
1.Which of the following is an absolute cell reference in MS-Excel?
A ) !A!1
B ) $A$1
C ) #a#1
D ) A1
2. In MS- Power Point, presentation designs regulate the formatting and layout for the slide and are commonly called :
A ) design plates
B ) templates
C ) placeholders
D ) blueprints
4. Which of the following should you use if you want all the slides in the presentation to have the same “look” in MS-PowerPoint?
A ) the slide layout option
B ) the add a slide option
C ) outline view
D ) a presentation design template
5. Which of the following is correct in MS-Excel?
A ) =power(2^3)
B ) =power(2*3)
C ) =power (2,3)
D ) None of these
6. How to go to page number 345 in an MS-WORD document containing 465 pages?
A ) Press Ctrl +F, then enter 345 and press enter
B ) Press Ctrl + R , then enter 345 and press enter
C ) Press Alt + G , then enter 345 and press enter
D ) Press Ctrl + G , then enter 345 and press enter
7. What is the maximum number of columns in a table in MS-word?
A ) 43
B ) 53
C ) 63
D ) 73
8. In MS-PowerPoint, the Header & Footer can be found on the insert tab in what group?
A ) Illustration group
B ) Object group
C ) Text group
D ) Tables group
9. In MS-Excel, to drag a selected range of data to another worksheet in the same workbook, use the :
A ) Ctrl Key
B ) Shift Key
C ) Alt Key
D ) Tab Key
10. A_______ is approximately one billion bytes.
A ) Megabyte
B ) Gigabytes
C ) Terabyte
D ) None of these
11. What does the VLOOKUP function do in MS-Excel?
A ) Looks up text that contains ‘v’
B ) Checks whether the text is the same in one cell as in next
C ) Finds value in an array
D ) All of the above
12. A feature in MS-Excel that display only the data in column (s) according to specified criteria :
A ) Formula
B ) Sorting
C ) Filtering
D ) Pivot
13. In MS-Word , which of the following do you use to change margins ?
A ) formatting toolbar
B ) page setup dialog box
C ) standard toolbar
D ) paragraph dialog box
14. In MS- PowerPoint how can you create a uniform appearance by adding a background image to all slides?
A ) Edit page layout
B ) Edit the slide master
C ) Use the autocorrect wizard
D ) All of the above
15. In MS-Excel the cell reference for a range of cells that starts in cell C1 and goes over to column H and down to row 10 is:
A) C1:10H
B) C1:H10
C) C1:H-10
D) C1:H:10
16. By default, your documents print in___ mode in MS Word.
A) Landscape
B) Portrait
C) Page Setup
D) Print View
17. What is the function of Ctrl+B in MS word?
A) It converts selected text into the next larger size of the same font
B) It adds a line break to the document
C) It makes the selected text bold
D) It applies italic to text
18. In MS-Excel you can create hyperlinks from the Excel workbook to:
A) A webpage on company internet
B) A web page on the internet
C) Other Office application documents
D) All of the above
19. In MS-Excel what does SUMIF function do?
A) Adds up cell values based on a condition
B) Adds all the numbers in a range of cells
C) Returns a subtotal in a list or database
D) Both (A) & (B)
20. In order to enter multiple rows in a cell in MS-Excel, which key(s) should be pressed after each line:
A) Enter
B) Ctrl + Enter
C) Alt + Enter
D) None of these
Match the following:
a) File extension for Power point file i) .doc
b) File extension for Word file ii) .xlsx
c) File extension for Excel file iii) .pptxiv
d) File extension for Text file iv) .doc).txt
A) a-iii, b-i, c-ii, d-iv
B) a-i, b-ii, c-iii, d-iv
C) a-ii, b-i, c-iii, d-iv
D) a-iv, b-ii, c-i, d-iii
21. The word FTP stands for :
A) File Transit Protocol
B) File Translate Protocol
C) File Transfer Protocol
D) File Typing Protocol
22. In MS-Excel the drag and drop method of copying or moving:
A) Can be used between a worksheet but not workbooks
B) Can be used between both workbooks and worksheets
C) Can be used between workbooks but not worksheets
D) None of these
23. In MS-PowerPoint, if you want to insert some slides from other presentation into current one choose:
A) From Insert menu choose Slides from Files
B) From Insert menu choose Slides from Presentation
C) From Insert menu choose Slides
D) None of the above
24. A function inside another function is called a ___function.
A) Nested
B) Round
C) Sum
D) Text
25. For the addition of a row at the end of a table in MS Word, move the cursor at the end and use:
A) All
B) Tab
C) Ctrl
D) Shift
26. Which one is not a Function in MS-Excel?
A) SUM
B) AVG
C) MAX
D) MIN
27. Which of these is a shortcut to add a border to the selected cell in MS Excel?
A). Ctrl + T
B) Ctrl + B
C) Shift + B
D) Ctrl + Shift + &
28. Which key should be pressed to start a new paragraph in MS-Word?
A) Down Cursor Key
B) Enter Key
C) Shift + Enter
D) Ctrl + Enter
29. Which input device cannot be used to work in MS Office?
A) Scanner
B) Light Pen
C) Mouse
D) Joy Stick
30. Which Key is used to rename a file in Windows Operating System?
A) F1
B) F5
C) F2
D) None of these
31. In MS-Excel how can you remove borders applied in cells?
A) Choose None on Border tab of Format cells
B) Open the list on Border tool in Formatting toolbar then choose first tool (no border)
C) Both of the above
D) None of the above
32. In MS-Excel which function displays row data in a column or column data in a row?
A) Hyperlink
B) Index
C) Rows
D) Transpose
33. The maximum Zoom percentage in MS-PowerPoint is:
A) 200%
B) 300%
C) 400%
D) 500%
34. In MS-PowerPoint when you were giving your presentation and you need to click a slide that’s few slides back. Best way to achieve this is:
A) Press ESC to get back into a normal view: click the slide thumbnail in normal view; then click the resume slide show button
B) Press backspace until your desired slide
C) Right click –>Goto Slide –> Select Slide
D) All of the above
35. A Firewall is used in PC for:
A) Authentication
B) Security
C) All of the above
D) None of these
36. In MS-Excel you want to paste a formula result – but not the underlying formula – to another cell. The procedure is to first copy the cell with the formula, then place the insertion point in the cell where you want to copy to. Then the next step is to:
A) Click the Paste button on the standard toolbar
B) Click the arrow on the paste button on the standard toolbar, then click formulas
C) Click the arrow on the Paste button on the standard toolbar, then click values
D) Both (A) & (C)
37. You have got a bunch of digital holiday photos you want to put into a slide show. What is the quickest method in MS-PowerPoint?
A) Apply a multiple-picture layout to several slides, and use the clipart icon on the slides to import your picture
B) On the Insert menu, point to the picture, click from file, and select your picture in a group for each slide
C) On the Insert menu, point the picture and click new photo album
D) All of the above
38. What will happen if you select 4 rows from row heading in MS-Excel and then right click and select insert?
A) Inserts a new row before the first selected row
B) Inserts 4 new rows before the first selected row
C) Inserts 8 new rows before the first selected row
D) None of the above
39. How do you insert a row in MS-Excel?
A) Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
B) Select the row heading where you want to insert the new row and select Edit >Row from the menu
C) Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
D) All of the above
40. In MS Excel, how do you change the column width to fit the contents?
A) Single-click the boundary to the left to the column heading
B) Double click the boundary to the right of the column heading
C) Press Alt and single-click anywhere in the column
D) All of the above
BASIC COMPUTER SKILL
SECTION-B: 20 Marks
Instructions: Each question under this section carries one mark. Please read each question carefully and answer them by selecting the right one out of the multiple answers given below each as A, B, C and D.
41. Which is the function button for spelling and grammar in MS Word?
A) F3
B) F5
C) F7
D) F9
42. In MS-PowerPoint, which of the following should be used when you want to add a slide to an existing presentation?
A) Edit, Add a New Slide
B) Insert, New Slide
C) File, Open
D) File, New
43. In MS-PowerPoint the entry effect as one slide replaces another in a show is called:
A) Animation
B) Slide transition
C) Custom animation
D) Preset animation
44. Which command brings you to the first slide in your presentation in MS-PowerPoint?
A) New slide button
B) Page up
C) Ctrl + home
D) Ctrl + end
45. What will be the shortcut key in MS Windows to perform the cut operation?
A) Ctrl+C
B) Ctrl+Z
C) Ctrl+P
D) Ctrl+X
46. Which of the following is the largest unit of storage?
B) KB
C) MB
A) GB
D) TB
47. In MS-Excel a circular reference is:
A) Geometric modeling tool
B) A cell that points to a drawing object
C) A formula that either directly or indirectly depends on itself
D) Always erroneous
48. The shortcut command of ‘save’ in MS Word:
A) Ctrl + A
B) ALT+F+S
C) Ctrl + S
D) Both (B) and (C)
49. Ctrl + Y is the short cut key for MS:
A) Undo the last action
B) Paste the selected text
C) Cut the selected text
D) Redo the last action
50. Which is the short cut of ‘replace’ in MS Word?
A) Ctrl+ R
B) Ctrl + F
C) Ctrl + H
D) Ctrl + Y
51. In MS-PowerPoint which of the following can you use to add time to the slides in a presentation?
A) Slide Show menu
B) Rehearse timing button
C) Slide transition button
D) All of the above
52. What type of chart is useful for showing trends or changes over time in MS-Excel?
A) Pie Chart
B) Column Chart
C) Line Chart
D) Dot Graph
53. In MS-PowerPoint in order to see all the slides on one screen use:
A) View, slide sorter
B) View, slide
C) View, master
D) View, slide show
54. The ___ feature of MS Excel quickly completes a series of data.
A) AutoComplete
B) Auto Fill
C) Fill Handle
D) Sorting
55. What is the shortcut to insert a comment in MS Excel?
A) Ctrl + F6
B) Alt + F8
C) Shift + F9
D) Shift + F2
56. If a new device is attached to a computer, such as a printer or scanner, its ____be installed before the device can be used.
A) Buffer
B) Driver
C) Pager
D) Server
57. In MS-Word, how to change the author’s name for review comments?
A) File>Open>Change Author
B) Right Click > Click on Author > Change Name
C) Tracking > Track Changes Option >Change User name
D) None of these
58. How to Add a new word into Dictionary of MS Word?
A) In Spelling & Grammar > New word > enter the word> save
B) Insert>select word >Add to Dictionary
C) In Spelling & Grammar > find the new word >Add
D) Word provides no such option to add more words to its Dictionary
59. What is the use of Track Changes in MS Word?
A) To lock the document if changes are done
B) To record changes done to the document by multiple editors
C) To change the word document to excel format
D) All of the above
60. In MS-Excel, value used in a formula that does not change is called a:
A) Ceil address
B) Constant
C) Function
D) None of these