module 4 & 5 Flashcards

(36 cards)

1
Q

TYPES OF SOFTWARE

helps the user, hardware, and application software to interact and function together. This is essential in managing the whole computer system

A

system software

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

TYPES OF SOFTWARE

system software that controls the working of computer hardware and software

A

operating system

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

TYPES OF SOFTWARE

system software that helps to maintain the proper and smooth functioning of a computer system

A

utility software

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

TYPES OF SOFTWARE

this is what you engage with the most
This is productive end-user programs that help you perform tasks

A

application software (apps)

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

TYPES OF SOFTWARE

It is designed to perform a wide range of fundamental functions that a user needs to perform on a system

A

general purpose applications

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

TYPES OF SOFTWARE

It is a type of application software designed to fulfill specific business function and operations
* These are presumed to improve the accuracy and efficiency of business operations

A

business applications

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

TYPES OF SOFTWARE

It is solely built for some specific organization or user based on business requirements

A

costum developed applications

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

TYPES OF SOFTWARE

the type of software that is not used by end-user. Programs that are used to write, develop, test, and debug other software, including apps and system software

A

programming software

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

TYPES OF SOFTWARE

any software that is available to use for free. They can be downloaded and installed over the internet without any cost

A

freeware

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

TYPES OF SOFTWARE

give common examples of freeware

A
  • Google Chrome
  • Skype
  • Instagram
  • Snapchat
  • Adobe reader
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

TYPES OF SOFTWARE

are software applications that are paid programs, but are made available for free for a limited period of time known as ‘trial period’.

A

shareware

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

TYPES OF SOFTWARE

give examples of shareware

A
  • Adobe PhotoShop
  • Adobe Illustrator
  • Netflix App
  • Matlab
  • McAfee Antivirus
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

TYPES OF SOFTWARE

open-source code that is available to use for all users. It can be modified and shared with anyone for any purpose

A

open source software

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

TYPES OF SOFTWARE

These are the types of software that are non-free for the programmers. For this software, the source code is the intellectual property of software publishers.

A

closed source (proprietor software)

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

CHALLENGES IN SOFTWARE UPDATES

Protecting software from unauthorized access and cyber threats.

A

security concern

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

CHALLENGES IN SOFTWARE UPDATES

Ensuring software works seamlessly across different devices and platforms.

A

compatibility issues

17
Q

CHALLENGES IN SOFTWARE UPDATES

Keeping up with evolving technologies and framework

A

rapid technological changes

18
Q

SPREADSHEET FEATURES

interactive computer application for organization, analysis and storage of data in tabular form

19
Q

SPREADSHEET FEATURES

multiple sheets can be
combined to create ___

20
Q

SPREADSHEET FEATURES

Built-in tools to showcase your data visually, including bar charts, graphs and pie charts in a variety of styles and colors

A

visual design

21
Q

SPREADSHEET FEATURES

It automatically recalculates all dependent formulas every time any value, formula, or name referenced in those formulas is changed

A

automatic calculations

22
Q

SPREADSHEET FEATURES

It automatically updates values in cells or ranges in a worksheet that is reference from another worksheet or program.

A

dynamic updates

23
Q

SPREADSHEET FEATURES

It provides a set of data analysis tools which you can use to save steps when you develop complex statistical analyses.

A

data analysis

24
Q

SPREADSHEET FEATURES

collection of rows and columns

25
# SPREADSHEET FEATURES o It is the Syntax of the operation to be used o Used to perform calculations
formulas
26
# SPREADSHEET FEATURES premade formulas
functions
27
# EXCEL considered the "gold standard of spreadsheets"
microsoft excel
28
# EXCEL ERRORS When the formula contains some incorrect cell references. Happens mainly when a row or column is mistakenly deleted.
#REF! (Reference Error)
29
# EXCEL ERRORS When a number you are referring to in your formula does not exist. (ex. when a sheet used in the formula was deleted)
#N/A (No Value Available error)
30
# EXCEL ERRORS When the formula contains numeric values that are not valid.
#NUM!
31
# EXCEL ERRORS When we reference the same cell in which we are writing the function or formula.
Circular Reference Error
32
# EXCEL ERRORS width of column is too small
(Width Error)
33
# EXCEL ERRORS when the text is not recognized in the formula
#NAME? (Name Error)
34
# EXCEL ERRORS when a variable mentioned in the formula is wrong
#VALUE! (Value Error)
35
# EXCEL ERRORS attempt to divide a number by zero
#DIV/0! (Division Error)
36
# EXCEL ERRORS when you forget to separate two cell references correctly
#NULL! (Null Error)