Learning For Life - ICT Skills Test
This quiz is designed for use in the Year 10 Learning for Life program at Lanyon High School. It is to help confirm that students have gained a basic knowledge of the workings of both a database and spreadsheet program. Enter both your first and last names when you take the quiz so that your results don't get mixed up with another students. Make sure to show your teacher your results at the conclusion of the quiz.
- 1.Which of the following programs can be used to create a database?
- A.
Microsoft Publisher
- B.
Microsoft Excel
- C.
Microsoft Access
- D.
Microsoft Word
- E.
Microsoft PowerPoint
- 2.Databases are primarily used to...
- A.
Create written documents
- B.
Perform calculations
- C.
Create presentations
- D.
Draw images
- E.
Store and link data
- 3.The data in a database is stored in a ...
- A.
Table
- B.
Report
- C.
Chart
- D.
List
- E.
Document
- 4.When creating a database the computer program needs to be told what type of data it is storing (i.e. it doesn't automatically detect the data type).
- A.
True
- B.
False
- 5.Once your database is full of data what can you create using the database program that allows you to display and print this data?
- A.
Table
- B.
Report
- C.
Form
- D.
Document
- E.
Presentation
- 6.Spreadsheets are primarily used to...
- A.
Create written documents
- B.
Perform calculations
- C.
Create presentations
- D.
Draw images
- E.
Store and link data
- 7.If you want Microsoft Excel to perform a calculation you start by typing what symbol?
- A.
$
- B.
#
- C.
=
- D.
+
- E.
-
- 8.Each box containing data within a spreadsheet is called a...
- A.
Box
- B.
Container
- C.
Area
- D.
Compartment
- E.
Cell
- 9.Which of the following is NOT an in-built funtcion in Excel?
- A.
SUM
- B.
COUNT
- C.
COUNTIF
- D.
AVERAGE
- E.
GRAPH
- 10.What does the use of the $ symbol mean in an equation?
- A.
It represents money
- B.
It tells Excel to perform a calculation
- C.
It is an in-built Excel function
- D.
It tells Excel to lock the address of the cell it is looking at
- E.
It tells Excel to look at all cells within a defined range
Related Topics
Recent Quizzes
Featured Quizzes
Back to top