Excel(Task2,Functions (1,2)

Excel(Task2,Functions (1,2)

12th Grade

24 Qs

quiz-placeholder

Similar activities

Tin học 7 Excel

Tin học 7 Excel

7th - 12th Grade

20 Qs

Google Sheets Review

Google Sheets Review

KG - University

20 Qs

Latihan soal PAT SIMKOMDIG

Latihan soal PAT SIMKOMDIG

8th - 12th Grade

25 Qs

grade 5- spreadsheet for a purpose review

grade 5- spreadsheet for a purpose review

3rd - 12th Grade

27 Qs

Tin 4 - Ôn Tập HK1

Tin 4 - Ôn Tập HK1

1st Grade - University

19 Qs

Excel - Listas desplegables/Concatenar/BuscarV

Excel - Listas desplegables/Concatenar/BuscarV

6th - 12th Grade

20 Qs

Google Sheets

Google Sheets

8th Grade - University

20 Qs

Excel Formula

Excel Formula

4th Grade - Professional Development

20 Qs

Excel(Task2,Functions (1,2)

Excel(Task2,Functions (1,2)

Assessment

Quiz

Computers

12th Grade

Hard

Created by

Yousra Abdelhamed

Used 3+ times

FREE Resource

24 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Media Image

Someone is trying to find the average profit amount between January and July, using the formula in cell B9.

What mistake did this person make?

Using parentheses in the formula

 

Using an incorrect formula

  The location of the equals sign

Using the incorrect range

2.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Media Image

What is the formula in cell B3 doing?

Subtracting inventory costs from the total budget  

Subtracting the total budget from inventory costs

Finding the average budget total

Multiplying inventory costs by the total budget

3.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Media Image

In this example, what information would this formula find:

=MAX(B2:B6)

  Average distance

Longest distance

Total distance

Shortest distance

4.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Media Image

In this example, what's wrong with the formula in cell B5?

It should use division instead of multiplication.

   

  It should use subtraction instead of addition.

Without parentheses, multiplication is performed too early.

Nothing. This formula is correct.

5.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Media Image

Select the formula that will subtract the inventory costs from the monthly budget.

=B3/B2

=B3-B2

=B3*B2

=B2-B3

6.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Media Image

Which formula will subtract the inventory costs from the annual budget and then divide by 12?

=(B2-B1)/12

    

=(B1-B2)/12

=B2-B1/12

=B2-(B1/12)

7.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Media Image

Which formula would find the fastest time for this running log?

=AVERAGE(B2:B6)

=SUM(B2:B6)

=MIN(B2:B6)

=MAX(B2:B6)

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?