MS Office Multiple Choice Questions and Answers | Computers & IT MCQs

Sports GK Questions and Answers 2024 (Latest Updated)

Awards & Honours GK Questions 2024 (Latest Updated)

1. Which of the following can create a vertical divide between columns?
  1. Margin
  2. Header
  3. Orientation
  4. Gutter

Answer: Margin

2. What do we do to autofit the width of the column?
  1. Double-click the left edge of the column.
  2. Right-click twice on the column’s edge.
  3. Click twice on the column header.
  4. Both a and c

Answer: Right-click twice on the column’s edge.

Advertisement
Article and Schedule Quiz Start Test!
DOWNLOAD CURRENT AFFAIRS PDF FROM APP
3. The ___ works with the standard Copy and Paste commands.
  1. View tab
  2. Paragraph dialog box
  3. Office Clipboard
  4. All of these

Answer: Office Clipboard

4. The Greater Than sign (>) exemplifies a/an _____ operator.
  1. Arithmetic
  2. Conditional
  3. Logical
  4. Greater

Answer: Logical

5. ____ type of chart is good for a single series of data.
  1. Column chart
  2. Cone chart
  3. Line chart
  4. Pie chart

Answer: Pie chart

6. Name the keyboard shortcut used to copy the value from the cell above the active cell into the cell or the Formula Bar in MS Excel____
  1. CTRL + SHIFT + C
  2. CTRL + SHIFT + "
  3. ALT + SHIFT + "
  4. CTRL + ALT + "

Answer: CTRL + SHIFT + "

7. _____ Excel function returns TRUE or FALSE based on two or more conditions
  1. =AVERAGEIFS
  2. =CONCAT
  3. =COUNTA
  4. =AND

Answer: =AND

8. Which of the following alignment cannot be placed where the tab stops?
  1. Decimal Alignment
  2. Center Alignment
  3. Bar Alignment
  4. Justify Alignment

Answer: Justify Alignment

9. Which function allows you to type straight quotations in place of smart quotes?
  1. Auto Correct as you type
  2. Auto Change as you type
  3. Auto Ignore as you type
  4. Auto Format as you type

Answer: Auto Format as you type

10. Shortcut Ctrl +H is used for :
  1. Activate the Insert Hyper Link Tab by opening the Insert Dialog box.
  2. Activate the Find and Replace dialogue box to display Access Tab
  3. With the Find Tab selected, launch the Find and Replace dialogue box.
  4. opens the find and replace tool that lets you search for a character, word or phrase and replace it with something else.

Answer: opens the find and replace tool that lets you search for a character, word or phrase and replace it with something else.

11. Which page’s header or footer is printed automatically?
  1. on the first page
  2. on the last page
  3. on alternate page
  4. every page

Answer: every page

12. Which of the following function key is used for doing the spelling check?
  1. F2
  2. F4
  3. F7
  4. F9

Answer: F7

13. How many columns can you insert into a Word document at most?
  1. 45
  2. 50
  3. 63
  4. 65

Answer: 63

14. Define Macro?
  1. If you require them, little add-on programs can be installed later.
  2. High-level programming language type
  3. Low-level programming language type
  4. Small programs made in MS Word using VBA to automate tedious activities

Answer: Small programs made in MS Word using VBA to automate tedious activities

15. Microsoft word is ____ software.
  1. Application
  2. Compiler
  3. System
  4. Programming

Answer: Application

16. Which of the following is an example of page orientation?
  1. Landscape
  2. Subscript
  3. Superscript
  4. A4

Answer: Landscape

17. The ability to combine name and addresses with a standard document is called ________
  1. Document formatting
  2. Database management
  3. Mail merge
  4. Form letters

Answer: Mail merge

18. Which can be used for quick access to commonly used commands and tools?
  1. Status bar
  2. Toolbar
  3. Menu bar
  4. Title bar

Answer: Toolbar

19. The name of a word document displays in ____.
  1. Ribbon
  2. Title bar
  3. Status bar
  4. Home tab

Answer: Home tab

20. What is MS Excel?
  1. Spreadsheet
  2. Database Management
  3. Presentation
  4. Workbook

Answer: Spreadsheet

21. ._____ logical function indicates TRUE only if all arguments are assessed as TRUE, and FALSE otherwise.
  1. OR
  2. AND
  3. IF
  4. ANDIF

