Test: Excel Functions- 2 - Primary 6 MCQ

AutoFill feature of Excel is a great time saver. This command can automatically extend the sequence, adds range of cell values, applies a boarder around the selected cells.

Office 365, always receive updates to the latest version of Office.

1. Efficiency:

• Refers to the ability of a worksheet to accomplish its purpose in an efficient and time-saving manner.


• Includes factors like minimizing manual calculations, automating repetitive tasks, and using formulas and functions effectively.


• Ensures that users can quickly and easily access and analyze data.

2. Editability:

• Refers to the ease with which a worksheet can be modified or updated.


• Allows users to make changes or add new data without disrupting the overall structure or functionality of the worksheet.


• Includes features like clear labeling, data validation, and protection of important cells or formulas.

3. Clarity:

• Refers to the readability and comprehensibility of the worksheet.


• Ensures that information is presented in a clear and organized manner.


• Includes factors like using appropriate fonts, colors, and formatting, as well as providing clear headings and labels.

4. Description:

• This is not a worksheet design criterion.


• It does not directly relate to the design and functionality of a worksheet.


• However, providing a brief description or title for the worksheet can help users understand its purpose or content.

To delete an embedded objects, first select it and then press the delete key.

Documentation should include Source of input data Destination and users of the output data Information on the purpose of the workbook.

Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button in Excel 2003 and earlier version.

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.

Double clicking the cell to edit it in-place

For inserting a blank embedded excel object in a word document we can click the object command on the insert menu.

Pressing the Esc key while editing a cell aborts the operation and leaves the cell in it’s original state.