Microsoft Excel Questions

MCQ bookmark_border

61.

In EXCEL, you can sum a large range of data by simply selecting a tool button called ________.

A

AutoFill

B

Auto correct

C

Auto sum

D

Auto format

Correct Answer: C

AutoSum is a Microsoft Excel function that adds together a range of cells and displays the total in the cell below the selected range.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

62.

To select an entire column in MS-EXCEL, press?

A

CTRL + C

B

CTRL + Arrow key

C

CTRL + S

D

None of the above

Correct Answer: D

To select an entire column in MS-EXCEL, Click the column heading letter or press CTRL + Space Bar key.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

63.

To return the remainder after a number is divided by a divisor in EXCEL we use the function?

A

ROUND ( )

B

FACT ( )

C

MOD ( )

D

DIV ( )

Correct Answer: C

The MOD function in Excel is used to find remainder after division of one number (dividend) by another (divisor). In mathematics, this operation is called the modulo operation or modulus, hence the name MOD.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

64.

Which function is not available in the Consolidate dialog box?

A

Pmt

B

Average

C

Max

D

Sum

Correct Answer: A

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

65.

Which function is not available in the Consolidate dialog box?

A

Pmt

B

Average

C

Max

D

Sum

Correct Answer: A

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

66.

Microsoft Excel is a powerful ________

A

Word processing package

B

Spreadsheet package

C

Communication S/W Package

D

DBMS package

Correct Answer: B

Microsoft Excel is Microsoft's general-purpose spreadsheet program for Windows, used for data analysis and display. It is commonly used in a business environment since it is part of the Microsoft Office package. Microsoft Excel is an extremely powerful tool, which is used by millions of people everyday. Functions tailored to a specific task can be programmed into Excel to extend its capabilities with customised analysis tools.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

67.

How do you rearrange the data in ascending or descending order?

A

Data, Sort

B

Data, Form

C

Data, Table

D

Data Subtotals

Correct Answer: A

Sorting data in MS Excel rearranges the rows based on the contents of a particular column. We can also sort a table to put names in alphabetical order or ascending or descending order. Or, maybe we want to sort data by Amount from smallest to largest or largest to smallest.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

68.

Which Chart can be created in Excel?

A

Area

B

Line

C

Pie

D

All of the above

Correct Answer: D

Excel offers the following major chart types ?
Column Chart
Line Chart
Pie Chart
Doughnut Chart
Bar Chart
Area Chart
XY (Scatter) Chart
Bubble Chart
Stock Chart
Surface Chart
Radar Chart
Combo Chart

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

69.

What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ?

A

5430

B

5436.80

C

5436.8

D

6.8

Correct Answer: B

'#,##0.00' = 5436.80

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

70.

What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ?

A

5430

B

5436.80

C

5436.8

D

6.8

Correct Answer: B

'#,##0.00' = 5436.80

Check Answer report_problem Report forum Discussion