Post Title KYP CIT Final Exam Practice Questions
Short Description - Kushal Yuva Program
KYP FINAL EXAM CIT PRACTICE FILE
2. In the given spreadsheet, insert hyperlink to the heading text ‘’magic cafe’’ and link this
“http://www.magiccafe.com” web page.
3. In the given worksheet, change the page orientation to landscape layout.
4. In the given presentation, insert a new blank slide at the end.
5. Display the given presentation in “slide sorter view”.
6. Remove the “drop cap” effect from the given document.
7. In the spreadsheet, insert new worksheet after “personal monthly budget” sheet and set the name of this sheet as “budget”.
8. In the given presentation, add two blank slides. Apply “uncover” slide transition effect and “from top” variation effect to all the slides.
9. Add additional two slides to the existing presentation. Set the timing of slide automatically after 4 seconds for 1st slide (slide no. 1).
10. Change the right margin of the given document to 0.6 inches.
11. In the given presentation, delete all the image from second slide.
12. Insert
additional six slides in the given MS power point presentation. Hide third
slide (slide no.3) while running slide show.
13. Add
the text “lanes town high school” to the footer and apply it to all slides.
14. Apply
“drop cap – in margin” effect to the first sentence of given document.
15. In the
given document, remove hyperlink of the word “home group”.
16. In the
given document, create a hyperlink for the text ‘project report’ to open
“http://www.google.com” web page.
17. In the
given document, apply ‘bold’ and ‘underline’ style to the third sentence.
18. In the
given MS word document, insert hyperlink to the image and link this image to
“http://www.theflyer.com” web page.
19. In the
given worksheet, insert new worksheet and change the page orientation to
landscape layout.
20. Insert the values 50, 100, 65, 96 in cells g7, g8, g9, g10 respectively. Calculate the sum of the cell range g7 to g10 and display it in the cell g13 using a function.
21. In the
given worksheet, select rows 10 and 11 and move them to rows 7 and 8.
22. Change
the font size of the second sentence to 14.
23.Insert additional four slides in the given MS power point presentation. Hide second slide (slide no.2) while running slide show.
24. Change
the font effect of the fifth sentence to “strikethrough” in the given document.
25. In the
given presentation, remove footer text from all the slides.
26. Check
and correct all spelling and grammar mistakes in the given.
27. Calculate
total marks of first student by using appropriate function in a cell l2 and replicate same formula to the cell range l3:l21.
28. In the given spreadsheet file, insert header “payment details” in the centre section of the header. After entering the header and footer, click on cell a1.
29. In the given presentation, change the case of the paragraph present on the third slide to “uppercase”.
30. Copy slide number 8 and paste it as a new slide at the
end of the given presentation.
31. In the given spreadsheet, change the chart from a column
chart to a bar chart. Apply any style from clustered bar chart.
32. For the given word document, change the top margin to 2
inches.
33. In the given spreadsheet, apply “accent2” cell style to
the cell range a2:g2.
34. In the given file, create a table of 5 rows and 5
columns.
35. In the given workbook, delete the “audit” worksheet.
36. In the given document, set the top margin to 2.5 inches.
37. Change the font style of third sentence of given
document to “italic”.
38. You are about to read a document which has lot of text pages. It’s difficult to browse through such document as the reading space is less. How will you switch to “read mode” view which gives maximum reading space?
39. In the
given spreadsheet file, apply “accent3” cell style to the cell range a2:h2.
40. In the
given presentation, create duplicate slide for the first slide.
41. Create two additional blank slides in the given presentation and view the
presentation through the “notes page view”.
42. In the
given presentation, insert a new slide with “two content” layout at the end.
43. Delete entire table from the given document.
44. In the given presentation, remove the reflection effect from the word art
text“savetigers”.
45.In the given presentation, insert additional three blank
slides at the end.
46. In the given document, insert registered trademark symbol, r at the end of the
document.
47. Add watermark text ‘envelope’ in the given document.
48. In the given presentation, delete any one placeholder
from the first slide.
49. Add additional four slides to the existing presentation. Display 4th slide (slide no. 4)
automatically after 3 seconds while running
slide show. Apply time effect for third slide (slide no.3).
50. Delete
worksheet “home loan” from the given spreadsheet.
51.In the
given document, use “draw table” option and create table with one row and two
columns.
52. Insert
one More Blank slide in the given presentation. Hide the first slide (slide
no.1).
53.In the
given presentation, insert action button “home” anywhere in the last slide (slide
no. 2).
54. You have created your resume using MS word. Now you
want to insert your photo in a
picture control. How will you insert a picture control at the beginning
of given document ?
55. Remove the numbered list from the given document.
56. In the given document, change the capitalization of entire
document to lowercase.
57. Remove the “drop cap” effect from the given document.
58. In the given word document, change the case of the third sentence
to upper case.
59. Apply “bold” font style to the entire document.
60. In the given document, insert the text box “Austin quote” and type
“welcome” text inside the text box.
61. In the given MS word document, replace the word “programmer” with the word
“developer” throughout the document.
62. In the given MS word document, replace the word “nice” with the
word “main” throughout the document.
63. Delete the “picture content control” from the given document.
64. In the given MS word document, replace the word “shelf” with the
word “desk” throughout the document.
65. In the given document, insert a table of five rows and six columns
at the top of the document.
66. Remove the table border from the given document.
67. You have 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?
68. You have created a project report in Ms Word. For all the
headings in the report you want to have consistent formatting. How will you
apply formatting of “introduction” heading to the remaining headings using
format painter.
69. In the word document, insert a table with 3 rows and 3
columns and change the background colour of entire table to “orange”.
70. In the given MS word document, change the page
orientation to landscape.
71. In the given MS word document, replace the word “magic”
with the word “drama” throughout the document.
“http://www.hallmark.com” web page.
73. Set 1.5 inch
bottom margin for the given document.
74. In the given MS
word document, replace the word “Unix” with the word “Linux” throughout the
document.
75. Apply artistic
page border to the given document.
76. Delete any one
table column from the given document.
77. Set 1.5 inch
top margin for the given document.
78. Set 1.5 inch
left margin for the given document.
79. Delete
worksheet “list info” from the given spreadsheet.
80. Set 80% zoom
level for the given document.
81. Set 90% zoom
level for the given document.
82. Merge and
centre the heading “blood donor database” from the cell a4 to h4.
83. Set 75% zoom
level for the given worksheet.
84. In the given
spreadsheet file, insert a new column after column B.
85. In the given spreadsheet
file, insert a new column after column E.
86. Change the
width of column e to 15.57.
87. Change the row
height to 30 for the row number 5.
88. Move the
worksheet, “car loan” and insert it after the worksheet “home loan”.
89. In the given
spreadsheet, show legend elements at the bottom of the chart.
90. Arrange excel
data by sorting column b (particular) in z to a (highest to lowest) order.
91. In the given
spreadsheet, remove all cell formatting from a1:d1 cell range.
92. Apply “style 6”
chart style to the given chart.
93. In the given
spreadsheet, change the chart from a pie chart to a bar chart. Apply default
chart style.
94. In the given
spreadsheet, auto fit the width of the column b 97. In the given worksheet,
apply “veranda” font to the cell h12.
uygygiuyiu
ReplyDelete