Google Sheets: Functions and Behavior Check-Up

Quiz
•
Computers
•
12th Grade
•
Medium
Tony Marelich
Used 1+ times
FREE Resource
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
15 mins • 1 pt
What does the equal sign do at the beginning of an expression in a spreadsheet?
It indicates a comment.
It starts a formula.
It formats the cell as text.
It locks the cell reference.
2.
MULTIPLE CHOICE QUESTION
15 mins • 1 pt
Which function would you use to generate a random number between 1 and 10?
RAND()
IF()
RANDBETWEEN(1, 10)
COUNTIF()
3.
MULTIPLE CHOICE QUESTION
15 mins • 1 pt
How does recalculation affect randomly generated cell values in a spreadsheet?
It keeps the values constant.
It changes the values each time recalculation occurs.
It deletes the values.
It formats the values as text.
4.
MULTIPLE CHOICE QUESTION
15 mins • 1 pt
What is the difference between copying a cell and copying the contents of a cell?
Copying a cell includes its formatting, while copying contents does not.
Copying a cell deletes the original, while copying contents does not.
Copying a cell moves it, while copying contents duplicates it.
There is no difference.
5.
MULTIPLE CHOICE QUESTION
15 mins • 1 pt
When using the function IF(), what is the purpose of the logical test?
To perform arithmetic operations.
To determine which value to return.
To format the cell.
To generate random numbers.
6.
MULTIPLE CHOICE QUESTION
15 mins • 1 pt
How can you lock a cell reference in a formula?
By using the "@" symbol.
By using the "#" symbol.
By using the "$" character.
By using the "&" symbol.
7.
MULTIPLE CHOICE QUESTION
15 mins • 1 pt
What happens to cell references when you copy and paste a formula?
They remain absolute.
They change relative to the new location.
They become text.
They are deleted.
Create a free account and access millions of resources
Similar Resources on Wayground
19 questions
S3 AIT Spreadsheets

Quiz
•
12th Grade
16 questions
7 класс 2 четверть

Quiz
•
7th Grade - University
18 questions
Google Sheets ReViEw

Quiz
•
KG - University
20 questions
Bài 5. Thao tác với bảng tính

Quiz
•
1st - 12th Grade
22 questions
Excel Basics and More

Quiz
•
7th - 12th Grade
23 questions
EXCEL TEST

Quiz
•
KG - University
20 questions
SPREADSHEET CR

Quiz
•
12th Grade
20 questions
Year 12 Spreadsheets

Quiz
•
12th Grade
Popular Resources on Wayground
10 questions
Video Games

Quiz
•
6th - 12th Grade
20 questions
Brand Labels

Quiz
•
5th - 12th Grade
15 questions
Core 4 of Customer Service - Student Edition

Quiz
•
6th - 8th Grade
15 questions
What is Bullying?- Bullying Lesson Series 6-12

Lesson
•
11th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
22 questions
Adding Integers

Quiz
•
6th Grade
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade