CBSE Class 7 Computer Science Introduction to Spreadsheets Worksheet Set 01

Answer: A spreadsheet is a program that stores data in rows and columns and performs calculations on it using formulas.

Teacher's Note:
1. Data is arranged in a grid of cells.
2. Results update when the data changes.

Answer: Microsoft Excel is a spreadsheet application used to enter, calculate, analyse and present data in tables and charts.

Teacher's Note:
1. It is part of the Microsoft Office family.
2. Other examples are LibreOffice Calc and Google Sheets.

Answer:

1. Title bar and ribbon with tabs and commands.
2. Name box and formula bar.
3. Worksheet area made of rows, columns and cells.
4. Sheet tabs and status bar at the bottom.

Teacher's Note:
1. The Name box shows the active cell address.
2. The formula bar shows the contents of the active cell.

Answer:

1. Click the Start button.
2. Choose All apps (or type Excel in the search box).
3. Click Excel, then open a blank workbook.

Teacher's Note:
1. The exact path depends on the version of Windows.
2. A blank workbook opens ready for use.

Answer:

1. Click the row number or column letter to select it.
2. Right-click on it.
3. Choose Delete.

Teacher's Note:
1. The cells below or to the right shift to fill the gap.
2. The Delete option is also on the Home tab.

Answer: Undo cancels the last action, and Redo repeats an action that was undone. The shortcuts are Ctrl+Z and Ctrl+Y.

Teacher's Note:
1. They help to correct mistakes quickly.
2. They are found on the Quick Access toolbar.

Answer:

1. Enter a value or the start of a series in a cell.
2. Select the cell and place the pointer on the fill handle at its bottom right corner.
3. Drag across the cells to fill.

Teacher's Note:
1. AutoFill can copy values or continue series such as days or numbers.
2. The pointer changes to a thin plus sign.

Answer:

1. Click File and then Save (or press Ctrl+S).
2. Choose the location and type a file name.
3. Click Save.

Teacher's Note:
1. Save often to avoid losing work.
2. The file is saved with the .xlsx extension.

Answer: spreadsheet

Teacher's Note:
1. It handles numbers and calculations.
2. It displays data in a grid.

Answer: worksheets

Teacher's Note:
1. A workbook is the whole file.
2. Worksheets are its pages.

Answer: 1,048,576 rows and 16,384 columns.

Teacher's Note:
1. Rows are numbered and columns are lettered.
2. The last column is XFD.

Answer: row and a column

Teacher's Note:
1. Each cell has an address such as B3.
2. The address is column letter then row number.

Answer: Name

Teacher's Note:
1. It shows the address of the active cell.
2. It can also be used to jump to a cell.

Answer: Shift + F11

Teacher's Note:
1. The plus sign next to the sheet tabs also adds a sheet.
2. The new sheet gets the next number.

Answer: True.

Teacher's Note:
1. Formulas and functions do the calculations.
2. Results change automatically with the data.

Answer: True.

Teacher's Note:
1. Anything you type goes into the active cell.
2. Its address appears in the Name box.

Answer: False. It has 1,048,576 rows and 16,384 columns.

Teacher's Note:
1. The numbers have been swapped.
2. Rows are many more than columns.

Answer: True.

Teacher's Note:
1. For example it may show A1.
2. It is not shown in the status bar.

Answer: A worksheet is a single page of a workbook made of rows and columns of cells.

Teacher's Note:
1. It is where data is entered.
2. A workbook may contain many.

Answer: A workbook is an Excel file that contains one or more worksheets.

Teacher's Note:
1. It is saved as one file.
2. Its sheet tabs are shown at the bottom.

Answer: Rows are the horizontal lines of cells, numbered 1, 2, 3 and so on.

Teacher's Note:
1. They run from left to right.
2. Row numbers are on the left.

Answer: Columns are the vertical lines of cells, named A, B, C and so on.

Teacher's Note:
1. They run from top to bottom.
2. Column letters are at the top.

Answer: A cell is the box where a row and a column meet, and it holds one piece of data.

Teacher's Note:
1. It has a unique address.
2. Examples are A1 and C5.

Answer: The active cell is the cell currently selected, shown with a dark border, where entries are made.

Teacher's Note:
1. Only one cell is active at a time.
2. Its address is in the Name box.

Answer: Data types are the kinds of data a cell can hold, such as text, numbers, dates and formulas.

Teacher's Note:
1. Numbers are right-aligned by default.
2. Text is left-aligned by default.