What-If Analysis, Charting, And Working With Large Worksheets Page 24
ADVERTISEMENT
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87EX 160
Excel Chapter 3
What-If Analysis, Charting, and Working with Large Worksheets
1
•
Select cell I11 and
then click the Insert
Function box in the
Insert Function
formula bar to display
dialog box
the Insert Function
dialog box.
Or select a category
box arrow
•
Click the ‘Or select a
category’ box arrow
Insert Function box
inserts equal sign
(Insert Function dialog
in active cell and in
box) and then select
formula bar
Date & Time in the
Date & Time
list to populate the
category
‘Select a function’ list
NOW function
with data and time
selected
functions.
description of
selected function
•
Scroll down in the
‘Select a function list’
and then click
NOW to select the
required function
OK button
(Figure 3 – 21).
Figure 3 – 21
2
•
Click the OK button
(Insert Function dialog
box) to close the
Insert Function dialog
cell I11 assigned
system date
system time
box and display the
NOW function
Function Arguments
dialog box.
•
Click the OK button
(Function Arguments
dialog box) to display
the system date and
time in the selected
cell, using the default
shortcut menu
date and time format
mm/dd/yyyy hh:mm.
•
Right-click cell I11
Format Cells
to display a shortcut
command
menu and Mini
toolbar (Figure 3 –22).
Why does the date
appear with the
Figure 3 – 22
mm/dd/yyyy hh:mm
format?
Excel automatically formats the result of the NOW function as a date, using the date and
time format, mm/dd/yyyy hh:mm, where the fi rst mm is the month, dd is the day of the
month, yyyy is the year, hh is the hour of the day, and mm is the minutes past the hour.
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education