Excel Functions and Formulas

Excel Functions and Formulas

Assessment

Assessment

Created by

Greg Baker

Computers

8th - 12th Grade

3K plays

Medium

Student preview

quiz-placeholder

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

Quizizz AI
Excel Formulas Básicas

20 questions

Excel Formulas Básicas

assessment

8th - 12th Grade

MS Excel Formulas

20 questions

MS Excel Formulas

assessment

8th - 12th Grade

Excel Functions

20 questions

Excel Functions

assessment

8th - 12th Grade

Excel Intro to Formulas

20 questions

Excel Intro to Formulas

assessment

8th - 12th Grade

Excel Formulas and Functions

20 questions

Excel Formulas and Functions

assessment

8th - 12th Grade

Excel Formulas

20 questions

Excel Formulas

assessment

8th - 12th Grade

Spreadsheet Formulas

20 questions

Spreadsheet Formulas

assessment

8th - 12th Grade

Excel Advanced Formulas

20 questions

Excel Advanced Formulas

assessment

8th - 12th Grade