Which of these statements is NOT true about cell ranges?

There is a limit of 30 cells in a cell range

A cell range is represented by the cell reference of the upper left cell and the lower right cell

The two cell references that make up a cell range are separated by a colon :

A cell range is a block of two or more cells

Which of these statements is NOT true about the formula fill handle?

You can only use it once every two minutes

It is located in the bottom right hand corner of an active cell

Allows formulas to be copied down a column or across a row

Wrap text (G) is an option which can be applied to cells in order to do what?

Place extra-long text onto multiple lines

Tell the spreadsheet what type of data the cell contains

Join two or more cells together to make one single cell

Add a solid, dotted, dashed or coloured border to the cell

Merge and center (H) is an option which can be applied to cells in order to do what?

Join two or more cells together to make one single cell

Put a border around a cell containing text

Put a background on a cell containing text

Place extra-long text onto multiple lines

Letter (I) is an option which can be changed for cells. What does it do?

Tell the spreadsheet what type of data the cell contains

Align the text in the cell vertically, horizontally or at an angle

Choose what colour the cell is filled with

Place extra-long text onto multiple lines

What is the purpose and benefit of freezing panes or rows and columns in a spreadsheet with a large dataset?

To keep certain rows and columns visible while scrolling through a large dataset, providing context and reference

To reduce the file size of the spreadsheet and improve its performance

To hide specific data that is not immediately relevant to the current analysis

To apply special formatting to selected cells to make them stand out from the rest of the data

What is the purpose and benefit of hiding columns or rows in a spreadsheet?

To hide specific data that is not immediately relevant to the current analysis

To reduce the file size of the spreadsheet and improve its performance

To apply special formatting to selected cells to make them stand out from the rest of the data

To keep certain rows and columns visible while scrolling through a large dataset, providing context and reference

Which of these is the most appropriate reason for using the SUM function?

To add together two or more cell values

To always get a negative result

To delete the values in multiple cells

To change the font of multiple cells

To find the average of a range of cells, the AVERAGE function can be used. What calculation does the AVERAGE function perform?

Totals the cell values then divides the total by the number of separate amounts

Totals the cell values then multiplies the total by 10 and divides the result by 2

Totals the cell values then multiplies the total by the number of separate amounts

Counts the number of separate amounts, then divides that amount by the total of the cell values

What is the MAX function used for?

To return the largest value in a range

To return the average of a range of numbers

To return the smallest value in a range

To return the number of blank cells in a range

Which of these is the most appropriate reason for using the COUNT function?

To count the number of cells containing a number in a range

To count the number of non-blank cells in a range

To return the number of blank cells in a range

What is the COUNTBLANK function used for?

To return the number of blank cells in a range

To count the number of non-blank cells in a range

To count the number of cells containing a number in a range

2023-24 - Y8 - Data Modelling EOU Assessment Quiz

65 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of these statements is NOT true about spreadsheets?

Spreadsheets calculate data using different operations and functions

Spreadsheets with formulas do not update when values are changed

Spreadsheets are used for storing, displaying, sorting and manipulating data

Spreadsheets are used for modelling data

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the correct name for the part of a spreadsheet labelled 'A'?

Row

Active Cell

Cell

Column

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the correct name for the part of a spreadsheet labelled 'B'?

Column

Row

Active Cell

Cell

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the correct name for the part of a spreadsheet labelled 'C'?

Active Cell

Column

Cell

Row

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the correct name for the part of a spreadsheet labelled 'D'?

Cell

Active Cell

Column

Row

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of these statements is NOT true about cell references?

A cell reference is a combination of a column letter and row number

A cell reference identifies a cell on a spreadsheet worksheet

Each cell reference on a worksheet is unique

A cell reference can only be used in one formula

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the cell reference for the cell shown in orange?

2A

AA

A2

22

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

61 questions

Ôn Tập Kiểm Tra Tin Học 8

Quiz

•

7th Grade

68 questions

7 сынып информатика

Quiz

•

7th Grade

60 questions

ECDL Python Lesson 14 recap

Quiz

•

5th - 12th Grade

63 questions

Chủ đề 1: CĂN BẢN VỀ CÔNG NGHỆ (GS6 LV2_ 2024)_1

Quiz

•

7th Grade

60 questions

Computer Hardware and Software Test

Quiz

•

6th - 8th Grade

60 questions

Programación

Quiz

•

KG - Professional Dev...

60 questions

GCSE J277 - Variables, Operators and Constructs Mega Quiz

Quiz

•

7th Grade

66 questions

Internet Safety

Quiz

•

5th - 12th Grade

Popular Resources on Wayground

7 questions

History of Valentine's Day

Interactive video

•

4th Grade

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

15 questions

Valentine's Day Trivia

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

Discover more resources for Computers

10 questions

Exploring Valentine's Day with Charlie Brown

Interactive video

•

6th - 10th Grade

18 questions

Valentines Day Trivia

Quiz

•

3rd Grade - University

14 questions

Volume of rectangular prisms

Quiz

•

7th Grade

10 questions

Valentine's Day History and Traditions

Interactive video

•

6th - 10th Grade

11 questions

Valentines Day

Quiz

•

6th - 8th Grade

20 questions

Graphing Inequalities on a Number Line

Quiz

•

6th - 9th Grade

25 questions

7th Reading STAAR Vocabulary

Quiz

•

6th - 8th Grade

20 questions

Revising & Editing practice

Quiz

•

7th Grade

2023-24 - Y8 - Data Modelling EOU Assessment

Which of these statements is NOT true about spreadsheets?

What is the correct name for the part of a spreadsheet labelled 'A'?

What is the correct name for the part of a spreadsheet labelled 'B'?

What is the correct name for the part of a spreadsheet labelled 'C'?

What is the correct name for the part of a spreadsheet labelled 'D'?

Which of these statements is NOT true about cell references?

What is the cell reference for the cell shown in orange?

Which of these statements is NOT true about cell ranges?

What is the cell range for the cells shown in blue?

If in cell D3 you have =A1, what cell does D3 refer to?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers