Microsoft Excel Question:

Download Job Interview Questions and Answers PDF

How can I enter the current date into a cell so it does not change from day to day? When I use the NOW function, it always shows the current date?

MS Excel Interview Question
MS Excel Interview Question

Answer:

The easiest way to enter the current date into a cell is to use the Ctrl-; key combination (press the Ctrl key and type a semicolon). Similarly, you can enter the current time by pressing Ctrl-Shift-; (press the Ctrl and Shift keys and type a semicolon). Both of these key combinations enter the information as a volatile value, not as a formula.

Download MS Excel Interview Questions And Answers PDF

Previous QuestionNext Question
How can I print a workbooks full path in the header or footer? The Page Setup dialog box does not seem to offer the option.?I need to determine the difference between two times. If the difference is positive, it works fine. But Excel does not want to display negative time values. Why not?