IT QUESTION – GVEKS

KYP Final Exam MS Word से पूछे जानेवाले सभी प्रश्न

यहाँ पर आपको MS-Word के सभी मिलेंगे अगर आप इन सभी प्रश्नों का नियमित अभ्यास करते हैं, तो आपका MS- Word में कोई भी प्रश्न नहीं छूटेगा-

All Important Questions of MS-Word-

1. How to change Font Name?

➡️ Select the text → Go to Home tab → Font group → Font box → Choose the desired font such as Times New Roman, Calibri, Arial, etc.

2. How to change Font Size?

➡️ Select the text → Go to Home tab → Font Size box → Choose the size (for example, 12, 14, 16, etc.).

3. How to apply and remove Bold, Italic and Underline effect?

➡️ Select the text → Go to Home tab → Font group →

Click B to make text Bold.

Click I to make text Italic.

Click U to Underline text.

➡️ Click again on the same buttons to remove the effects.

4. How to apply and remove Strikethrough effect?

➡️ Select the text → Go to Home tab → Font group → Strikethrough (abc with line) → Click to apply or remove.

5. How to apply and remove Subscript?

➡️ Select the text → Go to Home tab → Font group → Subscript (X₂) → Click to apply or remove.

6. How to apply and remove Superscript?

➡️ Select the text → Go to Home tab → Font group → Superscript (X²) → Click to apply or remove.

7. How to change Case? (Sentence Case, Upper Case, etc.)

➡️ Select the text → Go to Home tab → Font group → Change Case (Aa icon) → Choose any one:

Sentence case

lowercase

UPPERCASE

Capitalize Each Word

tOGGLE cASE

8. How to change Font Colour of Text?

➡️ Select the text → Go to Home tab → Font Color (A icon) → Choose a color from the palette.

9. How to Highlight Text with different colours?

➡️ Select the text → Go to Home tab → Text Highlight Color (marker icon) → Choose a highlight color or “No Color” to remove.

10. How to apply and remove Shadow and Reflection effect?

➡️ Select the text → Go to Home tab → Text Effects (glowing A icon) → Choose Shadow or Reflection → Click again to remove.

11. How to apply and remove Bullets and Numbering?

➡️ Select the text → Go to Home tab → Paragraph group → Bullets or Numbering icon → Click to apply or remove.

12. How to align Text?

➡️ Select the text → Go to Home tab → Paragraph group → Choose one of the following:

Align Left

Center

Align Right

Justify

13. How to change Line Spacing of Text?

➡️ Select the paragraph → Go to Home tab → Paragraph group → Line and Paragraph Spacing icon (↑↓) → Choose 1.0, 1.5, 2.0, etc.

14. How to increase and decrease Indent of Text?

➡️ Go to Home tab → Paragraph group → Click Increase Indent or Decrease Indent buttons.

15. How to apply different Borders effects on Text?

➡️ Select the text → Go to Home tab → Paragraph group → Borders icon → Choose type of border (Bottom, Box, Top, etc.).

16. How to Replace Text? (VVI)

➡️ Go to Home tab → Editing group → Replace option →

Enter the word to find and the word to replace with → Click Replace All or Replace.

17. How to insert Pictures in the document?

➡️ Go to Insert tab → Pictures → This Device / Online Pictures → Select the picture and click Insert.

18. How to insert different Shapes in the document?

➡️ Go to Insert tab → Shapes → Choose any shape → Click and drag on the page to draw.

19. How to insert different SmartArt in the document?

➡️ Go to Insert tab → SmartArt → Choose a layout like Process, Cycle, or Hierarchy → Click OK.

20. How to insert different Charts in the document?

➡️ Go to Insert tab → Chart → Choose a chart type (Column, Pie, Line, etc.) → Edit data in the Excel sheet that opens.

21. How to insert and remove Hyperlink in Text? (VVI)

➡️ To insert: Select the text → Go to Insert tab → Link / Hyperlink → Type web address → Click OK.

