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

Assessment
•
Ms. Wallum
•
Computers, Business
•
8th - 12th Grade
•
105 plays
•
Medium
Student preview

20 questions
Show answers
1.
Multiple Choice
If you copied D3 to D7, what would be the resulting cell reference in D7?
=D10
=D6
=C10
=C6
2.
Multiple Choice
Which type of cell references are automatically updated when copied?
Absolute
Formula
Worksheet
Relative
3.
Multiple Choice
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
If C4=15 and C7=14, what is the result of the logical expression C4>C7?
False
True
5.
Multiple Choice
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
Find a similar activity
Create activity tailored to your needs using
Google Sheets Basic Formulas

•
9th - 12th Grade
Google Sheets Functions

•
9th - 12th Grade
Excel 2P-2RVW-Formulas and Functions in Excel

•
10th - 12th Grade
IGCSE EXCEL Formulas & Functions

•
11th Grade
Google Sheets 2 Review

•
9th - 12th Grade
Using Formulas and Functions- Excel

•
6th - 8th Grade
Google Sheets 2: Fundamentals : Using Formulas and Functions

•
9th - 12th Grade
Google Sheets Formulas

•
9th - 12th Grade