Excel Functions and Formulas | 3.9K plays

Excel Functions and Formulas

Assessment

•

Greg Baker

•

Computers

•

8th - 12th Grade

•

3K plays

•

Medium

Student preview

20 questions

Show answers

1.

Multiple Choice

30 sec

1 pt

What would be a correct formula for SUM in excel?

=SUM(B3:B9)

=SUMB3+B9

SUM(B3:B9)

=ADD(B3:B9)

2.

Multiple Choice

1 min

1 pt

Which button can you click to add up a series of numbers?

The autosum button

The Formula button

The quicktotal button

The total button

3.

Multiple Choice

30 sec

1 pt

Which formula gets the biggest value of a range of cells?

MAX

MIN

LARGE

SUM

4.

Multiple Choice

1 min

1 pt

Which formula gets the smallest value of a range of cells?

MAX

MIN

SMALL

SUM

5.

Multiple Choice

1 min

1 pt

Which symbol must all formula begin with?

=

+

(

@

Explore all questions with a free account

or continue with

Microsoft

Apple

Others

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

Already have an account?

Find a similar activity

Create activity tailored to your needs using

20 questions

Excel Advanced Formulas

•

8th - 12th Grade

20 questions

Excel Formulas Básicas

•

8th - 12th Grade

20 questions

MS Excel Formulas

•

8th - 12th Grade

20 questions

Excel Functions

•

8th - 12th Grade

20 questions

Excel Intro to Formulas

•

8th - 12th Grade

20 questions

Excel Formulas and Functions

•

8th - 12th Grade

20 questions

Excel Formulas

•

8th - 12th Grade

20 questions

Spreadsheet Formulas

•

8th - 12th Grade