WAEC and NECO CBT App for Mobile Devices - Candidates, Schools, Centres, Resellers - 100% Offline -Download Now
Your School's Whatsapp Group - Join Us now

If today's date is 02/02/2008, what will be the result of typing "=today() - 1"...

Computer Studies
WAEC 2023

If today's date is 02/02/2008, what will be the result of typing "=today() - 1" in a cell of a spreadsheet?

  • A. 02/01/2008
  • B. 01/02/2009
  • C. 01/02/2008
  • D. 02/02/2007
Your School's Whatsapp Group - Join Us now
WAEC and NECO CBT App for Mobile Devices - Candidates, Schools, Centres, Resellers - 100% Offline -Download Now
Post UTME Past Questions Agent
Correct Answer: Option A
Explanation

If today's date is 02/02/2008, the result of typing "=today() - 1" in a cell of a spreadsheet will be "02/01/2008".

The today() function in Excel returns the current date. The - 1 operator subtracts one from the result of the today() function. Therefore, the expression =today() - 1 will return the date that is one day before the current date.

In this case, the current date is 02/02/2008. Subtracting one from this date gives us 02/01/2008.

NB: By default, Excel uses the mm/dd/yyyy format for dates. This means that the month is represented by the first two digits, the day is represented by the third digit, and the year is represented by the last four digits. The date format in Excel can be customized to suit your needs.

However, you can change the date format to something else if you prefer. For example, you could change the date format to dd/mm/yyyy, which would represent the day, month, and year in that order.


Report an Error Ask A Question Download App
Your School's Whatsapp Group - Join Us now
WAEC and NECO CBT Software for Computers and Laptops - Candidates, Schools, Centres, Resellers - 100% Offline -Download Now
Post-UTME Past Questions - Original materials are available here - Download PDF for your school of choice + 1 year SMS alerts

Contributions ({{ comment_count }})

Please wait...

{{ settings.no_comment_msg ? settings.no_comment_msg : 'There are no comments' }}

Quick Questions

Post your Contribution

Please don't post or ask to join a "Group" or "Whatsapp Group" as a comment. It will be deleted. To join or start a group, please click here

{{ quote.posted_by.display_name }}
{{ settings.form_textarea_description }}
 
WAEC and NECO CBT Software for Computers and Laptops - Candidates, Schools, Centres, Resellers - 100% Offline -Download Now
Post-UTME Past Questions - Original materials are available here - Download PDF for your school of choice + 1 year SMS alerts
Post UTME Past Questions Agent
Your School's Whatsapp Group - Join Us now
WAEC and NECO CBT App for Mobile Devices - Candidates, Schools, Centres, Resellers - 100% Offline -Download Now
WAEC and NECO CBT Software for Computers and Laptops - Candidates, Schools, Centres, Resellers - 100% Offline -Download Now
Your School's Whatsapp Group - Join Us now
Post-UTME Past Questions - Original materials are available here - Download PDF for your school of choice + 1 year SMS alerts
WAEC and NECO CBT App for Mobile Devices - Candidates, Schools, Centres, Resellers - 100% Offline -Download Now