Advanced Functions in Spreadsheets (Grade 12 NSC Matric Computer Application Technology): Quizzes
📚Quizzes
Practise the questions
10 questions from this quiz
ShowHide
Practise the questions
10 questions from this quiz
How does Excel store dates internally?
How does Excel store dates internally?
As numbers representing days since 1 Jan 1900
How does Excel represent times internally?
How does Excel represent times internally?
As decimal values (fractions of a day)
What decimal value represents 12:00 PM (noon) in Excel?
What decimal value represents 12:00 PM (noon) in Excel?
0.5
What is the key difference between TODAY() and NOW() functions?
What is the key difference between TODAY() and NOW() functions?
NOW() shows date and time; TODAY() only date
What is the correct argument order for the DAYS() function?
What is the correct argument order for the DAYS() function?
=DAYS(end_date, start_date)
What divisor is used to convert age from days to years?
What divisor is used to convert age from days to years?
365.25
Which formula calculates the quarter of the year from a date?
Which formula calculates the quarter of the year from a date?
=ROUNDUP(MONTH(date)/3,0)
What range does the MONTH() function return?
What range does the MONTH() function return?
1 to 12
To convert a time difference to hours, what should you multiply by?
To convert a time difference to hours, what should you multiply by?
24
To convert a time difference to minutes, multiply by what value?
To convert a time difference to minutes, multiply by what value?
1440