| Q1. In the given MS Word document, change the page orientation to landscape. |
| Q2. Highlight the third sentence in the given document with ‘Red’ color. |
| Q3. In the given MS Word document, replace the word “magic” with the word “drama” throughout the document. |
| Q4. In the given MS Word document, replace the word “unix” with the word “linux” throughout the document. |
| Q5. In the given MS Word document, replace the word “shelf” with the word “desk” throughout the document. |
| Q6. In the given MS Word document, replace the word “nice” with the word “main” throughout the document. |
| Q7. In the given MS Word document, replace the word “programmer” with the word “developer” throughout the document. |
| Q8. In the given word document, change the case of the third sentence to UPPER CASE. |
| Q9. In the given document, change the capitalization of entire document to lowercase |
| Q10. In the given document, insert a table of five rows and six columns at the top of the document. |
| Q11. In the given document, split all the text into four columns. |
| Q12. Apply “Drop Cap – In Margin” effect to the first sentence of given document. |
| Q13. Delete the “Picture Content Control” from the given document. |
| Q14. Delete any two table rows from the given document. |
| Q15. Remove the numbered list from the given document. |
| Q16. Remove the “Drop Cap” effect from the given document. |
| Q17. In the given document, insert the text box “Austin Quote” and type ‘Welcome’ text inside the textbox. |
| Q18. 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? |
| Q19. In the given MS word document, insert hyperlink to the image and link this image to “http://www.hallmark.com” web page. |
| Q20. Apply ‘Bold’ font style to the entire document. |
| Q21. Add watermark text ‘Envelope’ in the given document. |
| Q22. Apply artistic page border to the given document. |
| Q23. Apply ‘Bold’ and ‘Underline’ style to the entire document. |
| Q24. Apply ‘Light Green’ page color to the given document. |
| Q25. Set 1.5 inch left margin for the given document. |
| Q26. Set 1.5 inch bottom margin for the given document. |
| Q27. Remove watermark from the given document. |
| Q28. Set 75% zoom level for the given worksheet. |
| Q29. Change the width of column E to 15.57. |
| Q30. Arrange excel data by sorting column B (Particular) in Z to A (Highest to Lowest) order. |
| Q31. In the given spreadsheet, autofit the width of the column B. |
| Q32. In the given spreadsheet file, AutoFit width of the entire column “Quantity” (Column C). |
| Q33. In the given spreadsheet, remove all cell formatting from A1:D1 cell range. |
| Q34. In the given spreadsheet file, insert a new column after column B. |
| Q35. In the given spreadsheet, insert a new column after column A. |
| Q36. Change the row height to 35 for the row number 1. |
| Q37. Change the row height to 30 for the row number 5. |
| Q38. Use ‘Replace All’ option to replace all occurrences of text “Candidate” with “Student”. |
| Q39. Move the worksheet, ‘Car Loan’ and insert it after the worksheet ‘Home Loan’. |
| Q40. Set 90% zoom level for the given worksheet. |
| Q41. Set 80% zoom level for the given worksheet. |
| Q42. Apply ‘Style 6’ chart style to the given chart. |
| Q43. In the given worksheet, apply ‘Verdana’ font to the cell H12. |
| Q44. Set 70% zoom level for the given worksheet. |
| Q45. Move the worksheet, ‘Holiday List’ and insert it after the worksheet ‘List Info’. |
| Q46. In the given spreadsheet, change the chart from a Pie chart to a Bar chart. Apply default chart style. |
| Q47. In the given spreadsheet, insert a new column after column E. |
| Q48. In the given spreadsheet, select row number 6 and move this to row number 1 using Cut – Paste option. |
| Q49. Merge and center the heading “Blood Donor Database” from the cell A4 to H4. |
| Q50. Delete worksheet ‘List Info’ from the given spreadsheet. |
| Q51. Delete worksheet ‘Home Loan’ from the given spreadsheet. |
| Q52. Change the width of column C to 25. |
| Q53. In the given presentation, change the line spacing of the title present on first slide (Slide No. 1) to “1.5 lines”. |
| Q54. Add four new slides in the given presentation. Insert textbox with text : OFFICE in the first slide (Slide Number 1). Using Copy – Paste option, paste the textbox in all the remaining slides. View this presentation in “Slide Sorter View”. |
| Q55. In the given presentation add two blank slides. Apply “Fade” slide transition and “Smoothly” effect to second slide (Slide Number: 2). |
| Q56. In the given presentation, change the case of the paragraph present on the Third slide to “UPPERCASE”. |
| Q57. In the given presentation, change the case of the paragraph present on the Third slide to “lowercase”. |
| Q58. In the given presentation, change the case of the paragraph present on the Third slide to “Capitalize Each Word”. |
| Q59. Copy slide number 8 and paste it as a new slide at the end of the given presentation. |
| Q60. In the given presentation, delete any one placeholder from the first slide. |
| Q61. In the given presentation, remove the strikethrough effect of the text “Information Technology”. |
| Q62. In the given presentation, remove the “Italic” effect from the paragraph beginning from “Information Technology is ……..Information.” |
| Q63. Display the given presentation in “Notes Page view”. |
| Q64. In the given presentation, create duplicate slide for the first slide. |
| Q65. In the given presentation, delete all the images from second slide. |
| Q66. In the given presentation, change the line spacing of the title present on first slide (Slide No. 1) to “2.5 lines”. |
| Q67. Create additional four slides in the given MS Power Point Presentation. |
| Q68. Create additional nine slides in the given MS Power Point Presentation. |
| Q69. Add new five slides in the given presentation. |
| Q70. In the given presentation, insert an “Oval Callout” shape. |
| Q71. In the given presentation, insert a “Rectangle” shape. |
| Q72. In the given presentation, insert a new slide with “Title and Content” layout at the end. |
| Q73. In the given presentation, insert a new slide with “Two content” layout at the end. |
| Q74. In the given presentation, insert a new slide with “Comparison” layout at the end. |
| Q75. In the given presentation, insert a new slide with “Content With Caption” layout at the end. |
| Q76. In the given presentation add two slides with “Title and Content” layout at the end. |
| Q77. In the given presentation, add two blank slides. Apply “Uncover” slide transition effect and “From Top” variation effect to all the slides. |
| Q78. Display the given presentation in “Notes Page View”. |
| Q79. In the given presentations add two blank slides. Apply “Random Bars” slide transition and “Horizontal” effect to all slides. |
| Q80. Create two additional Blank slides in the presentation and view presentation through the “Slide Sorter View”. |
| Computer Competency Test (Question Bank) |
 Happy Learning |
){kind=link}
0 Comments