ITDAB C4 17/5

ITDAB C4 17/5

12th Grade

10 Qs

quiz-placeholder

Similar activities

IBDP Organisational Structure

IBDP Organisational Structure

11th - 12th Grade

14 Qs

Business Finance Reviewer

Business Finance Reviewer

12th Grade

15 Qs

Marketing Campaign

Marketing Campaign

9th - 12th Grade

10 Qs

CorporateSocial Responsibility

CorporateSocial Responsibility

10th - 12th Grade

15 Qs

INDUSTRIAL AND CONSUMER PRODUCTS

INDUSTRIAL AND CONSUMER PRODUCTS

12th Grade

10 Qs

Break-even and contribution

Break-even and contribution

11th Grade - University

11 Qs

QUIZ IN FABM 1

QUIZ IN FABM 1

11th - 12th Grade

10 Qs

Cash Book #2

Cash Book #2

12th Grade

10 Qs

ITDAB C4 17/5

ITDAB C4 17/5

Assessment

Quiz

Business

12th Grade

Hard

Created by

SBAMP SBAMP

FREE Resource

AI

Enhance your content

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

What is the syntax for the IF function in Excel?

=IF(logical_test, value_if_true, value_if_true)

=IF(logical_test: value_if_false, value_if_true)

=IF(logical_test; value_if_true; value_if_nil)

=IF(logical_test, value_if_true, value_if_false)

2.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Which function is used to find the difference in number of days/months/years between 2 dates in Excel?

IF Function

OR Function

AND Function

DATEDIF Function

3.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

What does the ISERROR function in Excel check for?

Whether the value is an error

Whether the value is a number

Whether the value is a text

Whether the value is blank

4.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

What does the NOT function in Excel do?

Checks whether the value is blank

Used to invert the results from TRUE to FALSE or vice versa

Checks whether the value is a number

Checks whether the value is an error

5.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Which logical operator in Excel is used when there are more than 1 condition and the result will be TRUE if all stated conditions are fulfilled?

AND

OR

NOT

IS

6.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

What is the purpose of the VLOOKUP function in Excel?

To find the maximum value in a range of cells

To search for a value in the first column of a table array and return a value in the same row from another column

To calculate the average of a range of cells

To count the number of cells that contain numbers

7.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Which Excel function is used to round a number up to the nearest integer?

ROUNDUP

ROUNDDOWN

ROUND

CEILING

Create a free account and access millions of resources

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?