Course Content

  • Formulas With Solution(3)

Course Content


  • Open a Google Sheets spreadsheet on your PC.
  • Choose the cells to which you want to apply format rules.
  • Select Format from the Format menu. Formatting that is conditional.
  • Make a rule for yourself. a single hue: Choose the circumstance that will cause the rule to be
  • triggered under "Format cells if."
  • After that, click Done.

Conditional functions only execute calculations on a cell or range of cells if they fulfil a set of criteria. Before continuing, these functions examine a given range and determine whether the condition is true or false.

The DATE function generates a serial number that matches an Excel date. The year 1900 is the start of the Excel date range. Excel will add 1900 if the year is between zero and 1900. The DATE function only accepts numeric input and returns #VALUE if text is provided.

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere