BS CIT PRACTICAL PRACTICE QUESTION
1. In the given document, insert the text box “Austin Quote” & type ‘Welcome’ text inside the text box.
Go to insert tab
Go to text group
Click on text box dropdown button
Click on Austin Quote
Type Welcome
2. In the given word document, change the case of third sentence to UPPERCASE.
Select third sentence
Go to home tab
Go to font group
Click on change case dropdown button
Click on UPPERCASE
3. Remove the drop cap effect form the given document.
Select the first word of the document
Go to insert tab
Go to text group
Go to drop cap dropdown button
Click on none
4. Apply ‘’Drop Cap’’ in margin effect to the first sentence of given document.
Select the first line
Go to insert tab
Go to text group
Click on drop cap dropdown button
Click on In Margin
5. In the given MS word document, replace the word ‘’Shelf’’ with the word ‘’desk’’ throughout the document.
Go To Home Tab
Go To Editing Group
Click On Replace Button
Type Shelf In First Column And desk In Second Column
Click On Replace Button
Click On Ok
Click On Close
6. In the given MS word document, replace the word ‘’programmer’’ with the word ‘’developer’’ throughout the document.
Go To Home Tab
Go To Editing Group
Click On Replace Button
Type programmer In First Column And developer In Second Column
Click On Replace Button
Click On Ok
Click On Close
7. In the given document, change the capitalization of entire document to ‘lowercase’.
Select all
Go to home tab
Go to font group
Click change case dropdown button
Click on lowercase
8. In the given document, insert a table of five rows and six columns at the top of the document.
Go to insert tab
Go to table group
Click on table
Click on insert table
Type row value and column value
Click on ok
9. Remove the ‘’Picture Content Control’’ from the given document.
10. Apply ‘Bold’ font style to the entire document.
Select all
Go to home tab
Go to font group
Click on bold button
11. Remove the numbered list from the given document.
Select all
Go to home tab
Go to paragraph group
Click on number list
12. Remove the table border from the given document.
Select all border
Go to home tab
Go to paragraph group
Click on border dropdown button
Click on No border
13. Highlight the third sentence in the given document with ‘Red’ color.
Select third sentence
Go to home tab
Go to font group
Click on text highlight color dropdown button
Click on red color
14. You have a created a birthday greeting card for your friend. You want to change the background of the greeting card. How will you apply “purple Mesh’’ texture effect to the given greeting card?
Go to design tab
Go to page background group
Click on page color dropdown button
Click on fill effect
Click on texture
Scroll and find purple mesh
Click on ok
15. Delete the entire table from the given document.
Select entire table
Press delete key
16. In the given document, split all text into four columns.
Select all
Go to page layout
Go to page set up group
Click on columns dropdown button
Click on more columns
Type four in number of column
Click on ok
17. Apply ‘Light green’ page color to the given document.
Go to design tab
Go to page background group
Click on page color dropdown button
Click on light green
18. Apply ‘’Bold’’ and ‘’Underline’’ style the entire document.
Select all
Go to home tab
Go to font group
Click on bold option
Click on underline option
19. Set 1.5 inch to margin for the given document.
Go to page layout tab
Go page setup group
Click on margins dropdown option
Click on custom margins
20. In the given MS word document, replace the word “UNIX” with the word “LINUX” throughout The Document.
Go To Home Tab
Go To Editing Group
Click On Replace
Type UNIX In First Column And LINUX In Second Column
Click On Replace
Click On Ok
Click On Close
21. Apply artistic page border to the given document.
Go to design tab
Go to page background group
Click on page border
Click on Art page border column dropdown button
Click on any border
22. Delete any one table column from the given document.
Select any one table column
Click on delete
23. Set 1.5 inch left margin for the given document.
Go to page Layout tab
Go to page setup group
Click on custom margins
Put 1.5 in left column
Click on ok
24. Remove watermark form the given document.
Go to design tab
Go to page background group
Click on watermark dropdown button
Click on remove watermark
25. Add watermark text ‘Envelope’ in the given document.
Go to design tab
Go page background group
Click on watermark drop down button
Click on custom watermark
Check text watermark
Type Envelope in text column
Click apply and ok
26. In the given MS word document, replace the word “magic” with the word “drama” throughout the word document.
Go to home tab
Go to Editing group
Click on replace
Type magic in first column and drama in second column
Click on replace
Click on ok
Click on close
27. Move the worksheet ‘Holiday List’ and insert it after the worksheet ‘list info’.(Excel)
Click on holiday List
Go to home tab
Go to cells group
Click on format
Click on move or copy sheet
Click on move to end
click on ok
28. In the given worksheet move car loan and insert it after the worksheet Home Loan.
Click on car lone
Go to home tab
Go to cells group
Click on format
Click on move or copy sheet
Click on move to end
click on ok
29. Change the width of column c to 25.
Click on column c
Go to home tab
Go to cells group
Click on format
Click on column width
Put the value
Click on ok
30. Change the row height to 30 for the row number 5.
Click on row 5
Go to home tab
Go to cells group
Click on format
Click on row height
Put the value
Click on ok
31. In the given spreadsheet, insert a new column after column E.
Click on column F
Go to home tab
Go to cells group
Click on insert
32. Delete worksheet “List Info” from the given spread sheet.
Right click on List Info worksheet
Click on delete
33. Set 75% zoom level for the given worksheet.
Go to view tab
Go to zoom group
Click on zoom option
Put the value in custom column 75
34. Set 80% zoom level for the given worksheet.
Go to view tab
Go to zoom group
Click on zoom option
Put the value in custom column 80
35. In the given worksheet file, insert a new column after column B.
Click on column C
Go to home tab
Go to cells group
Click on insert
36. In the given worksheet, insert a new column after column A.
Click on column B
Go to home tab
Go to cells group
Click on insert
37. Merge and center the heading “Blood Donor Database” from the cell A4 to H4.
Select A4 to H4
Go to home tab
Go to alignment group
Click on merge and center
38. Delete worksheet “Home Loan” from the given the spreadsheet.
Right Click on Home Loan sheet
Click on delete
39. Change the width of column E to 15.57.
Click on E column
Go to home tab
Go to cells group
Click on column width
Put the value
Click on ok
40. Set 90% zoom level for the given worksheet.
Go to view tab
Go to zoom group
Click on zoom option
Put the value in custom column 90
Click on ok
41. In the given spreadsheet, select row number 6 and move to row number 1 using cut paste option.
Right Click on row 6
Click on cut
Right Click on row 1
Click on paste
42. In the given spreadsheet, show legend elements at the bottom of the chart.
Click on given chart
Go to design tab
Go to chart layout group
Click on add chart element
Click on legend
Click on bottom
43. Apply Style 6 chart style to the given chart.
Click on chart
Go to design tab
Go to chart style group
Click on 6 chart style
44. Use ‘replace all’ option to replace all occurrences of text “Candidate” with student’’.
Go to home tab
Go to editing group
Click on find and select option
Click on replace
Type Candidate in first column and student in other column
Click on replace all and ok
Click on close
45. In the given spreadsheet, remove all cell formatting from A1:D1 cell range.
Select A1 to D1
Go to home tab
Go to editing group
Click on clear drop dropdown button
Click on clear format
46. Use the replace option to replace for all occurrences of “Price” with “Cost”.
Go to home tab
Go to editing group
Click on find and select option
Click on replace
Type Price in first column and Cost in other column
Click on replace and ok
Click on close
47. In the given worksheet, keep first two columns visible while scrolling in the worksheet.
48. Change the row height to 35 for the row number 1.
Click on row 1
Go to home tab
Go to cell group
Click on format
Click on row height
Put the value 35
Click ok
49. In the worksheet outfit the width of the column B.
Click on B
Go to home tab
Go to cells group
Click on format
Click on Auto Fit Column Width
50. Set 70% zoom level for the given worksheet.
Go to view tab
Go to zoom group
Click on zoom
Put the value 70 in custom column
51. In the given worksheet apply ‘Verdana’ font to the cell H12.
Click on H12
Go to home tab
Go to font group
Click on font family column
Type Verdana
Press enter
52. In the given presentation insert a new blank slide at the end.
Go to home tab
Go to slides group
Click on slide button
53. Add new five slides in the given presentation.
Go to home tab
Go to slides group
Click on slide five times
54. In the given presentation delete any tow slides.
Click on any slide
Press delete
Click on any slide
Press delete
55. In the given presentation, insert blank slide at the end. Insert text box with the text: picture in the
second slide (slide Number 2).
Go to home tab
Go to slide group
Click on slide
Go to second slide
Go to insert tab
Go to text group
Click on text box and type Picture
56. In the given presentation, insert a new slide with “Title and content “layout at the end.
Go to last slide
Go to home tab
Go to slides group
Click on new slide dropdown button
Click on Title and content
57. Create two additional Blank slides in the presentation and view presentation through the “Slide
Sorter View”.
Go to home tab
Go to slides group
Click on new slide two times
Go to view tab
Go to presentation view click on Slide Sorter
58. In the given presentation, insert a new slide with “Picture with caption “Layout at the end.
Go to last slide
Go to home tab
Go to slides group
Click on New Slide dropdown button
Click on Picture with caption
59. In the given presentation, insert a new slide with “Two Content” layout at the end.
Go to last slide
Go to home tab
Click on New Slide dropdown button
Click on Two Content
60. Display the given presentation in “Notes Page View”.
Go to view tab
Go to Presentation view
Click on Notes Page view
61. In the presentation, insert a new slide with “Content with Caption” layout ate the end.
Go to last slide
Go to home tab
Click on New Slide dropdown button
Click on Content with Caption
62. In the given presentation, change the case of the paragraph present on the Third slide to
“lowercase”.
Go to third slide
Select the paragraph
Go to home tab
Go to font group
Click on change case
Click on lowercase
63. In the given presentation, delete all the images present on second slide.
Go to second slide
Select the all picture
Press delete key
64. In the given presentation, change the case of the paragraph present on the third slide to
“Capitalize Each Word”.
Go to third slide
Select the paragraph
Go to home tab
Go to font group
Click on change case
Click on Capitalize Each Word
65. In the given presentation, change the line spacing of the title present on first slide to “1.5 lines”.
Click on end of the title
Go to home tab
Go to paragraph group
Click on Line Spacing
Click on 1.5
66. In the given presentation, insert action button “home” anywhere in the last slide (slide no 2).
67. In the given presentation, change the line spacing of title present on first slide to “3.0 lines”.
Go to first slide
Click the end of title
Go to home tab
Go to paragraph group
Click on Line spacing
Click on 3.0
68. In the given presentation, replace the “Announcement” with the word “Declaration” using “find
and replace” option.
Go to home tab
Go editing group
Click on replace button
Type Announcement in first column Declaration in second column
69. In the given presentation, insert “pyramid list” smart art graphic in the second slide.
Go to second slide
Go to insert tab
Go illustration group
Click on SmartArt
Click on pyramid list
Click on any pyramid list
70. In the given presentation, add two blank slides. Apply ‘’Uncover’’ slide transition effect and “from
top” variation effect to all the slides.
Go to home tab
Go to sides group
Click on New Slide two times
Go to transition
Go transition to this slide group
Click on uncover from transition list
Click on effect Option dropdown button
Click on from top
Go to timing group
Click on apply to all
71. In the given presentation, add three blank slides. Apply “Uncover’’ slide transition effect and
from top variation effect to all the slides.
Go to home tab
Go to sides group
Click on New Slide three times
Go to transition
Go transition to this slide group
Click on uncover from transition list
Click on effect Option dropdown button
Click on from top
Go to timing group
Click on apply to all
72. Display the given presentation in “Notes Page View”.
Go to view tab
Go to presentation view
Click on Notes Page View
73. Create additional four slides in the given MS Power Point Presentation.
Go to Home tab
Go to slides group
Click on new slide four times
74. Copy slide number 8 and paste it as a new slide at the end of the given presentation.
Click on slide number 8 by scrolling
Again right click on slider number 8
Click on copy
Go to the last slide by scrolling
Paste it by right click
75. In the given presentation, change the line spacing of the title present on first slide to “2.5 lines”.
Go to first slide
Click on the end of the title
Go to home tab
Go to paragraph
Click Line Spacing
Click on 2.5
76. In the given presentation remove the “Italic” effect from the paragraph beginning from
“Information Technology is………………………. Information”.
Select the given text
Go to home tab
Go to font group
Click on Italic
77. In the given presentation remove the strikethrough effect of the text “information Technology”.
Select the text “information Technology”.
Go to home tab
Go to font group
Click on Strikethrough
78. Add four new slides in the given presentation. Insert textbox with text: OFFICE in the first slide
Using Copy paste option, paste the textbox in all the remaining slides. And display in “slide sorter
view.
Go to home tab
Go to slides group
Click on New Slide four times
Go to first slide
Go to insert tab
Go to text group
Click on text box
Click on first slide and Type OFFICE
Select OFFICE and copy
And paste to all slide by shortcut
Go to view tab
Go to presentation view
Click on slide sorter
79. Delete any one placeholder in the first slide in the given MS PowerPoint presentation.
Select place holder
Press delete key
80. In the given presentation insert an “Oval Callout’’ shape.
Go to insert tab
Go to illustration
Click on shape
Click on Oval Callout
81. Arrange excel data by sorting column E in (A to Z smallest to largest) order.
Click on E column
Go to home tab
Go to editing group
Click on sort & filter dropdown button
Click on “A to Z smallest to largest”
Post a Comment