MS Excel Questions & Answers | Basic Computer Knowledge

MS Excel Questions & Answers | Basic Computer Knowledge

1.

Which among the following is not associated with the spelling dialogue box?

   A.) Edit

   B.) Ignore All

   C.) Ignore

   D.) Change

Answer: Option 'A'

Edit

2.

To drag a selected range of data to another worksheet in the same workbook, use the?

   A.) Ctrl key

   B.) Tab key

   C.) Shift key

   D.) Alt key

Answer: Option 'A'

​Ctrl key

3.

How can we set Page Border in Excel?

   A.) From Edit menu

   B.) From Home

   C.) You can not set page border in Excel

   D.) From Tools menu

Answer: Option 'C'

You can not set page border in Excel

4.

The default style for new data keyed in a new workbook is?

   A.) Comma

   B.) Normal

   C.) Currency

   D.) Per cent

Answer: Option 'B'

Normal

5.

Which of the following all formulas in excel starts?

   A.) =

   B.) /

   C.) *

   D.) $

Answer: Option 'A'

=

6.

What function displays row data in a column or column data in a row?

   A.) Hyperlinks

   B.) Transpose

   C.) Rows

   D.) Index

Answer: Option 'B'

​Transpose

7.

In Excel, Columns are labelled as ________.

   A.) A, B, C, etc

   B.) 1,2,3 etc

   C.) A1, A2, etc.

   D.) $A$1, $A$2, etc.

Answer: Option 'A'

​A, B, C, etc

8.

Which among the following can't be considered as a worksheet criterion?

   A.) Efficiency

   B.) Auditability

   C.) Clarity

   D.) Description

Answer: Option 'D'

Description

9.

What excels feature can you use if you want to work with one record at a time?

   A.) AutoComplete

   B.) Data Form

   C.) Set Form

   D.) Auto Text

Answer: Option 'B'

Data Form

10.

When the formula bar is activated, you can see

   A.) The Edit Formula button

   B.) The Cancel button

   C.) The Enter button

   D.) All of above

Answer: Option 'D'

All of above

11.

Which dialogue box we can use to name a constant?

   A.) Create Name

   B.) Define Name

   C.) Get Name

   D.) Create Constant

Answer: Option 'B'

Define Name

12.

3-D reference in a formula?

   A.) Spans worksheets

   B.) Can not be modified

   C.) Only appears on summary worksheets

   D.) Limits the formatting options

Answer: Option 'A'

Spans worksheets

13.

What type of chart is good for a single series of data?

   A.) Column Chart

   B.) Line Chart

   C.) Pie Chart

   D.) Cone Chart

Answer: Option 'C'

​Pie Chart

14.

To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called?

   A.) Pivot Table Report

   B.) Pivot Table Field List

   C.) HTML

   D.) Pivot Table List

Answer: Option 'A'

​Pivot Table Report

15.

What do you use to create a chart?

   A.) Pie Wizard

   B.) Excel Wizard

   C.) Data Wizard

   D.) Chart Wizard

Answer: Option 'D'

Chart Wizard

16.

Except which of the following function, a formula with a logical function shows the word "TRUE" or "FALSE" as a result?

   A.) NOT

   B.) IF

   C.) OR

   D.) AND

Answer: Option 'B'

​IF

17.

A function inside another function is known as?

   A.) Switch function

   B.) Sandwich function

   C.) Nested function

   D.) Round function

Answer: Option 'C'

​Nested function

18.

In Excel, Rows are labelled as ________.

   A.) A, B, C, etc

   B.) 1,2,3 etc

   C.) A1, A2, etc.

   D.) $A$1, $A$2, etc.

Answer: Option 'B'

​1,2,3 etc

19.

The cell reference for a range of cells that starts in cell C1 and goes over to column H and down to row 10 is?

   A.) C1:10H

   B.) C1:H10

   C.) C1:H-10

   D.) C1:H:10

Answer: Option 'B'

C1:H10

20.

Except which of the following function, a formula with a logical function shows the word "TRUE" or "FALSE" as a result?

   A.) NOT

   B.) OR

   C.) IF

   D.) AND

Answer: Option 'C'

IF

21.

Which among the following wildcard characters are recognized by excel?

   A.) + and -

   B.) ! and ^

   C.) * and?

   D.) < and >

Answer: Option 'C'

​* and?

22.

3-D reference in a formula?

   A.) Spans worksheets

   B.) Can not be modified

   C.) Only appears on summary worksheets

   D.) Limits the formatting options

Answer: Option 'A'

Spans worksheets

23.

Which of the following is not a valid Zoom percentage in Excel?

   A.) 500

   B.) 300

   C.) 100

   D.) 10

Answer: Option 'A'

500

24.

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: Option 'A'

​Finds related records

• Tit-Bits
  * Each new workbook created in Excel has three worksheets by default.
  * Active cell a cell in which you are currently working.
  * File format or extension of Excel is .xlsx or .xls.
  * Illustrations group allows insertion of pictures, clip art, shapes and smart art.
  * Scatter compares pairs of values.
  * Charts wizard used to create charts in MS-Excel.
  * Embedded chart is a chart that is drawn on an existing sheet.

25.

Which of these will not select all the cells in a document?

   A.) Using the Edit - Select All menu

   B.) Pressing Ctrl + A on the keyboard

   C.) Clicking three times with the right mouse button in the spreadsheet

   D.) None of these

Answer: Option 'C'

Clicking three times with the right mouse button in the spreadsheet