AES Excel 2: Quiz Unit 1-Using Formulas & Functions

AES Excel 2: Quiz Unit 1-Using Formulas & Functions

Assessment

Assessment

Created by

Ms. Wallum

Computers, Business

8th - 12th Grade

105 plays

Medium

Student preview

quiz-placeholder

20 questions

Show answers

1.

Multiple Choice

2 mins

1 pt

Media Image

If you copied D3 to D7, what would be the resulting cell reference in D7?

=D10

=D6

=C10

=C6

2.

Multiple Choice

30 sec

1 pt

Which type of cell references are automatically updated when copied?

Absolute

Formula

Worksheet

Relative

3.

Multiple Choice

1 min

1 pt

Media Image

What formula would you enter in C4 that combines A4 and B4 to get a result like in C2?

“=A4&""&B4” “="A4"&"

"&"B4"”

“=A4& &B4”

“=A4&" "&B4”

4.

Multiple Choice

1 min

1 pt

If C4=15 and C7=14, what is the result of the logical expression C4>C7?

False

True

5.

Multiple Choice

30 sec

1 pt

Media Image

What formula should be entered to calculate the total budget?

=B3*B4*B5*B6

=3B+4B+5B+6B

=3B*4B*5B*6B

=B3+B4+B5+B6

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
Google Sheets Basic Formulas

15 questions

Google Sheets Basic Formulas

assessment

9th - 12th Grade

Google Sheets Functions

15 questions

Google Sheets Functions

assessment

9th - 12th Grade

Excel 2P-2RVW-Formulas and Functions in Excel

19 questions

Excel 2P-2RVW-Formulas and Functions in Excel

assessment

10th - 12th Grade

IGCSE EXCEL Formulas & Functions

20 questions

IGCSE EXCEL Formulas & Functions

assessment

11th Grade

Google Sheets 2 Review

18 questions

Google Sheets 2 Review

assessment

9th - 12th Grade

Using Formulas and Functions- Excel

20 questions

Using Formulas and Functions- Excel

assessment

6th - 8th Grade

Google Sheets 2: Fundamentals : Using Formulas and Functions

15 questions

Google Sheets 2: Fundamentals : Using Formulas and Functions

assessment

9th - 12th Grade

Google Sheets Formulas

15 questions

Google Sheets Formulas

assessment

9th - 12th Grade