Excel(Task2,Functions (1,2)

Excel(Task2,Functions (1,2)

12th Grade

24 Qs

quiz-placeholder

Similar activities

Recusion

Recusion

12th Grade

19 Qs

Power Tools Student Test PLTW

Power Tools Student Test PLTW

7th Grade - Professional Development

20 Qs

Arduino_Quiz

Arduino_Quiz

12th Grade

20 Qs

Computer parts

Computer parts

1st - 12th Grade

20 Qs

History of the computer

History of the computer

12th Grade

20 Qs

Django-quiz

Django-quiz

5th Grade - University

20 Qs

Sun lit

Sun lit

1st Grade - University

20 Qs

QUIZ 3 SAM

QUIZ 3 SAM

12th Grade

20 Qs

Excel(Task2,Functions (1,2)

Excel(Task2,Functions (1,2)

Assessment

Quiz

Computers

12th Grade

Practice Problem

Hard

Created by

Yousra Abdelhamed

Used 3+ times

FREE Resource

AI

Enhance your content in a minute

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

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)

Access all questions and much more by creating a free account

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

Already have an account?