Can You Pass This Microsoft Excel Exam Quiz?

15 Questions | By Arunavaguha416 | Last updated: Mar 21, 2022 | Total Attempts: 303

Questions

Settings

Create your own Quiz

Questions and Answers

1.

AN EXAMPLE OF CELL ADDRESS ..
- A.
  
  23G
- B.
  
  11
- C.
  
  A11
- D.
  
  A
2.

WHAT IS SHORTCUT FOR COPY ?
- A.
  
  CTRL+C
- B.
  
  CTRL
- C.
  
  COPY
- D.
  
  PASTE
3.

HOW TO START ANY FORMULA IN A CELL ?
- A.
  
  /
- B.
  
  *
- C.
  
  +
- D.
  
  =
4.

WHICH SYNTAX IS CORRECT ?
- A.
  
  =(A1-B1)
- B.
  
  (A1-B1)
- C.
  
  A1
5.

On an excel sheet the active cell in indicated by ?
- A.
  
  A dark wide border
- B.
  
  WITH A DOT
- C.
  
  COLOR OF THE CELL IS CHANGED
- D.
  
  By italic text
6.

If you press ___, the cell accepts your typing as its contents ?
- A.
  
  SHIFT+ENTER
- B.
  
  ENTER
- C.
  
  CTRL
- D.
  
  CTRL+ENTER
7.

A EXCEL SHEET CONTAINS ?
- A.
  
  ROW
- B.
  
  COLUMN
- C.
  
  ROW AND COLUMN
- D.
  
  LINES
8.

CAN WE ADD PICTURE IN A EXCEL SHEET ?
- A.
  
  YES
- B.
  
  NO
9.

Which of the following function, a formula with a logical function shows the word "TRUE" or "FALSE" as a result ?
- A.
  
  IF
- B.
  
  OR
- C.
  
  AND
- D.
  
  NOT
10.

PRODUCT FUNCTION IS USED FOR ?
- A.
  
  MULTIPLICATION
- B.
  
  DIVISION
- C.
  
  ADDITION
- D.
  
  NOTHING
11.

What is Microsoft Excel?
- A.
  
  Microsoft excel is an electronic worksheet developed by Microsoft, to be used for organizing, storing and manipulating.
- B.
  
  IT IS USED FOR VARIOUS CALCULATION
- C.
  
  ANY OF THE ABOVE
12.

EVERY CELL MUST HAVE A ADDRESS ..
- A.
  
  TRUE
- B.
  
  FALSE
13.

TABLE OPTION CAN BE FOUND ON ...
- A.
  
  HOME
- B.
  
  INSERT
- C.
  
  FORMULAS
- D.
  
  VIEW
14.

CTRL + X COMMAND IS USED FOR ?
- A.
  
  CUT
- B.
  
  COPY
- C.
  
  PASTE
15.

CTRL + Z IS USED FOR ?
- A.
  
  REDO
- B.
  
  COPY
- C.
  
  UNDO
- D.
  
  PASTE