Worksheet | MCQs

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

From Edit menu choose Move or Copy then select (new book) from To Book list and click OK

Explanation

Data can be transferred between worksheets using linking or referencing formulas.

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

Zoom slider is in the bottom right corner of the Excel window.

To use the Zoom slider, drag the slider to the right or to the left.

To zoom in, drag the slider to the right.

AGM 17-12-2022

Explanation

Rows are the horizontal lines in an Excel spreadsheet.

A row is identified by a number, which appears on the left side of the row.

AGM 24-12-2022

Explanation

Description is the pattern of narrative development that aims to make vivid a place, object, character, or group.

Description is one of four rhetorical modes, along with exposition, argumentation, and narration.

In practice it would be difficult to write literature that drew on just one of the four basic modes.

****

RY17-012-23

Explanation

All elements of a worksheet can be protected from accidental modification.

To protect a worksheet in Excel 2007 and higher versions, click the Review tab, click Protect Worksheet (or Protect Sheet), and click OK.

Excel 2003 and Earlier Versions click Tools > Protection, click Protect Sheet, and click OK.

Explanation

When there is no data in in the adjacent cells, long text flows into adjacent cells on a worksheet.

Explanation

If we need to remove only the formatting done in a range, we must use From Edit menu choose Clear and then Formats.