Page 8 of 9PREVNEXT

Figure out dates by using formulas in Excel 2010

Test yourself

Complete the following test so you can be sure you understand the material. Your answers are private, and test results are not scored.


8/22/2011 and 22-August-2011 are stored as different serial numbers.

True

False

To get Excel to recognize dates, you must type them in a format Excel recognizes. Which of these dates will Excel store as plain text rather than as a serial number?

June 23, 2012

23-June-12

June 23 2012

Which function would you use to find the date that falls after a number of workdays?

NETWORKDAYS

WORKDAY

TODAY

What do you type to start a formula in Excel?

A function.

Mathematical operators.

An equal sign (=)

How do you separate formula arguments?

With parentheses.

With a space.

With a comma.

Page 8 of 9PREVNEXT