MS EXCEL Q&A

Questions and Answers

1. Define Spreadsheet
   Ans: A spreadsheet is a software application used to store, organize, and manipulate data in a tabular format.

2. What is a data table?
   Ans: A data table organizes facts and figures in rows and columns within a spreadsheet.

3. What are the advantages of organizing data as a table?
   Ans:

   • Easier to sort and search data

   • Formatting highlights important information

   • Formulas can calculate new values

4. Define records, fields, and primary key.
   Ans:

   • Records: Rows in a data table, each representing one item

   • Fields: Columns in a data table, each storing a specific fact

   • Primary Key: A unique field used to identify each record

5. What is sorting?
   Ans: Sorting arranges data in a specific order, usually ascending or descending, based on one or more fields.

6. How many types of sorting are there?
   Ans: Two main types: alphabetical and numerical.

7. What is filtering?
   Ans: Filtering displays only the rows that meet specific criteria, hiding the rest.

8. What do you mean by validation of data?
   Ans: Data validation checks input data against set rules to ensure accuracy and consistency.

9. What is list validation?
   Ans: List validation restricts input to values from a predefined list.

10. What is a logical test?
    Ans: A logical test checks a condition and returns either TRUE or FALSE.

----------------------------------------------------------------------------------------------------------

Terminologies

1. Workbook: A file containing one or more worksheets for organizing and analyzing data.

2. Worksheet: A single sheet in a workbook where data is entered and manipulated in rows and columns.

3. Cell: The intersection of a row and a column, used to input data, formulas, or functions.

4. Cell Reference: Identifies a cell using its column letter and row number (e.g., A1).

5. Range: A group of cells defined by a starting and ending cell reference (e.g., A1:B10).

6. Column: A vertical group of cells in a worksheet (e.g., A, B, C).

7. Row: A horizontal group of cells in a worksheet (e.g., 1, 2, 3).

8. Formula: A mathematical expression starting with "=" used for calculations.

9. Function: A predefined formula such as SUM, AVERAGE, or COUNT that performs specific tasks.

10. AutoSum: A feature that automatically adds a selected range of numbers.

11. AutoFill: A tool to quickly fill a series of cells with data or patterns by dragging the fill handle.

12. Fill Handle: A small square at the cell corner used to copy data or extend patterns.

13. Data Types: Categories of data like Text, Number, Date/Time, and Boolean (True/False).

14. Cell Formatting: Adjusting the visual appearance of a cell’s contents.

15. Borders: Lines used around cells to enhance organization and clarity.

16. Chart: A graphical representation of data such as bar, pie, or line charts.

17. PivotTable: An interactive tool used to summarize and analyze large datasets.

18. Merge Cells: Combines two or more cells into a single larger cell.

19. Freeze Panes: Keeps specific rows or columns visible while scrolling.

20. Conditional Formatting: Applies formatting to cells based on certain conditions.

21. Sort: Arranges data in ascending or descending order.

22. Filter: Displays only rows that meet specified criteria for easier analysis.

23. Data Validation: Ensures only valid data is entered into a cell using set rules.

24. List Validation: A type of validation that restricts input to predefined choices.

25. Logical Test: A condition that returns either TRUE or FALSE.

26. Relative Reference: A cell reference that changes when the formula is copied (e.g., A1 to A2).

27. Absolute Reference: A fixed cell reference that does not change when copied (e.g., $A$1).

28. Clipboard: A temporary storage area used for copying or moving data.

29. Hyperlink: A clickable link to a webpage or another location in the workbook.

30. Workbook Protection: Limits access or editing of workbook contents using passwords or permissions.