Microsoft Excel - Std V- ICT
Microsoft Excel -
Std V- ICT
1. Answer the Following
Q1: What is Microsoft Excel?
Ans: Microsoft Excel is a spreadsheet software for organizing, calculating, and analyzing data.
Q2: What are the first steps to open a new workbook in Excel?
Ans: Open a new workbook: File > New > Blank Workbook.
Q3: Define a workbook in the context of Microsoft Excel.
Ans: A workbook is an Excel file containing one or more worksheets.
Q4: What are the different mouse pointers in Excel used for?
Ans: Mouse pointers include selection, fill handle, resize, and crosshair for various tasks.
Q5: How can you rename a sheet tab in Excel?
Ans: Right-click the sheet tab > Rename.
Q6: What is a Worksheet?
Ans: A worksheet is a single spreadsheet page in a workbook.
Q7: What is a Home Tab?
Ans: The Home Tab is the main tab with basic commands like formatting and editing.
Q8: In how many groups is the Home tab divided? Name them.
Ans: The Home Tab is divided into 7 groups: Clipboard, Font, Alignment, Number, Styles, Cells, and Editing.
Q9: What are the 3 parts of Excel?
Ans: Workbook, Worksheet, Ribbon.
Q10: What are Cells?
Ans: Cells are individual data boxes in a worksheet.
Q11: What are Rows?
Ans: Rows are the horizontal lines of cells in a worksheet, labeled by numbers.
Q12: How can you select a single cell?
Ans: Click on the cell.
Q13: How can you resize a column?
Ans: Drag the right boundary of the column header.
Q14: How can you resize a row?
Ans: Drag the bottom boundary of the row number.
Q15: How can you replace text in Excel?
Ans: Go to Home > Find & Select > Replace.
2. Fill in the Blanks
1. Excel is used primarily for __________ management and data analysis.
Ans: spreadsheet
2. The intersection of a row and column in Excel is called a __________.
Ans: cell
3. Each Excel workbook can contain multiple __________.
Ans: sheets
4. The Excel function to add numbers is __________.
Ans: SUM
5. Excel’s file extension for workbooks is usually .xlsx or .__________.
Ans: .xls
6. To change the font color in Excel, you use the __________ tool.
Ans: Font Color
7. You can format numbers as currency using the __________ tool.
Ans: Number Format
8. Cell __________ allows you to combine multiple cells into one.
Ans: merging
9. To adjust cell borders, use the __________ tool in the Format Cells dialog.
Ans: Border
10. To apply a color to the background of a cell, use the __________ tool.
Ans: Fill Color
11. The __________ function in Excel calculates the total of a range of cells.
Ans: SUM
12. To calculate the average of numbers, you use the __________ function.
Ans: AVERAGE
13. The __________ function returns the highest value in a range.
Ans: MAX
14. To count the number of cells that contain numbers, use the ___ function.
Ans: COUNT
3. True or False Questions
1. Excel is a spreadsheet application developed by Microsoft.
Ans: True
2. Excel files use the .docx extension.
Ans: False (Excel files use the .xlsx or .xls extension.)
3. The main component of Excel is the worksheet.
Ans: True
4. Each cell in Excel can contain only text data.
Ans: False (Cells can contain text, numbers, formulas, and more.)
5. Excel allows for the creation of graphs and charts.
Ans: True
6. Excel allows you to change the font size and color of text in a cell.
Ans: True
7. You can apply conditional formatting to cells based on their content.
Ans: True
8. Formatting cells in Excel affects only the content, not the cell itself.
Ans: False (Formatting affects both content and cell appearance.)
9. Excel does not support date formatting.
Ans: False (Excel supports various date formats.)
10. You can merge cells in Excel to create a larger cell area.
Ans: True
11. Formulas in Excel always start with the equal sign (=).
Ans: True
12. You cannot use functions in Excel formulas.
Ans: False (Functions are integral to Excel formulas.)
13. Excel formulas can reference other cells in the same worksheet or different worksheets.
Ans: True
14. The AVERAGE function calculates the sum of a range of cells.
Ans: False (The AVERAGE function calculates the average of a range.)
15. To find the maximum value in a range, use the MIN function.
Ans: False (Use the MAX function to find the maximum value.)
4. Match the Following
| Column A | Column B |
|---|---|
| Rows | Horizontal lines of cells |
| Columns | Vertical lines of cells |
| Cells | Box for entering data |
| Font | Style of text |
| Select Cell | Click on cell |
| Resize Column | Drag column boundary |
| Rename Sheet | Right-click sheet tab > Rename |
| Select Row | Click row number |
| Resize Row | Drag row boundary |
| Merge Cells | Combines multiple cells |
Comments
Post a Comment