Describe how dates are calculated using serial values.
What will be an ideal response?
When you enter a date in a worksheet cell, the date appears in a familiar format (such as May 20, 2016), but it is actually stored as a serial value. A serial value is a number in a sequential series of numbers. Date serial values represent the number of days since January 1, 1900. Dates are stored as serial values so they can be used in calculations. This is useful to know if you remove formatting from a cell previously formatted as a date, or apply the General format to a cell containing a date. Instead of displaying the date, Excel displays the serial value that represents that date. To make the cell contents recognizable again, right-click the cell, click Format Cells to open the Format Cells dialog box, click Date in the Category list, choose a date format in the Type list, then click OK.
You might also like to view...
In scientific notation, the number of ____ digits determines the position, while the number of digits in the scale factor determines the range of magnitudes.
A. floating B. significant C. indexed D. encapsulated
How can you preserve the comments in a Word document when you save
it as a PDF file? What will be an ideal response?
The Premiere Products database includes four tables.
Answer the following statement true (T) or false (F)
If the increment operator is __________ to a variable, first the variable is incremented by 1, then its new value is used in the expression.
Fill in the blank(s) with the appropriate word(s).