➡️ To remove: Right-click on the link → Select Remove Hyperlink.

22. How to insert and remove Header and Footer in the document?

➡️ Go to Insert tab → Header or Footer → Choose a style → Type text.

➡️ To remove: Insert tab → Header → Remove Header (same for Footer).

23. How to insert Text Box in the document?

➡️ Go to Insert tab → Text Box → Choose a built-in text box or draw manually.

24. How to apply and remove Drop Cap in the document?

➡️ Go to Insert tab → Drop Cap → Choose Dropped or In Margin → Click OK.

➡️ To remove: Go to Insert tab → Drop Cap → None.

25. How to insert different Symbols in the document?

➡️ Go to Insert tab → Symbol → More Symbols → Choose the required symbol → Click Insert.

26. How to apply and remove Watermark in the document?

➡️ Go to Design tab → Watermark → Choose any design or create a custom one.

➡️ To remove: Go to Design tab → Watermark → Remove Watermark.

27. How to change the Page Colour?

➡️ Go to Design tab → Page Color → Choose a color from the palette.

28. How to apply different Texture in the Page?

➡️ Go to Design tab → Page Color → Fill Effects → Texture tab → Select a texture and click OK.

29. How to apply Page Borders?

➡️ Go to Design tab → Page Borders → Borders and Shading box → Choose border style, color, and width → Click OK.

30. How to apply Artistic Page Border?

➡️ Go to Design tab → Page Borders → Art box → Choose an artistic border → Click OK.

31. How to change the Margin (Left, Right, Bottom) of the Page?

➡️ Go to Layout tab → Margins → Custom Margins → Enter values for Left, Right, Top, and Bottom → Click OK.

32. How to change Page Orientation?

➡️ Go to Layout tab → Orientation → Choose Portrait or Landscape.

33. How to change Page Size? (A4, Letter, etc.)

➡️ Go to Layout tab → Size → Choose page size like A4, Letter, or Legal.

34. How to split all the text into different Columns?

➡️ Go to Layout tab → Columns → Choose Two, Three, or More Columns → Click OK.

35. How to Group and Ungroup?

➡️ Select multiple shapes or objects → Go to Shape Format tab → Group → Group.

➡️ To Ungroup: Shape Format tab → Group → Ungroup.

36. How to check Spelling and Grammar mistakes?

➡️ Go to Review tab → Spelling & Grammar → Word will show corrections → Apply changes as needed.

37. How to view the document in Read Mode View?

➡️ Go to View tab → Read Mode → Document will open in reading layout.

38. How to Zoom the document? (125%, 75%, etc.)

➡️ Go to View tab → Zoom → Choose percentage → Click OK.

➡️ You can also use the Zoom slider at the bottom-right of the window.

39. How to apply Gridline View?

➡️ Go to View tab → Show group → Tick Gridlines to display or remove gridlines.

40. How to view the document in Draft View?

➡️ Go to View tab → Draft → Document will switch to Draft layout.

41. How to view the document in Outline View?

➡️ Go to View tab → Outline → Document appears in Outline form.

KYP Final Exam MS Excel से पूछे जानेवाले सभी प्रश्न

अब आपको MS-Excel के सभी मिलेंगे, यदि आप इन सभी प्रश्नों का नियमित अभ्यास करते हैं, तो आपका MS- Excel में कोई भी प्रश्न नहीं छूटेगा-

All Important Questions of Excel-

1. How to cut, copy and paste cell, row and column?

Select the cell, row, or column you want to move or copy.
Go to the Home tab → In the Clipboard group, click Cut (scissors icon) or Copy (two papers icon).
Select the location where you want to paste.
Click Paste from the Home tab.

2. How to change font name and font size of any cell?

Select the cell or range of cells.
Go to the Home tab → In the Font group, click on the Font Name box and choose the desired font (e.g., Calibri, Times New Roman).
In the same group, click on the Font Size box and choose the desired size (e.g., 12, 14, etc.).

3. How to change cell shading?

