WorksheetsTest de Evaluare Inițială, Clasa a 11-a
Total questions: 50
Worksheet time: 25mins
A database is used to
Calculate figures
Store data in a logical order
Layout pages attractively
Present material using animations and graphics
The software that we would use to create a database is
Microsoft Publisher
Microsoft Excel
Microsoft Word
Microsoft Access
In a database, data is stored in
Tables
Forms
Reports
Queries
Which of the following would be used to uniquely identify a record?
Validation
Data type
Primary key
Field size
The best data type to choose for date of birth would be
Number
Text
Date/Time
Currency
A ‘required field’ is a form of
Validation
Verification
Data Entry
Data Output
A postcode is usually written in the same format e.g. LLNN NLL (L=letter, N=number). The most suitable type of validation to use in this instance would be
Input Mask
Required Field
Range Check
None
To find a particular set of data in a database you would use a
Table
Form
Query
Report
Besides entering data directly into the table, you could use a
Field
Form
Query
Report
To display the data from a query in a professional format you could use a
Table
Form
Query
Report
In a database, a "form" allows you to...
Create a query
Enter data and edit it in a simple form that consists of the fields from a table
Nick wants Access to assign an ID number to each record. What is this called?
Data Type
auto numbering
Properties
Text
What is design view?
The function we use to set up a table in a database.
The place where we type in all the information.
What function enables you to ask questions about the data stored in a database and returns the answers based on your criteria?
Query
Form
Report
Table
To sort from the smallest to the largest (from A to Z and 0 to 9)
Ascending
Descending
Advanced Sort/Filter
În Excel, suma a doua sau mai multor celule se realizeaza cu ajutorul functiei:
PRODUCT
ADUN
SUM
COUNTIF
În Excel înaintea fiecarei formule sau functii se introduce semnul:
+
:=
=
*
Pentru a calcula media aritmetica a doua sau mai multor celule folosim functia:
MAX
MEDIA
SUM
AVERAGE
Cum se numește spațiul situat la intersecția unui rând cu o coloană?
celula
worksheet
camp de lucru
workbook
Cum se numesc fișierele cu care operează Microsoft Excel?
publicatii
foi de calcul tabelar
baze de date
documente
