What is the difference between the TODAY() and NOW() functions? Why is this difference important?
What will be an ideal response?
The TODAY() function uses the computers system clock to insert the current date into a cell in the worksheet. The NOW() function uses the computers system clock to insert the current date and time into the worksheet. Since dates are stored in Excel as a serial number that counts the number of days since 1/1/1900, time is calculated as a fraction of that serial number. When comparing dates in Excel, it is important to consider the effect of time in any calculations.
You might also like to view...
As with other popular mobile operating systems, Android is designed for ____________________ processors.
Fill in the blank(s) with the appropriate word(s).
To divide the value of the seventh element of array a by 2 and assign the result to the variable x, we would write ________.
a. ``` x / 2 = a( 7 ) ``` b. ``` x = a[ 7 ] / 2 ``` c. ``` x = a[ 6 ] / 2 ``` d. ``` x = a( 6 / 2 ) ```
The results of doing a Find are displayed in the ________
A) Review Pane B) Navigation Pane C) Locate Pane D) Find Pane
By default, PivotTables display aggregated data for each category
Indicate whether the statement is true or false