Spreadsheets Quiz 1

Spreadsheets Quiz 1

6th Grade

18 Qs

quiz-placeholder

Similar activities

Google Sheets Review

Google Sheets Review

KG - University

20 Qs

Advanced Functions and Formulas

Advanced Functions and Formulas

6th - 8th Grade

15 Qs

Spreadsheet

Spreadsheet

5th - 9th Grade

19 Qs

KIỂM TRA 15P TIN 7 (18-23/10-2022)

KIỂM TRA 15P TIN 7 (18-23/10-2022)

6th - 9th Grade

20 Qs

Spreadsheets - Lesson 3

Spreadsheets - Lesson 3

6th - 9th Grade

20 Qs

Spreadsheet Basics

Spreadsheet Basics

6th - 8th Grade

20 Qs

Introduction to Spreadsheet

Introduction to Spreadsheet

4th - 6th Grade

20 Qs

MS EXCEL Quiz 1

MS EXCEL Quiz 1

6th - 8th Grade

15 Qs

Spreadsheets Quiz 1

Spreadsheets Quiz 1

Assessment

Quiz

Computers

6th Grade

Medium

TA.6.L.ii, TA.3.D, TA.2.A

+2

Standards-aligned

Created by

Michael Keeton

Used 34+ times

FREE Resource

18 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is one reason to use cell references in a formula?

The answer will change if the numbers in referenced cells change.

You need cell references to use functions.

Only formulas with cell references can be copied and pasted.

You need cell references to use operators.

Tags

TA.6.L.ii

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of these adds two referenced cells?

=B3+C3

=B+C+3+3

=(B3,C3)

=B+C

Tags

TA.6.L.ii

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the operator used to multiply?

@

^

/

*

Tags

TA.6.L.ii

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If you type =1+1 in the formula bar, what will show in the cell after you hit Enter or Return?

=1+1

2

1+1

=2

Tags

TA.6.L.ii

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Cell C1 has =A1+B1 in it. If you copy and paste cell C1 into cell C2, what will show in the formula bar for C2?

=A1+B1

=C1+C2

=A2+B2

=A1+B1+A2+B2

Tags

TA.6.L.ii

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What would you type to find the sum of the cells D4 through D6?

=SUM(D4/D6)

=SUM(D4,D6)

=SUM(D4:D6)

=SUM(D4-D6)

Tags

TA.6.L.ii

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How do you copy a formula from one cell into a large group of cells?

Select the group of cells and type the formula into the formula bar.

Retype the formula into each cell.

Copy the formula, select the group of cells, and paste.

Select the group of cells and hit Enter or Return.

Tags

TA.6.L.ii

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?