stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
M@HS ICT Applications Software 2 Flashcards | StudBud
Explore
/
M@HS ICT Applications Software 2
M@HS ICT Applications Software 2
33 terms
·
StudBud Administration
·
151 plays
Revision for GCSE ICT.
Flashcards
33 cards
F
Practice quiz
P
Host live
L
Questions
33
Answers
1
What does the table in a database consists of?
Columns
Text
Records
Rows
2
Which one is an example of absolute cell reference?
A4:A10
A4
Abs(A4)
$A$4
3
What does this symbol mean?
Less than
Greater or equal to
Less or equal to
Greater than
4
B3:B6 refers to which cells?
Ratio of B3 to B6
B3 and B6
B4 and B5
B3, B4, B5 and B6
5
What would be the main reason for using
data validation rules
?
To make inputting data easier.
Because otherwise your database will not work.
To make the database more professional.
To reduce mistakes during inputting data.
6
Which view will you use to set up your table in Access?
PivotTable view
Datasheet view
Layout view
Design view
7
What does '
merge text'
do?
Display the contents over more than one line.
Join two cells into one.
Automatically change format if content meets requirements.
Check that all of a cell is displayed.
8
Which symbol will you use in a wildcard search?
+
*
/
?
9
What is the smallest part of a spreadsheet called?
Square
Row
Cell
Column
10
With a spreadsheet you can:
Sort data
Record data
Produce Charts
Perform calculations
11
What formula will you insert into cell B7?
B3 + B4 + B5 + B6
=SUM(B3:B6)
SUM(B3:B6)
=B3 + B4 + B5 + B6
12
The columns in a database table is called...
Fields
Records
Information
Data
13
What does this symbol mean?
Equal to
Not equal to
Greater than or less than
Less than or greater than
14
What does this symbol mean?
Less or equal
Greater or equal
Greater than
Less than
15
What does '
wrap text'
do?
Display the contents over more than one line.
Join two cells into one.
Check that all of a cell is displayed.
Automatically change format if content meets requirements.
16
What will you use to model different scenarios in a spreadsheet?
Scenario analysis
Change the formulas you used.
Change the values in different cells
what-if analysis
17
What do companies use to sent individually addressed junk mail?
Forms
Mail merge
Lists
Reports
18
If you enter 34kg into a cell you can do calculations with it.
False
True
19
What type of formatting is conditional formatting?
Join two cells into one.
Check that all of a cell is displayed.
Automatically change format if content meets requirements.
Display the contents over more than one line.
20
What is a database called that uses only one table to store data?
Flat-file database
One file database
Normal database
Relational database
21
How can you improve the spreadsheet below?
Use fill colour to highlight headings.
Put in grid lines.
Use colour to highlight data.
22
Which row is G14 in?
Sheet1
None of these answers
Row 14
Row G
23
What function will you use to display data from a table in another part of the spreadsheet?
DISPLAY
SHOW
COUNTA
LOOKUP
24
What does the number 1 indicates in the function '=RANK(C4,C2:C10,1)?
Descending order.
First position.
Ascending order.
Last postion.
25
Give one problem with flat file databases?
Does not have a Primary Key.
Cannot use queries.
Uses too many tables.
Data redundancy.
26
Which datatype will be best suited for the
Primary Key
?
Hyperlink
AutoNumber
Text
Number
27
What will be displayed in cell B9 when you use '=IF(B3>50,"Too heavy","Acceptable weight")'?
Acceptable weight
Too heavy
False
True
28
A characteristic of a database form.
The form have to be linked to at table.
Users can edit an existing record.
Users can create new record.
Forms have text boxes or tick boxes.
29
A cell contains the following data: KT123AB. What type of data is this?
a Postal code
a text string
Numerical data
Alphanumerical data
30
What is data?
Raw figures or words
Numbers only
Information
Words only
31
What does the function '=COUNT(B2:D5)'?
Count cells with numbers in.
Count the empty cells.
Count the cells with text.
Count all the cell in range B2:D5.
32
Which program will you use to store lots of data in an organised way?
Word
Excel
PowerPoint
Access
33
To how many places does the function '=ROUND(0.12345,0)' round to?
0
2
3
1