Select the cell(s).
Go to the Home tab → In the Font group, click the Fill Color bucket icon.
Choose a color to fill the background of the cell.

4. How to change font colour of text?

Select the cell(s).
Go to Home tab → Font group → Click on the Font Color (A symbol) → Choose any color.

5. How to align text Left, Right and Centre of any cell?

Select the cell(s).
Go to Home tab → Alignment group → Choose Left Align, Center Align, or Right Align icons.

6. How to Merge and Centre cell?

Select the cells you want to combine.
Go to Home tab → Alignment group → Click Merge & Center.

7. How to Wrap Text of any cell?

Select the cell(s).
Go to Home tab → Alignment group → Click Wrap Text.

8. How to change Orientation of any cell? (Vertical text)

Select the cell(s).
Go to Home tab → Alignment group → Click Orientation → Choose Vertical Text.

9. How to increase and decrease indent of any cell?

Select the cell(s).
Go to Home tab → Alignment group → Click Increase Indent or Decrease Indent buttons.

10. How to change number format?

Select the cell(s) with numbers.
Go to Home tab → Number group → Click the Number Format box → Choose Number, Date, Time, Percentage, etc.

11. How to change currency symbol?

Select the cell(s).
Go to Home tab → Number group → Click the drop-down → Choose Currency or Accounting → Select desired symbol (₹, $, £, etc.).

12. How to change cell style? (Accent 1, Accent 3)

Select the cell(s).
Go to Home tab → Styles group → Click Cell Styles → Choose Accent 1, Accent 2, or Accent 3.

13. How to insert new columns in sheet?

Select a column (e.g., column C).
Go to Home tab → Cells group → Click Insert → Choose Insert Sheet Columns.

14. How to insert new rows in worksheet?

Select a row number.
Go to Home tab → Cells group → Click Insert → Choose Insert Sheet Rows.

15. How to delete rows from worksheet?

Select the row(s).
Go to Home tab → Cells group → Click Delete → Choose Delete Sheet Rows.

16. How to delete columns from worksheet?

Select the column(s).
Go to Home tab → Cells group → Click Delete → Choose Delete Sheet Columns.

17. How to change row height of any row?

Select the row.
Go to Home tab → Cells group → Click Format → Choose Row Height → Enter desired value.

18. How to change column width of any column?

Select the column.
Go to Home tab → Cells group → Click Format → Choose Column Width → Enter desired value.

19. How to rename sheet?

Double-click on the sheet tab name below.
Type the new name and press Enter.

20. How to move or copy worksheet?

Right-click on the sheet tab.
Choose Move or Copy → Select destination → Tick Create a copy (if needed) → Click OK.

21. How to use Sum function?

Click the cell where result is needed.
Go to Home tab → Editing group → Click AutoSum (Σ) → Press Enter.

22. How to use Min function?

Click on an empty cell.
Type =MIN(A1:A10) and press Enter.

23. How to use Max function?

Click on an empty cell.
Type =MAX(A1:A10) and press Enter.

24. How to use Average function?

Click on an empty cell.
Type =AVERAGE(A1:A10) and press Enter.

25. How to sort and filter (A to Z and Z to A) columns?

Select the column.
Go to Home tab → Editing group → Click Sort & Filter → Choose Sort A to Z or Sort Z to A.

26. How to replace text in Excel?

Go to Home tab → Editing group → Click Find & Select → Choose Replace → Type the word to find and replace.

27. How to insert picture in worksheet?

Go to Insert tab → Illustrations group → Click Pictures → Choose This Device → Select image → Click Insert.

28. How to insert shapes in worksheet?

Go to Insert tab → Illustrations group → Click Shapes → Choose desired shape → Draw it on the sheet.

29. How to insert Hyperlink in cell? (VVI)

Select the cell.
Go to Insert tab → Links group → Click Link → Enter the URL or file path → Click OK.

30. How to insert Text Box in worksheet?

Go to Insert tab → Text group → Click Text Box → Draw the box → Type your text.

