Excel(Task2,Functions (1,2)

Excel(Task2,Functions (1,2)

12th Grade

24 Qs

quiz-placeholder

Similar activities

EXA_COMPUTACION _II_1_PARCIAL MERCA 4° Y TURISMO 2°_2025

EXA_COMPUTACION _II_1_PARCIAL MERCA 4° Y TURISMO 2°_2025

1st Grade - University

20 Qs

Tin 4 - Ôn Tập HK1

Tin 4 - Ôn Tập HK1

1st Grade - University

19 Qs

Questionário Introdutório de Excel

Questionário Introdutório de Excel

12th Grade

20 Qs

Google Sheets: Functions and Behavior Check-Up

Google Sheets: Functions and Behavior Check-Up

12th Grade - University

20 Qs

Google Sheets Review

Google Sheets Review

KG - University

20 Qs

Spreadsheet

Spreadsheet

9th Grade - Professional Development

21 Qs

TIN HỌC 7

TIN HỌC 7

9th Grade - University

22 Qs

Spreadsheet Formulas and Functions

Spreadsheet Formulas and Functions

9th - 12th Grade

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?

Discover more resources for Computers