OU All In One

MS Office questions

Excel functions, Word and PowerPoint features (asked by Accenture).

1. In MS Excel, which function adds a range of cells?

  1. TOTAL
  2. ADD
  3. SUM
  4. PLUS
Answer

C. SUM =SUM(A1:A10) adds the range.

2. Which Excel function finds a value in the first column of a table and returns a value from another column?

  1. COUNTIF
  2. CONCAT
  3. HLOOKUP only for rows
  4. VLOOKUP
Answer

D. VLOOKUP VLOOKUP searches vertically.

3. In Excel, a cell reference like $A$1 is:

  1. A mixed reference
  2. An absolute reference
  3. A relative reference
  4. A named range
Answer

B. An absolute reference Dollar signs fix both column and row.

4. Which Excel function counts cells that meet a condition?

  1. SUMIF
  2. IF
  3. COUNT
  4. COUNTIF
Answer

D. COUNTIF COUNTIF(range, criteria).

5. What does =IF(A1>50, "Pass", "Fail") return when A1 is 40?

  1. Error
  2. 40
  3. Pass
  4. Fail
Answer

D. Fail The condition is false, so the third argument is returned.

6. What does =AVERAGE(10, 20, 30) return?

  1. 20
  2. 60
  3. 30
  4. 10
Answer

A. 20 (10 + 20 + 30)/3 = 20.

7. Which Excel feature summarises large data by dragging fields into rows and columns?

  1. Pivot Table
  2. Track Changes
  3. Mail Merge
  4. Slide Master
Answer

A. Pivot Table Pivot Tables summarise data.

8. In Excel, what is the intersection of a row and a column called?

  1. A workbook
  2. A sheet
  3. A range
  4. A cell
Answer

D. A cell Cells hold values and formulas.

9. Which keyboard shortcut copies selected content in MS Office on Windows?

  1. Ctrl + C
  2. Ctrl + X
  3. Ctrl + P
  4. Ctrl + V
Answer

A. Ctrl + C Ctrl + V pastes; Ctrl + X cuts.

10. Which shortcut undoes the last action?

  1. Ctrl + Y
  2. Ctrl + A
  3. Ctrl + Z
  4. Ctrl + U
Answer

C. Ctrl + Z Ctrl + Y redoes.

11. In MS Word, which feature creates personalised letters for many recipients from a list?

  1. Mail Merge
  2. Page Break
  3. Track Changes
  4. Format Painter
Answer

A. Mail Merge Mail Merge combines a document with a data source.

12. In MS Word, Track Changes is used to:

  1. Change the page colour
  2. Insert tables
  3. Record edits so they can be reviewed and accepted or rejected
  4. Count words
Answer

C. Record edits so they can be reviewed and accepted or rejected Useful for collaborative editing.

13. Which Word feature copies formatting from one piece of text to another?

  1. Mail Merge
  2. Thesaurus
  3. Header
  4. Format Painter
Answer

D. Format Painter Format Painter copies styles.

14. The default file extension of a modern Word document is:

  1. .txt
  2. .doc only
  3. .docx
  4. .wrd
Answer

C. .docx .docx since Office 2007.

15. In PowerPoint, Slide Master is used to:

  1. Check spelling
  2. Record audio
  3. Apply consistent design and layout to all slides
  4. Add animations to one slide
Answer

C. Apply consistent design and layout to all slides Changes to the master update all slides.

16. Which PowerPoint view shows thumbnails of all slides for rearranging?

  1. Slide Sorter
  2. Notes Page
  3. Reading View
  4. Outline only
Answer

A. Slide Sorter Slide Sorter makes reordering easy.

17. Which key starts a PowerPoint slideshow from the beginning?

  1. F2
  2. F12
  3. F7
  4. F5
Answer

D. F5 Shift + F5 starts from the current slide.

18. Which character is typed first to start a formula in Excel?

  1. =
  2. #
  3. %
  4. $
Answer

A. = Formulas start with an equals sign.

19. What does the Excel error #DIV/0! mean?

  1. The column is too narrow
  2. A reference is invalid
  3. A formula is dividing by zero
  4. A name is not recognised
Answer

C. A formula is dividing by zero Division by zero or an empty cell.

20. Which Excel function joins text from several cells?

  1. LINK
  2. CONCAT (or CONCATENATE)
  3. MERGE
  4. JOINROW
Answer

B. CONCAT (or CONCATENATE) CONCAT joins strings.

21. Which Excel function returns the average of a range?

  1. AVERAGE
  2. MEDIAN
  3. MEAN
  4. AVG
Answer

A. AVERAGE =AVERAGE(A1:A10).

22. Which Excel function returns the largest value in a range?

  1. LARGE only
  2. MAX
  3. HIGH
  4. TOP
Answer

B. MAX =MAX(A1:A10).

23. What does =CONCAT("OU", "2026") return?

  1. OU 2026
  2. OU2026
  3. OU+2026
  4. Error
Answer

B. OU2026 CONCAT joins text with no space.

24. What does =ROUND(3.456, 1) return?

  1. 3
  2. 3.5
  3. 3.46
  4. 3.4
Answer

B. 3.5 Rounding to 1 decimal place gives 3.5.

25. What does =LEN("Placement") return?

  1. Placement
  2. 8
  3. 10
  4. 9
Answer

D. 9 LEN counts characters: P-l-a-c-e-m-e-n-t = 9.

