Explanation

• Referencing means referring to or retrieving data from another cell or worksheet.
• In Excel, a reference to another sheet can be written as =Sheet2!A1.
• This allows data from one worksheet to be used in another worksheet.
• It is especially useful for linking related data across multiple sheets.

There are Three types of Cell reference in Excel.

1. Relative
2. Absolute
3. Mixed

Last verified on 26-08-2026

Explanation

• “Monthly Wages” and “Final Approval Rating” are descriptive text entries.
• In a spreadsheet, such text is called a Label.
• Labels are used to identify or describe data in cells.

Additional information:

• A value is usually a number.
• A formula performs a calculation.

Last verified on 25-08-2026

Explanation

• Microsoft Excel is the spreadsheet program in the Microsoft Office Suite.
• It is used for calculations, data entry, analysis, tables, and charts.
• Excel organizes data into rows and columns.
• It supports formulas and functions for performing calculations.

Last verified on 25-08-2026

Explanation

• The Excel SORT function has 4 arguments in its full syntax.
• Syntax: SORT(array, [sort_index], [sort_order], [by_col])
• Only the array argument is required.
• The other three arguments are optional.

Last verified on 25-08-2026

Explanation

• Ctrl + 1 opens the Format Cells dialog box in MS Excel.
• It provides options for Number, Alignment, Font, Border, Fill, and Protection.
• It is a useful shortcut for quickly formatting selected cells.

Additional information:

• Ctrl + 5 — Strikethrough
• Ctrl + 6 — Show/Hide objects
• Ctrl + F10 — Maximize/restore active window

Last verified on 25-08-2026

Explanation

• CAD Chart is not a standard MS Excel chart type.
• Bar Chart is a standard Excel chart type.
• Waterfall Chart is also available in modern versions of Excel.
• Scatter Chart is a standard Excel chart type.

Last verified on 24-08-2026

Explanation

• AVERAGE is the built-in Excel function used to calculate the arithmetic mean.
• It adds the values and divides their sum by the number of values.
• Example: =AVERAGE(A1:A5) calculates the average of cells A1 through A5.

Last verified on 24-08-2026

Explanation

• The SUM function adds all numerical values in a specified range.
• =SUM(A1:A5) adds the values in cells A1, A2, A3, A4, and A5.

Additional information:

• SUM — Calculates total
• AVERAGE — Calculates average
• MAX — Finds maximum value
• MIN — Finds minimum value
• COUNT — Counts numerical cells

Last verified on 24-08-2026

Explanation

• To add the values in A1 and A2, enter =A1+A2.
• In Excel, the plus (+) operator is used to add values from cells.
• Excel calculates the result automatically.
• The SUM function can also be used: =SUM(A1,A2).

Last verified on 24-08-2026

Explanation

• To add a new row, right-click the row number where you want the new row.
• Select Insert from the context menu.
• Excel inserts a new row above the selected row.
• You can also use Home → Insert → Insert Sheet Rows.

Last verified on 24-08-2026