PSC

PSC Exam Support Nepal

How do you display updatable current date in MS Excel?

Introduction - Insert the current date and time in a Excel cell
Embed a static date or time into an Excel cell: 
A static incentive in a worksheet is one that doesn't change when the worksheet is recalculated or opened. When you press a key mix, for example, Ctrl+; to embed the present date in a cell, Excel "takes a depiction" of the present date and after that embeds the date in the cell. Since that cell's esteem doesn't change, it's viewed as static. 

Embed a date or time whose esteem is refreshed: 
A date or time that updates when the worksheet is recalculated or the exercise manual is opened is viewed as "dynamic" rather than static. In a worksheet, the most widely recognized approach to restore a dynamic date or time in a cell is by utilizing a worksheet work. 


Answer: Right Answer is Option (B)


No comments:

Post a Comment

Popular

Recent

Comments