31. How to insert Header and Footer in worksheet?

Go to Insert tab → Text group → Click Header & Footer → Type your header/footer text.

32. How to change Margin (Left, Right, Top and Bottom) of worksheet?

Go to Page Layout tab → Page Setup group → Click Margins → Choose Normal, Wide, or Narrow.

33. How to change orientation of worksheet?

Go to Page Layout tab → Page Setup group → Click Orientation → Choose Portrait or Landscape.

34. How to change page size of worksheet?

Go to Page Layout tab → Page Setup group → Click Size → Choose A4, Letter, Legal, etc.

35. How to change the view of worksheet as Page Break Preview?

Go to View tab → Workbook Views group → Click Page Break Preview.

36. How to apply gridline in the worksheet?

Go to View tab → Show group → Tick the Gridlines checkbox.

37. How to zoom worksheet?

Go to View tab → Zoom group → Click Zoom → Select 100%, 75%, 125%, etc.

38. How to chart design?

Select data → Go to Insert tab → Charts group → Choose chart type →
To customize, go to Chart Design tab → Choose different designs or layouts.

39. How to change Pie chart to Column chart?

Click the chart → Go to Chart Design tab → Click Change Chart Type → Choose Column → Click OK.

40. How to change the chart legend?

Click on the chart → Go to Chart Elements (+ symbol) → Tick Legend → Choose Top, Bottom, Left, or Right position.

KYP Final Exam MS Power Point से पूछे जानेवाले सभी प्रश्न

अब आपको MS-Power Point के सभी मिलेंगे, यदि आप इन सभी प्रश्नों का नियमित अभ्यास करते हैं, तो आपका MS- Power point में कोई भी प्रश्न नहीं छूटेगा-

All important questions of MS- Power Point

1. How to cut, copy and paste slides?

In the Slides Pane (left side), select the slide you want to cut or copy.
Go to the Home tab → In the Clipboard group, click Cut or Copy.
Click where you want to paste the slide and click Paste from the same group.

2. How to insert new slides?

Go to the Home tab → In the Slides group, click New Slide.
Choose the desired layout for the new slide.

3. How to change the layout of any slide?

Select the slide.
Go to the Home tab → Slides group → Click Layout → Choose the desired layout (e.g., Title Slide, Title and Content, Two Content, etc.).

4. How to change font name and font size of text?

Select the text.
Go to Home tab → Font group → Choose font name (e.g., Calibri, Times New Roman) and font size (e.g., 18, 24, etc.).

5. How to apply and remove Bold, Italic and Underline effect from text?

Select the text.
Go to Home tab → Font group → Click Bold (B), Italic (I), or Underline (U) to apply.
Click again to remove.

6. How to apply and remove strikethrough effect from text?

Select the text.
Go to Home tab → Font group → Click the Font Dialog Box Launcher (small arrow) → Check or uncheck Strikethrough → Click OK.

7. How to apply shadow effect on text?

Select the text.
Go to Home tab → Font group → Click Text Effects and Typography (A with glow) → Choose Shadow → Pick a shadow style.

8. How to change the case of text?

(Uppercase, lowercase, capitalize each word, toggle case)

Select the text.
Go to Home tab → Font group → Click Change Case (Aa) → Choose your desired option.

9. How to highlight text with different colour?

Select the text.
Go to Home tab → Font group → Click the Text Highlight Color icon → Choose a color.

10. How to change the font colour of text?

Select the text.
Go to Home tab → Font group → Click Font Color (A) → Choose a color.

11. How to apply and remove Bullets and Numbering from text?

Select the text.
Go to Home tab → Paragraph group → Click Bullets or Numbering to apply or remove.

12. How to change the alignment of text?

(Left, Center, Right, or Justify)

Select the text.
Go to Home tab → Paragraph group → Click Align Left, Center, Align Right, or Justify.

13. How to increase and decrease indent of text?

Select the text.
Go to Home tab → Paragraph group → Click Increase List Level or Decrease List Level.

