AI Chapter-3

1. What is the primary purpose of a spreadsheet?

• a) To create videos
• b) To store data systematically and perform calculations
• c) To make presentations
• d) To write letters

Answer explanation

Explanation: As mentioned in the text, a spreadsheet is an electronic document used to store data in a systematic way and perform calculations, similar to maintaining an expense sheet.

2. In a spreadsheet, what is the default alignment for numbers?

• a) Left aligned
• b) Right aligned
• c) Center aligned
• d) No alignment

Answer explanation

Explanation: The text explicitly states that numbers are automatically (by default) right aligned in cells.

3. Which function is used for adding multiple cells in a spreadsheet?

• a) ADD()
• b) PLUS()
• c) SUM()
• d) TOTAL()

Answer explanation

Explanation: The SUM() function is specifically mentioned in the text as the function used to add numbers in separate cells or cell ranges.

4. How can you protect a spreadsheet?

• a) By hiding it in a folder
• b) By using a password
• c) By renaming the file
• d) By copying it to another location

Answer explanation

Explanation: The text describes two methods of protecting a spreadsheet, both involving the use of a password.

5. What is a cell in a spreadsheet?

• a) A column of data
• b) A row of data
• c) A rectangle shaped box where row and column meet
• d) A group of worksheets

Answer explanation

Explanation: The text defines a cell as a rectangle shaped box where the row and column intersect.

6. Which of these is NOT a presentation software mentioned in the text?

• a) LibreOffice Impress
• b) Microsoft PowerPoint
• c) Adobe Presenter
• d) Google Slides

Answer explanation

Explanation: The text lists LibreOffice Impress, Microsoft PowerPoint, OpenOffice Impress, Google Slides, and Apple Keynote as presentation software options, but does not mention Adobe Presenter.

7. How many default textboxes are there in the first slide of LibreOffice Impress?

• a) One
• b) Two
• c) Three
• d) Four

Answer explanation

Explanation: The text states that by default, there are two textboxes in the first slide - one for the title and one for other details.

8. What is the keyboard shortcut to add a new slide in LibreOffice Impress?

• a) Ctrl+N
• b) Ctrl+S
• c) Ctrl+M
• d) Ctrl+A

Answer explanation

Explanation: The text mentions that Ctrl+M can be used as a keyboard shortcut to add a new slide.

9. What happens when you click on AutoFilter icon in a spreadsheet?

• a) It automatically sorts the data
• b) It puts filters at the top of each column
• c) It removes all filters
• d) It filters only numeric data

Answer explanation

Explanation: The text explains that clicking on the AutoFilter icon puts filters at the top of each column.

10. What is the first step in using the SUM() function?

• a) Select the cells
• b) Type '=SUM('
• c) Press Enter
• d) Click the cell

Answer explanation

Explanation: The text shows that the first step in using the SUM() function is to type '=SUM(' in the cell where you want the total.