Microsoft Excel | MCQs

Explanation

In Excel, a Data Series is defined as a collection of related data.

 Microsoft Excel features calculation or computation capabilities, graphing tools, pivot tables etc.

Explanation

An apostrophe before a cell value forces Excel to interpret the value as text.

This is mostly useful for values that look like a number or date.

Explanation

The formatting and Drawing toolbar is a toolbar in Microsoft Office 2003 and earlier applications, that gives the user the ability to change the formatting of selected text or cell.

Explanation

Data sheet can not be a sheet in workbook.

Explanation

To removes a sheet from workbook select the sheet, then choose Edit > Delete Sheet these options available in excel 2003 and earlier version.

Explanation

Ctrl + P is the shortcut key to print.

Explanation

Dragging is used to move an object from one position to another position on the computer screen.

Explanation

On the Data tab, in the Data Tools group, click Text to Columns.

The Convert Text to Columns Wizard opens.

Choose Delimited if it is not already selected, and then click Next.

Select the delimiter or delimiters to define the places where you want to split the cell content.

Explanation

There is no option to set page border in Excel.

Explanation

Minimum zooming is 10% and Maximum zooming allowed is 400%.

500% is invalid zoom percentage in Excel