Search Header Logo

Spreadsheet Functions and Formatting Quiz y9

Authored by Conor Frater

Computers

7th Grade

Used 12+ times

Spreadsheet Functions and Formatting Quiz y9
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the function of a spreadsheet?

Play music

create an interesting presentation

Write a letter

Organize, analyze, and store data in a tabular format

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you format cells to display currency in a spreadsheet?

Choose the 'Currency' format from the 'Number' menu in the 'Format' options.

Apply the 'Italic' format from the 'Alignment' options

Select the 'Date' format from the 'Format' menu

Use the 'Bold' option in the 'Font' menu

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the formula to calculate the average of a range of cells in a spreadsheet?

=MEDIAN(range)

=MAX(range)-MIN(range)

=SUM(range)/COUNT(range)

=AVERAGE(range)

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of data analysis in spreadsheets?

To make decisions based on random guesses

To create chaos and confusion

To organize, interpret, and visualize data to make informed decisions.

To waste time and effort without any purpose

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you create a pie chart in a spreadsheet?

Using the 'Format' menu to create a pie chart

Selecting the data and using the 'Insert' or 'Chart' menu to choose 'Pie Chart'

Typing 'Pie Chart' in the search bar

Right-clicking on the data and selecting 'Pie Chart'

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the function of the SUM function in spreadsheets?

To add up a range of numbers

To subtract a range of numbers

To multiply a range of numbers

To find the average of a range of numbers

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you apply conditional formatting to a range of cells in a spreadsheet?

Select the range, go to 'Format' menu, choose 'Conditional formatting'

Use the shortcut Ctrl + C to apply conditional formatting to the range

Type 'Conditional formatting' in the search bar and click on the first result

Right-click on the range and choose 'Conditional formatting'

Access all questions and much more by creating a free account

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

Already have an account?