MS | MCQs

Explanation

Paste Special feature helps US to inserts the contents of the Clipboard as text without any formatting. 

Explanation

A Workbook is a group of Worksheets.

A workbook is a file that contains one or more worksheets to help you organize data.

A workbook initially contains three worksheets, which are saved in a single file. 

1. Sheet1

2. Sheet2

3. Sheet3

Explanation

A trendline is added to a chart to show patterns or trends in the data.

It helps in analyzing data over time or predicting future values.

Explanation

The Wrap feature allows text to appear on multiple lines within a single Excel cell.

It improves readability without expanding the cell width.

Explanation

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