Practice Using Formulas and Functions - 3.2.1 | 3. Information and Communication | CBSE Class 12th AI (Artificial Intelligence)
K12 Students

Academics

AI-Powered learning for Grades 8–12, aligned with major Indian and international curricula.

Professionals

Professional Courses

Industry-relevant training in Business, Technology, and Design to help professionals and graduates upskill for real-world careers.

Games

Interactive Games

Fun, engaging games to boost memory, math fluency, typing speed, and English skills—perfect for learners of all ages.

Practice Questions

Test your understanding with targeted questions related to the topic.

Question 1

Easy

What does the SUM function do?

💡 Hint: Think about its role in calculations.

Question 2

Easy

Explain the function of the NOW() function.

💡 Hint: Consider how this might be useful in tracking changes.

Practice 4 more questions and get performance evaluation

Interactive Quizzes

Engage in quick quizzes to reinforce what you've learned and check your comprehension.

Question 1

What does the COUNT function do?

  • Counts number of cells with numbers
  • Calculates average
  • If false
  • produces a result

💡 Hint: Think about its name—what does it imply?

Question 2

True or False: The ROUND function can only round numbers up.

  • True
  • False

💡 Hint: Consider how rounding affects a number.

Solve 3 more questions and get performance evaluation

Challenge Problems

Push your limits with challenges.

Question 1

Create a spreadsheet that calculates the final grade of students based on scores in three categories: assignments, midterms, and finals. Use IF to determine pass/fail based on the average.

💡 Hint: Break it down into parts: calculate average first, then decide.

Question 2

Use DATEDIF to find out how many months have passed since a specific date in A1 and return a message indicating if it’s more than 6 months.

💡 Hint: Focus on breaking the problem into checking the month difference.

Challenge and get performance evaluation