MS Office

In Microsoft Excel, pressing Ctrl+Shift+3 applies the Date format to the selected cells. The other shortcuts apply different number formats.

In Microsoft Excel, pressing 'Alt' and '=' together (Alt+=) automatically inserts the SUM formula for the cells above the current cell. This is a quick shortcut for summing a column of numbers.

In Excel, columns are labeled alphabetically as A, B, C, etc., while rows are labeled numerically. The other options refer to row labels or cell references, not column labels.

In Excel, pressing Ctrl+Shift+2 formats the selected cell(s) as time (h:mm AM/PM). This is the standard keyboard shortcut for applying the time format.

In Microsoft Excel, pressing Ctrl+Shift+4 applies the currency format to the selected cells. The number 4 corresponds to the dollar sign ($) on most keyboards, which is the symbol for currency formatting.

In Microsoft Excel, pressing Shift+F3 opens the Insert Function dialog box, which is commonly referred to as the formula window. This allows users to search for and insert functions into their worksheet.

In Microsoft Excel, the keyboard shortcut Ctrl+Shift+5 formats the selected cells as a percentage. This is a quick way to apply percentage formatting without using the ribbon menu.

Pressing Ctrl+1 in Excel opens the Format Cells dialog box, allowing users to change cell formatting options such as number, alignment, font, and border.

In Microsoft Excel, pressing Ctrl+Space selects the entire column of the active cell. This is a standard keyboard shortcut for column selection.

In Microsoft PowerPoint, the effect that occurs as one slide replaces another during a presentation is called a slide transition. Animations, on the other hand, are effects applied to objects within a slide.