BS-CIT ALL QUESTIONS ANSWER STEP BY STEP - KYP FINAL EXAM

BS-CIT ALL QUESTIONS ANSWER STEP BY STEP   - KYP FINAL EXAM

1. In the given document, split all the text into one column

Step 1: Click on the Layout tab in the ribbon.
Step 2: Click on Columns.
Step 3: Select One to set the entire text into a single column.

2. In the given spreadsheet, insert a hyperlink to the heading text "Magic Cafe" and link this to “http://www.magiccafe.com”

Step 1: Select the heading text “Magic Cafe.”
Step 2: Click on the Insert tab in the ribbon.
Step 3: Click on the Hyperlink option.
Step 4: In the Address field, type “http://www.magiccafe.com.”
Step 5: Click OK.

3. In the given worksheet, change the page orientation to landscape layout

Step 1: Click on the Page Layout tab in the ribbon.
Step 2: Click on Orientation.
Step 3: Select Landscape from the dropdown list.

4. In the given presentation, insert a new blank slide at the end

Step 1: Click on the Home tab in the ribbon.
Step 2: Click on New Slide.
Step 3: Scroll to the last slide in the slide pane.
Step 4: Drag the newly inserted slide to the end if needed.

5. Display the given presentation in “Slide Sorter View”

Step 1: Click on the View tab in the ribbon.
Step 2: Click on Slide Sorter from the Presentation Views group.

6. Remove the “Drop Cap” effect from the given document

Step 1: Select the paragraph with the Drop Cap effect.
Step 2: Click on the Insert tab in the ribbon.
Step 3: Click on Drop Cap and select None.

7. Change the line spacing of the title present on the first slide (Slide No.1) to “2.0 lines” in the given presentation

Step 1: Click on the title text box on Slide 1.
Step 2: Click on the Home tab in the ribbon.
Step 3: Click on the Line Spacing option.
Step 4: Select 2.0 from the dropdown list.

8. Insert a new worksheet after “Personal Monthly Budget” sheet and name it “Budget” in the spreadsheet

Step 1: Click on the + (New Sheet) button at the bottom.
Step 2: Click and drag the new sheet after Personal Monthly Budget.
Step 3: Right-click on the new sheet tab, select Rename, and type Budget.

9. Add two blank slides and apply “Uncover” slide transition with “From Top” variation to all slides in the presentation

Step 1: Click on the Home tab and select New Slide twice.
Step 2: Click on the Transitions tab.
Step 3: Select Uncover transition.
Step 4: Click on Effect Options and select From Top.
Step 5: Click on Apply to All.

10. Add two slides to the presentation and set slide No.1 to advance automatically after 4 seconds

Step 1: Click on the Home tab and insert two new slides.
Step 2: Click on the Transitions tab.
Step 3: In the Timing group, uncheck On Mouse Click and check After.
Step 4: Set the time to 4 seconds.
Step 5: Click Apply to All if needed.

11. Change the right margin of the given document to 0.6 inches

Step 1: Click on the Layout tab.
Step 2: Click on Margins.
Step 3: Click on Custom Margins.
Step 4: Set Right Margin to 0.6 inches.
Step 5: Click OK.

12. Delete all images from the second slide in the given presentation

Step 1: Navigate to the second slide.
Step 2: Click on each image and press Delete.

13. Insert six additional slides and hide Slide No.3 while running the slideshow

Step 1: Click on the Home tab and insert six new slides.
Step 2: Right-click on Slide No.3 and select Hide Slide.

14. Add the text “Lanes Town High School” to the footer and apply it to all slides

Step 1: Click on the Insert tab.
Step 2: Click on Header & Footer.
Step 3: Check the Footer box and enter “Lanes Town High School.”
Step 4: Click on Apply to All.

15. Apply “Drop Cap – In Margin” effect to the first sentence of the given document

Step 1: Select the first sentence.
Step 2: Click on the Insert tab.
Step 3: Click on Drop Cap and select In Margin.

16. Remove the hyperlink of the word “Home Group” in the given document

Step 1: Right-click on the word “Home Group.”
Step 2: Select Remove Hyperlink.

17. Create a hyperlink for the text ‘Project Report’ to open “http://www.google.com” in the given document

Step 1: Select the text “Project Report.”
Step 2: Click on the Insert tab.
Step 3: Click on Hyperlink.
Step 4: Enter “http://www.google.com” in the Address field.
Step 5: Click OK.

