Font size
WorksheetsGoogle Sheets
Total questions: 15
Worksheet time: 12mins
Is the intersection of a row and a column
Range
Cell
Formula
Autofill
Columns are horizontal
True
False
Columns are identified by a
Letter
Number
Rows are horizontal
True
False
Rows are identified by a
Number
Letter
D7 is an example of a name for
A column
A row
A cell
A formula
What is AutoFill?
Is a feature that helps you automatically copy information.
Is a feature that helps you automatically enter data.
Is a feature that helps you to fill a data you forgot.
What is a range in Google Sheets?
Is a collection of selected columns.
Is a collection of selected rows.
Is a collection of selected formulas.
Is a collection of selected cells.
Complete the sentence:
_________ is an expression that operates on values in a range of cells or a cell.
Autofill
Average
Data type
Formula
What does the AVERAGE function do?
It calculates the average of a group of data.
It calculates the sum of a group of data.
It divides the total amount of columns into the number of rows.
Using the SUM function, you can include cell by cell or a range of cells.
(There are two right answers)
True, cell by cell you separate the cells by comas.
False, you can only sum cell by cell, separated by comas.
False, you can only include a range of cells, using the " + " sign.
True, to sum a range you use " : " to indicate the beginning and the end of the range.
I want to know the name of the students who obtained a perfect note. Which of the following options will help me.
You can go to your file if you want to check the values that formula uses.
= if ( I6 = 100 , "Perfect note" , "Keep on trying")
if ( I6 = 100 , "Perfect note" , "Keep on trying")
= if ( I6 = 100 , "Keep on trying" , "Perfect note")
if ( I6 = 100 , "Keep on trying" , "Perfect note")
We used the COUNT function to...
Count the number of cells that contain numbers
Count the number of columns that contain numbers
Count the number of cells that include 100
If you need to combine several cells into one you select the option...
Merge
Borders
Autofill
Colour fill
If the data in a cell is marked as "Text type" the text will be aligned
In the center
To the left
To the right
