MS Excel MCQ Quiz Set-2

Are you finding the computer general knowledge questions for competitive exams? Here I am sharing computer general knowledge quiz questions and answers covering important topics in computer awareness, which is common for all the competitive exams.

These are the selective and important questions of the computer. You can increase your knowledge by learning these computer questions which help you while solving computer questions in SSC, Bank exams and many other competitive exams.

Learning Zone About us Our Services

---

---

1) Which bar show the used formula of selected active cell_________?

A) Formula Bar
B) Ribon
C) Menu Bar
D) Scroll Bar

...

Answer is A) Formula Bar

The formula Bar is where data or formulas you enter into a worksheet appear for the active cell. The formula bar can also be used to edit data or formula in the active cell. The active cell displays the results of its formula while we see the formula itsef in the formula Bar.

---

2) Typed text showed in active cell and also in _________?

A) Formula Bar
B) Ribbon
C) Title Bar
D) Scroll Bar

...

Answer is A) Formula Bar

Formula Bar shows the typed text and formaulas that you enter in an active cell.

---

3) _______Returns the least common multiple.

A) LCCM()
B) LCM()
C) TLCM()
D) RTLCM()

...

Answer is B) LCM()

The Excel LCM() returns the least common multiple of integers. The least commom multiple is the smallest positive integer that is a multiple of all supplied numbers. For Example =LCM(25,40) returns 200. Get the least common multiple or two or more numbers.

---

4) Workbook is a collection of________?

A) Worksheets
B) Page set-up
C) Diagrams
D) Buttons

...

Answer is A) Worksheets

Workbook is a file that contains one or more worksheets to help you organize data. You can create a new workbook from a blnk workbook or a template.

---

5) The worksheets name appear on tabs at the______of the workbook window.

A) Bottom right
B) Bottom left
C) Top left
D) Top right

...

Answer is B) Bottom left

By default, the worksheets name appear on tabs at the "buttom left" of the workbook window.

---

6) ___________Sign is used to create an absolute cell reference.

A) %
B) @
C) &
D) $ StarOffice

...

Answer is D) $

An absolute reference in Excel is a cell address with the doller ($) sign in the row or column coordinates, like $A$1.

---

7) #VALUE! refers to __________?

A) Font value
B) Error in value
C) Subscript of the number value
D) Addtion of value

...

Answer is B) Error in value

#VALUE is Excel's way of saying, "There's something wrong with the way your formula is typed. Or there's somthing wrong with the cells you are referencing.

---

8) Press______to close an open menu or submenu, dialog box, message window.

A) Tab+ctrl+6
B) Alt+f5
C) Esc
D) Ctrl+f4

...

Answer is C) Esc

Esc (short for Escape) is a key found on the top-left corner of a computer keyboard. It allow the user to abort, Cancel, or close an operation or leaves the cell in its original state.

---

9) On an Excel sheet the active cell is indicated by_________?

A) A dotted border
B) A dark wide border
C) A blinking border
D) By italic text

...

Answer is B) A dark wide border

The thick border gridlines around the cell indicates that it is active cell.

---

10) Waht term describes explanatory text attached to a cell________?

A) Context
B) Callout
C) Comment
D) Dialog

...

Answer is C) Comment

Cell Comment allow us to attach a comment to a cell to inform, remind or explain the content of a cell or range of cell.

---

❮ Previous Next ❯