18. Apply ‘Bold’ and ‘Underline’ style to the third sentence in the given document

Step 1: Select the third sentence.
Step 2: Click on the Home tab.
Step 3: Click on Bold (B) and Underline (U).

19. Insert a hyperlink to an image and link it to “http://www.theflyer.com” in the given MS Word document

Step 1: Click on the image.
Step 2: Click on the Insert tab.
Step 3: Click on Hyperlink.
Step 4: Enter “http://www.theflyer.com” in the Address field.
Step 5: Click OK.

20. Insert a new worksheet and change the page orientation to landscape layout in the given worksheet

Step 1: Click on the + (New Sheet) button.
Step 2: Click on the Page Layout tab.
Step 3: Click on Orientation and select Landscape.

21. Insert values 50, 100, 65, 96 in cells G7, G8, G9, G10, then calculate the sum and display in G13

Step 1: Enter values 50, 100, 65, 96 in G7, G8, G9, G10 respectively.
Step 2: Click on cell G13.
Step 3: Type =SUM(G7:G10) and press Enter.

22. Move rows 10 and 11 to rows 7 and 8 in the given worksheet

Step 1: Select rows 10 and 11.
Step 2: Right-click and select Cut.
Step 3: Right-click on row 7 and select Insert Cut Cells.

23. Change the font size of the second sentence to 14 in the given document

Step 1: Select the second sentence.
Step 2: Click on the Home tab.
Step 3: Change the Font Size to 14.

24. Insert additional four slides in the given MS PowerPoint presentation. Hide second slide (Slide No.2) while running the slideshow

Step 1: Click on the Home tab.
Step 2: Click on New Slide four times to insert four slides.
Step 3: Right-click on Slide No.2 and select Hide Slide.

25. Change the font effect of the fifth sentence to “Strikethrough” in the given document

Step 1: Select the fifth sentence.
Step 2: Click on the Home tab.
Step 3: Click on the Strikethrough (S̶) button.

26. In the given presentation, remove footer text from all the slides

Step 1: Click on the Insert tab.
Step 2: Click on Header & Footer.
Step 3: Uncheck the Footer box.
Step 4: Click Apply to All.

27. Check and correct all spelling and grammar mistakes in the given document

Step 1: Click on the Review tab.
Step 2: Click on Spelling & Grammar.
Step 3: Correct the mistakes as suggested.

28. Calculate total marks of the first student by using an appropriate function in cell L2 and replicate the same formula to the cell range L3:L21

Step 1: Click on cell L2.
Step 2: Type =SUM(range of marks).
Step 3: Press Enter.
Step 4: Click on the fill handle and drag it down to cell L21.

29. In the given spreadsheet file, insert header “Payment Details” in the center section of the header. After entering the header and footer, click on cell A1

Step 1: Click on the Insert tab.
Step 2: Click on Header & Footer.
Step 3: Click in the center section and type “Payment Details.”
Step 4: Click on any cell (A1).

30. In the given presentation, change the case of the paragraph present on the third slide to “Uppercase”

Step 1: Select the paragraph on Slide No.3.
Step 2: Click on the Home tab.
Step 3: Click on Change Case and select UPPERCASE.

31. Copy Slide No.8 and paste it as a new slide at the end of the given presentation

Step 1: Right-click on Slide No.8.
Step 2: Select Copy.
Step 3: Scroll to the end and right-click in the slide pane.
Step 4: Select Paste.

32. In the given spreadsheet, change the chart from a column chart to a bar chart. Apply any style from Clustered Bar Chart

Step 1: Select the chart.
Step 2: Click on the Chart Design tab.
Step 3: Click on Change Chart Type.
Step 4: Select Bar Chart → Clustered Bar Chart.
Step 5: Click OK.

33. For the given Word document, change the top margin to 2 inches

Step 1: Click on the Layout tab.
Step 2: Click on Margins.
Step 3: Click on Custom Margins.
Step 4: Set the top margin to 2 inches.
Step 5: Click OK.

34. In the given spreadsheet, apply “Accent2” cell style to the cell range A2:G2

Step 1: Select the range A2:G2.
Step 2: Click on the Home tab.
Step 3: Click on Cell Styles and choose Accent2.

35. In the given file, create a table of 5 rows and 5 columns

