ICT SA1 Flashcards
Under which tab is the “Sort and filter” command present?
Home tab
What do we use the “Sort A to Z” option to sort?
Text
Where does a small arrow appear when we apply filter feature?
Column headers
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
b. A to Z
What option is used to remove conditional formatting?
Clear rules
Give an example of a cloud storage service provider.
One drive
What is the account you must have to use One Drive?
Microsoft account
Give examples of social networking websites.
Facebook, Twitter, LinkedIn.
What is the process of writing blogs called?
Blogging.
What is the process of making digital recordings that are available for download?
Podcasting
In what way can Excel arrange data
In ascending and descending order.
Is the “add level” button available under the insert tab?
No, its not
What kind of data can be used with conditional formatting?
Numeric data
What does COD stand for?
Cash on Delivery
What is the biggest social networking website by number of users?
Companies can rent or buy_ from a service provider instead of owning and maintaining the complete computing infrastructure.
Cloud storage
Write names of two modes of payment
Debit or Credit card and Net banking.
Name two things that you cannot do on Quora.
1-You cannot argue on any topic or raise a conflict.
2-You cannot promote business ideas or market your products.
What do you know about the “where you are logged in” feature of Facebook?
This feature helps you find all of your active Facebook logins from any device.
Write two risks involved in cloud computing.
1-Some people might lose their data
2-Sensitive data might be at risk from hackers
Define sorting(data)
Sorting of data means to organize in ascending or descending order.
How do you remove filters in Excel?
Click anywhere in the worksheet and repeat steps to apply filters, filter arrows on column headers disappear while hidden rows reappear.
What command is used to hide unimportant data?
Sort and filter
Why is custom sorting used?
Custom sorting is used to apply sorting on more than one column in a selected range.
Define network.
A network is a group or system of interconnected people or things.
How do ATM facilities help us?
The ATM is part of e-banking that lets you withdraw cash, and the amount is removed from your account automatically.
Define blog, and give two types of blogs.
Blog is the shortform of WEBLOG which refers to a website where new information is updated regularly.
e.g. Personal blogs, Travel blogs
What are the key features of skype?
-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
Write the steps to apply conditional formatting.
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
What is the difference between sorting data and filtering data?
-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.
