module 4 & 5

Question 1

TYPES OF SOFTWARE

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

Answer 1

system software

Question 2

TYPES OF SOFTWARE

system software that controls the working of computer hardware and software

Answer 2

operating system

Question 3

TYPES OF SOFTWARE

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

Answer 3

utility software

Question 4

TYPES OF SOFTWARE

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

Answer 4

application software (apps)

Question 5

TYPES OF SOFTWARE

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

Answer 5

general purpose applications

Question 6

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

Answer 6

business applications

Question 7

TYPES OF SOFTWARE

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

Answer 7

costum developed applications

Question 8

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

Answer 8

programming software

Question 9

TYPES OF SOFTWARE

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

Answer 9

freeware

Question 10

TYPES OF SOFTWARE

give common examples of freeware

Answer 10

• Google Chrome
• Skype
• Instagram
• Snapchat
• Adobe reader

Question 11

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’.

Answer 11

shareware

Question 12

TYPES OF SOFTWARE

give examples of shareware

Answer 12

• Adobe PhotoShop
• Adobe Illustrator
• Netflix App
• Matlab
• McAfee Antivirus

Question 13

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

Answer 13

open source software

Question 14

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.

Answer 14

closed source (proprietor software)

Question 15

CHALLENGES IN SOFTWARE UPDATES

Protecting software from unauthorized access and cyber threats.

Answer 15

security concern

Question 16

CHALLENGES IN SOFTWARE UPDATES

Ensuring software works seamlessly across different devices and platforms.

Answer 16

compatibility issues

Question 17

CHALLENGES IN SOFTWARE UPDATES

Keeping up with evolving technologies and framework

Answer 17

rapid technological changes

Question 18

SPREADSHEET FEATURES

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

Answer 18

spreadsheet

Question 19

SPREADSHEET FEATURES

multiple sheets can be
combined to create ___

Answer 19

workbook

Question 20

SPREADSHEET FEATURES

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

Answer 20

visual design

Question 21

SPREADSHEET FEATURES

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

Answer 21

automatic calculations

Question 22

SPREADSHEET FEATURES

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

Answer 22

dynamic updates

Question 23

SPREADSHEET FEATURES

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

Answer 23

data analysis

Question 24

SPREADSHEET FEATURES

collection of rows and columns

Answer 24

worksheet

Question 25

SPREADSHEET FEATURES

o It is the Syntax of the operation to be used
o Used to perform calculations

Answer 25

formulas

Question 26

SPREADSHEET FEATURES

premade formulas

Answer 26

functions

Question 27

EXCEL

considered the “gold standard of spreadsheets”

Answer 27

microsoft excel

Question 28

EXCEL ERRORS

When the formula contains some incorrect cell references. Happens mainly when a row or column is mistakenly deleted.

Answer 28

REF! (Reference Error)

Question 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)

Answer 29

N/A (No Value Available error)

Question 30

EXCEL ERRORS

When the formula contains numeric values that are not valid.

Answer 30

NUM!

Question 31

EXCEL ERRORS

When we reference the same cell in which we are writing the function or formula.

Answer 31

Circular Reference Error

Question 32

EXCEL ERRORS

width of column is too small

Answer 32

(Width Error)

Question 33

EXCEL ERRORS

when the text is not recognized in the formula

Answer 33

NAME? (Name Error)

Question 34

EXCEL ERRORS

when a variable mentioned in the formula is wrong

Answer 34

VALUE! (Value Error)

Question 35

EXCEL ERRORS

attempt to divide a number by zero

Answer 35

DIV/0! (Division Error)

Question 36

EXCEL ERRORS

when you forget to separate two cell references correctly

Answer 36

NULL! (Null Error)