Explanation

Comments that are put in a cell in MS Excel are called Cell tips

**

ND16-1-2023

Explanation

To duplicate values in a cell range in Excel 2016, follow these steps:

• Select the range of cells that you want to duplicate.
• Go to the Home tab in the ribbon.
• Click on the "Fill" handle (the small square at the bottom-right corner of the selection) and drag it down to the range where you want to duplicate the values.
• Alternatively, you can right-click on the selection and choose "Copy" (or press Ctrl+C), then select the range where you want to duplicate the values and right-click and choose "Paste" (or press Ctrl+V).

Explanation

The Name Box normally displays the address of the "active cell" on the worksheet.

Data or Formula of the Current Active Cell can be viewed inside the Cell Contents box of the Excel Formula bar

Explanation

The cell is the basic structural, functional, and biological unit of all known organisms.

Explanation

• Tab key should be pressed continuously while moving a column in MS Excel.
• A tab key is generally used in a document for proper spacing and enhancing readability by adjusting the text in the document.
• It can also be used for moving a cursor across the screen and for indenting a paragraph while the user is working with the document.

Explanation

In MS Excel 2016, you can split the window into two panes using the following steps:

• Go to the "View" tab in the ribbon
• Click on "Window" in the "Window" group
• Select "Split" from the dropdown menu

Alternatively, you can also use the shortcut key:

Alt + W + S

Explanation

Data, sort is used for arranging data in ascending/descending order in MS Excel

 Sort A to Z to perform an ascending sort (A to Z or smallest number to largest).

 Sort Z to A to perform a descending sort (Z to A or largest number to smallest).

***

ND11-12-2022

Explanation

$ sign is used to create an absolute cell reference in MS Excel.

In Excel, an absolute reference is a cell reference in which the column and row coordinates stay constant while copying a formula from one cell to the other.

A dollar symbol ($) is used before the coordinates to correct them.

For instance, $D$2 is an absolute reference to cell D2

Explanation

Excel uses three types of references:

1. Relative
2. Absolute
3. Mixed

These determine how cell references adjust when formulas are copied across cells.

Explanation

A column chart is ideal for comparing the performance of two employees in 2021 because it allows for a side-by-side comparison of their performance metrics, such as sales, productivity, or revenue.

Pie Chart: Shows how different components contribute to a whole.

Dot Chart: Displays a small number of data points.

Column Chart: Compares performance metrics side-by-side.

Line Chart: Shows trends over time.