COMPUTER IMPORTANT QUESTIONS
Q 1. What is a spread sheet?
Ans - A spreadsheet is a computer program that
organizes data into rows and columns, allowing users to
perform calculations, analyze information, and create
visual representations of data.
Popular spreadsheet software includes Microsoft Excel
and
Google Sheets.
Q 2. Write down the main features of open office calculator?
1. Cell Formatting
2. Formulas and Functions
3. Charts and Graphs
4. Data Sorting and Filtering
5. Data Validation
6. Pivot Tables
7. Conditional Formatting
8. Import and Export
9. Collaboration
10. Macro Support
, Q 2. Describe the following terms in brief :
1. Workbook
2. Worksheet
3. Row
4. coloums
5. Cell reference
6. Cell
7. Cell assessment
1. Workbook: A workbook is a file in spreadsheet software,
such as Excel or Calc, that contains one or more
worksheets. It serves as the primary container for
organizing and managing data.
2. Worksheet: A worksheet is a single sheet within a
workbook. It consists of rows and columns where users
can input and manipulate data, perform calculations, and
create visual representations.
3. Row: In a spreadsheet, a row is a horizontal line of
cells identified by numbers. Rows are used to organize
and group data horizontally.
4. Column: In a spreadsheet, a column is a vertical set of
cells identified by letters. Columns are used to organize
and group data vertically.
5. Cell Reference: A cell reference is a combination of the
column letter and row number that identifies a specific
cell in a worksheet. For example, "A1" refers to the cell in
the first column and first row.
6. Cell: A cell is the basic unit of a worksheet, identified
by its intersection of a column and a row. It can contain
data, formulas, or be left empty.
Q 1. What is a spread sheet?
Ans - A spreadsheet is a computer program that
organizes data into rows and columns, allowing users to
perform calculations, analyze information, and create
visual representations of data.
Popular spreadsheet software includes Microsoft Excel
and
Google Sheets.
Q 2. Write down the main features of open office calculator?
1. Cell Formatting
2. Formulas and Functions
3. Charts and Graphs
4. Data Sorting and Filtering
5. Data Validation
6. Pivot Tables
7. Conditional Formatting
8. Import and Export
9. Collaboration
10. Macro Support
, Q 2. Describe the following terms in brief :
1. Workbook
2. Worksheet
3. Row
4. coloums
5. Cell reference
6. Cell
7. Cell assessment
1. Workbook: A workbook is a file in spreadsheet software,
such as Excel or Calc, that contains one or more
worksheets. It serves as the primary container for
organizing and managing data.
2. Worksheet: A worksheet is a single sheet within a
workbook. It consists of rows and columns where users
can input and manipulate data, perform calculations, and
create visual representations.
3. Row: In a spreadsheet, a row is a horizontal line of
cells identified by numbers. Rows are used to organize
and group data horizontally.
4. Column: In a spreadsheet, a column is a vertical set of
cells identified by letters. Columns are used to organize
and group data vertically.
5. Cell Reference: A cell reference is a combination of the
column letter and row number that identifies a specific
cell in a worksheet. For example, "A1" refers to the cell in
the first column and first row.
6. Cell: A cell is the basic unit of a worksheet, identified
by its intersection of a column and a row. It can contain
data, formulas, or be left empty.
