mpapworth
Quiz by , created more than 1 year ago

Diagnosis and testing quiz about spreadsheets

328
6
0
mpapworth
Created by mpapworth over 9 years ago
Close

Spreadsheets Quiz

Question 1 of 15

2

Which of the following is capable of producing a spreadsheet Tick all that apply?

Select one or more of the following:

  • Google Docs

  • Microsoft Office Excel

  • Microsoft Office Word

Explanation

Question 2 of 15

1

What word is used to describe re-organising the order of data?

Select one or more of the following:

  • Search

  • Filter

  • Sort

Explanation

Question 3 of 15

1

In a cell reference, for example A1, what does the letter refer to?

Select one of the following:

  • The row the cell is in

  • The column the cell is in

  • The worksheet the cell is in

Explanation

Question 4 of 15

1

Formulae must always start with which symbol?

Select one of the following:

  • Equals

  • Add

  • Brackets

Explanation

Question 5 of 15

2

Which of the following tasks would a spreadsheet be best used for (tick all that apply)?

Select one or more of the following:

  • Present promotional information about a new television channel

  • Creating a budget for a party

  • Keep track of money raised at a charity event

  • To write a letter of complaint

Explanation

Question 6 of 15

1

Which tool is best used to duplicate information from cell to cell?

Select one of the following:

  • Autosum

  • Fill Handle

  • Filter

Explanation

Question 7 of 15

1

Why might charts and graphs be a way of making the data in a spreadsheet easier to understand?

Select one of the following:

  • Because Mr Obhan can use bar charts

  • Because they don't require you to enter any formula.

  • Because you do not need to enter any data

  • Because the data is presented in a more visual way.

Explanation

Question 8 of 15

2

Wrap text is an option which can be applied to cells in order to do what? (Tick all that apply)

Select one or more of the following:

  • Resize a cell to fit the text inside

  • Put a background on a cell containing text

  • Put a border around a cell containing text

  • Put text that is longer than the width of the cell on more than one line within the same cell

Explanation

Question 9 of 15

1

The software can help guide us through the process of creating a chart. This is called a...?

Select one of the following:

  • Teacher

  • Wizard

  • Help

  • Magician

Explanation

Question 10 of 15

1

What term describes changing the horizontal or vertical position of text?

Select one of the following:

  • Font

  • Alignment

  • Format

Explanation

Question 11 of 15

1

Getting cells to change colour automatically based on the contents of the cell is called...?

Select one of the following:

  • Content formating

  • Conditional formatting

  • Cell formatting

Explanation

Question 12 of 15

1

Which function would we use to calculate the total of a column or a row?

Select one of the following:

  • SUM

  • ADD

  • PLUS

Explanation

Question 13 of 15

1

When we select a group of cells together to use in a formula this is called a..?

Select one of the following:

  • Block

  • Sheet

  • Range

Explanation

Question 14 of 15

1

What function do we use to join a group of cells together to make a larger cell ?

Select one of the following:

  • Merge

  • Verge

  • Combine

Explanation

Question 15 of 15

3

Spreadsheets can (tick all that apply)...?

Select one or more of the following:

  • Complete mathmatical calculations

  • Present data in a visual way

  • Produce large written documents

  • Search large amounts of data

Explanation

Previous
Next