ICT Flash Cards > Software Skills > Flashcards

Software Skills Flashcards

(56 cards)

Study These Flashcards
1
Q

What is relative cell referencing

A

This is when the cell references in the formulae or function changes, but the structure of the formulae or function remains constant.

The cell references will refer to cells that are in the same relative position of the new cell, to that of the original cell.

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

What is a single operator forumla

A

This is a formula that only contains a single operator. Ex : A3 + B4

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

Advantages of linking worksheets in a spreadsheet

A

When data is changed in one worksheet, the data in the linked cells of the linked worksheet will also get updated. This reduces human error.

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

What are logical functions

A

These are functions that return values after a test has been carried out using conditions and evaluates whether the outcome is true or false

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

Advantages of having multiple worksheets

A

It makes the spreadsheet more organized and easier to read and understand how the spreadsheet works and what it is representing.

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

Advantages of displaying data in graphs

A

This makes it easier for the reader to read, analyze and understand the data because it displays the data in a visual format.

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

Types of Charts and their functions

A
  1. Pie Chart : This is a chart that is used to show the proportion of data from a whole
  2. Bar Chart : This chart is used to show the comparison between 2 sets of data values.
  3. Line Chart : This chart is used to show the trend in data changes as time passes.
  4. Scattergram : This chart is used to show the relationship between two sets of data values.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What are the important sections in file management

A
  1. Appropriate and meaningful file names
  2. Appropriate File Formats
  3. Security of the Files
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

How can data you were working on be retrieved if an application crashes.

A

Applications save your work in a temporary file so that the work can be retrieved from there if you did not save it.

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

Why is reverse data order (year / month / day) used when naming files

A

So that the files will be sorted according to date when sorted by name

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

What are the advantages of using Folders

A
  1. They don’t need to repeat the same text when typing the file name, this reduces human data entry errors and makes the process faster and efficient.
  2. It also makes the files more organized and easily accessible and understandable, which makes it easier to find the file you are looking for.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What are the 2 types of file formats

A
  1. Published file formats

2. Application file formats

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

What are published file formats

A

When applications are stored as published file formats. they can be viewed by the user in a variety of application. Ex : .PDF or .TXT . However, it is harder for the user to edit the file because it has been exported and can only be viewed.

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

What are application file formats

A

When files are stored as application file formats, they can only be opened using a specific type of application. Ex : .xlsx or .accdb . However, these allow the user to edit the file very easily.

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

Why do you need to regularly save your files

A

To prevent data loss that can occur due to a power failure or an application crash because data is stored in the RAM, which is volatile, and not saved in the secondary storage if it is not saved.

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

What is the page layout

A

This states how content is placed on a page

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

Why are bullet points used

A

They are used to emphasize key points in your document.

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

What are the types of formatting in a word processed application

A
  1. Paragraph formatting
  2. Font
  3. Alignment
  4. Text Boxes
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Why are some lists numbered

A

Numbering shows a particular order in the list and gives priority to certain items on the list, over others.

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

What is the use a a template

A

Templates are used to give digital products produced by an organization a certain amount of consistency. This increases the professional-look in documents produced by an organization and makes them look more formal

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

How do layers allow uses to create images

A

Layers allow users to place images on top of or beneath elements on the z-axis.

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

A drawback of using vector images for natural objects.

A

Vector images often look very stylized and unreal

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

Advantages of having the presenter view in presentation software

Study These Flashcards
A
  • The user will not need to print the notes for the presentation. This reduces the amount of paper used, thus making it better for the environment.
24
Q

Examples for row and column headings

Study These Flashcards
A

A, B, C, D, E, F, G or 1,2,3,4,5,6,7

