ICT SA1

Question 1

Under which tab is the “Sort and filter” command present?

Answer 1

Home tab

Question 2

What do we use the “Sort A to Z” option to sort?

Answer 2

Text

Question 3

Where does a small arrow appear when we apply filter feature?

Answer 3

Column headers

Question 4

Which of the following is not a category used in conditional formatting?
a. Data bars
b. A to Z
c. Top/Bottom rules
d. Icon sets

Answer 4

b. A to Z

Question 5

What option is used to remove conditional formatting?

Answer 5

Clear rules

Question 6

Give an example of a cloud storage service provider.

Answer 6

One drive

Question 7

What is the account you must have to use One Drive?

Answer 7

Microsoft account

Question 8

Give examples of social networking websites.

Answer 8

Facebook, Twitter, LinkedIn.

Question 9

What is the process of writing blogs called?

Answer 9

Blogging.

Question 10

What is the process of making digital recordings that are available for download?

Answer 10

Podcasting

Question 11

In what way can Excel arrange data

Answer 11

In ascending and descending order.

Question 12

Is the “add level” button available under the insert tab?

Answer 12

No, its not

Question 13

What kind of data can be used with conditional formatting?

Answer 13

Numeric data

Question 14

What does COD stand for?

Answer 14

Cash on Delivery

Question 15

What is the biggest social networking website by number of users?

Answer 15

Facebook

Question 16

Companies can rent or buy_ from a service provider instead of owning and maintaining the complete computing infrastructure.

Answer 16

Cloud storage

Question 17

Write names of two modes of payment

Answer 17

Debit or Credit card and Net banking.

Question 18

Name two things that you cannot do on Quora.

Answer 18

1-You cannot argue on any topic or raise a conflict.
2-You cannot promote business ideas or market your products.

Question 19

What do you know about the “where you are logged in” feature of Facebook?

Answer 19

This feature helps you find all of your active Facebook logins from any device.

Question 20

Write two risks involved in cloud computing.

Answer 20

1-Some people might lose their data
2-Sensitive data might be at risk from hackers

Question 21

Define sorting(data)

Answer 21

Sorting of data means to organize in ascending or descending order.

Question 22

How do you remove filters in Excel?

Answer 22

Click anywhere in the worksheet and repeat steps to apply filters, filter arrows on column headers disappear while hidden rows reappear.

Question 23

What command is used to hide unimportant data?

Answer 23

Sort and filter

Question 23

Why is custom sorting used?

Answer 23

Custom sorting is used to apply sorting on more than one column in a selected range.

Question 24

Define network.

Answer 24

A network is a group or system of interconnected people or things.

Question 25

How do ATM facilities help us?

Answer 25

The ATM is part of e-banking that lets you withdraw cash, and the amount is removed from your account automatically.

Question 26

Define blog, and give two types of blogs.

Answer 26

Blog is the shortform of WEBLOG which refers to a website where new information is updated regularly. e.g. Personal blogs, Travel blogs

Question 27

What are the key features of skype?

Answer 27

-Translating the conversation if the other person is talking in another language -Safe way to have a conversation without interruption -Sharing screen -live subtitle option which helps deaf people

Question 28

Write the steps to apply conditional formatting.

Answer 28

Step 1.Select the data you want to conditionally format Step 2.Click the "Conditional formatting" command from the styles group in the home tab Step 3. Choose the desired conditional formatting from the drop-down list, and it should be applied

Question 29

What is the difference between sorting data and filtering data?

Answer 29

-Sorting data Sorting data is organizing data in ascending or descending order, Excel allows you to sort both numeric and textual data. -Filtering data Filtration process is used to separate unwanted material from the mixture, Excel allows us to filter from a data set.