Practice Exam - Wrong Answers (Knowledge Gaps) Flashcards

1
Q

Which of the following are elements of a chart in a spreadsheet? (Multiple Response)

A) Data Table

B) Trend Line

C) Data Label

D) Macro

E) Cell Border

A

A) Data Table

B) Trend Line

C) Data Label

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Which spreadsheet function returns the current date and time?

A) =DATE()

B) =NOW()

C) =TODAY()

D) =TIME()

A

B) =NOW()

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Which field properties in a database help speed up data entry? (Multiple Response)

A) Default values

B) Look-up lists

C) Criteria lists

D) Table relationships

A

A) Default values
B) Look-up lists
C) Criteria lists

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What does the MODE calculation show?

A) The middle number in a dataset

B) The most frequent value

C) The average of all numbers

D) The range between values

A

B) The most frequent value

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Before employees access data outside the office on mobile devices, which legislation must they be familiar with? (Multiple Response)

A) Data Protection Act (2018)

B) Computer Misuse Act (1990)

C) Freedom of Information Act (2000)

D) GDPR Regulation (2018)

A

A) Data Protection Act (2018)
B) Computer Misuse Act (1990)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What should be considered when designing a one-page business form? (Multiple Response)

A) Use of bright colours

B) Positioning of fields

C) Volume of information

D) Font style only

A

B) Positioning of fields
C) Volume of information

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What should action minutes from a meeting include?

A) Attendees

B) Apologies

C) Agenda items

D) Actions to be taken

A

All of the above (A, B, C, D)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Which of the following are good backup practices? (Multiple Response)

A) Done by user only

B) Carried out regularly by network manager

C) Kept off-site for security

D) Carried out by user themselves

A

B) Regular network manager backups
C) Kept off-site
D) User-initiated backups (also encouraged)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What does the Employment Rights Act (1996) cover?

A) Maternity rights

B) Workplace discrimination

C) Discipline and dismissal

D) Data privacy

A

C) Discipline and dismissal

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What are benefits of an organisational house style? (Multiple Response)

A) Supports company image

B) Ensures consistency

C) Boosts productivity

D) Reduces costs

A

A) Supports company image
B) Ensures consistency

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What ensures a meeting is run effectively? (Multiple Response)

A) Booking room & refreshments

B) Distributing agenda/notice

C) Providing documents in advance

D) Assigning a dress code

A

A), B), and C) are correct

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

In a review of a system, what steps occur? (Multiple Response)

A) Consider legal implications

B) Research good practice

C) Examine current procedures

D) Distribute minutes

A

A) Consider legal implications
B) Research good practice
C) Examine current procedures

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Organisational charts help with: (Multiple Response)

A) Showing number of levels

B) Identifying line management

C) Presenting sales data

D) Managing budgets

A

A) Showing number of levels

B) Identifying line management

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What does the Data Protection Act (1998) cover?

A) Corporate data

B) Government secrets

C) Data identifying a living individual

D) Patents

A

C) Identifiable personal data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What legislation must employees be aware of before accessing info outside the office? (Multiple Response)

A) Data Protection Act (2018)

B) Display Screen Equipment Regulations (1992)

C) RIDDOR

D) COSHH

A

A) Data Protection
B) Display Screen Equipment Regulations (1992) — relevant to screen and device use

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Which of these are employer responsibilities under the Health & Safety at Work Act (1974)? (Multiple Response)

A) Cooperate on safety matters

B) Identify job hazards

C) Provide free meals

D) Review policies annually

A

A) Cooperate
B) Identify and manage hazards

17
Q

Why must practices and procedures be non-discriminatory?

A) It’s good PR

B) It’s the law

C) It prevents conflict

D) It supports good business practice

A

B) It’s the law
D) Good business practice

18
Q

In Health and Safety, what is a hazard?

A) A near miss

B) Something that could cause harm

C) A legal breach

D) An inconvenience

A

B) Something that could cause harm

19
Q

What skills support excellent customer service? (Multiple Response)

A) Attentiveness

B) Empathy

C) Product knowledge

D) IT skills

A

A) Attentiveness
B) Empathy
C) Product knowledge

20
Q

What does “Addendum” mean in meeting terms?

A) A summary of the agenda

B) A note about a typo

C) A query or clarification regarding meeting rules

D) A formal break in the meeting

A

C) A query raised regarding procedure, standing orders, or quorum