Explanation

• Pressing F2 allows you to edit the contents or formula of the current cell in MS Excel.

Additional information:

• F4: Repeat last action / toggle absolute and relative references
• CTRL + 1: Opens Format Cells dialog
• CTRL + F: Opens Find dialog
• Works in: Excel 2007, 2010, 2013, 2016, 2019, 365

Last verified on 12-03-2026

Explanation

• In MS Excel, to sum values in a range based on a condition, the SUMIF() function is used.
• It allows you to add only the numbers that meet a specific criterion, such as all sales above 1000 or only a certain category.
• This is different from SUM(), which adds all numbers in a range without any condition.

Last verified on 11-03-2026

Explanation

• In MS Excel, a pre-programmed formula is called a Function.
• Functions perform specific calculations or tasks automatically, such as SUM, AVERAGE, or IF.
• They save time by automating repetitive formulas and reducing errors.

Last verified on 11-03-2026

Explanation

• In MS Excel, different functions are used to handle dates and times.
• To display the current date and time, the NOW() function is used.

Additional information:

• DATE() – Returns a date based on year, month, and day
• TODAY() – Returns today’s date only
• TIME() – Constructs a specific time from hours, minutes, and seconds

Last verified on 11-03-2026

Explanation

• In MS Excel 2016, the UPPER() function is used to convert text to uppercase letters.
• It changes all lowercase characters in a cell to capital letters.

Additional information:

• LOWER() – Converts text to lowercase
• PROPER() – Capitalizes the first letter of each word

Last verified on 11-03-2026