Step 1: Click on the Insert tab.
Step 2: Click on Table.
Step 3: Select 5x5 table size.

36. In the given workbook, delete the “Audit” worksheet

Step 1: Right-click on the “Audit” sheet tab.
Step 2: Click on Delete.

37. In the given document, set the top margin to 2.5 inches

Step 1: Click on the Layout tab.
Step 2: Click on Margins → Custom Margins.
Step 3: Set the top margin to 2.5 inches.
Step 4: Click OK.

38. Change the font style of the third sentence of the given document to “Italic”

Step 1: Select the third sentence.
Step 2: Click on the Home tab.
Step 3: Click on Italic (I).

39. Switch to “Read Mode” view for better reading space in the document

Step 1: Click on the View tab.
Step 2: Click on Read Mode.

40. In the given spreadsheet file, apply “Accent3” cell style to the cell range A2:H2

Step 1: Select the range A2:H2.
Step 2: Click on the Home tab.
Step 3: Click on Cell Styles and choose Accent3.

41. In the given presentation, create a duplicate slide for the first slide

Step 1: Right-click on Slide No.1.
Step 2: Click on Duplicate Slide.

42. Create two additional blank slides in the given presentation and view the presentation through the “Notes Page View”

Step 1: Click on the Home tab.
Step 2: Click on New Slide twice.
Step 3: Click on the View tab.
Step 4: Click on Notes Page.

43. In the given presentation, insert a new slide with the “Two Content” layout at the end

Step 1: Click on the Home tab.
Step 2: Click on New Slide → Two Content layout.

44. Delete the entire table from the given document

Step 1: Click on the table.
Step 2: Click on the Table Tools Layout tab.
Step 3: Click on Delete → Delete Table.

45. In the given presentation, remove the reflection effect from the WordArt text “Save Tigers”

Step 1: Click on the WordArt text “Save Tigers.”
Step 2: Click on the Format tab.
Step 3: Click on Text Effects → Reflection → No Reflection.

46. In the given presentation, insert additional three blank slides at the end

Step 1: Click on the Home tab.
Step 2: Click on New Slide three times.

47. In the given document, insert the registered trademark symbol (®) at the end of the document

Step 1: Click at the end of the document.
Step 2: Click on the Insert tab.
Step 3: Click on Symbol → More Symbols.
Step 4: Select ® and click Insert.

48. Add watermark text “Envelope” in the given document

Step 1: Click on the Design tab.
Step 2: Click on Watermark.
Step 3: Click on Custom Watermark.
Step 4: Type “Envelope” and click OK.

49. In the given presentation, delete any one placeholder from the first slide

Step 1: Click on the placeholder on Slide No.1.
Step 2: Press Delete.

50. Add four additional slides to the existing presentation. Display Slide No.4 automatically after 3 seconds while running the slideshow. Apply a time effect for Slide No.3

Step 1: Click on the Home tab.
Step 2: Click on New Slide four times.
Step 3: Click on Slide No.4.
Step 4: Click on the Transitions tab.
Step 5: In the Timing group, uncheck On Mouse Click and check After.
Step 6: Set the time to 3 seconds.
Step 7: Click on Slide No.3 and apply a transition effect.

51. Delete the worksheet “Home Loan” from the given spreadsheet.
Step 1: Right-click on the “Home Loan” sheet tab.
Step 2: Select Delete.
Step 3: Click OK to confirm.

52. Use the “Draw Table” option to create a table with one row and two columns in the given document.
Step 1: Click on the Insert tab.
Step 2: Click on Table and select Draw Table.
Step 3: Draw a table with one row and two columns.

53. Insert one more blank slide in the given presentation and hide the first slide (Slide No.1).
Step 1: Click on the Home tab and select New Slide.
Step 2: Right-click on Slide No.1 and select Hide Slide.

54. Insert an action button “Home” anywhere in the last slide (Slide No.2) in the given presentation.
Step 1: Click on the Insert tab.
Step 2: Click on Shapes and select Action Buttons.
Step 3: Choose the Home button and place it on Slide No.2.
Step 4: Select an action for the button and click OK.

55. Insert a picture control at the beginning of the given document to add a photo in a resume.
Step 1: Click on the Developer tab.
Step 2: Click on Picture Content Control from the Controls group.
Step 3: Click inside the control to insert a picture.

