Explanation

Formula palette is used to create and edit formula.

It is also possible to type a function directly into a cell.

Explanation

 Columns are denoted and identified by a unique alphabetical header letter, which is located at the top of the worksheet.

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.

Explanation

 Columns are denoted and identified by a unique alphabetical header letter, which is located at the top of the worksheet.

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

The formula evaluates as:

(7-3)×(4+3)/4 = 4×7/4 = 28/4 = 7.

Explanation

When we open a new workbook in MS Excel, the Title bar appears on the topmost portion of the screen.

It displays the name of the open document.

Explanation

The cell margin is the distance between the cell border

Cell contents and is specified for all four sides of a cell

How to Change Margins in Excel?

Click on Page layout tab.

Explanation

In Excel, formulas must begin with an equals sign (=).

Options A, B, and C are all valid formulas.

Option D (C1+15) is not a valid formula because it lacks the = sign.

Explanation

The "Edit, Clear" command in spreadsheet software (like Microsoft Excel) allows you to remove different elements from selected cells, such as:

• Contents (values/data)

• Formats (cell formatting)

• Comments/Notes

However, it does not delete the cells themselves—it only clears their contents or attributes.