Computer Test 05

Total Questions: 28

1 - For spreadsheet with software is used:

A ) MS word
B ) MS Access
C ) MS PowerPoint
D ) MS Excel ✅

3 - F12 key in MS word is used for?

A ) Save
B ) Save as ✅
C ) Restore
D ) None of these

4 - Which of the following is not a search engine?

A ) Yahoo
B ) Google
C ) Ask
D ) None of these

5 - Ctrl + shift+< is used for

A ) Decrease in font size ✅
B ) Delete
C ) Redo
D ) None of these

6 - When you open web browser which page is open

A ) Home page ✅
B ) Bookmark
C ) Cast
D ) None of these

7 - 8/9 write in excel without formula than it shows:

A ) Fraction
B ) Date ✅
C ) Table
D ) None of these

8 - What does the Now() function return in Excel

A ) Past time
B ) Current time
C ) Future time
D ) Current date and time ✅

9 - Which key is used for redo in MS word:

A ) Ctrl + W
B ) Ctrl + Y ✅
C ) Ctrl + X
D ) None of these

Explanation:
  1. Ctrl + Y (or Ctrl + Shift + Z in some applications)
    This shortcut reverses the last undo, restoring the previously undone action. Commonly used in:
    • Microsoft Office Suite
    • Google Docs / Sheets / Slides
    • Design software like Photoshop, Illustrator.
  2. CTRL + T used 
    •   In Web Browsers  Opens a new tab
    •  in Microsoft Word  Opens the Font dialog box (for advanced text settings)
    •  in PowerPoint  Opens Font dialog box (like in Word)
  3. Ctrl + U Shortcut key to  underline the selected text
  4. Ctrl+K is a keyboard shortcut used in many applications, primarily for inserting or editing hyperlinks.
  5. Ctrl+Shift+Up Arrow selects the text from the current cursor position up to the beginning of the current paragraph.
  6. Ctrl + L: This combination aligns the selected text or paragraph to the left margin. 
  7. Ctrl+Shift+Left Arrow is a keyboard shortcut that extends the text selection to the left, specifically by one word at a time
  8. Alt + Ctrl + Left Arrow typically rotates the display 90 degrees to the left.
  9. Shift key + Use mouse shortcut key to select text in MS Word   
  10. Ctrl + Shift + D Shortcut key to double underline the selected text  
  11. Alt+L to quickly focus on the address bar, enabling you to enter a new website or search term efficiently. 
  12.  Ctrl+Z shortcut key is used to Undo the last action in a document .
  13. Ctrl + R: This shortcut aligns text to the right. 
  14. Ctrl+N :Shortcut key for blank Presentation in MS PowerPoint
  15. Ctrl + J: This shortcut justifies the text, aligning it evenly on both left and right margins. 
  16. Ctrl + V is a keyboard shortcut used to paste content that has been previously copied or cut.
  17. Ctrl + Y (or Cmd + Y on Mac) shortcut key is used to Redo the last action in a document .
  18. Ctrl + E: This shortcut centers the text. 
  19. 100 times undo level can be used in a worksheet
  20. Ctrl+5 shortcut key are used to strike through highlighted selection in excel 
  21. ✅ Ctrl+5 shortcut key are used to Word / WordPadSets 1.5 line spacing
  22. HIGHLIGHT Shortcut Key For PowerPoint : Ctrl + Alt + H,For Word Same as PowerPoint: Ctrl + Alt + H,For Excel Alt + H + H (Fill cell color)

Ctrl + Spacebar 

📝 In Microsoft Word / Office:     

Removes character formatting  

🧮 In Microsoft Excel:

Selects the entire column of the active cell

🧾 Microsoft Word / Excel / PowerPoint:  Ctrl + H opens the Find and Replace window.

🌐 In Web Browsers (Chrome, Firefox, Edge, etc.):

Ctrl + TOpens a new browser tab

📝 In Microsoft Word:

Ctrl + TCreates a hanging indent

📊 In Microsoft Excel:

Ctrl + TCreates a table from selected cells

 ✅Ctrl + Enter Function Word/Docs( Insert a page break), Excel (Fill same value in selected cells (not line break)),
Gmail  (Send Email).

10 - _____Is used to move the cursor one word right:

A ) CTRL+Right Arrow ✅
B ) SHIFT+Right Arrow
C ) ALT+Right Arrow
D ) None of these

11 - Which of the following is called as page in PowerPoint:

A ) Sheet
B ) Slide ✅
C ) Paper
D ) None of these

12 - Cyber security is related to

A ) Network
B ) Computer
C ) Software
D ) All of these ✅

13 - To write 2 in x² in MS word we use the key

A ) CTRL+SHIFT
B ) CTRL+=
C ) CTRL+SHIFT++ ✅
D ) None of these

14 - Option used to save after 10 minutes automatically in MS word:

A ) Save draft
B ) Auto recover ✅
C ) Instant recover
D ) None of these

15 - Which one is the most suitable reason to use Macro in MS Office:

A ) To Record keystroke
B ) To automate repetitive tasks ✅
C ) To Record Mouse Movr
D ) To Record Sound

16 - What is to be used to add text in slide?

A ) Text layer
B ) Text box ✅
C ) Note Box
D ) None of these

17 - The option____ is used to show a specific rolls and columns to appear on each face:

A ) Print view
B ) Print title ✅
C ) Print layout
D ) None of these

18 - Which key is used to creat chart in MS Excel

A ) F11 ✅
B ) F6
C ) F9
D ) None of these

19 - What are inserted as cross-reference in word?

A ) Placeholders
B ) Bookmarks
C ) Objects
D ) Word fields ✅

20 - To view the websites, we use

A ) Browser ✅
B ) Whatsapp
C ) Email
D ) None of these

22 - In Excel a data series is defined as what?

A ) A type of chart
B ) A division of results
C ) A collection of related data ✅
D ) A cell reference

23 - Design template option in available under

A ) Drawing bar
B ) Standard toolbar
C ) Formatting toolbar ✅
D ) All of these

24 - Moving from one webpage to another webpage is known as

A ) Hyperlink
B ) Web browsing ✅
C ) Web navigation
D ) None of these

25 - Specific information added on the top of the

A ) Header ✅
B ) Footer
C ) Margin
D ) None of these

26 - We can add in MS PowerPoint

A ) Animation
B ) Audio
C ) Vdeio
D ) All of these ✅

27 - Which value remain unchanged in MS Excel

A ) Variable
B ) Constant ✅
C ) Function
D ) None of these

28 - #value!Which type of error record in Excel

A ) Numerical error
B ) Excel doesn't recognize the formula ✅
C ) Syntax error
D ) None of these