Learning For Life - ICT Skills Test

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Lindauhlmann
L
Lindauhlmann
Community Contributor
Quizzes Created: 1 | Total Attempts: 134
| Attempts: 134
Quiz Flashcard
SettingsSettings
Please wait...
  • 1/10 Questions

    Databases are primarily used to...

    • Create written documents
    • Perform calculations
    • Create presentations
    • Draw images
    • Store and link data
Please wait...
About This Quiz


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.

Learning For Life - ICT Skills Test - Quiz

Quiz Preview

  • 2. 

    Each box containing data within a spreadsheet is called a...

    • Box

    • Container

    • Area

    • Compartment

    • Cell

    Correct Answer
    A. Cell
    Explanation
    In a spreadsheet, each box that holds data is referred to as a "cell". A cell is the basic unit of a spreadsheet and is identified by a unique combination of a column letter and a row number. It can hold different types of data such as numbers, text, or formulas. Cells are used to organize and manipulate data within a spreadsheet, allowing for calculations, data analysis, and presentation of information.

    Rate this question:

  • 3. 

    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).

    • True

    • False

    Correct Answer
    A. True
    Explanation
    When creating a database, the computer program does not automatically detect the data type. The user needs to explicitly specify the type of data that will be stored in the database. This is because different data types require different storage mechanisms and operations. Therefore, it is necessary to inform the computer program about the data type to ensure proper handling and manipulation of the data within the database.

    Rate this question:

  • 4. 

    Which of the following programs can be used to create a database?

    • Microsoft Publisher

    • Microsoft Excel

    • Microsoft Access

    • Microsoft Word

    • Microsoft PowerPoint

    Correct Answer
    A. Microsoft Access
    Explanation
    Microsoft Access is the correct answer because it is a database management system that allows users to create, manage, and manipulate databases. It provides tools and features specifically designed for database creation and management, such as table design, data entry forms, queries, and reports. Microsoft Publisher, Microsoft Excel, Microsoft Word, and Microsoft PowerPoint are all office productivity programs that do not have the same database functionality as Microsoft Access.

    Rate this question:

  • 5. 

    If you want Microsoft Excel to perform a calculation you start by typing what symbol?

    • $

    • #

    • =

    • +

    • -

    Correct Answer
    A. =
    Explanation
    In Microsoft Excel, the "=" symbol is used to start a calculation. When you type "=" followed by a formula or function, Excel will evaluate the expression and provide the result. This symbol is essential for performing calculations in Excel and is the standard way to initiate any mathematical operation or formula in a cell.

    Rate this question:

  • 6. 

    Spreadsheets are primarily used to...

    • Create written documents

    • Perform calculations

    • Create presentations

    • Draw images

    • Store and link data

    Correct Answer
    A. Perform calculations
    Explanation
    Spreadsheets are primarily used to perform calculations. They are designed to handle numerical data and perform various mathematical operations, such as addition, subtraction, multiplication, and division. Spreadsheets also have built-in functions and formulas that can be used to perform more complex calculations, analyze data, and generate reports. They provide a grid-like structure that allows users to organize and manipulate data in a tabular format, making them an essential tool for financial analysis, budgeting, data analysis, and other numerical tasks.

    Rate this question:

  • 7. 

    Once your database is full of data what can you create using the database program that allows you to display and print this data?

    • Table

    • Report

    • Form

    • Document

    • Presentation

    Correct Answer
    A. Report
    Explanation
    Once your database is full of data, you can create a report using the database program. A report allows you to display and print the data in a structured and organized manner. Reports are commonly used to summarize and present data in a format that is easy to read and understand.

    Rate this question:

  • 8. 

    The data in a database is stored in a ...

    • Table

    • Report

    • Chart

    • List

    • Document

    Correct Answer
    A. Table
    Explanation
    The data in a database is stored in a table. A table is a structured collection of data organized in rows and columns. Each row represents a record, and each column represents a field or attribute. Tables are used to store and organize large amounts of data in a structured and efficient manner, allowing for easy retrieval and manipulation of the data.

    Rate this question:

  • 9. 

    Which of the following is NOT an in-built funtcion in Excel?

    • SUM

    • COUNT

    • COUNTIF

    • AVERAGE

    • GRAPH

    Correct Answer
    A. GRAPH
    Explanation
    The given question asks for an option that is NOT an in-built function in Excel. Among the options provided, SUM, COUNT, COUNTIF, and AVERAGE are all in-built functions in Excel that perform mathematical calculations and data analysis. However, GRAPH is not an in-built function in Excel. Excel does provide various charting and graphing tools, but there is no specific function called GRAPH.

    Rate this question:

  • 10. 

    What does the use of the $ symbol mean in an equation?

    • It represents money

    • It tells Excel to perform a calculation

    • It is an in-built Excel function

    • It tells Excel to lock the address of the cell it is looking at

    • It tells Excel to look at all cells within a defined range

    Correct Answer
    A. It tells Excel to lock the address of the cell it is looking at
    Explanation
    The use of the $ symbol in an equation tells Excel to lock the address of the cell it is looking at. This means that when the formula is copied or dragged to other cells, the cell reference with the $ symbol will not change. This is useful when you want to keep a specific cell reference constant in a formula while allowing other cell references to adjust relative to their new location.

    Rate this question:

Quiz Review Timeline (Updated): Mar 7, 2024 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 07, 2024
    Quiz Edited by
    ProProfs Editorial Team
  • May 16, 2010
    Quiz Created by
    Lindauhlmann
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.