Spreadsheet Concepts

Spreadsheet Concepts

9th Grade

12 Qs

quiz-placeholder

Similar activities

Workplace Readiness Skills - IC Practice #2

Workplace Readiness Skills - IC Practice #2

9th - 12th Grade

10 Qs

DATA ANALYSIS 101 (Formulas / Functions)

DATA ANALYSIS 101 (Formulas / Functions)

8th - 9th Grade

11 Qs

Spreadsheets Quiz

Spreadsheets Quiz

9th Grade

14 Qs

Microsoft Word Ribbon (2019)

Microsoft Word Ribbon (2019)

7th - 12th Grade

17 Qs

materi Excel Macro kelas 9

materi Excel Macro kelas 9

9th Grade

10 Qs

Prokaryote vs. Eukaryote

Prokaryote vs. Eukaryote

9th - 10th Grade

13 Qs

Microsoft Word

Microsoft Word

1st - 10th Grade

10 Qs

Tin học

Tin học

6th Grade - University

10 Qs

Spreadsheet Concepts

Spreadsheet Concepts

Assessment

Quiz

Other

9th Grade

Hard

Created by

Kinga Penjor

FREE Resource

12 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a formula in a spreadsheet?

A font style for the text

A color scheme for the cells

A type of graph

An expression that performs calculations on values in the cells.

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Give an example of a mathematical function in a spreadsheet.

=A1*C1

=A1+B1

=IF(A1>10, B1, C1)

=SUM(A1:A10)

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Explain the importance of formatting in a spreadsheet.

Formatting in a spreadsheet is irrelevant and unnecessary

Formatting in a spreadsheet is crucial for data organization, visual appeal, readability, analysis, presentation, and interpretation.

Formatting in a spreadsheet has no impact on data analysis

Formatting in a spreadsheet only slows down data entry

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you use absolute cell references in formulas?

Italicize the cell reference

Add a dollar sign ($) before the column letter and row number of the cell reference.

Use a question mark (?) before the column letter and row number

Add a hashtag (#) before the cell reference

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of the SUM function in a spreadsheet?

To calculate the total sum of a range of numbers or cells.

To format text in bold

To change the font color

To insert images into cells

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Describe the difference between relative and absolute cell references.

Relative cell references are for text, absolute cell references are for numbers.

Relative cell references change, absolute cell references stay the same.

Relative cell references are always in bold, absolute cell references are always in italics.

Relative cell references are used in Excel, absolute cell references are used in Google Sheets.

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you apply conditional formatting in a spreadsheet?

Click on the cell, Format -> Conditional formatting -> Set conditions and formatting -> Apply

Highlight the range, Format -> Conditional formatting -> Define rules and formatting -> Confirm

Right-click on the selection, Format -> Conditional formatting -> Specify conditions and formatting -> Save

Select range, Format -> Conditional formatting -> Set conditions and formatting -> Done

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?