Chapter 5 Spreadsheet: An Introduction

Quick Check

Fill in the blanks:

  1. In Microsoft Excel 2016, a cell is an intersection of a row and a column.
  2. The panel at the top of an Excel document, divided into tabs like Home, Insert and Formulas, is called the Ribbon.
  3. To create a new workbook in Excel, you can use the shortcut keys Ctrl + N or go to the File tab and select the New option.
  4. Numeric data in Excel consists of numbers from 0 to 9 and symbols like +, -, !, @, $ and % is primarily used in calculations.
  5. Formula in Excel should always begin with an equal to (=) sign and may contain numbers, operators and cell address.

Choose True or False for the following statements.

  1. Excel provides different types of formulae in the Formula tab for performing calculations. True
  2. To perform a simple addition calculation in Excel, you can type the '=' sign in the result cell, click on the cell containing the first number, type the '+' symbol and then click on the subsequent cells you want to add. True
  3. In Excel, you can switch between worksheets by pressing Ctrl + Page Up and Ctrl + Page Down keys. True
  4. To rename a worksheet in Excel, you can right-click on the Sheet tab, select the Rename option and then type the new name for the worksheet. True

Time to Perform

A Fill in the blanks.

  1. Microsoft Excel 2016 organizes data in the form of rows and columns.
  2. The Excel window that appears on the screen is called workbook.
  3. Each cell is known by cell address.
  4. Cell address is displayed in the small box called Name Box.
  5. A range is specified with the starting cell address followed by the ending cell address, separated by a colon.

B State whether the following statements are true or false.

  1. Performing calculations manually can consume a lot of time. True
  2. Active cell is surrounded by a thin border. False
  3. File tab contains many functions. True
  4. Ribbon has 4 tabs. False
  5. Status bar displays the information about the current selection. True

C Choose the correct answer.

  1. There are ________ number of columns in a worksheet.
    a. 16,384
    b. 16,834
    c. 16,348
    d. 16,438
  2. ________ moves the pointer to the first cell.
    a. Shift + Home
    b. Ctrl + Home
    c. Ctrl + Shift + Home
    d. Ctrl + 1
  3. Merge & Center button is in the ________ group of the ________ tab.
    a. Alignment, File
    b. Home, Alignment
    c. Alignment, Home
    d. Alignment, Insert
  4. A formula should always begin with a/an ________.
    a. number
    b. cell address
    c. range
    d. equal to (=) sign
  5. An Excel file is saved with an extension ________.
    a. .xlsx
    b. xlsx
    c. .lsx
    d. .exs

E Answer the following questions.

  1. Enlist the methods in which data can be entered in Excel.
    a. Enter data in an active cell.
    b. Enter data using Formula bar.
  2. Define the components of Excel 2016.
    a. Cell - Intersection of a row and a column.
    b. Active Cell - Currently selected cell.
    c. Range - Group of continuous cells.
    d. Name Box - Displays the location of the currently selected cell.
    e. Formula Bar - Shows the formula entered in the selected cell.
    f. Column Headings - Letters assigned to each column.
    g. Row Headings - Numbers assigned to each row.
    h. Ribbon - Panel that contains 7 tabs.
    i. Status Bar - Displays information about the current selection.
  3. Write the steps to enter data in a worksheet.
    a. Click on the desired cell and enter the data.
    OR
    b. Enter the data using the Formula bar.
  4. How can we switch between worksheets?
    Using keyboard shortcut keys Ctrl + Page Up and Ctrl + Page Down.
  5. Write the steps to save a workbook and exit Excel.
    a. Click on the File tab.
    b. Click on the Save option.
    c. Type the file name.
    d. Click on the Save button.

Extra Questions

  1. Microsoft Excel 2016 is an application software and a component of Microsoft Office Suite.
  2. Data can be viewed in graphical form like charts.
  3. The default name of the workbook is Book1.
  4. A workbook consists of a number of pages called worksheets.
  5. A worksheet is also called a spreadsheet.
  6. A worksheet consists of 1,048,576 rows.
  7. The default name of a worksheet is Sheet1.
  8. Numbers and formulae are collectively known as values.
  9. You can also double-click on the Sheet tab to rename it. True
  10. You can also insert a new worksheet by clicking on the + button present next to the Sheet tab. True
  11. Shortcut keys:
    a. To create a new workbook: Ctrl + N
    b. To save a workbook: Ctrl + S
    c. To move the cell pointer to the last cell of a sheet. Ctrl + End
  12. Name the three types of data that can be entered in Excel.
    a. Numbers or Numeric Data
    b. Text Data
    c. Formulae Data

Comments

Post a Comment