CUETMOCK
  • Pricing
  • Mentors
Log inStart freeStart free mocks→

First test, then trust

Try a free CUET mock test.

Join 5,00,000+ students who rehearsed exam day on the exact NTA screen before sitting CUET. On the web and on Android.

Start free mocks →Get the Android app
CUETMOCK

India's #1 CUET Mock Test Platform. Original NCERT-based questions on the exact NTA exam screen — trusted by 5,00,000+ students since CUET 2022.

Get it onGoogle PlayScan to download the CUETMOCK app

Mock tests

  • CUET mock test series
  • Browse all papers
  • Commerce mocks
  • Humanities (Arts) mocks
  • Science mocks
  • Languages & GAT mocks
  • Free practice questions
  • Pricing

Resources

  • CUET exam guide
  • CUET syllabus
  • Universities accepting CUET
  • Expert blogs
  • News & notifications
  • Webinars & counselling
  • CUET score calculator
  • How we estimate your rank
  • FAQs

Company

  • About us
  • Our leadership & team
  • Our toppers
  • Mentors
  • For schools
  • Contact us
  • Terms
  • Privacy
  • Refund policy

Talk to us

+91 7696 6630 56info@cuetmock.comWhatsApp us

Our other platforms

  • JEE Mock — For IIT-JEE aspirants
  • NEET Mock — For NEET aspirants

Newsletter

Exam updates, study material and offers — no spam.

© 2026 NYC Ventures Pvt. Ltd.

701-702, Royal Business Park, Zirakpur, Punjab - 140603

  • Terms of use
  • Privacy policy
  • Refund policy
  • Contact us

iCUETMOCK is an independent preparation platform, not affiliated with the National Testing Agency (NTA). Always check exam details on the official NTA website.

  • Home
  • Mock tests
  • CUET guide
  • Pricing
  • Log in
Home/Practice questions/Accountancy Part C
Accountancy Part CSpreadsheet

Which category in the Formula tab includes functions like TODAY(), NO…

Which category in the Formula tab includes functions like TODAY(), NOW(), etc.?

Answer & explanation+

Correct answer: option 3

The correct answer is option 3- Date and Time Function.

Date and Time Function category in the Formula tab includes functions like TODAY(), NOW(), etc.

 

Date and Time Function

1. TODAY () is the function for today’s date in the blank worksheet. TODAY – Returns the serial number of the current date. The serial number is the date-time code used by Excel for date and time calculations. Times are represented as fractions of a day. By default January 1, 1900 is serial number 1. Thus, January 1, 2009 is serial number 39814 (because it is 39814 days after January 1, 1900).

2. NOW () is similar function but it includes the current time also.

3. DAY(serial_number) function returns the day of a date as an integer ranging from1 to 31. For example, if A5 = 16-Apr-2009 then = DAY (A2) will be 16. Similarly, two other functions MONTH (serial_number) returns month of a date as an integer ranging from 1 (January) to 12 (December) and YEAR (serial_number) returns the year corresponding to a date as an integer ranging from 1900 – 9999.

4. DATEVALUE (date_text) converts a date in the form of text to a serial number e.g. = DATEVALUE(“16-04-2009”) will return a value 39919.

Advertisement

Practise more on Spreadsheet

Chapter-wise mocks on the real NTA exam screen, with solutions and your rank. Your first mocks are free.

Start free mocks →

Advertisement

Next questions

  1. The mixture of two colours Blue and Yellow creates:Fine Arts · The Living Art Traditions of India
  2. Which of the following has become the first state in the country to get the L-root server?General Aptitude Test · General Knowledge
  3. Which of the following letter-clusters will replace the question mark (?) and complete the following letter-cluster series? DW, FU, GT, IR,…General Aptitude Test · General Ability
  4. An electron moving along the x axis has a position given by x = 20t e^–t m, where t is in second. How far is the electron from the origin w…Physics · Motion in a straight Line
  5. Which of the following statements is correct? Statement 1: The North Indian Plains, deltas and Coastal Plains have higher proportion of pop…Geography · India-People and Economy: Population-Distribution,Density, Growth and Composition
  6. Who among the following was the main artist and creator of the journal "Indian Society of Oriental Art".Fine Arts · The Bengal School and Cultural Nationalism
  7. Find the value of p for which the points (-2, 5), (-5, -10) and (p, -13) are collinear.General Aptitude Test · Quantitative Reasoning
  8. Johnson & Johnson has pushed decision making down to its many smaller companies. Even so, decisions that affect the whole group are still t…Business Studies · Organising
  9. Which among the following is not a component of nucleotide? (Question 3)Biology · Molecular Basis of Inheritance
  10. United Nations has declared 2024 as the ________________.General Aptitude Test · Current Affairs