56. Remove the numbered list from the given document.
Step 1: Select the numbered list.
Step 2: Click on the Home tab.
Step 3: Click on the Numbering icon to remove the numbering.

57. Change the capitalization of the entire document to lowercase.
Step 1: Press Ctrl + A to select all text.
Step 2: Click on the Home tab.
Step 3: Click on Change Case and select lowercase.

58. Remove the “Drop Cap” effect from the given document.
Step 1: Select the paragraph with the Drop Cap effect.
Step 2: Click on the Insert tab.
Step 3: Click on Drop Cap and select None.

59. Change the case of the third sentence to uppercase in the given document.
Step 1: Select the third sentence.
Step 2: Click on the Home tab.
Step 3: Click on Change Case and select Uppercase.

60. Apply “Bold” font style to the entire document.
Step 1: Press Ctrl + A to select all text.
Step 2: Click on the Home tab.
Step 3: Click on Bold (B).

61. Insert the text box “Austin Quote” and type “Welcome” inside the text box in the given document.
Step 1: Click on the Insert tab.
Step 2: Click on Text Box and select “Austin Quote.”
Step 3: Type “Welcome” inside the text box.

62. Replace the word “Programmer” with “Developer” throughout the given MS Word document.
Step 1: Press Ctrl + H to open the Find and Replace dialog box.
Step 2: Type “Programmer” in the Find what box.
Step 3: Type “Developer” in the Replace with box.
Step 4: Click on Replace All.

63. Replace the word “Nice” with “Main” throughout the given MS Word document.
Step 1: Press Ctrl + H.
Step 2: Type “Nice” in the Find what box.
Step 3: Type “Main” in the Replace with box.
Step 4: Click Replace All.

64. Delete the “Picture Content Control” from the given document.
Step 1: Click on the picture content control.
Step 2: Press Delete.

65. Replace the word “Shelf” with “Desk” throughout the given MS Word document.
Step 1: Press Ctrl + H.
Step 2: Enter “Shelf” in the Find what box.
Step 3: Enter “Desk” in the Replace with box.
Step 4: Click Replace All.

66. Insert a table with five rows and six columns at the top of the given document.
Step 1: Click on the Insert tab.
Step 2: Click on Table and select Insert Table.
Step 3: Enter 5 for rows and 6 for columns, then click OK.

67. Remove the table border from the given document.
Step 1: Click inside the table.
Step 2: Click on the Table Design tab.
Step 3: Click on Borders and select No Border.

68. Apply the “Purple Mesh” texture effect as the background of a greeting card.
Step 1: Click on the Design tab.
Step 2: Click on Page Color and select Fill Effects.
Step 3: Click on the Texture tab and select “Purple Mesh.”
Step 4: Click OK.

69. Apply formatting of the “Introduction” heading to all remaining headings using Format Painter.
Step 1: Select the “Introduction” heading.
Step 2: Click on the Home tab.
Step 3: Click on Format Painter.
Step 4: Click on each heading to apply the formatting.

70. Insert a table with 3 rows and 3 columns and change its background color to “Orange” in the given document.
Step 1: Click on the Insert tab.
Step 2: Click on Table and insert a 3x3 table.
Step 3: Select the entire table.
Step 4: Click on the Table Design tab, click Shading, and select Orange.

71. Change the page orientation to Landscape in the given MS Word document.
Step 1: Click on the Layout tab.
Step 2: Click on Orientation.
Step 3: Select Landscape.

72. Replace the word “Magic” with “Drama” throughout the given MS Word document.
Step 1: Press Ctrl + H.
Step 2: Type “Magic” in the Find what box.
Step 3: Type “Drama” in the Replace with box.
Step 4: Click Replace All.

73. Insert a hyperlink to an image and link it to “http://www.hallmark.com” in the given MS Word document.
Step 1: Click on the image.
Step 2: Click on the Insert tab.
Step 3: Click on Hyperlink.
Step 4: Enter “http://www.hallmark.com” in the Address field.
Step 5: Click OK.

74. Set the bottom margin to 1.5 inches in the given document.
Step 1: Click on the Layout tab.
Step 2: Click on Margins and select Custom Margins.
Step 3: Set Bottom Margin to 1.5 inches and click OK.

75. Replace the word “Unix” with “Linux” throughout the given MS Word document.
Step 1: Press Ctrl + H.
Step 2: Enter “Unix” in the Find what box.
Step 3: Enter “Linux” in the Replace with box.
Step 4: Click Replace All.

