Google Sheets is used to?

Put information in columns and rows.

Study the highlighted cells in the image below and identify which of the following represents the correct cell address for these cells:

d) The cell reference for the selected cells is B15:F15

a) The cell reference for the selected cells is B:21, C:28, D:22, E:26 and F:25.

b) The cell reference for the selected cells is row 15, column F

c) The cell reference for the selected cells is F4:F5

Oliver's teacher has shared multiple worksheets in the same spreadsheet file titled "Spreadsheets_Labs". The teacher asks Oliver to go to the "Budget" worksheet. When he opens the "Spreadsheets_Labs" file he initially sees the "Science Data" worksheet. How can Oliver go to the "Budget" worksheet?

He can click the tab at the bottom of the file that represents the "Budget" worksheet.

He must select the new worksheet tab to see the "Budget" worksheet.

He needs to close the file and look for the "Budget" file in his directory.

He can not view the "Budget" worksheet because there is only one worksheet allowed per spreadsheet file.

Patricia's partner Alex has shared a spreadsheet he created. On the first row he has given the spreadsheet a title. The title appears in the cell located in the first column even though the spreadsheet is five columns wide. What can Patricia do so that the title appears centered in the first row above the five columns?

Merge cells A1:E1 and center the title text in the merged cell.

Merge cells A1:E5 and center the title text in the merged cell.

Select cells A1:E1 and center the title text in cell A1.

Unmerge cells A1:F1 and center the title text in the cells.

Tyrell has a spreadsheet consisting of four columns (A, B, C, and D) and 30 rows. He wants to make Row 1 a header row that contains Columns A through D so that he can add a title to describe all the data. How can Tyrell accomplish this?

Select cells A1:D1 and center the title text in cell A1.

Select cells A1:D1 and center the title text in cell D1.

SPREADSHEET FORMATTING, SORTING, AND FILTERING

Authored by NDAYISENGA Celestin

Design

6th Grade

Used 3+ times

SPREADSHEET FORMATTING, SORTING, AND FILTERING

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

30 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the name of this cell?

B10

you cannot know the name from this picture

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

=A1*B1

Error

MULTIPLE CHOICE QUESTION

1 min • 1 pt

All formulas in Google sheets begin with the following symbol:

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Columns are labeled by ______________.

numbers

letters

symbols

colors

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Rows are labeled by __________.

numbers

letters

symbols

colors

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Which of the following is a correctly named cell?

8-B

BB-8

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A ____________ is where a row and column meet.

sheet

formula

blank

cell

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

25 questions

OCR Digital Media Unit 1: LO5 Research data used by media institutions

Quiz

•

12th Grade

33 questions

Interior Design 1 2.01

Quiz

•

9th - 12th Grade

32 questions

Architect Scale Parts and Basic Measurement

Quiz

•

9th - 10th Grade

27 questions

The Science of Food - Year 10

Quiz

•

9th - 12th Grade

25 questions

Database Design

Quiz

•

10th Grade

28 questions

InDesign Certification Prep #1

Quiz

•

9th - 12th Grade

25 questions

Design Engineering Autumn Assessment

Quiz

•

9th - 11th Grade

25 questions

Autocad

Quiz

•

University

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

20 questions

Figurative Language Review

Quiz

•

6th Grade

Discover more resources for Design

20 questions

Context Clues

Quiz

•

6th Grade

20 questions

Figurative Language Review

Quiz

•

6th Grade

10 questions

Groundhog Day Trivia Questions

Interactive video

•

3rd - 6th Grade

20 questions

Exponents

Quiz

•

6th Grade

5 questions

Legends, Leaders, & Changemakers: Maya Angelou

Interactive video

•

6th - 8th Grade

15 questions

Distributive Property & Review

Quiz

•

6th Grade

10 questions

Figurative Language

Quiz

•

6th Grade

10 questions

Understanding Poetry and Literary Devices

Interactive video

•

4th - 8th Grade

SPREADSHEET FORMATTING, SORTING, AND FILTERING

What is the name of this cell?

=A1*B1

All formulas in Google sheets begin with the following symbol:

Columns are labeled by ______________.

Rows are labeled by __________.

Which of the following is a correctly named cell?

A ____________ is where a row and column meet.

Which symbol tells the computer you want to create an equation or formula?

A spreadsheet is made up of all of the following EXCEPT

Rows are labeled by __________.

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Design