Question

To display the current date in the selected cell, __________ function is used​

Answer 1

Answer:

A static value in a worksheet is one that doesn't change when the worksheet is recalculated or opened. When you press a key combination such as Ctrl+; to insert the current date in a cell, Excel “takes a snapshot” of the current date and then inserts the date in the cell.