Spreadsheets Quiz

mpapworth
Quiz by , created about 4 years ago

Diagnosis and testing quiz about spreadsheets

267
3
0
Tags
mpapworth
Created by mpapworth about 4 years ago
OCR Gateway GCSE P3 Revision Quiz
xhallyx
Ancient Roman Quiz
Rev32
Blues, Beats & More! Quiz
Mike'd
Contract Law
sherhui94
What are they doing?
Tamara Urzhumova
German House Types
Zainny
Test your Knowledge with Quizzes
daniel.praecox
GoConqr Getting Started Guide
Norman McBrien
General Knowledge Quiz
Andrea Leyden
Revision Timetable
katy.lay

Question 1

Question
Which of the following is capable of producing a spreadsheet Tick all that apply?
Answer
  • Google Docs
  • Microsoft Office Excel
  • Microsoft Office Word

Question 2

Question
What word is used to describe re-organising the order of data?
Answer
  • Search
  • Filter
  • Sort

Question 3

Question
In a cell reference, for example A1, what does the letter refer to?
Answer
  • The row the cell is in
  • The column the cell is in
  • The worksheet the cell is in

Question 4

Question
Formulae must always start with which symbol?
Answer
  • Equals
  • Add
  • Brackets

Question 5

Question
Which of the following tasks would a spreadsheet be best used for (tick all that apply)?
Answer
  • 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

Question
Which tool is best used to duplicate information from cell to cell?
Answer
  • Autosum
  • Fill Handle
  • Filter

Question 7

Question
Why might charts and graphs be a way of making the data in a spreadsheet easier to understand?
Answer
  • 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

Question
Wrap text is an option which can be applied to cells in order to do what? (Tick all that apply)
Answer
  • 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

Question
The software can help guide us through the process of creating a chart. This is called a...?
Answer
  • Teacher
  • Wizard
  • Help
  • Magician

Question 10

Question
What term describes changing the horizontal or vertical position of text?
Answer
  • Font
  • Alignment
  • Format

Question 11

Question
Getting cells to change colour automatically based on the contents of the cell is called...?
Answer
  • Content formating
  • Conditional formatting
  • Cell formatting

Question 12

Question
Which function would we use to calculate the total of a column or a row?
Answer
  • SUM
  • ADD
  • PLUS

Question 13

Question
When we select a group of cells together to use in a formula this is called a..?
Answer
  • Block
  • Sheet
  • Range

Question 14

Question
What function do we use to join a group of cells together to make a larger cell ?
Answer
  • Merge
  • Verge
  • Combine

Question 15

Question
Spreadsheets can (tick all that apply)...?
Answer
  • Complete mathmatical calculations
  • Present data in a visual way
  • Produce large written documents
  • Search large amounts of data