26. Which Excel function counts non-empty cells in a range?

  1. COUNTBLANK
  2. COUNTA
  3. COUNT
  4. SUM
Answer

B. COUNTA COUNT counts only numbers; COUNTA counts any non-empty cell.

27. A tool in Excel that summarises large data by grouping and totalling it is a:

  1. Pivot table
  2. Hyperlink
  3. Text box
  4. Watermark
Answer

A. Pivot table Pivot tables group and aggregate data.

28. Which symbol starts every formula in Excel?

  1. =
  2. @
  3. +
  4. #
Answer

A. = Formulas begin with "=".

29. In Excel, $A1 is a:

  1. Named range
  2. Mixed reference with the column fixed
  3. Fully absolute reference
  4. Relative reference
Answer

B. Mixed reference with the column fixed Only the column is locked.

30. What does =SUMIF(A1:A5, ">10") add?

  1. Values in A1:A5 greater than 10
  2. Values less than 10
  3. All values in A1:A5
  4. The count of values above 10
Answer

A. Values in A1:A5 greater than 10 SUMIF adds the cells that meet the condition.

31. Which feature highlights cells automatically based on their value?

  1. Data validation
  2. Freeze panes
  3. Conditional formatting
  4. Goal Seek
Answer

C. Conditional formatting Rules change cell colours based on values.

32. Freeze Panes in Excel is used to:

  1. Lock the file with a password
  2. Stop formulas from calculating
  3. Hide a sheet
  4. Keep rows or columns visible while scrolling
Answer

D. Keep rows or columns visible while scrolling Headers stay in view.

33. Which Excel function returns today's date?

  1. DATE()
  2. DAY()
  3. NOW_DATE()
  4. TODAY()
Answer

D. TODAY() TODAY() updates every day.

34. Which feature restricts what can be entered in a cell, such as a drop-down list?

  1. Conditional formatting
  2. AutoSum
  3. Sort
  4. Data validation
Answer

D. Data validation Data validation limits allowed entries.

35. In MS Word, which shortcut makes selected text bold?

  1. Ctrl + I
  2. Ctrl + U
  3. Ctrl + D
  4. Ctrl + B
Answer

D. Ctrl + B Ctrl + I is italic; Ctrl + U is underline.

36. In MS Word, Ctrl + Z is used to:

  1. Redo
  2. Zoom
  3. Undo the last action
  4. Save
Answer

C. Undo the last action Ctrl + Y redoes.

37. Which Word feature automatically creates a list of headings with page numbers?

  1. Mail merge
  2. Footnote
  3. Table of contents
  4. Watermark
Answer

C. Table of contents It is built from heading styles.

38. Mail Merge in MS Word is used to:

  1. Combine tables
  2. Create personalised letters for many people from one template
  3. Merge two documents into one
  4. Send email attachments
Answer

B. Create personalised letters for many people from one template Data from a list fills fields in the letter.

39. Text placed at the top of every page in Word is called the:

  1. Footer
  2. Margin
  3. Title bar
  4. Header
Answer

D. Header Footers appear at the bottom.

40. Which Word shortcut centre-aligns text?

  1. Ctrl + E
  2. Ctrl + L
  3. Ctrl + R
  4. Ctrl + C
Answer

A. Ctrl + E Ctrl + L left, Ctrl + R right, Ctrl + J justify.

41. Track Changes in Word is used to:

  1. Record edits so others can review and accept them
  2. Check spelling
  3. Change the page size
  4. Count words
Answer

A. Record edits so others can review and accept them Each insertion and deletion is marked.

42. In PowerPoint, which key starts the slide show from the first slide?

  1. F7
  2. F1
  3. F5
  4. F12
Answer

C. F5 Shift + F5 starts from the current slide.

43. Effects that play when moving from one slide to the next are called:

  1. Transitions
  2. Animations
  3. Themes
  4. Layouts
Answer

A. Transitions Animations apply to objects within a slide.

44. Which PowerPoint view shows small versions of all slides for rearranging?

  1. Reading View
  2. Notes Page
  3. Outline only
  4. Slide Sorter
Answer

D. Slide Sorter Slide Sorter makes reordering easy.

45. The Slide Master in PowerPoint is used to:

  1. Print handouts only
  2. Add speaker notes
  3. Play a video
  4. Set the design and layout used by all slides
Answer

D. Set the design and layout used by all slides Changes to the master apply to every slide.

46. Which file extension is used by modern Excel workbooks?

  1. .txt
  2. .docx
  3. .xlsx
  4. .pptx
Answer

C. .xlsx .docx is Word and .pptx is PowerPoint.

47. Which shortcut copies selected content in MS Office?

  1. Ctrl + C
  2. Ctrl + P
  3. Ctrl + V
  4. Ctrl + X
Answer

A. Ctrl + C Ctrl + V pastes, Ctrl + X cuts.

48. What does =IF(B2>=40, "Pass", "Fail") return when B2 is 40?

  1. 40
  2. Pass
  3. Fail
  4. Error
Answer

B. Pass 40 >= 40 is true, so the second argument is returned.

49. Which chart is best for showing parts of a whole?

  1. Scatter plot
  2. Line chart
  3. Histogram
  4. Pie chart
Answer

D. Pie chart A pie chart shows shares that add up to 100%.

50. Which chart is best for showing a trend over time?

  1. Pie chart
  2. Line chart
  3. Radar chart
  4. Doughnut chart
Answer

B. Line chart Line charts connect values in time order.

Mock test

More Technical MCQs topics