Microsoft Excel Questions

MCQ bookmark_border

71.

How do you display current date only in MS Excel?

A

Date ()

B

Today ()

C

Now ()

D

Time ()

Correct Answer: B

DATE - returns the serial date value for a date
TODAY - returns today's date
NOW - returns the current date and time
TIME - assemble a proper time.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

72.

How do you wrap the text in a cell?

A

Format, cells, font

B

Format, cells, protection

C

Format, cells, number

D

Format, cells, alignment

Correct Answer: D

Microsoft Excel can wrap text so it appears on multiple lines in a cell. We can format the cell so the text wraps automatically, or enter a manual line break.
On the Home tab, in the Alignment group, click Wrap Text.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

73.

What does COUNTA () function do?

A

Counts cells having alphabets

B

Counts empty cells

C

Counts cells having number

D

Counts non-empty cells

Correct Answer: D

COUNTA function counts cells containing any type of information, including error values. COUNTA function does not count empty cells.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

74.

What is the short cut key to highlight the entire column?

A

Ctrl + C

B

Ctrl + Enter

C

Ctrl + Page Up

D

Ctrl + Space Bar

Correct Answer: D

Ctrl + Space Bar is the short cut key to highlight the entire column.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

75.

What is the short cut key to highlight the entire column?

A

Ctrl + C

B

Ctrl + Enter

C

Ctrl + Page Up

D

Ctrl + Space Bar

Correct Answer: D

Ctrl + Space Bar is the short cut key to highlight the entire column.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

76.

Excel displays the current cell address in the ________

A

Formula bar

B

Status Bar

C

Name Box

D

Title Bar

Correct Answer: C

Name Box refers to an input box directly to the left of the formula bar. The Name Box normally displays the address of the "active cell" on the worksheet. You can also use the name box to quickly create a named range.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

77.

What is the correct way to refer the cell A10 on sheet3 from sheet1?

A

Sheet3!A10

B

Sheet1!A10

C

Sheet3.A10

D

A10

Correct Answer: A

First we use the name of sheet, then put an exclamation mark, at the end give the cell reference.
It would be look like =Sheet3!A10

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

78.

Which language is used to create macros in Excel?

A

Visual Basic

B

C

C

Visual C++

D

Java

Correct Answer: A

VBA (Visual Basic for Applications) is the programming language of Excel with VBA we can automate tasks in Excel by writing so called macros.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

79.

Which of the following is not a term of MS-Excel?

A

Cells

B

Rows

C

Columns

D

Document

Correct Answer: D

A worksheet in Excel is made up of Rows and Columns. Intersection of a Row and column in an Excel worksheet is a rectangle called as a Cell. Cells store a value, a formula, or text.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

80.

Which of the following is not a term of MS-Excel?

A

Cells

B

Rows

C

Columns

D

Document

Correct Answer: D

A worksheet in Excel is made up of Rows and Columns. Intersection of a Row and column in an Excel worksheet is a rectangle called as a Cell. Cells store a value, a formula, or text.

Check Answer report_problem Report forum Discussion