Excel

Excel

9th Grade

10 Qs

quiz-placeholder

Similar activities

Basic Excel

Basic Excel

5th - 12th Grade

10 Qs

Excel 3 - Funzioni

Excel 3 - Funzioni

8th - 10th Grade

10 Qs

Uji Pemahaman Fungsi Excel

Uji Pemahaman Fungsi Excel

9th Grade

13 Qs

Excel 1

Excel 1

5th - 10th Grade

10 Qs

Recuperación TIC 4º ESO - 2ªEvaluación

Recuperación TIC 4º ESO - 2ªEvaluación

9th - 10th Grade

10 Qs

Intro to Spreadsheets

Intro to Spreadsheets

9th - 10th Grade

15 Qs

Modulo Excel

Modulo Excel

9th Grade

11 Qs

Excel Wochenquiz KW 22

Excel Wochenquiz KW 22

9th Grade

15 Qs

Excel

Excel

Assessment

Quiz

Computers

9th Grade

Medium

Created by

Marvin Mangali

Used 10+ times

FREE Resource

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which symbol is used for addition in Excel formulas?

/

*

+

-

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If cell A1 contains 10 and cell B1 contains 5, what formula would you use to subtract B1 from A1?

=A1-B1

=B1-A1

=A1+B1

=A1*B1

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How would you write a formula to multiply the values in cells C1 and D1?

=C1+D1

=C1/D1

=C1*D1

=C1-D1

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What formula is used to divide the value in cell E1 by the value in cell F1?

=E1/F1

=E1*F1

=E1+F1

=E1-F1

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function would you use to find the largest number in a range of cells?

=MAX(range)

=MIN(range)

=SUM(range)

=LARGE(range)

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the formula =MIN(A1:A10) return?

The largest value in the range

The average value of the range A1 to A10.

The smallest value in the range A1 to A10.

The total sum of the range A1 to A10.

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If you want to calculate the average of numbers in cells A1 through A5, which formula should you use?

=AVERAGE(A1:A5)

=SUM(A1:A5)/COUNT(A1:A5)

Both a and b

None of the above

Create a free account and access millions of resources

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

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

Already have an account?