Google Sheets Review 1

Google Sheets Review 1

9th - 12th Grade

15 Qs

quiz-placeholder

Similar activities

Online Platform Block Q

Online Platform Block Q

11th - 12th Grade

20 Qs

โปรแกรมตารางงาน ทดสอบปลายภาค ชุดที่1

โปรแกรมตารางงาน ทดสอบปลายภาค ชุดที่1

10th - 12th Grade

20 Qs

Server Administration- Quiz 1

Server Administration- Quiz 1

12th Grade - University

10 Qs

Informatika Kelas 5 Bab 2

Informatika Kelas 5 Bab 2

5th Grade - University

19 Qs

Quiz 9 (15.09.2021)

Quiz 9 (15.09.2021)

1st - 12th Grade

10 Qs

Technology Week HTG Quiz - Monday

Technology Week HTG Quiz - Monday

7th - 12th Grade

10 Qs

Thinglink

Thinglink

9th - 12th Grade

10 Qs

Recording Software Button Identification Quiz

Recording Software Button Identification Quiz

8th Grade - University

10 Qs

Google Sheets Review 1

Google Sheets Review 1

Assessment

Quiz

Computers

9th - 12th Grade

Medium

Created by

Denise Contreras

Used 45+ times

FREE Resource

15 questions

Show all answers

1.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

Why is it necessary to manually adjust the column width sometimes? (more than one answer is true)

This is the only way to resize a column.

The title is included in the column and autofit will make the width too wide.

The data in the columns is too crowded with autofit.

There are too many rows.

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In Google Sheets, formulas always start with an = sign.

True

False

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In Google Sheets, all formulas that are pre-programmed into the software can be found under this icon.

filter

comment

functions

border

4.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

To AUTOFIT a column in Google Sheets, do the following:

Drag the line between the columns right or left.

Do nothing, the program does it on its own.

Click on the AUTOFILL button.

Double-click the line to the right of the column you want to resize.

5.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

When using the Count function, it is important to remember this (more than one answer is correct).

Select all of the cells you want the program to count.

The cells you are using must contain data that IS NOT NUMERIC.

The program will give you an error if you select cells that do not contain numeric values.

The cells you are using must contain data that IS NUMERIC.

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Before starting a formula in Google Sheets, you should select the cell you want the formula/answer to appear in.

Show Answers

10 secTime Limit

True

False

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In Google Sheets, the Max formula is used:

only by anyone who is named Max

when you want to determine the LARGEST NUMBER in a range of cells

when you want to determine the SMALLEST NUMBER in a range of cells

when you want to determine which cells are full

Create a free account and access millions of resources

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?

Discover more resources for Computers