14. How to change the line spacing of text or paragraph?

Select the text.
Go to Home tab → Paragraph group → Click Line Spacing → Choose spacing (1.0, 1.5, 2.0, etc.).

15. How to insert new slides?

Go to Home tab → Slides group → Click New Slide → Choose desired layout.

16. How to insert table in the slide?

Go to Insert tab → Tables group → Click Table → Select number of rows and columns.

17. How to insert picture in the slide?

Go to Insert tab → Images group → Click Pictures → Choose This Device → Select image → Click Insert.

18. How to insert different shapes in the slide?

Go to Insert tab → Illustrations group → Click Shapes → Choose a shape → Draw it on the slide.

19. How to insert action button (Home, Next, and Previous) in the slide?

Go to Insert tab → Illustrations group → Click Shapes → Select an Action Button → Draw it →
In the Action Settings box, choose the desired action (e.g., “Next Slide”, “Previous Slide”, or “First Slide”).

20. How to insert different SmartArt in the slide?

Go to Insert tab → Illustrations group → Click SmartArt → Choose a layout (e.g., List, Process, Cycle) → Click OK.

21. How to insert different charts in the slide?

Go to Insert tab → Illustrations group → Click Chart → Choose a chart type → Click OK.

22. How to change the chart style of the chart?

Click on the chart.
Go to Chart Design tab → In the Chart Styles group, choose a different style.

23. How to change column chart to pie chart?

Click on the chart.
Go to Chart Design tab → Click Change Chart Type → Select Pie → Click OK.

24. How to insert hyperlink on the text?

Select the text.
Go to Insert tab → Links group → Click Link → Enter the URL or select a slide → Click OK.

25. How to insert different text box in the slide?

Go to Insert tab → Text group → Click Text Box → Draw it → Type your text.

26. How to insert Header and Footer in the slide?

Go to Insert tab → Text group → Click Header & Footer → Select options (Date, Footer, Slide Number) → Click Apply to All.

27. How to insert date and time in the slide?

Go to Insert tab → Text group → Click Date & Time → Choose Fixed or Update automatically → Click Apply.

28. How to insert different symbols in the slide?

Go to Insert tab → Symbols group → Click Symbol → Choose a symbol → Click Insert.

29. How to change the slide size of the presentation?

Go to Design tab → Customize group → Click Slide Size → Choose Standard (4:3) or Widescreen (16:9) → Click OK.

30. How to change the slide background of the presentation?

Go to Design tab → Customize group → Click Format Background → Choose Solid Fill, Gradient Fill, Picture, or Texture → Apply to all.

31. How to apply different slide transition in the presentation?

Select a slide.
Go to Transitions tab → Transition to This Slide group → Choose a transition style (e.g., Push, Fade, Wipe).

32. How to set slide time for slide?

Go to Transitions tab → Timing group → Tick After → Set the number of seconds → Click Apply to All if needed.

33. How to apply different animations in the slide?

Select the text or object.
Go to Animations tab → Animation group → Choose an animation effect (e.g., Appear, Fly In, Zoom).

34. How to hide the slide? (VVI)

Select the slide.
Go to Slide Show tab → Set Up group → Click Hide Slide.

35. How to check spelling and grammar mistake in the presentation?

Go to Review tab → Proofing group → Click Spelling → Review and correct errors.

36. How to change the view of presentation in different views?

(Slide Sorter, Notes Page, Slide Master, etc.)

Go to View tab → Presentation Views group → Click Normal, Slide Sorter, Notes Page, or Slide Master.

37. How to zoom the slide?

Go to View tab → Zoom group → Click Zoom → Choose a zoom percentage (e.g., 100%, 150%, etc.).

38. How to apply gridline in the slide?

Go to View tab → Show group → Tick the Gridlines checkbox.

39. How to change colour and grayscale view of slide?

Go to View tab → Color/Grayscale group → Choose Color View or Grayscale View.

40. How to view the presentation in black and white view?

Go to View tab → Color/Grayscale group → Click Black and White.