Microsoft Excel Calculation

Microsoft Excel Calculation

Assessment

Flashcard

Computers

10th Grade

Practice Problem

Hard

Created by

Wayground Content

FREE Resource

Student preview

quiz-placeholder

20 questions

Show all answers

1.

FLASHCARD QUESTION

Front

What is the basic formula to add two cells in Excel?

Back

=A1+B1

2.

FLASHCARD QUESTION

Front

What function is used to find the average of a range of cells in Excel?

Back

AVERAGE

3.

FLASHCARD QUESTION

Front

What is the operator used for multiplication in Excel?

Back

*

4.

FLASHCARD QUESTION

Front

What is the formula to subtract the value in cell B1 from the value in cell A1?

Back

=A1-B1

5.

FLASHCARD QUESTION

Front

What is the purpose of using the SUM function in Excel?

Back

To add up the values in a range of cells.

6.

FLASHCARD QUESTION

Front

the largest number =MAX(the first cell address:then the second cell address) For Example: =MAX(C1:C33)

Back

Maximum 

7.

FLASHCARD QUESTION

Front

Tells excel to include all the cells between the two endpoints. A1:D1

Back

Colon

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?