Explanation

AutoSum is a fast, easy way to add up multiple values in Excel.

You can access the AutoSum command from either the Home tab or the Formulas tab,

but there is a keyboard shortcut that makes it even faster: Alt + =. 

Explanation

The =NOW() function in MS Excel returns the current date and time.
It is updated automatically whenever the worksheet is opened or calculations are performed.

Some other important functions in MS Excel include:

1. =TODAY() - returns the current date (without time)

2. =YEAR() - returns the year from a given date

3. =MONTH() - returns the month from a given date

4. =DAY() - returns the day from a given date

5. =HOUR() - returns the hour from a given time

6. =MINUTE() - returns the minute from a given time

7. =SECOND() - returns the second from a given time

Explanation

In Excel, the function used to perform addition is =SUM().

It calculates the total of the specified numbers or range of cells.

Explanation

In MS Excel, you can use the horizontal and vertical scroll bars to view different rows and columns in a worksheet.

The scroll bars are located on the right side and bottom of the Excel window, respectively.

• The vertical scroll bar allows you to scroll up and down to view different rows.
• The horizontal scroll bar allows you to scroll left and right to view different columns.

Explanation

The Format Painter copies formatting from one place and applies it to another.

Explanation

Explanation

CTRL+SHIFT+ & key are used to apply outline border to the selected cell in MS Excel.

Explanation

As of now, Excel 2021 is the latest standalone version of Microsoft Excel, released alongside Office 2021.

However, Office 365 (now known as Microsoft 365) is continuously updated with new features and improvements.

This making it the most up-to-date version in terms of features.

Explanation

In Excel, a group of cells is known as a Cell Range.

Single cell address like A1,  a cell range using the cell addresses of the first

and last cells in the cell range separated by a colon.

For example, a cell range with cells D1, D2, D3, D4, and D5 would be written as D1:D5

Explanation

A cell can contain 32,767 number of characters.

**** 

 At the same time, the Formula bar can show all 32,767 symbols.

The maximum length of a formula is 8,192 characters in Excel 2007

RY19012023