ICT

Question 1

____________ is the infrastructure and components that enable modern computing.

Answer 1

ICT, or information and communications technology (or technologies)

Question 2

what are the USES OF ICT IN OUR DAILY LIVES

Answer 2

1. COMMUNICATION:
2. Job Opportunities:
3. Education:
4. Socializing:

Question 3

Nowadays people are in touch with the help of ICT. Through chatting, E-mail, voice mail and social networking people communicate with each other. It is the cheapest means of communication.

Answer 3

COMMUNICATION:

Question 4

In the employment sector, ICT enables organizations to operate more efficiently, so employing staff with ICT skills is vital to the smooth running of any business.

Answer 4

Job Opportunities:

Question 5

ICT provides the flexibility and availability of learning materials to all students. While all resources are available in classrooms, students can also access them outside schools.

Answer 5

Education:

Question 6

Social media has changed the world. The rapid and vast adoption of these technologies is changing how we find partners, how we access information from the news, and how we organize to demand political change.

Answer 6

Socializing:

Question 7

What are the Positive Impacts of
Information and Communication Technology

Answer 7

1. ACCESS TO INFORMATION:
2. IMPROVED ACCESS TO EDUCATION:
3. NEW TOOLS, NEW OPPORTUNITIES:
4. COMMUNICATION:
5. INFORMATION MANAGEMENT:
6. SECURITY:
7. PEOPLE PARTICIPATION:
8. DISTANCE LEARNING:
9. TESTING AND EXPERIMENTS:
10. CREATION OF NEW MORE INTERESTING JOBS:

Question 8

Examples would be systems analysts, programmers and software engineers, as well as help desk operators and trainers.

Answer 8

CREATION OF NEW MORE INTERESTING JOBS:

Question 9

ICT facilitates the ability to perform ‘impossible’ experiments’ by using simulations.

Answer 9

TESTING AND EXPERIMENTS:

Question 10

Students can access teaching materials from all over the world.

Answer 10

DISTANCE LEARNING:

Question 11

ICT allows people to participate in a wider, even worldwide, society.

Answer 11

PEOPLE PARTICIPATION:

Question 12

: ICT solves or reduces some security problems, e.g., Encryption methods can keep data safe from unauthorized people, both while it is being stored or while it is being sent electronically.

Answer 12

SECURITY

Question 13

Data mining of customer information to produce lists for targeted advertising.

Answer 13

INFORMATION MANAGEMENT:

Question 14

Cost savings by using e.g., VoIP instead of normal telephone, email / messaging instead of post, video conferencing instead of traveling to meetings, e-commerce web sites instead of sales catalogues. Access to larger, even worldwide, markets.

Answer 14

COMMUNICATION:

Question 15

ICT gives access to new tools that did not previously exist.

Answer 15

NEW TOOLS, NEW OPPORTUNITIES:

Question 16

Distance learning and online tutorials. New ways of
learning, e.g., interactive multi-media and virtual reality.

Answer 16

IMPROVED ACCESS TO EDUCATION:

Question 17

All you need is a phone and access to the Internet to find what you need. Thousands of resources are available on various online platforms, making it convenient for someone to search for the information they need.

Answer 17

ACCESS TO INFORMATION:

Question 18

What are the Negative Impacts of
Information and Communication Technology

Answer 18

1. JOB LOSS:
2. REDUCED PERSONAL INTERACTION:
3. REDUCED PHYSICAL ACTIVITY:
4. COST:
5. COMPETITION:

Question 19

____________is a spreadsheet program that help us to store and represent the data in tabular form, manage and manipulate data, create optically logical charts, and more.

Answer 19

Microsoft Excel

Question 20

Provides you the worksheet to create a new document in it.

Answer 20

Microsoft Excel

Question 21

it’s used to create grids of text, numbers and formulas specifying calculations.

Answer 21

Microsoft Excel

Question 22

________are the specific groups of related commands.

Answer 22

TABS:

Question 23

________it contains multiple commands that divided into groups.

Answer 23

RIBBON:

Question 24

_______a set of closely related commands normally performed as part of a larger task.

Answer 24

GROUP:

Question 25

_________a group that brings up more related commands.

Answer 25

LAUNCH BUTTON:

Question 26

________- are made up of columns and rows.

Answer 26

Spreadsheet

Question 27

the intersection of rows and columns is called a ______

Answer 27

Cell

Question 28

A ______ is a group of cells that are together.

Answer 28

range

Question 29

A _______ is a file that contains one or more worksheets to help us organize data.

Answer 29

workbook

Question 30

_______ a single page or sheet within the workbook.

Answer 30

Worksheet

Question 31

Steps in Creating a workbook

Answer 31

1. Open the Microsoft excel 2. Select blank workbook. 3. Select an empty cell. 4. Then type any data. 5. Save your workbook.

Question 32

Steps in Modifying a workbook

Answer 32

The two ways to modify a workbook 1. Edit the data itself, such as the labels, numbers, and formulas that make up a spreadsheet. 2. Edit the physical layout of the spreadsheet, such as adding or deleting rows and columns.

Question 33

Steps in Modifying Worksheet

Answer 33

1. Display the worksheet that you want to edit. 2. Then save changes you have made and return to the worksheet.

Question 34

Steps in Merge and unmerge cell

Answer 34

1. Merging combines two or more cells into a single cell. It’s a great way to create a label or header that will fit together. 2. Unmerge cell get things back to normal.

Question 35

It’s a great way to create a label or header that will fit together.

Answer 35

Merging

Question 36

Customize the Excel 2016 app window You can personalize the ribbon with things like:

Answer 36

1. Adding buttons to the Quick Access Toolbar 2. Rearrange tabs, in the order you want. 3. Creating a new ribbon tab 4. Adding group to ribbon tab

Question 37

______can replicate the same across the remaining cells in the column.

Answer 37

Flash Fill

Question 38

It recognizes the pattern and completes it.

Answer 38

Flash Fill

Question 39

How to Move Data within a Workbook

Answer 39

Select the worksheet tab, and drag it to where you want it to move a portion of the data within a workbook.

Question 40

Sometimes we need to_____ multiple excel cells to make them fit the text content.

Answer 40

expand

Question 41

Formulas always start with an_________, which can be followed by numbers, math operations, and functions

Answer 41

equal sign (=)

Question 42

_______ finds the total of values in cells

Answer 42

SUM function

Question 43

________- allows you to make logical comparisons between a value and what you expect.

Answer 43

IF function

Question 44

_______is a series of data in a row, column or combination of rows and column

Answer 44

Array

Question 45

_______ performs calculations on a data in one or more arrays returning a single or multiple results. ________

Answer 45

1. Array formula 2. ctrl shift enter

Question 46

How to Find and Correct errors in calculations

Answer 46

1. #DIV/0! 2. #NAME?

Question 47

true or false: Adding limit to your worksheet allows you to better analyze your data.

Answer 47

true

Question 48

_______ is the process of choosing a smaller part of your data set and using that subset for viewing or analysis.

Answer 48

Data filtering

Question 49

_______ is the changing of data to make it easier to read or be more organized and to display information to users in a more meaningful way based on data formatting defined by a user.

Answer 49

Data manipulation

Question 50

Define valid sets of values for ranges of cells

Answer 50

1. Sort worksheet data 2. Sort data by using custom lists 3. Organize data into levels 4. Look up information in a worksheet 5.Link to data in other worksheets and workbooks