Class-X-Solved Exercise:
Unit-8 Spreadsheet (Intermediate)
Session-1 Using Auto-sum in Cells
Session-2 Conditional Formatting
Session-3 Hide/Unhide/Freeze Rows and Columns
I. Objective Type Questions:
1. Fill in the blanks:
a. _________ function automatically add values in the selected cells.
Answer: AutoSum
b. To lock the scrolling of any row or column, we can use ______ command.
Answer: Freeze
c. To put off the display of a row or column, _____________ it.
Answer: Hiding
d. __________ is a tool to highlight cells that meet a condition or rule.
Answer: Conditional formatting
e. To edit or delete conditional formatting rules, select _____ rules option from menu.
Answer: Edit
2. Write 'T' for true and 'F' for false:
a. Conditional formatting includes filling the cell with a colour.
Answer: T
b. AutoSum command is under the Format tab.
Answer: F
c. Freeze Panes command locks the cells for editing.
Answer: T
d. Hiding a row or column excludes it from calculation done on that row/column.
Answer: T
e. Panes are freeze where cursor is placed.
Answer: T
II. Multiple choice questions. Tick the correct answer:
1. Which feature in Excel do you use to add values in selected cells?
a. Auto total b. Sub totals c. Auto-Sum d. AutoComplete
Answer: AutoSum
2. A fast way to add up a column of numbers is to click in the cell below the numbers and then:
a. Click subtotals on the data menu
b. View the sum in the formula bar
c. Click the AutoSum button on the Ribbon and then press enter
d. None of the above.
Answer: Click the AutoSum button on the Ribbon and then press enter
3. To hold row and column titles in places so that they do not scroll, when we scroll a worksheet, click the...
a. Unfreeze panes command on the view tab
b. Freeze panes command on the view tab
c. Hold titles command on the data tab
d. Split command on the view tab
Answer: Freeze panes command on the view tab
4. To unhide a column B
a. Select column B, left click, unhide
b. Select column A and C, right click , unhide
c. Select column C, right click, unhide
d. Cannot unhide it.
Answer: Select column C, right click, unhide
5. You can check the conditions against _______ when applying conditional formatting.
a. Cell value b. Formula c. both a and b d. none of the above
Answer: Both a and b
6. Which of the following is not regarding conditional formatting?
a. You can add more than one condition to a check.
b. You can set condition to make text bold or italics.
c. You can apply font, border and pattern that meets the specified condition
d. You can delete any condition from conditional formatting dialog box, if it is not required.
Answer: You can set condition to make text bold or italics.
III. Short Answer Questions:
1. What is the use of AutoSum() feature in spreadsheet?
Answer: AutoSum is used for adding the values given in cells automatically without writing the formula to perform the operation. It automatically selects the values around the cells either horizontally or vertically.
2. What is conditional formatting useful for?
Answer: Conditional Formatting is a tool through which you can select one or more cells and create rules for when and how those cells are formatted. The conditions can be based on the selected cell's contents, or based on the contents of another cell.
3. What is the use of Freeze panes command in Excel?
Answer: When you work with large worksheets, once you scroll down, the heading row disappears and you can no longer be sure what each column contains.
Steps to freeze rows are as follows:
1. Select the row below the row you want to freeze.
2. Click the view tab on the Ribbon
3. Select the freeze panes command button, then choose freeze panes option from the drop-down menu. The rows will be frozen in place.
4. Writes steps to hide row and column in a worksheet.
Answer:
Steps to Hide row and Column:
1. Open a new spreadsheet.
2. Select the 3rd row of the spreadsheet.
3. Click on Home tab on the ribbon.
4. Click on format button available under cells group in the home tab.
5. Click on Hide & Unhide- Hide rows.
5. Write steps to unhide row or column.
Answer: You can easily unhide a row or column that is hidden. To do so follow the steps given below.
1. Select row 2 and 4 unhiding row 3.
2. Click on format button and point to hide & unhide option
3. Click on unhide rows option from drop down menu.
Some other links:
No comments:
Post a Comment