25
Examples for row and column headers
firstname, lastname, age, DoB
26
What are the advantages of using Named Ranges
These make the cells more humanly readable and understandable and the cell references do not have to be remembered. Cells with named ranges are also automatically set to be constant and fixed, meaning that the user does not have to manually absolute reference the cells in the named range.
27
How does VLOOKUP work
It finds a given value in the first column of a given table array and then returns the corresponding value from a given column.
28
Why is referential integrity used in a database
It makes sure that data from a foreign table can be entered into a related table only if the related record exists in the foreign table. This reduces data entry errors.
29
What are fields
These are used to store attributes about entities
30
What are records
These are used to store data about entities
31
Why is validation used in a database
To reduce the number of data entry errors, keeping the data more consistent To make sure that the data entered is acceptable and reasonable.
32
How does the lookup function work
It looks up the given value in the lookup vector and then moves to the result vector to return the corresponding value.
33
What are presentations used for
They contain images, videos, text, or animations that are used to support a speaker during a presentation to an audience. They help to engage the audience.
34
What are the advantages of using a slide master
They provide a more consistent layout for the slides.
35
What is a placeholder
This is an area in a layout to which content can be placed.
36
What are the changes that can be made to a master slide in a presentation
1. Placeholders ( Ex: Image placeholders, text placeholders, content placeholders) 2. Background ( Ex: a background image or background color) 3. Font enhancements (Ex: Bold, Italics, or underlining.)
37
Why should a presentation contain as little text as possible
To make sure that the audience is able to listen and focus on the speaker's talk rather than trying to read a lot of text on the presentation.
38
What are the types of content that you can add to a presentation
1. Text and Images. 2. Animations 3. Transitions 4. Hyperlinks 5. Action Buttons
39
What is the difference between animations and transitions
Transitions are applied to the slide and animations are applied to the content in the slides.
40
Advantage of applying the same transition to all slides in the presentation
This improves the consistency of the slides in the presentations.
41
What are the different types of layouts available to print your presentation in
1. Handouts 2. Notes Page 3. Full page
42
What is the advantage of using the handouts layout for printing presentations
This gives the audience a copy of the presentation, allowing them to easily follow the speaker's talk and even take notes on the speaker's talk.
43
What is the advantage of having a presentation printed as a notes page
This gives the presenter the freedom to easily move around the stage when delivering his presentation while they control the presentation remotely.
44
What is the use of full-page slides
These are used to allow the user to create posters from the presentation
45
Why are action buttons useful for presentations running in Kiosk mode
To provide navigation to users because most presentations running in Kiosk mode are running on touchscreens, where users do not have access to a keyboard or mouse.
46
How can presenter view help a presenter give a presentation
1. Presenter view allows the presenter to glance at the time taken for the presentation by providing timing options. 2. Presenter view also allows the presenter to get ready for the next slide by showing the next slide as a thumbnail. 3. Presenter view shows the notes for the slide the presenter is displaying and allows them to make certain key points in the presentation and draw the user's attention to certain animations.
47
How can you improve a webpage that you create
1. Adding Alt text so that screen readers will be able to read them and help people with
48
What is an attribute in HTML
This is something that provides additional information about an HTML tag
49
What is a required attribute in HTML
This is an attribute that is required for an HTML tag to work as intended.
50
What are the different target attributes that can be added to an anchor tag when creating a hyperlink and their explanation?
_blank : Opens it in a new window or tab _self : Opens it in the same frame as the frame in which it was clicked. _parent : Opens it in the parent frame _top : Opens it in the full body of the page.
51
Why is it not always a good idea to use tags when creating a webpage
- Because hyperlinks on a webpage are also underlined. Therefore, underlining text that is not a hyperlink may end up confusing the user
52
What is a report
A report is a formal document that is used to bring together information about a specific topic.
53
What is a newsletter
This is a less formal way of distributing information, typically to a club or society
54
What are memos
These are short messages that are used to convey information and messages clearly and quickly.
55
What are the advantages of mail merge
Personal information of users does not have to be manually entered for each person, instead, the user can make one letter and insert personal information from a data source of other's personal information. This saves time and reduces the amount of human error that can occur.
56
How does mail merge work/
A data source gets selected and fields from the data source are inserted into a letter. Then they are populated by selected records.
ICT Flash Cards
flashcards
Decks in class (14)
# Cards
Brainscape helps you reach your goals faster, through stronger study habits.
© 2026 Bold Learning Solutions. Terms and Conditions