MS-Excel | MCQs

Explanation

In the Data ribbon of Microsoft Excel, the feature "PivotTable" cannot be found.

The PivotTable feature is located in the Insert ribbon.

The Data ribbon includes features such as What-If Analysis, Data Validation, and Text to Columns.

Explanation

To select an entire column in MS-EXCEL:

• Click the column heading letter.
• Press CTRL + Space Bar key.

Explanation

The current active cell can be identified as being the one that has a darker black border around it.

Explanation

Formulas are equations that perform calculations on values in your sheet.

All formulas begin with an equal sign (=).

You can create a simple formula by using constant and calculation operators.

For example, the formula =5+2*3, multiplies two numbers and then adds a number to the result.

Explanation

Pie charts

• Pie charts are used to show parts of a whole.

• Specifically, pie charts illustrate meaningful relationships between percentages or parts of 100%.

• If the data that we want to display adds up to 100%, a pie chart is the best choice.

• When creating a pie chart, the description of each section is called the category, and the number connected to the category is called the value.

Explanation

• To protect a worksheet, you can lock cells to prevent changes, formatting, or deletion.
• This is done by using the "Protect Sheet" feature in spreadsheet software like Microsoft Excel or Google Sheets.

Explanation

To zoom an Excel worksheet, you can use:

• The mouse pointer in Print Preview: Click and drag the mouse pointer in the lower right corner of the Print Preview window to zoom in or out.
• The zoom button on the Print Preview toolbar: Click the zoom button (magnifying glass icon) to zoom in or out.
• The zoom command on the View menu: Select View > Zoom > Zoom In/Out or use the shortcuts Ctrl+Plus sign (+) to zoom in or Ctrl+Minus sign (-) to zoom out.

Explanation

Explanation

A pie chart in MS Excel represents only one value for each variable.

It showing parts of a whole as slices of a circle.

It is ideal for visualizing the proportion of different categories within a dataset.

Explanation

A pie chart is best suited for showing the proportion of parts to a whole.

As it visually represents data as slices of a circle.

It highlighting the relative sizes of components.