Question

A. Multiple Choice Questions
1.
A...
2.
3.
resembles a fill-in-the-blank sheet.
(a) Report
(b) Form
(c) Record
We can add Form button in the ...
of the Excel Window,
(a) Title Bar
(b) Quick Access Toolbar
(c) None of these
To sort data, we use
tab on the Ribbon.
(a) Home
(b) Data
(c) View
is a quick way to find a set of data in a range.
(a) Sorting
(b) Filtering
(c) Grouping
The subtotal option is present in the
group of Data tab.
(a) Sort & Filter (b) Data tools
(c) Outline
4.
5.
21
Computers • 2​

Answer 1

Concept introduction:

Transmissible storage computer information is known as data. It consists of facts and figure.

Explanation:

Given that, fill in the blanks.

We have to find, suitable option that fits into the blank.

According to the question,

1. (b) Form. Form resembles a fill-in-the-blank sheet.
2. (b) Quick Access Toolbar. We can add Form button in the Quick Access Toolbar of the Excel Window.
3. (b) Data. To sort data, we use Data tab on the Ribbon.
4. (b) Filtering. Filtering is a quick way to find a set of data in a range.
5. (c) Outline. The subtotal option is present in the group of Data tab is outline.

Final Answer:

1. (b) Form.
2. (b) Quick Access Toolbar.
3. (b) Data
4. (b) Filtering
5. (c) Outline

#SPJ3

Answer 2

Answer:

The form resembles a fill-in-the-blank sheet.

We can add the Form button in the Quick Access Toolbar of the Excel Window.

To sort data, we use the Data tab on the Ribbon.

Filtering is a quick way to find a set of data in a range.

The subtotal option is present in the Outline group of the Data tab.

EXPLANATION:

1. A form is like a virtual fill-in-the-blank sheet. We fill our details in a form just like the physical sheet.
2. A quick access toolbar is present in Microsoft excel that is used to add the form button quickly.
3. The data entered in any column of excel can be sorted in either ascending or descending order using the data tab present on the ribbon.
4. Filters are applied to visualize only a particular set of data. They show only that range of data that matches our criteria.
5. The subtotal option is present in the Outline group of data tab.

#SPJ2