Font size
WorksheetsGoogle Sheets- Summative Block C
Total questions: 25
Worksheet time: 50mins
The name of the cell colored orange is 6B
True
False
Which one is cell G10?
What does the lock next to the sheet name mean?
The sheet is hidden.
The sheet cannot be deleted.
The sheet is protected.
The sheet is the first one be viewed.
Which button can be used from the menu bar to merge cells?
Which button can be used from the menu bar to change the number formatting?
Which button can be used from the menu bar to change the cell border?
Which button can be used from the menu bar to strikethrough text?
What is the name of the range?
B3:E3
3B:3E
B3-E3
B3+E3
The range is named (a)
When applying filters to a range of numbers, A->Z refers to an ascending ordering.
True
False
The blue biutton that shows up in bottom right corner of selected cell-when dragged, automatically fills in selected cells, is called:
Text wrapping
Conditional Formatting
Auto Fill handle
Drag Drop Hand
What is this bar called?
Formula bar
Display bar
Auto Sum bar
Menu bar
Which number format do you apply to display the following:
($122.5)
Percent
Currency
Scientific
Auto
When the sum function is applied, the answer will be (a)
Write the formula that was applied to achieve the value in red.
(a)
Explain why thus formula is not displaying a value,
(a)
A filter has been applied to this list of students names.
Which of the following filter options was used?
Sort Range column C, Z to A
Sort Range column C, A to Z
Sort Range column B, Z to A
Sort Range column B, A to Z
This is the current list of names (on the side).
When the following filter is applied, what will the list of names look like?
Sort Range column B, Z to A
his is the current list of names (on the side).
When the following filter is applied, what will the list of names look like?
Sort Range column C, Z to A
his is the current list of names (on the side).
When the following filter is applied, what will the list of names look like?
Sort Range column C, A to Z
The trick to using the Google sheets as a calculator is to start your math expression or formulas with an
dollar sign
equal sign
f(x)
parentheses
Under which menu or tab you find the charts?
File
View
Edit
Insert
Under which menu or tab will you find the Filters Views?
Format
Data
Tools
File
What will be the result of this formula:
=MAX(B2:B8)
300
345
400
245
What will happen when the plus sign is pressed?
A new cell is added
A new sheet is added
A new row is added
A new column is added
