mpapworth
Quiz by , created about 4 years ago

Diagnosis and testing quiz about spreadsheets

268
3
0
Tags
mpapworth
Created by mpapworth about 4 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

    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

    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

    Question 4 of 15

    1

    Formulae must always start with which symbol?

    Select one of the following:

    • Equals

    • Add

    • Brackets

    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

    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

    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.

    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

    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

    Question 10 of 15

    1

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

    Select one of the following:

    • Font

    • Alignment

    • Format

    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

    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

    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

    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

    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