MS Excel MCQ Quiz | Set-4

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

---

MCQ Quiz |welcome2protec

---

1) Which Key Is Used For Help In Ms Excel_________?

A) F2
B) F3
C) F1
D) F10

...

Answer is C) F1

The F1 key is often used as the default for help key in many programs.

---

2) You Can Convert Existing Excel Worksheet Data And Charts To HTML Document By Using The_________?

A) Intranet Wizard
B) Import Wizard
C) Export Wizard
D) Internet Assistant Wizard

...

Answer is D) Internet Assistant Wizard

The Internet Assistant for Excel is an add-in wizard that allows you to create and distribute Excel documents online for viewing with any popular browser. The Internet Assistant helps you convert your spreadsheet data to HTML format.

---

3) To Create An Interactive Pivot Table For The Web, You Use A Microsoft Office Web Component Called_______?.

A) HTML
B) Pivot Table Report
C) Pivot Table List
D) Pivot Table Field List

...

Answer is B) Pivot Table Report

Pivot Table Report is the web component which helps the user to create both simple and complex report.

---

4) Worksheet data can be viewed in forms of________?

A) Graphs
B) Charts
C) Tables
D) All of the above

...

Answer is D) All of the above

Worksheet data can be viewed in form of either Graphs, Charts, or Table.

---

5) Which of the following key is used to "Goto" tab In Ms Excel______?

A) F5
B) F9
C) F7
D) F6

...

Answer is A) F5

On the Ribbon, click the Find & Select command button in the Editing group on the Home tab and then choose Go To from its drop-down menu or press Alt+HFDG, Ctrl+G or F5. The Go To dialog box opens.

---

6) Which one is not a function in ms excel______?

A) SUM
B) AVG
C) MAX Characters
D) MIN Characters

...

Answer is B) AVG

There is no such (AVG funciton) in Excel.

---

7) Hyperlinks Can Be In __________?

A) Text
B) Pictures
C) Drawing Objects
D) All Of the Above

...

Answer is D) All of the above

Hyperlinks can be a text or drawing objects or pictures. A hyperlink is a word, phrase, or image that we can click on to jump to a new file or a new section within the current file.

---

8) VLOOKUP Function Used To _______?

A) Finds Related Records
B) Looks Up Text That Contain "v"
C) Check If Two Cells Are Identical
D) None Of Above

...

Answer is A) Finds Related Records

VLOOKUP stands for 'Vertical Lookup'. It is a function that makes Excel search for a certain value in a column (the so called 'table array'), in order to return a value from a different column in the same row.

---

9) We Can Cancel Marquee By Pressing _________?

A) Ctrl + Esc
B) Alt + Esc
C) Shift + Esc
D) Esc

...

Answer is D) Esc

Pressing the escape key while editing a cell aborts the operation and leaves the cell in it's original state.

---

10) Merge Cells Option Can Be Applied From _______

A) Formatting Toolbar
B) Format Cells Dialog Box Alignment Tab
C) Both Of Above
D) None Of Above

...

Answer is B) Format Cells Dialog Box Alignment Tab

Merging combines two or more cells to create a new, larger cell.Inside the Format Cells menu, click on the Alignment tab and tick the box that says Merge Cells.

---

❮ Previous Next ❯