76. Apply an artistic page border to the given document.
Step 1: Click on the Design tab.
Step 2: Click on Page Borders.
Step 3: Select an Artistic border and click OK.

77. Delete any one column from a table in the given document.
Step 1: Click inside the column you want to delete.
Step 2: Click on the Table Layout tab.
Step 3: Click on Delete and select Delete Columns.

78. Set the top margin to 1.5 inches in the given document.
Step 1: Click on the Layout tab.
Step 2: Click on Margins and select Custom Margins.
Step 3: Set Top Margin to 1.5 inches and click OK.

79. Set the left margin to 1.5 inches in the given document.
Step 1: Click on the Layout tab.
Step 2: Click on Margins and select Custom Margins.
Step 3: Set Left Margin to 1.5 inches and click OK.

80. Delete the worksheet “List Info” from the given spreadsheet.
Step 1: Right-click on the “List Info” sheet tab.
Step 2: Click Delete.
Step 3: Click OK to confirm.

81. Set 80% zoom level for the given document.
Step 1: Click on the View tab.
Step 2: Locate the Zoom section.
Step 3: Click on Zoom and select 80%.
Step 4: Click OK.

82. Set 90% zoom level for the given document.
Step 1: Click on the View tab.
Step 2: Click on Zoom and select 90%.
Step 3: Click OK.

83. Change the width of column C to 25.
Step 1: Open the spreadsheet.
Step 2: Select column C.
Step 3: Right-click and choose Column Width.
Step 4: Enter 25 and click OK.

84. Merge and center the heading “Blood Donor Database” from cell A4 to H4.
Step 1: Select the range A4 to H4.
Step 2: Click on the Home tab.
Step 3: Click on Merge & Center.

85. Set 75% zoom level for the given worksheet.
Step 1: Click on the View tab.
Step 2: Click on Zoom and select 75%.
Step 3: Click OK.

86. Insert a new column after column B in the given spreadsheet.
Step 1: Select column C (since the new column will be inserted after B).
Step 2: Right-click and select Insert.
Step 3: A new blank column will appear.

87. Insert a new column after column E in the given spreadsheet.
Step 1: Select column F.
Step 2: Right-click and select Insert.

88. Change the width of column E to 15.57.
Step 1: Select column E.
Step 2: Right-click and choose Column Width.
Step 3: Enter 15.57 and click OK.

89. Change the row height to 30 for row number 5.
Step 1: Select row 5.
Step 2: Right-click and choose Row Height.
Step 3: Enter 30 and click OK.

90. Move the worksheet “Car Loan” and insert it after the worksheet “Home Loan.”
Step 1: Click and drag the “Car Loan” worksheet tab.
Step 2: Drop it after the “Home Loan” worksheet tab.

91. Show legend elements at the bottom of the chart in the given spreadsheet.
Step 1: Click on the chart.
Step 2: Click on Chart Elements (the plus icon).
Step 3: Select Legend, then choose Bottom.

92. Sort column B (Particular) in Z to A (highest to lowest) order.
Step 1: Select the data range that includes column B.
Step 2: Click on the Data tab.
Step 3: Click on Sort.
Step 4: Select Column B and choose Sort Order: Z to A.
Step 5: Click OK.

93. Remove all cell formatting from the A1:D1 cell range in the given spreadsheet.
Step 1: Select the cell range A1:D1.
Step 2: Click on the Home tab.
Step 3: Click on Clear and choose Clear Formats.

94. Apply “Style 6” chart style to the given chart.
Step 1: Click on the chart.
Step 2: Click on the Chart Design tab.
Step 3: Click on Chart Styles and select Style 6.

95. Change the chart from a pie chart to a bar chart and apply the default chart style in the given spreadsheet.
Step 1: Click on the pie chart.
Step 2: Click on the Chart Design tab.
Step 3: Click on Change Chart Type.
Step 4: Select Bar Chart and click OK.

96. Auto-fit the width of column B in the given spreadsheet.
Step 1: Select column B.
Step 2: Double-click the right edge of the column header.

97. Apply “Verdana” font to cell H12 in the given worksheet.
Step 1: Select cell H12.
Step 2: Click on the Home tab.
Step 3: Click on the Font dropdown and select “Verdana.”