MS Excel MCQ Quiz | Set-3

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

---

---

1) Which function is use to display the current date and time in a cell_________?

A) Today
B) Now
C) Current
D) Day

...

Answer is B) Now

The NOW function is useful when you need to display the current date and time on a worksheet or calculate a value based on the current date and time, and have that value updated each time you open the worksheet.

---

2) Which chart displays values as percentages of the whole _________?

A) Scatter Chart
B) Bar Chart
C) Surface Chart
D) Doughnut Chart

...

Answer is D) Doughnut Chart

Doughunt Chart displays values as percentages of the whole. The Doughunt Chart is a built-in chart type in Excel. Doughunt Charts are meant to express a "part-to-whole" relationship, where all pieces together represent 100%.

---

3) The function that counts the number of cells in a range that are not blank is known as_______ function.

A) COUNTA
B) COUNTB
C) COUNT
D) COUNTIF

...

Answer is A) COUNTA

The Excel CONUTA function returns the count of cells that contain any value (That is, cells that are not blank).

---

4) The Chart title option is available in________?

A) Format
B) Design
C) Developer
D) Layout

...

Answer is D) Layout

On the Layout tab, in the Labels group, click Chart Title. Click Centered Overlay Title or Above Chart. In the Chart Title text box that appears in the chart, type the text that you want.

---

5) The process of keep the top row visible while scrolling through the rest of the worksheet is known as___?

A) Freeze Panes
B) Page Breaks
C) Margins
D) Sorting

...

Answer is A) Freeze Panes

The Excel Freeze Panes tool allows you to lock your column and / or row headings so that, when you scroll down or over to view the rest of your sheet, the first column and/ or top row remain on the screen.

---

6) Maximum column width in Excel sheet is______?

A) 226 Characters
B) 254 Characters
C) 255 Characters
D) 256 Characters

...

Answer is C) 255 Characters

Maximum column width in Excel sheet is 255 Characters.

---

7) Where you can change the "number of Recent Workbooks" shown option in Excel Office button __________?

A) Save
B) Customize
C) Add-Ins
D) Advanced

...

Answer is D) Advanced

You can show up to 50 recent workbooks. Go to File- Options- Advanced- Scroll down- to display and choose show the number of recent Workbooks.

---

8) A function inside another function is known as____?

A) Nested function
B) Mode function
C) HLOOKUP function
D) Indirect function

...

Answer is A) Nested function

A function inside another function is known as nested function.

---

9) In Excel Options, the Auto Correct Option can be found in_________?

A) Popular
B) Formulas
C) Proofing
D) Advanced

...

Answer is C) Proofing

Proofing is used in Excel to check the "spelling". Auto Correct Option is used for correcting types and spelling mistakes automatically.

---

10) Strikethrough, Superscript and Subscript are the _______ in Excel:

A) Design
B) Text Control
C) Effects
D) Style

...

Answer is C) Effects

In most cases, Strikethrough in Excel means that the task or activity has been completed and has been checked off. Superscript is a small letter or number typed above the baseline. And Subscript is a small character or string that sits below the line of text.

---

❮ Previous Next ❯