Question

a. Kanika is a Chartered Accountant. She looks after the accounts of various companies and keeps their records in Microsoft Excel. She does not have any idea on how to view only those records that she wants to see. Suggest the feature of Microsoft Excel, using which she can perform this task.
1 point
DATA> SORT FILTER > FILTER
DATA>UNSORT FILTER > FILTER
None
b. Varun is maintaining the marksheet of his class in Microsoft Excel. The teacher has asked him to restrict the marks entries between 1 and 100 in all the subjects. Which feature of Microsoft Excel should Varun use in order to accomplish the task?
1 point
DATA VALIDATION FEATURE
DATA CHECKING FEATURE
None
Q 3 In Binary addition, 1+1 equals to ....................... .
1 point
10
11
None
Q 4 .A database helps the user to ......................., retrieve, sort and edit data as needed.
1 point
ORGANISE
MANAGE
None
Q 5. A ....................... window or a screen that contains numerous fields or spaces to enter, modify, and view one record at a time.
1 point
FORM
COPY
None
Q 6 To search for a record with specific value, click on the ....................... button in a form.
1 point
CRITERIA
CONDITION
None
Q 7. Sorting means to arrange data either in ascending or descending order.
1 point
True
False
None
Q 8 . Filtering is a quick way to find a set of data in a range.
1 point
True
False
None
Q 9. A collection of related tables with data is called a database.
1 point
True
False
None
Q 10. Number System is not a set of values used to represent different quantities.
1 point
True
False
None

Answer 1

Answer:

Hope it helps!! Mark this answer as brainliest if u found it useful.

Explanation:

1) I would suggest her to use data filter option of ms excel

2) THE FILTER OPTION IS A WAY TO RESTRICT OR NARROW THE DATA. FILTERS CAN BE APPLIED ON BOTH DATA TABLES AND CHARTS. VARUN CAN USE THE FILTER OPTION AND CAN FILTER THE DATA IN ANY WAY HE WANTS. SOME FILTERS ARE - GREATER THAN, LESS THAN, EQUAL TO ETC.

3)  10

4) save

5 database

6)  CTRL+F

7) True

8) False

9) True

10) False (A set of values used to represent different quantities is known as Number System.)

Answer 2

Answer:

khud karle. jsjsjkdkakdnhc bsdkjajkakdnndjajajsmadarchodjajsjndnsnajbahanchodjajsnndnsjs