Practice Using Formulas And Functions (3.2.1) - Information and Communication

Practise this section

11 questions

Flashcard drill
4 cards from this section. Quick, good the night before a test.
Exercise
6 questions · about 4 min · pass mark 70%. Hints available.
Sign up to start the exercise
Quiz
5 questions · about 3 min · pass mark 70%. Hints available.
Sign up to start the quiz

6 sample questions

Question 1.
What does the SUM function do?
Show hintHide hint
Think about its role in calculations.
Question 2.
Explain the function of the NOW() function.
Show hintHide hint
Consider how this might be useful in tracking changes.
3Question 3.
What does the COUNT function do?
- Counts number of cells with numbers
- Calculates average
- If false
- produces a result
Show hintHide hint
Think about its name—what does it imply?
4Question 4.
True or False: The ROUND function can only round numbers up.
- True
- False
Show hintHide hint
Consider how rounding affects a number.
Question 5.
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.
Show hintHide hint
Break it down into parts: calculate average first, then decide.
Question 6.
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.
Show hintHide hint
Focus on breaking the problem into checking the month difference.

7 more questions in this section. Enroll free to practise them all.