Answer: AND

22. ___is the function used to match multiple values and returns the first match in Windows/ MAC(if you have Office 2019, or if you have a Microsoft 365 subscription)
  1. IF()
  2. IFS()
  3. IIF()
  4. SWITCH()

Answer: SWITCH()

23. What is an Excel feature that displays only the data in column (s) according to specified criteria?
  1. Filtering
  2. Sorting
  3. Formula
  4. Pivot

Answer: Filtering

24. Why is the =COUNTIF function in Excel used?
  1. Counts cells as specified
  2. Counts blank cells in a range
  3. Counts cells with numbers in a range
  4. Returns values based on a TRUE or FALSE condition

Answer: Counts cells as specified

25. What purpose do bookmarks serve?
  1. To save the document in a specific location
  2. To save a website’s URL for future reference
  3. To use the document for search
  4. To save alignments as it is.

Answer: To save a website’s URL for future reference

26. What does Ctrl + G do?
  1. Goto Tab is activated while the Find and Replace dialogue box is opened.
  2. With the Find Tab selected, launch the Find and Replace dialogue box.
  3. Activate the Replace tab to open the Find and Replace dialogue box.
  4. Launch the Goto Dialog box

Answer: Goto Tab is activated while the Find and Replace dialogue box is opened.

27. Which of the following can be looked at using the find tab?
  1. format
  2. characters
  3. symbol
  4. All of the above

Answer: All of the above

28. By which of the following option navigation, a sound file can be added to a word document?
  1. From insert -> sound menu option
  2. From insert -> object menu option
  3. From insert -> subject menu option
  4. From insert -> file menu option

Answer: From insert -> object menu option

29. How to implement page breaks in a document?
  1. By pressing enter at the end of the document
  2. By pressing the page break tab in the insert option
  3. Put the cursor at the end of the page and then click enter
  4. All of the above

Answer: By pressing the page break tab in the insert option

30. A document’s typeface can be changed by selecting the following menu item:
  1. Edit
  2. View
  3. Tools
  4. Format

Answer: Format

31. ____ cannot be used to work in MS Office.
  1. Joystick
  2. Scanner
  3. Light Pen
  4. Mouse

Answer: Joystick

32. Which of the following software is used for making a resume?
  1. MS Excel
  2. MS Word
  3. Dev C
  4. Java

Answer: MS Word

33. What is gutter margin?
  1. Margin that is added to the left margin when printing
  2. Margin that is added to the right margin when printing
  3. Margin that is added to the binding side of the page when printing
  4. Margin that is added to the outside of the page when printing

Answer: Margin that is added to the binding side of the page when printing

34. ____ is not a part of a MS Word document.
  1. Quick access toolbar
  2. Start Menu button
  3. Home panel
  4. View option

Answer: View option

35. _____ is not a valid data type in MS-Excel.
  1. Number
  2. Character
  3. Label
  4. Date/ Time

Answer: Character

36. The intersection of a column and a row in a worksheet is called____
  1. Column
  2. Address
  3. Value
  4. Cell

Answer: Cell

37. Name the keyboard shortcut to use to switch between open Excel windows.
  1. CTRL + TAB
  2. ALT + TAB
  3. CTRL + ALT + TAB
  4. None of the above

Answer: CTRL + TAB

38. Where on the MS Word screen you can locate the horizontal split bar?
  1. On the vertical scroll bar’s top
  2. On the vertical scroll bar’s bottom
  3. The horizontal scroll bar’s left side
  4. the horizontal scroll bar’s right side

Answer: On the vertical scroll bar’s top

39. What does Ctrl + D do?
  1. To add the dialogue folder
  2. Bookmark of the URL is added and also contents can be overwritten in Google sheets and Microsoft Excel
  3. To insert any subfolder in desktop
  4. To save any URL in the system

Answer: Bookmark of the URL is added and also contents can be overwritten in Google sheets and Microsoft Excel

40. Which of these toolbars allows you to alter the fonts’ sizes?
  1. Standard
  2. Formatting
  3. All of the above
  4. None of the above

Answer: Formatting

Assam Direct Recruitment Test Series

Teacher Eligibility Test

Assam Direct Recruitment Test Series