Computer Science, asked by hamidmaryam974, 6 months ago

Electronic Spreadsheet
A. Multiple Choice Questions
1. Which of the following technique can be used to allow only date value in cell?
(a) Data formatting (b) Data sorting (c) Data filtering (d) Data validation Check Your Progress Unit
2. Which of the following options when selected deletes all data validation?
(a) Delete formatting (b) Delete all (c) Delete formula (d) Delete me
3. We can replace multiple occurrences of a word using which of the following facilities of Calc?
(a) Find and replace (b) By replace only (c) By copy command (d) By preview command
4. What is the name of mechanism to arrange the data in a particular order?
(a) Sorting (b) Searching (c) Filtering (d) Validating
5. What is the name of mechanism to filter out unnecessary data?
(a) Sorting (b) Searching (c) Filtering (d) Validating
6. Which of the following type of package does Calc refer to?
(a) Spreadsheet (b) Double sheet (c) Multi-sheet (d) Cannot determine
7. Which of the following is an extension of a worksheet created in Calc?
(a) .ods (b) .odd (c) .xls (d) .obj
8. How can one calculate the total of values entered in a worksheet column of?
(a) By manual entry (b) By auto-sum (c) By formula (d) By sum function
9. If we move a cell containing a formula having reference to another cell in the worksheet what will happen to the cell numbers used in the formula?
(a) The cell row and columns are changed at destination. (b) The cell row change at destination. (c) The cell columns are changed at destination. (d) No change will scour.
10. What is the correct way to enter a function in Calc?
(a) Directly typing function name in a cell (b) Using function wizard or selecting from toolbar (c) Both (a) and (b) (d) Depends on the function
11. A function should start with______.
(a) ‘=’ sign (b) alphabets (c) numbers (d) All of the these
12. Which of the following option is used to print a chart?
(a) Insert → Chart (b) File → View (c) File → Print (d) View → Chart
13. How many axes does charts in Calc have?
(a) Two (b) Three (c) Two or three (d) Four
14. The chart preview can be seen in.
(a) Page preview (b) Chart preview (c) Export chart (d) All of these
B. Fill in the blanks
1. The column immediately next to column “Z” is _.
2. The default extension of a workbook created using a LibreOffice Calc spreadsheet is _.
3. The spreadsheet feature used to continue the series is called as ____.
4. The formula “=MIN(C1:C5)” stored in cell C6 when copied to cell D6 changes to .
5. The formula in cell A2 is =B2+C3. On copying this formula to cell C2, C2 will change to _.
6. The cell address of the cell formed by the intersection of the ninth column and the eighth row will be _.
7. $A1$B2 is an example of _ referencing in spreadsheet software.
8. Numbers entered into a cell are automatically _ aligned.
9. If A1:A5 contain the numbers 16, 10, 3, 25 and 6 then =Average(A1:A5;60) will display.
10. In _____referencing, the reference changes rows and columns automatically when it is copied to a new cell.
C. State whether the following statements are True or False
1. A cell is a combination of row and column.
2. A spreadsheet is also called as worksheet.
3. There are ‘n’ number of sheets in a spreadsheet.
4. In a spreadsheet, we can change the column width and row height.
5. $A1$B2 is an example of mixed referencing.

Answers

Answered by sujatakadali

Answer:

$\huge{\boxed{\mathfrak{\overbrace{\underbrace{\fcolorbox{r}{red}{✯Answer}}}}}}$

In 60 minutes, minute hand completes 3600 i.e., one rotation.

⇒ in 1 minute, minute hands completes 60360∘=6∘

Hence, in 5 minutes the angle covered is is 6×5=30o.

The angle of sector formed is 30o.

The area swept by the minute hand in 5 minutes=36030×π×14×14

Using π=722, we get

The area swept by the minute hand in 5 minutes =3154 sq. cm

Answered by officialrashikansal