Quiz
Spreadsheet quiz
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (20)
1An instruction used to carry out operations on numerical data
- Acell
- BRow
- CFormula
2Runs up and down and are lettered
- ARows
- BCells
- CColumns
3A piece of data that can be used in a calculation
- ASpreadsheet
- BValue
- CRow
4A program which organizes information into rows and columns so that it can be easily operated on.
- ASpreadsheet
- BFormula
- CValue
5
The intersection (meeting point) of a row and a column.- ARow
- BLabel
- CCell
6Can be used as a title or heading to describe an aspect of the worksheet.
- Avalue
- BData
- CLabel
7Run from left to right and are numbered
- ARow
- Bvalue
- CColumn
8What is a spreadsheet
- AA sheet that is spread out
- BA document on a computer
- CA google app
9What is a spreadsheet used for?
- ATo edit data
- BTo organise your diary
- CTo process and perform calculations of raw data
10What is a column?
- AData arranged horizontally on a spreadsheet
- BData arranged vertically on a spreadsheet
- CA google format
11What is a chart?
- AAppears vertically in a worksheet and is identified by letters at the top of the worksheet window.
- BKeeps row or column titles on the screen no matter where you scroll in the worksheet.
- CA graphic representation of values and their relationships.
12What is a Format?
- AAlphabetical or numeric text that will not be used in calculations.
- BNumeric characters that can be calculated in a spreadsheet.
- CArranging the shape, size, type, and general makeup of a cell or document.
13To allow you to evenly distribute a title over a table of numbers, use the
- ACentre button
- BMerge and Centre button
- CMerge cells only button
14The numbers in Excel represent the
- ARows
- BColumns
- Ccells
15Which of these would add up the numbers from A3 to A6
- A+(A3:A6)
- B=(Ave(a3:a6))
- C=Sum(A3:A6)
16A formula in the spreadsheet should always start with
- Aa plus sign
- Ba capital letter
- Can equals sign
17Excel is part of?
- APower Point
- BAccess
- CMicrosoft Office Suite
18How do you select an entire column?
- ASelect Edit > Select > Column from the menu
- BClick the column heading letter
- CHold down the Ctrl key as you click anywhere in the column
19The letters in Excel represent the...
- ARows
- BColumns
- CCells
20How do you change column width to fit the contents?
- ASingle-click the boundary to the left of the column heading
- BDouble-click the boundary to the right of the column heading
- CPress ALT and single-click anywhere in the column
Information
- Description
- A quiz to help students describe the functions used in spreadsheets
- Author
- christina Littlewood
- Language
- English
- Views
- 0
- Tags
- Rating
- No ratings yet Rate this quiz