Computer Skills: How Well Do You Know About MS Office And Email? Trivia Quiz

40 Questions | By ErVshalM | Updated: Mar 20, 2022 | Attempts: 339

Questions

Settings

Computer Skills: How Well Do You Know About MS Office And Email? Trivia Quiz - Quiz

This trivia quiz is on Computer Skills. How Well Do You Know About MS Office And Email? Ms. Office is the most common use mode of communication for emails when it comes to most organizations, and people need to know about using the application correctly at the workplace. How about you give it a shot and learn something!

Questions and Answers

1.

Ramesh Ahuja wants to store data of his monthly visits to schools over the last financial year. Which of the Office application is most suitable for this purpose?
- A.
  
  MS word
- B.
  
  Outlook
- C.
  
  MS Excel
- D.
  
  None of the above
2.

Mention the shortcut key combinations used for navigating to the top of the worksheet
- A.
  
  CTRL + HOME
- B.
  
  CTRL + END
- C.
  
  ALT + HOME
- D.
  
  ALT + END
3.

Which symbol always comes before an Excel formula?
- A.
  
  A common
- B.
  
  An equal sign
- C.
  
  Two times plus sign
- D.
  
  A percentage sign
4.

Address of second cell in a worksheet is
- A.
  
  C2
- B.
  
  2
- C.
  
  2C
- D.
  
  None of the above
5.

You can automatically adjust the size of text in a cell if they do not fit in width by
- A.
  
  Double clicking on the right border of column header
- B.
  
  From Format choose Columns and then Autofit Selection
- C.
  
  From Format Cells dialog box mark Shrink to fit check box
- D.
  
  All of above
6.

Based on the spreadsheet given below answers the below QuestionsFormula for calculating the Total Marks as sum of Science, Maths & Computers for each student and display them in column F-
- A.
  
  =SUM(A2+B2+C2+D2)
- B.
  
  =SUM(A1:E2)
- C.
  
  =SUM(C2+D2+E2)
- D.
  
  SUM(C2+D1+E2)
7.

Based on the spreadsheet given below answers the below QuestionsFormula for calculating the average marks for each student and display them in column G
- A.
  
  =AVERAGE(C1:E2)
- B.
  
  =AVERAGE(C2:E2)
- C.
  
  =AVERAGE(C1:E2)
- D.
  
  –AVG(C2:E2)
8.

Click on the right option to freeze a column-
- A.
  
  View- freeze first column
- B.
  
  Data- freeze column
- C.
  
  Insert- freeze
- D.
  
  Home – freeze
9.

Merge cells option can be applied from
- A.
  
  Format Cells dialog box Alignment Tab
- B.
  
  Formatting toolbar
- C.
  
  Both of above
- D.
  
  None of above
10.

Long text can be broken down into many lines within a cell. You can do this through
- A.
  
  Wrap Text in Format >> Cells
- B.
  
  Justify in Edit >> Cells
- C.
  
  Text Wraping in Format >> Cells, Layout tab
- D.
  
  All of above
11.

The file type _____ indicates the file is a Word document
- A.
  
  .msw
- B.
  
  .wor
- C.
  
  .wrd
- D.
  
  .doc
12.

Using Find command in Word, we can search?
- A.
  
  Word
- B.
  
  Formats
- C.
  
  Story
- D.
  
  All of the above
13.

By default, on which page the header or the footer is printed?
- A.
  
  on first page
- B.
  
  On alternate page
- C.
  
  On every page
- D.
  
  None of the above
14.

Which menu in MSWord can be used to change character size and typeface?
- A.
  
  View
- B.
  
  Tools
- C.
  
  Format
- D.
  
  Data
15.

Which key should be pressed to start a new paragraph in MS-Word?
- A.
  
  Down Cursor Key
- B.
  
  Enter Key
- C.
  
  Shift + Enter
- D.
  
  Ctrl + Enter
16.

What is the function of Ctrl + B in Ms-Word
- A.
  
  It converts selected text into the next larger size of the same font
- B.
  
  It adds a line break to the document
- C.
  
  It makes the selected text bold
- D.
  
  It applies Italic formatting t the selected text
17.

Why headers and footers used in MS –Word
- A.
  
  To enhance the overall appearance of the document
- B.
  
  To mark the starting of a page
- C.
  
  To make large document more readable
- D.
  
  To allow page headers and footers to appear on document when it is printed
18.

How to insert water mark-
- A.
  
  Insert- watermark
- B.
  
  Page layout- watermark
- C.
  
  Home – watermark
- D.
  
  None of the above
19.

There can be many ways to insert page number in a document. Which of the following lets you insert page number
- A.
  
  Page number from Insert menu
- B.
  
  Footnote from Insert menu
- C.
  
  Page Setup from file menu
- D.
  
  Both a & b
20.

Which is the correct keyboard short cut for COPY
- A.
  
  CTRL + C
- B.
  
  CTRL + D
- C.
  
  CTRL + E
- D.
  
  CTRL + W
21.

Before Sending very large attachments I should,
- A.
  
  Compress them up( Zip them)
- B.
  
  Send all attachments without compressing them
- C.
  
  Don’t attach them
- D.
  
  Send them in two separate email
22.

How Quickly Should I reply to an email?
- A.
  
  As soon as I can
- B.
  
  I don’t have to reply
- C.
  
  When I get around
- D.
  
  Doesn’t matter
23.

Why shouldn’t I type emails in all CAPS?
- A.
  
  It makes you look lazy
- B.
  
  It shows arrogant
- C.
  
  Its shows you are yelling.
- D.
  
  All of the above
24.

If you don't want to type your name at the end of every email you send, what you can you do instead?
- A.
  
  Don't sign at all .. people know who the email is from thanks to your return email address
- B.
  
  Only sign emails to business associates, but you can exclude this step with friends and family
- C.
  
  Create a signature that will attach to every email you send
- D.
  
  None of the above
25.

What is the most important thing I should do with every e-mail?
- A.
  
  Spell check, use full sentence structure and use proper grammar
- B.
  
  Have a nice greeting: Hi, Hello, etc
- C.
  
  Include signature
- D.
  
  All of the above