Answer the following questions:-
1. What is a spreadsheet?
Ans. The spreadsheet is derived from the word 'spread. It can be seen in the context of a newspaper or magazine where two facing pages extend or are spread across the centerfold and considered as one.
2. Name three important features of spreadsheets.
Ans. Formulas and Functions→ Formulas are mathematical expressions that are mainly used for performing simple and complex calculations. Functions are the built-in formulas that are used for calculating percentage, interest, average, etc. in MS Excel
Formatting Features → These features are used for Improving the appearance of dada.
Auto Fill → This feature helps in entering data in serious automatically.
3: Mention any four spreadsheet software.
Ans.
- Microsoft Excel
- Google Sheets
- LibreOfficeCalc
- WkiCalc
4. Define a Workbook.
Ans. A workbook is a collection of one or more worksheets in a single file.
5. How is a formula bar different from the Name box?
Ans. Formula Bar - It is located to the right of the Name box. This bar shows the characters and formulas that you enter in an active cell. It shows the actual content of the cell
Name Box - The Name box is located above the Column heading on the left-hand side of the window. The unique cell name/cell reference is displayed in this box. It displays the location of the cell pointer.
6. Define cell range in MS Excel.
Ans. A range can be two or more contiguous cells, which are selected or denoted collectively. You can specify a range by writing the starting cell address followed by the ending cell address, both separated by a colon(:). A range can be of three types.
Column Range: In this type of range, the column letter is constant whereas the row number varies.
Row range: In this type of range, the now number is constant whereas the column letter varies.
Row and column range: This type of range is in the form of a matrix including multiple rows and columns.
Post a Comment