MS Word & Excel Quiz # 2

25 Questions | By Copa201718 | Updated: Mar 15, 2022 | Attempts: 260

Questions

Settings

Create your own Quiz

Questions and Answers

1.

Which of the following is the second step in creating a macro?
- A.
  
  Start recording
- B.
  
  Using your mouse or keyboard, perform the task you want to automate
- C.
  
  Assign a keyboard shortcut to the macro
- D.
  
  Give the macro a name
2.

When assigning a shortcut key to a symbol, you should always try to select a key or key combination that is:
- A.
  
  Unassigned
- B.
  
  Located on the ten-key pad section of your keyboard
- C.
  
  Assigned to another task
- D.
  
  From the same font family as the symbol
3.

Which feature is used to replace straight quotes with smart quotes as you type?
- A.
  
  Auto Correct as you type
- B.
  
  Auto Change as you type
- C.
  
  Auto Format as you type
- D.
  
  Smart Tags as you type
4.

Which of the following command is not available in Tools menu?
- A.
  
  Auto text
- B.
  
  Autocorrect
- C.
  
  Auto summarize
- D.
  
  Macro
5.

Word has a list of predefined typing, spelling, capitalization, and grammar errors that _____ can detect and correct.
- A.
  
  AutoEntry
- B.
  
  AutoCorrect
- C.
  
  AutoAdd
- D.
  
  AutoSpell
6.

Which option is not available in Insert Table Autofit behavior?
- A.
  
  Fixed Column Width
- B.
  
  AutoFit to Contents
- C.
  
  Autofit to Window
- D.
  
  Autofit to Column
7.

Tabs stop position cannot be the following alignment
- A.
  
  Decimal Alignment
- B.
  
  Center Alignment
- C.
  
  Bar Alignment
- D.
  
  Justify Alignment
8.

Ctrl + B
- A.
  
  Search the selected text
- B.
  
  Paste the selected text
- C.
  
  Bold the selected text
- D.
  
  Open the specified file
9.

To move the cursor page to page of document
- A.
  
  Ctrl+PgDn
- B.
  
  Ctrl+PgUp
- C.
  
  Both of above
- D.
  
  None of above
10.

What is the shortcut key to "Insert Hyperlink" in a document?
- A.
  
  Ctrl + H
- B.
  
  Ctrl + K
- C.
  
  Ctrl + L
- D.
  
  None of above
11.

What is extension of files created in MS-Excel 97-2003
- A.
  
  .xlx
- B.
  
  .msx
- C.
  
  .dot
- D.
  
  .xls
12.

What is extension of files created in MS-Excel 2007-2015
- A.
  
  .txt
- B.
  
  .xls
- C.
  
  .xlsx
- D.
  
  .xsl
13.

Which is the correct formula for SUM Function in MS Excel.
- A.
  
  /SUM(A1+A5)
- B.
  
  =SUM(A1-A5)
- C.
  
  =SUM(A1:A5)
- D.
  
  +SUM(A1:A5)
14.

Which menu option in MS Excel has the option to "Sort the Data"
- A.
  
  Review
- B.
  
  Data
- C.
  
  Formula
- D.
  
  Insert
15.

Which button in MS Excel to calculate the sum of number
- A.
  
  AutoSum
- B.
  
  Fill
- C.
  
  Insert
- D.
  
  Merge
16.

What is the Shortcut key for "Current Date" in Excel
- A.
  
  Ctrl + C
- B.
  
  Ctrl + D
- C.
  
  Alt + ;
- D.
  
  Ctrl + ;
17.

What is the intersection of a column and a row on a worksheet called?
- A.
  
  Column
- B.
  
  Value
- C.
  
  Address
- D.
  
  Cell
18.

Which type of chart is useful for comparing value over categories?
- A.
  
  Pie Chart
- B.
  
  Column Chart
- C.
  
  Line Chart
- D.
  
  Dot Chart
19.

Which function in Excel tells how many numeric entries are there
- A.
  
  Num
- B.
  
  Count
- C.
  
  Sum
- D.
  
  ChkNum
20.

A features that displays only the data in column (s) according to specified criteria
- A.
  
  Formula
- B.
  
  Sorting
- C.
  
  Filtering
- D.
  
  Pivot
21.

Statistical calculations and preparation of tables and graphs can be done using
- A.
  
  Adobe Photoshop
- B.
  
  Excel
- C.
  
  Notepad
- D.
  
  Power Point
22.

What type of chart will you use to compare performance of two employees in the year 2016 ?
- A.
  
  Column Chart
- B.
  
  Line Chart
- C.
  
  Pie Chart
- D.
  
  Dot Chart
23.

Which one is not a Function in MS Excel ?
- A.
  
  SUM
- B.
  
  AVG
- C.
  
  MAX
- D.
  
  MIN
24.

Functions in MS Excel must begin with ___
- A.
  
  An () sign
- B.
  
  An Equal Sign
- C.
  
  A Plus Sign
- D.
  
  A > Sign
25.

Which function in Excel checks whether a condition is true or not ?
- A.
  
  SUMAVER
- B.
  
  COUNT
- C.
  
  IF
- D.
  
  AVERAGE