Explanation

In Excel, a small square in the lower-right corner of a selected cell is called the fill handle.

It is used to quickly copy or fill data into adjacent cells by dragging the fill handle.

Explanation

=SUM(A1:A5)/(10-10) is not calculated in excel because 10-10 is zero so something divided by zero is not defined in the excel function.

***

ND18-1-2023

****

RY17-012-23

Explanation

• The title bar in MS Excel displays the name of the workbook
• ***
• in the Excel program.
• Click the File tab.
• Click Open.
• Press Ctrl + O to quickly display the Open tab of the Backstage view.
  
  

Explanation

A PivotTable helps you calculate, summarize, and analyze data efficiently.

It lets you spot comparisons, patterns, and trends within large datasets.

Explanation

The purpose of the TRANSPOSE function in Excel is to convert rows to columns,

i.e. switch the orientation of a given range from horizontal to vertical or vice versa.

The function takes just one argument:

TRANSPOSE(array)

Where array is the range of cells to transpose.

Explanation

Transpose (rotate) data from rows to columns or vice versa.

To use options from the Paste Special box, click Home > Paste > Paste Special > Transpose

Explanation

•  In a computer spreadsheet, a function that is used to count a number of entries in a given range is called length
• ***
• COUNTA: To count cells that are not empty.
• COUNT: To count cells that contain numbers.
• COUNTBLANK: To count cells that are blank.
• COUNTIF: To count cells that meet specified criteria.

Explanation

On the Home tab, in the Alignment group, click Wrap Text.

Notes: Data in the cell wraps to fit the column width, so if you change the column width, data wrapping adjusts automatically.

Explanation

Conditional Formatting highlights data based on rules, making patterns easy to spot.

It provides visual cues like colors or icons to quickly understand data trends.

Explanation

Transpose (rotate) data from rows to columns or vice versa.

To use options from the Paste Special box, click Home > Paste > Paste Special > Transpose

Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK