Microsoft Excel mcq questions With Answer | MS Excel || Computer Fundamental

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

Discuss

Answer & Solution

Answer: Option C

Solution:

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

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

Discuss

Answer & Solution

Answer: Option D

Solution:

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

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 ( )

Discuss

Answer & Solution

Answer: Option C

Solution:

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.

64

Which function is not available in the Consolidate dialog box?

A) Pmt B) Average C) Max D) Sum

Discuss

Answer & Solution

Answer: Option A

Solution:

65

Which is not the function of "Edit, Clear" command?

A) Delete contents B) Delete notes C) Delete cells D) Delete formats

Discuss

Answer & Solution

Answer: Option C

Solution:

66

Microsoft Excel is a powerful ________

A) Word processing package B) Spreadsheet package C) Communication S/W Package D) DBMS package

Discuss

Answer & Solution

Answer: Option B

Solution:

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.

67

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

A) Data, Sort B) Data, Form C) Data, Table D) Data Subtotals

Discuss

Answer & Solution

Answer: Option A

Solution:

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.

68

Which Chart can be created in Excel?

A) Area B) Line C) Pie D) All of the above

Discuss

Answer & Solution

Answer: Option D

Solution:

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

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

Discuss

Answer & Solution

Answer: Option B

Solution:

'#,##0.00' = 5436.80

70

How do you display current date and time in MS Excel?

A) Date () B) Today () C) Now () D) Time ()

Discuss

Answer & Solution

Answer: Option C

Solution:

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.