CL05 CO06 MS EXCEL

by

.

1. The Hook (The Tech Innovation)

  • Imagine if you could command a computer to instantly calculate the total sales of a global retail store, manage the salaries of thousands of employees, track school fee collections, or analyze test scores for an entire district—all while automatically recalculating every single result the split-second a number is modified!
  • Did you know that Microsoft Excel (commonly known as MS Excel) is a highly advanced electronic spreadsheet program that functions as an intelligent, giant table composed of thousands of intersecting rows and columns designed to handle complex data operations?
  • Imagine if you could transform rows of raw, unorganized numbers into vibrant, colorful, and interactive charts—such as pie charts, column charts, and bar graphs—with just a few clicks, making complex trends instantly understandable.
  • Did you know that while MS Excel is the global gold standard in professional data operations, other popular spreadsheet applications include Lotus, Calc, Apple Numbers, and Gnumeric? However, Excel remains the absolute powerhouse for data management, automatic computations, and reporting across the digital world.

2. Real-World Lesson (Why This Matters)

In the modern digital landscape, data is the most valuable asset. Simply entering numbers into a list is no longer sufficient; professionals must know how to organize, analyze, and visualize data efficiently.

Modern Workplace Applications

  • Financial Modeling & Budgeting: Accountants, analysts, and business managers use Excel to manage corporate budgets, project revenues, calculate worker salaries, track business expenses, and plan investments.
  • Operations & Inventory Management: Retail stores, factories, and supermarkets use spreadsheets to manage stock quantities, calculate rates, and determine the exact valuation of their inventory in real time.
  • School Administration: School administrators use Excel to record fee collections, track student attendance, analyze test pass-rates, and generate report cards.

Internet Development & Data Science

  • Data Cleansing and Structuring: Web developers and data analysts use Excel to prepare structured datasets. Before importing customer lists, product tables, or system configurations into databases or web applications, the data is cleaned, structured, and saved as standard tabular data in Excel.
  • API Integration & CSV Configurations: Excel is the default tool for managing comma-separated value configuration files used for bulk uploads on e-commerce platforms and system backends.

Everyday Digital Life

  • Personal Organization: Excel allows individuals to track monthly personal savings, manage fitness schedules, plan household budgets, and organize project tasks.

The Practical Advantage

Mastering Excel transforms a student from a passive data consumer into an active data engineer. In the real world, someone who can write formulas to automate calculations in seconds has a massive productivity and decision-making advantage over someone who manually calculates values using a calculator. It eliminates human mathematical error, minimizes operational time, and allows professionals to communicate heavy datasets clearly using dynamic visual charts.

3. The Execution Sequence (Algorithms & Navigation)

This section details the exact step-by-step navigation paths, mouse clicks, keyboard combinations, and syntax rules required to operate MS Excel.

Sequence 3.1: Launching MS Excel (Standard Mouse Method)

  1. Position your mouse pointer on the Start button at the bottom-left of your computer screen.
  2. Click the Start button once with the left mouse button.
  3. Scroll through the installed programs list to find Excel.
  4. Click on Excel.
  5. The Microsoft Excel startup window appears, displaying a list of new workbooks in a thumbnail view.
  6. Click on the Blank workbook thumbnail option.
  7. The Microsoft Excel application window opens, displaying a blank workbook automatically assigned the temporary name Book1.

Sequence 3.2: Launching MS Excel (Run Window Keyboard Shortcut Method)

  1. Press and hold the Windows key, then press the R key on your keyboard (Windows + R).
  2. The Run dialog box appears on the screen.
  3. Click inside the “Open:” text input field.
  4. Type the exact command: excel (all letters lowercase).
  5. Click the OK button or press the Enter key.
  6. The New Workbook selection window appears with different types of new workbooks in a thumbnail view.
  7. Click on the Blank workbook thumbnail option.
  8. The Excel application window opens with a blank workbook named Book1.

Sequence 3.3: Selecting a Single Cell

  1. Position the mouse pointer directly over the target cell (the intersection of your desired column and row).
  2. Click the left mouse button once.
  3. The selected cell is now the Active Cell, indicated by a bold border known as the Cell Pointer.
  4. The cell’s coordinates (column letter and row number) are instantly displayed in the Cell Name Box.

Sequence 3.4: Selecting an Entire Column

  • Method A (Mouse): Move the mouse pointer over the alphabetical heading of the column (e.g., A, B, C…) and click the left mouse button once.
  • Method B (Keyboard): Click on any single cell inside the target column, then press the keyboard combination Ctrl + Spacebar.

Sequence 3.5: Selecting an Entire Row

  • Method A (Mouse): Move the mouse pointer over the numerical heading of the row (e.g., 1, 2, 3…) and click the left mouse button once.
  • Method B (Keyboard): Click on any single cell inside the target row, then press the keyboard combination Shift + Spacebar.

Sequence 3.6: Selecting a Contiguous Range of Cells (e.g., Selecting B2 to C4)

  • Method A (Mouse Click-and-Drag):
    1. Move the mouse pointer over the starting cell (e.g., B2) and click the left mouse button.
    2. While keeping the left mouse button held down, drag the pointer diagonally across to the ending cell (e.g., C4).
    3. Release the left mouse button. The entire block of cells from B2 to C4 will be highlighted.
  • Method B (Keyboard Shift Method):
    1. Select the first cell of the desired range (e.g., B2) using the mouse or keyboard arrow keys.
    2. Press and hold down the Shift key on the keyboard.
    3. Use the keyboard Arrow Keys (Down and Right) to move the selection pointer to the final cell of the range (e.g., C4).
    4. Release the Shift key. The range B2:C4 remains selected.

Sequence 3.7: Selecting All Cells in a Worksheet (Select All)

  • Method A (Mouse): Click the Select All button located at the top-left cross-section of the row and column headings (the gray triangle above Row 1 and to the left of Column A).
  • Method B (Keyboard): Click anywhere inside the worksheet grid and press the keyboard combination Ctrl + A.

Sequence 3.8: Selecting Non-Contiguous (Random) Ranges of Cells

  1. Click and drag the mouse to select the first range of cells (e.g., A1:B3), then release the mouse button.
  2. Press and hold down the Ctrl key on your keyboard.
  3. While continuing to hold down the Ctrl key, click and drag your mouse to select the second, non-adjacent range of cells (e.g., D1:E3).
  4. Release the mouse button, and then release the Ctrl key. Both separated ranges are now active and highlighted.

Sequence 3.9: Deselecting a Cell Range

  1. Click on any single cell anywhere in the worksheet grid outside of the currently highlighted range. The range selection is instantly cleared.

Sequence 3.10: Entering Data in a Worksheet Grid

  1. Move the mouse pointer to cell C1 and click to select it.
  2. Type the text: World Ranking.
  3. Move the pointer to cell A2, click it, and type: Team.
  4. Press the Right Arrow key to move to cell B2, and type: Cricket.
  5. Press the Right Arrow key again to move to cell C2, and type: Football.
  6. Press the Right Arrow key once more to move to cell D2, and type: Tennis.
  7. Click on cell A3, type: India, and press the Enter key. The cell pointer automatically shifts down to cell A4.
  8. Type: Bhutan in cell A4. Continue this exact pattern to enter the remaining text and numbers.

Sequence 3.11: Editing Existing Cell Content (Three Methods)

  • Method A (In-Cell Double-Click):
    1. Position the mouse pointer directly over the target cell you wish to edit.
    2. Double-click the left mouse button. A flashing insertion cursor appears inside the cell.
    3. Modify, insert, or replace characters as required.
    4. Press the Enter key to apply and save changes.
  • Method B (Keyboard F2 Shortcut):
    1. Click once on the target cell to make it active.
    2. Press the F2 function key on your keyboard. The insertion cursor appears at the end of the cell’s current text or numbers.
    3. Edit the content.
    4. Press the Enter key to commit the changes.
  • Method C (Formula Bar Method):
    1. Click once on the target cell to make it active.
    2. Move the mouse pointer to the Formula Bar located above the worksheet grid.
    3. Click inside the Formula Bar. The insertion cursor appears inside the bar.
    4. Type your changes directly in the Formula Bar.
    5. Press the Enter key on the keyboard, or click the checkmark button next to the Formula Bar to apply changes.

Sequence 3.12: Deleting Cell Content

  1. Click on the cell (or drag to select the range of cells) that contains the data you wish to remove.
  2. Press the Backspace key or the Delete key on the keyboard. The data is cleared, leaving the cell completely empty.

Sequence 3.13: Replacing a Specific Part of Existing Cell Data

  1. Double-click the cell, or select it and press the F2 key to enter edit mode.
  2. Use your mouse to click and drag across the specific numbers, letters, or words you wish to replace, highlighting them.
  3. Type the new characters. The highlighted characters are instantly overwritten by the new input.
  4. Press the Enter key to confirm.

Sequence 3.14: Inserting New Characters into Existing Cell Data

  1. Double-click the cell, or select it and press the F2 key to enter edit mode.
  2. Position the mouse pointer at the exact spot inside the cell where the new text or numbers should go and click once. A flashing vertical line (insertion point) appears.
  3. Type the new content. The existing data pushes to the right to make room for the new input.
  4. Press the Enter key to finalize.

Sequence 3.15: Saving a Workbook for the First Time

  1. Click on the File tab on the Ribbon.
  2. Click on the Save As option. The Save As pane appears on the right side of the window.
  3. Click on the Browse button. The Save As dialog box opens.
  4. Inside the dialog box, navigate to select the specific drive or folder where you want to store the file.
  5. Click inside the File name text box and type the filename (e.g., FruitBasket).
  6. Click on the Save button. The workbook is saved with the standard .xlsx file extension.

Sequence 3.16: Closing an Active Workbook

  1. Click on the File tab on the Ribbon.
  2. Click on the Close option. (If you have unsaved changes, Excel will prompt you to save before closing).

Sequence 3.17: Opening an Existing Saved Workbook

  1. Click on the File tab on the Ribbon.
  2. Click on the Open option. The Open pane appears on the right.
  3. If the file is in the list of Recent Workbooks: Click directly on the filename under the “Recent” section to open it instantly.
  4. If the file is not in the list:
    • Click on the This PC option.
    • Select the drive or folder where the file is stored, OR click on the Browse button to open the standard Open dialog box.
    • Navigate to the file location, click on the file name to select it, and click on the Open button.

Sequence 3.18: Adding a New Worksheet to a Workbook

  • Method A (New Sheet Plus Button):
    1. Go to the bottom of the worksheet screen next to the existing Sheet1 tab.
    2. Click on the New Sheet icon (the plus sign + inside a circle). A new worksheet (e.g., Sheet2) is instantly added.
  • Method B (Right-Click Context Menu):
    1. Position your mouse pointer over the existing sheet tab (e.g., Sheet1) at the bottom of the screen.
    2. Click the right mouse button to open the context-menu.
    3. Click on the Insert… option. The Insert dialog box opens.
    4. On the General tab of the dialog box, click on the Worksheet icon once to select it.
    5. Click on the OK button. A new sheet is created.

Sequence 3.19: Renaming a Worksheet

  • Method A (Double-Click):
    1. Position your mouse pointer over the sheet tab (at the bottom of the screen) that you want to rename.
    2. Double-click the left mouse button. The sheet name (e.g., Sheet1) is highlighted in blue.
    3. Type the new name (e.g., CricketScoreCard).
    4. Press the Enter key.
  • Method B (Right-Click Context Menu):
    1. Right-click on the target sheet tab at the bottom of the screen.
    2. Click on the Rename option in the context-menu. The sheet name is highlighted.
    3. Type the new name.
    4. Press the Enter key.

Sequence 3.20: Deleting a Worksheet

  • Method A (Home Tab Ribbon Path):
    1. Click on the tab of the worksheet you want to delete to make it active.
    2. Click on the Home tab on the Ribbon.
    3. In the Cells group (right side of the Home tab), click on the dropdown arrow below the Delete button.
    4. Click on the Delete Sheet option in the dropdown list.
  • Method B (Right-Click Context Menu):
    1. Position your mouse pointer over the tab of the worksheet you wish to delete.
    2. Click the right mouse button to open the context-menu.
    3. Click on the Delete option. The sheet is permanently deleted.

4. Technical Glossary (The Word List)

  • Electronic Spreadsheet – A specialized computer application structured like a grid of horizontal rows and vertical columns, designed for performing numerical calculations, organizing data, and generating charts. – Used in the opening of the chapter to introduce MS Excel as a calculations tool.
  • Workbook – An individual Microsoft Excel file which acts as a container holding multiple worksheets. When launched, a new workbook is assigned a temporary file name of Book1 by default. – Used to describe the entire document file created and saved in Excel.
  • Worksheet – A single page within a workbook composed of a grid of cells arranged in rows and columns. By default, a new Excel workbook contains exactly one worksheet. – Used to define the actual workspace where users input and organize data.
  • Row – A horizontal series of cells across a worksheet, numbered sequentially from 1 to 1,048,576. – Used as one of the two main structural dimensions that make up the worksheet grid.
  • Column – A vertical series of cells down a worksheet, labeled alphabetically from A to Z, then continuing as AA, AB, AC… AZ, BA, BB… up to a maximum of 16,384 columns (ending at XFD). – Used as the second structural dimension of the worksheet grid.
  • Cell – The rectangular box formed at the intersection of a single row and a single column. It is the basic unit of data storage in Excel and can hold text (labels), numbers (values), or formulas. – Used as the primary input block for spreadsheets.
  • Active Cell – The currently selected cell in a worksheet, visually identified by a thick, bold border. – Used to indicate the specific cell ready to receive keyboard input or data editing.
  • Cell Pointer – The highlighted, thick, bold border that surrounds the active cell. – Used as the visual pointer that distinguishes the selected cell from other cells.
  • Cell Reference (Cell Address) – The unique name or coordinate of a cell, created by combining its column letter and row number (e.g., A1 is the first cell; XFD1048576 is the last cell). – Used to identify and call specific cells within formulas, calculations, and selections.
  • Cell Range – A group of contiguous (adjacent) cells forming a rectangular block. It is written as the address of the first cell (top-left), a colon (:), and the address of the last cell (bottom-right) (e.g., B2:C4). – Used to reference multiple cells simultaneously for formatting or calculations.
  • Title Bar – The bar located at the very top of the Excel window that displays the name of the active workbook and contains the standard window control buttons (Minimize, Maximize, Restore, Close). – Used to identify the file being worked on and manage the application window size.
  • Quick Access Toolbar – A small, customizable toolbar situated at the top-left of the Excel window that offers quick, one-click access to frequently used commands like Save, Undo, Redo, and Print. – Used to bypass ribbon navigation for common tools.
  • Ribbon – The wide control panel below the Title Bar containing eight primary tabs (File, Home, Insert, Page Layout, Formulas, Data, Review, View), with each tab hosting commands organized into logical groups. – Used as the primary command-and-control interface for Excel.
  • Cell Name Box – A box on the left side of the screen just below the Ribbon that displays the cell reference (address) of the currently active cell. – Used to quickly confirm the exact grid coordinates of the cell selection.
  • Formula Bar – A long horizontal input bar located below the Ribbon and next to the Cell Name Box that displays the text, numbers, or formulas stored in the active cell. It can also be used to write or edit cell content. – Used as a primary interface for inputting complex data and structural formulas.
  • Sheet Tab – A tab located at the bottom-left of the worksheet area (above the Status Bar) that displays the name of the worksheet and allows users to switch between different sheets. – Used to navigate and manage individual sheets within a workbook.
  • Status Bar – The bar running along the bottom edge of the Excel window that displays information about the active cell selection (such as cell count, average, and sum of selected numeric data), view layout buttons, and the zoom slider. – Used to view real-time calculations on selected cells without writing formulas.
  • Text (Labels) – A data type consisting of alphabetical characters, words, or alphanumeric values. By default, text is left-aligned in a cell. – Used for headings, descriptions, and structural labels in data tables.
  • Numbers (Values) – A data type consisting of numerical digits. By default, numbers are right-aligned in a cell. – Used for raw numeric data that will be computed or analyzed.
  • Formulas – A type of input that performs mathematical calculations on numbers in a worksheet. – Used to automate arithmetic computations and data transformations.
  • .xlsx – The standard, default file extension used when saving Microsoft Excel 2007 and newer workbooks. – Used as the file format suffix for saved spreadsheet projects.
  • Ctrl + N – Keyboard shortcut that instantly opens a new, completely blank Excel workbook. – Used to start a new project from scratch without going through the File menu.
  • Ctrl + S – Keyboard shortcut to save the active workbook. – Used as a fast, one-key method to protect data and save changes.
  • Ctrl + O – Keyboard shortcut to open the Open pane and locate existing Excel workbooks. – Used to quickly retrieve a previously saved project.
  • Ctrl + A – Keyboard shortcut that selects every cell inside the active worksheet. – Used to apply universal formatting or delete everything at once.
  • Shift + F11 – Keyboard shortcut that inserts a new, blank worksheet into the active workbook. – Used as a fast shortcut to bypass the right-click or Ribbon commands for adding sheets.
  • F2 – Keyboard shortcut that places the selected active cell into edit mode, positioning the insertion point at the end of the cell’s contents. – Used to edit cell contents using only the keyboard.
  • Ctrl + Spacebar – Keyboard shortcut that selects the entire vertical column containing the active cell. – Used to quickly format or manipulate an entire column.
  • Shift + Spacebar – Keyboard shortcut that selects the entire horizontal row containing the active cell. – Used to quickly format or manipulate an entire row.
  • Ctrl + Right Arrow (\(\rightarrow\)) – Keyboard shortcut that moves the active cell pointer to the absolute last cell of the current row. – Used for high-speed row-level navigation.
  • Ctrl + Left Arrow (\(\leftarrow\)) – Keyboard shortcut that moves the active cell pointer to the absolute first cell of the current row. – Used to return to the beginning of a row instantly.
  • Ctrl + Down Arrow (\(\downarrow\)) – Keyboard shortcut that moves the active cell pointer to the absolute last cell of the current column. – Used for high-speed column-level navigation.
  • Ctrl + Up Arrow (\(\uparrow\)) – Keyboard shortcut that moves the active cell pointer to the absolute first cell of the current column. – Used to return to the top of a column instantly.
  • Ctrl + Home – Keyboard shortcut that instantly moves the cell pointer to cell A1 (the first row, first column of the worksheet). – Used to reset the active view back to the top-left origin of the worksheet.
  • Ctrl + End – Keyboard shortcut that instantly moves the active cell pointer to the last used cell on the worksheet. – Used to navigate to the bottom-right boundary of your active data.
  • Windows + R – Keyboard shortcut that opens the Windows Run dialog box. – Used as a fast system-level shortcut to launch Excel by typing its command name.

5. Teacher’s Chapter Checklist

Teachers can use this comprehensive list of lesson targets to structure lectures, practical computer lab classes, and exams.

5.1 Technical Concepts Targets

  • [ ] Define spreadsheet and explain how it differs from a word processor.
  • [ ] Differentiate between a Workbook (the file) and a Worksheet (the grid page).
  • [ ] Memorize the grid limits of Excel: 1,048,576 rows and 16,384 columns (ending at XFD).
  • [ ] Understand the concept of Cell Reference (Cell Address) as a column letter followed by a row number.
  • [ ] Define the syntax of a Cell Range (e.g., B2:C4) and understand how the colon (:) acts as a range operator.
  • [ ] Identify the three types of data that can be entered in cells: Text, Numbers, and Formulas.
  • [ ] Explain default cell alignments: Text is left-aligned and Numbers are right-aligned.

5.2 Application Interface Targets

  • [ ] Locate and identify the Quick Access Toolbar and its default commands (Save, Undo, Redo, Print).
  • [ ] Identify the Title Bar, workbook file name, and window controls (Minimize, Maximize, Restore, Close).
  • [ ] List the 8 tabs of the Ribbon in correct order: File, Home, Insert, Page Layout, Formulas, Data, Review, and View.
  • [ ] Locate and explain the function of the Cell Name Box.
  • [ ] Locate and explain the function of the Formula Bar.
  • [ ] Identify the visual difference between standard cells and the Active Cell (bold border and cell pointer).
  • [ ] Locate the Sheet Tabs and the New Sheet icon (+).
  • [ ] Analyze the Status Bar and demonstrate how it displays live calculations (Sum, Average, Count) for selected data ranges.

5.3 Practical Skill Sequences (Lab Checklist)

  • [ ] Launch Excel using the Start Menu.
  • [ ] Launch Excel using the Run window shortcut command excel.
  • [ ] Click and create a new Blank workbook.
  • [ ] Select a single cell using the mouse.
  • [ ] Select an entire column using mouse clicks and the Ctrl + Spacebar keyboard shortcut.
  • [ ] Select an entire row using mouse clicks and the Shift + Spacebar keyboard shortcut.
  • [ ] Select a contiguous range of cells using click-and-drag and the Shift + Arrow Keys keyboard combination.
  • [ ] Select non-contiguous cell ranges randomly using the Ctrl key.
  • [ ] Deselect active cell selections.
  • [ ] Navigate the worksheet using standard cell navigation keys (Tab, Enter, arrows) and advanced keyboard combinations (Ctrl + Arrows, Ctrl + Home, Ctrl + End).
  • [ ] Enter text labels and numeric values into cell grids correctly.
  • [ ] Edit existing data inside a cell using:\
    • Double-click method.\
    • F2 key method.\
    • Formula Bar method.
  • [ ] Delete cell data using Backspace or Delete.
  • [ ] Save a spreadsheet using File -> Save As -> Browse with a custom name and verify the .xlsx extension.
  • [ ] Close and open saved workbooks.
  • [ ] Perform worksheet management:\
    • Add worksheets.\
    • Rename worksheets.\
    • Delete worksheets.

6. Ready-Reckoner Student Revision Notes

A complete study guide written directly for students to prepare for practical laboratory exams or written tests.

I. SPREADSHEETS: THE ESSENTIALS

  • Definition: An electronic spreadsheet is a software program structured as a giant table of intersecting rows and columns used to perform computations and organize numerical data.
  • Core Strengths:
    1. Automatic Calculations: Once a formula is written, you can copy it anywhere. If you modify a number in a cell, Excel automatically recalculates the results instantly.
    2. Data Management: Easily add, check, organize, search, and sort information.
    3. Visual Charts: Transform tables of data into colorful visual representations (pie, column, and bar charts).
  • Alternative Programs: Other spreadsheet applications include Lotus, Calc, Apple Numbers, and Gnumeric.

II. THE WORKSHEET GRID METRICS

  • Workbook vs. Worksheet:
    • A Workbook is the Excel file itself (the container). It is assigned the default name Book1 upon creation. It can contain multiple worksheets.
    • A Worksheet is a single grid sheet inside the workbook where data is written. It starts with one worksheet by default.
  • Rows: Run horizontally. Labeled with numbers (1, 2, 3, 4…). Total rows in a worksheet = 1,048,576.
  • Columns: Run vertically. Labeled with alphabetical letters (A, B, C… Z, then AA, AB… AZ, up to XFD). Total columns = 16,384.
  • Cells: The intersection points of rows and columns. Each cell holds one item of data (text, numbers, or formulas).
  • Cell Reference (Cell Address): The unique coordinate of a cell, written as: [Column Letter][Row Number] (e.g., A1).
    • First cell address: A1
    • Last cell address: XFD1048576
  • Cell Range: A rectangular block of adjacent (touching) cells. It is written as: [Top-Left Cell Address] : [Bottom-Right Cell Address] (e.g., B2:C4).
    • Smallest range: A single cell.
    • Largest range: An entire worksheet.

III. UNDERSTANDING THE USER INTERFACE

  • Quick Access Toolbar: Located at the top left. Holds buttons for fast, single-click operations like Save, Undo, Redo, and Print.
  • Title Bar: Located at the top. Displays the current filename and standard window controls (Minimize, Maximize, Restore, Close).
  • Ribbon: The command hub containing 8 tabs. Each tab contains groups of tools:
    • File, Home, Insert, Page Layout, Formulas, Data, Review, View.
  • Cell Name Box: Displays the address of the active cell.
  • Formula Bar: Displays whatever data, text, or formulas are inside the active cell. Can also be used to enter or edit content.
  • Active Cell & Cell Pointer: The selected cell is called the active cell. It is surrounded by a thick, dark border called the cell pointer. To enter data, a cell must be active.
  • Sheet Tabs: Located at the bottom left, above the status bar. Shows the names of worksheets (e.g., Sheet1). Click a sheet tab to switch sheets.
  • Status Bar: At the very bottom. Displays live calculations when multiple cells are selected:
    • Sum (total value), Average (arithmetic mean), and Count (total cells containing data). Also contains the Zoom slider and view layout buttons.

IV. CELL DATA & ALIGNMENT RULES

  • Excel handles three distinct data types: Text (Labels), Numbers (Values), and Formulas.
  • Default Alignment Rules:
    • Text (Labels) automatically align to the LEFT of the cell.
    • Numbers (Values) automatically align to the RIGHT of the cell.

V. MASTER KEYBOARD SHORTCUTS REFERENCE CARD

Action / CommandKeyboard Shortcut
Open New Blank WorkbookCtrl + N
Open Existing WorkbookCtrl + O
Save WorkbookCtrl + S
Select Entire ColumnCtrl + Spacebar
Select Entire RowShift + Spacebar
Select All Cells in WorksheetCtrl + A
Insert a New WorksheetShift + F11
Edit Selected Active CellF2
Open Run Window (Windows)Windows + R
Move Cell Pointer One Column RightTab or Right Arrow (\(\rightarrow\))
Move Cell Pointer One Column LeftShift + Tab or Left Arrow (\(\leftarrow\))
Move Cell Pointer One Row UpUp Arrow (\(\uparrow\))
Move Cell Pointer One Row DownEnter or Down Arrow (\(\downarrow\))
Move to Last Cell of Current RowCtrl + Right Arrow
Move to First Cell of Current RowCtrl + Left Arrow
Move to Last Cell of Current ColumnCtrl + Down Arrow
Move to First Cell of Current ColumnCtrl + Up Arrow
Move to First Cell of Worksheet (A1)Ctrl + Home
Move to Last Used Cell on WorksheetCtrl + End

7. Activities

These educational projects and laboratory activities are designed to build hands-on competency in spreadsheets, integrating both curriculum concepts and experiential real-world scenarios.

Activity 7.1: The Fruit Basket Inventory (Curriculum Project)

  • Objective: Learn raw data entry, observe auto-alignments, modify active cells, and perform basic file saving.
  • Directions:
    1. Launch Microsoft Excel. Create a Blank workbook.
    2. Input the following inventory data starting from cell A1:
      • Row 1 (Headings): ITEMS (A1), TYPE (B1), QUANTITY (KG) (C1), RATE PER KG (D1), AMOUNT (E1).
      • Row 2: MANGO (A2), A (B2), 42 (C2), 140 (D2), 5880 (E2).
      • Row 3: CHERRY (A3), A (B3), 317 (C3), 210 (D3), 66570 (E3).
      • Row 4: APPLE (A4), A (B4), 430 (C4), 120 (D4), 51600 (E4).
      • Row 5: BANANA (A5), B (B5), 320 (C5), 60 (D5), 19200 (E5).
    3. Observe: Notice that textual headings (ITEMS, TYPE, fruit names) automatically align to the left side of the cell, while numeric entries automatically shift and align to the right.
    4. Edit Practice: Select cell C2 (42), press the F2 key, change the quantity to 50. Select cell E2 (5880), double-click inside, and change the amount to 7000.
    5. Save: Save the workbook as FruitBasket.xlsx using the File -> Save As -> Browse navigation sequence.

Activity 7.2: Cricket Team Stat Tracker (Interactive Class Project)

  • Objective: Learn cell navigation, sheet insertion, renaming, and selection sequences.
  • Directions:
    1. Open a new Excel workbook (Ctrl + N).
    2. Input this player database starting from cell A1:
      • Headers (Row 1): PLAYER (A1), BALLS PLAYED (B1), RUNS (C1), OVERS (D1), WICKETS TAKEN (E1).
      • Player 1 (Row 2): Player 1 (A2), 91 (B2), 53 (C2), 0 (D2), 0 (E2).
      • Player 2 (Row 3): Player 2 (A3), 80 (B3), 45 (C3), 4 (D3), 3 (E3).
      • Player 3 (Row 4): Player 3 (A4), 1 (B4), 0 (C4), 4 (D4), 1 (E4).
      • Player 4 (Row 5): Player 4 (A5), 90 (B5), 112 (C5), 0 (D5), 0 (E5).
    3. Renaming Sheet: Double-click on the tab Sheet1 at the bottom-left of the screen and rename it to CricketScorecard.
    4. Worksheet Insertion: Click on the New Sheet icon (+) to insert a brand new sheet. Rename this new sheet to SummaryStats.
    5. Deselect and Navigate Practice: Navigate back to the CricketScorecard sheet tab. Use Ctrl + Home to jump back to cell A1. Select cells B2:B5 using the Shift + Down Arrow keyboard shortcut.
    6. Status Bar Observation: While B2:B5 is highlighted, look down at the Status Bar. Write down the Sum, Average, and Count of balls played that Excel displays automatically.

Activity 7.3: The Experiential School Tuck Shop Business Simulation (Outside-the-Book Project)

  • Objective: Connect Excel grids with real-world entrepreneurship, data structures, and inventory management.
  • Directions:
    1. Tell students they are opening a school tuck shop selling healthy snacks and stationery.
    2. Create a new workbook named TuckShopPlanner.xlsx.
    3. Design the inventory table using these columns:
      • Column A: Item Name (e.g., Apple, Notebook, Pen, Juice Box)
      • Column B: Item Category (e.g., Fruit, Stationery, Snack)
      • Column C: Stock Quantity (e.g., 50, 100, 75, 40)
      • Column D: Buying Price (e.g., 10.00, 15.00, 5.00, 8.00)
      • Column E: Selling Price (e.g., 15.00, 25.00, 10.00, 12.00)
    4. Active Selection Practice:
      • Highlight all item names in Column A by clicking cell A2 and pressing Shift + Down Arrow.
      • Highlight entire columns to change their alignment or colors using Ctrl + Spacebar.
    5. Interactive Classroom Simulation:
      • The teacher announces that a local supplier reduced the notebook cost.
      • Students navigate to cell D3 (Notebook Buying Price), hit F2, and update it to 12.00.
      • Students practice deleting discontinued snacks by selecting the row and hitting Delete.

Activity 7.4: The Keyboard Navigation Race (Lab Game)

  • Objective: Build reflex and speed with keyboard navigation shortcuts, eliminating dependence on the mouse.
  • Rules:
    1. All students open Excel with a blank worksheet. Hands must start off the mouse, resting flat on the desk.
    2. The teacher calls out a structural grid target, for example: “Navigate to the absolute bottom-left cell of the worksheet (Row 1048576, Column A)!”
    3. Students must use key combinations (Ctrl + Left Arrow to get to Column A, then Ctrl + Down Arrow to get to row 1048576).
    4. The first student to successfully raise their hand and display their active cell coordinate in the Cell Name Box as A1048576 wins a point.
    5. Alternative targets:
      • “Jump to the absolute last cell of the spreadsheet!” (Shortcut: Ctrl + End, target: XFD1048576).
      • “Select Column D!” (Shortcut: click a cell in D, hit Ctrl + Spacebar).
      • “Return home instantly!” (Shortcut: Ctrl + Home, target: A1).

8. Flow Charts & Diagrams

These descriptive models illustrate the structural mechanics of Excel workflows and user interface layouts for blackboard sketches, slide illustrations, or notes.

Diagram 8.1: The Interactive MS Excel Screen Interface Map

A visual map labeling the primary software components of the active Excel workspace.

  • Topmost Level (Window Frame):
    • [Label: Title Bar] (Center-top): Displays file title Book1 - Excel and window buttons (Minimize, Maximize, Close).
    • [Label: Quick Access Toolbar] (Top-left corner): Displays quick icons for Save (diskette), Undo (curved back arrow), Redo (curved forward arrow), and Print.
  • Second Level (Ribbon Bar):
    • [Label: Ribbon Control Center] (Below Title Bar): Displays 8 tabs (File, Home, Insert, Page Layout, Formulas, Data, Review, View) containing tools grouped logically.
  • Third Level (Grid Name and Inputs):
    • [Label: Cell Name Box] (Left, below Ribbon): Shows the current active cell coordinate (e.g., A1).
    • [Label: Formula Bar] (Right of Name Box, wide bar): Displays the formula or active data of the selected cell.
  • Fourth Level (The Workspace Grid):
    • [Label: Columns] (Vertical headers): Running along the top margin of the grid, labeled alphabetically A, B, C … XFD.
    • [Label: Rows] (Horizontal headers): Running down the left margin of the grid, labeled numerically 1, 2, 3 … 1048576.
    • [Label: Active Cell & Cell Pointer] (Selected rectangular intersection): Displays a thick, dark bold frame around the active cell.
  • Fifth Level (Navigation & Information):
    • [Label: Sheet Tab Hub] (Bottom-left): Shows tab Sheet1 next to a plus sign + button labeled [New Sheet Icon].
    • [Label: Scroll Bars] (Right edge and bottom-right edge): Displays the Vertical Scrollbar and Horizontal Scrollbar for grid panning.
    • [Label: Status Bar] (Very bottom strip): Displays selection calculations (Sum: XX, Average: YY, Count: ZZ) on the left, and standard view buttons with the Zoom Slider on the right.

Flowchart 8.2: The Launch-to-Save Document Pipeline

A logical sequential flow showing the algorithm to open, work, and successfully save a new Excel workbook.

[Start]
   │
   ▼
[Choose Launch Method]
   ├── Start Menu Path: Click Start -> Find Excel -> Click
   └── Run Dialog Path: Windows+R -> Type 'excel' -> Click OK
   │
   ▼
[New File selection Window]
   │
   ▼
[Click "Blank workbook" Thumbnail] ───► (Initializes as "Book1")
   │
   ▼
[Select Target Cell (e.g., C1)]
   │
   ▼
[Type Cell Content / Numbers]
   │
   ├── (Text automatically aligns LEFT)
   └── (Numbers automatically align RIGHT)
   │
   ▼
[Click "File" Tab on Ribbon]
   │
   ▼
[Select "Save As" Option]
   │
   ▼
[Click "Browse" Button]
   │
   ▼
[Choose Folder Location & Type Filename]
   │
   ▼
[Click "Save" Button] ───► (File saved as .xlsx)
   │
   ▼
[End]

Flowchart 8.3: Worksheet Lifecycle Decision Map

Procedural flows detailing sheet management routines (Adding, Renaming, and Deleting) depending on whether the user prefers the Ribbon or context menus.

                  [Sheet Management Choice]
                              │
       ┌──────────────────────┼──────────────────────┐
       ▼                      ▼                      ▼
  [ADD SHEET]          [RENAME SHEET]         [DELETE SHEET]
       │                      │                      │
 ┌─────┴─────┐          ┌─────┴─────┐          ┌─────┴─────┐
 ▼           ▼          ▼           ▼          ▼           ▼
[Path A]    [Path B]   [Path A]    [Path B]   [Path A]    [Path B]
Click "+"   Right-Click Double-Click Right-Click Click Home  Right-Click
icon next   Sheet Tab -> Sheet Tab -> Sheet Tab -> Tab ->      Sheet Tab ->
to Sheet1   Select      Type New   Select     Click       Select
tab    "Insert" -> Name ->    "Rename" -> Delete ->   "Delete"
            Click "OK"  Press      Type New   Click
                   Enter Name ->    "Delete
                                   Press      Sheet"
                                   Enter

Diagram 8.4: Cell Range Address Syntax Parser

An anatomical diagram showing how Excel interprets contiguous selections of cell blocks.

  • Visual Representation: A highlighted 3×3 box grid starting at cell B2 and ending at cell C4.
  • Syntactical Breakdown: $$\mathbf{B2 : C4}$$
    • [B2 Component] Labeled as: “Top-Left Origin Reference” (Coordinating Column B, Row 2).
    • [: Component] Labeled as: “Range Operator” (Tells Excel to select all adjacent cells between the boundaries).
    • [C4 Component] Labeled as: “Bottom-Right Boundary Reference” (Coordinating Column C, Row 4).
    • Entire Highlighted Block Labeled as: “Contiguous Cell Range B2:C4” (Comprising cells B2, B3, B4, C2, C3, and C4).

QUESTIONS :

Master Question Bank: MS Excel – Working with Worksheet

Section 1: The “Hidden” In-Text Questions (Mid-Chapter Extraction)

Q1. Based on the chapter introduction, how does the process of performing worksheet operations differ conceptually from simply entering data, and what is its primary purpose?

Q2. According to the text, what is the exact technical difference between “copying” and “moving” cell contents in MS Excel?

Q3. What is the moving dashed line that appears when Copy or Cut is clicked on the Ribbon, and what specific step must be executed to remove it from the selected cells?

Q4. How does the right-click context menu method for copying and pasting data provide alternative visual “Paste Options” compared to the standard ribbon command?

Q5. When using the mouse pointer to copy data in adjoining cells, what physical change happens to the cursor at the bottom-right corner, and what is this handle called?

Q6. What visual cue does the mouse pointer display when you hover over the boundary edge of a selection to move cell contents, and how does this differ from the AutoFill handle?

Q7. Explain how the AutoFill feature operates when selecting a single text value (such as days of the week or months) versus selecting numbers. Why do numbers require typing the first two values?

Q8. Describe the complete menu navigation path in the Excel Options dialog box that a user must follow to locate the “Edit Custom Lists…” button.

Q9. In terms of worksheet recovery, what are the precise behaviors of the Undo and Redo commands, and where are they visually located in the Excel application window?

Q10. Explain the structural rules governing cell insertion. What happens when a user selects “Shift cells down” versus “Shift cells right” in the Insert dialog box?

Q11. According to the literal wording of the textbook, how does the “Shift cells left” option behave in the Delete dialog box, and how does this compare to the “Shift cells up” option?

Q12. What is the default character width of a column in Excel, what is the maximum width allowed, and what is the physical result of setting the column width to 0?

Q13. Compare the default row heights between Microsoft Office 2016 and Microsoft Office 2019, and identify the maximum point value allowed for row height in Excel.

Section 2: The Textbook Exercise Integration (Back-of-Chapter)

A. Choose the correct answer.

Q14. Which option is used to automatically change the column width to fit the content?

A) AutoAdjust Column Width B) AutoSet Column Width C) AutoFit Column Width D) AutoFit Column Height

Q15. Cell A1 contains the date 06-10-2023 and cell A2 contains 03-10-2023. After selecting both and dragging the fill handle down, what date will appear in cell A3?

A) 30-9-2023 B) 09-10-2023 C) 03-10-2023 D) 27-09-2023

Q16. + shaped mouse pointer at the bottom right corner of a cell is called

A) AutoFill Handle B) Addition sign C) Move handle D) Resize handle

Q17. Anu has created her own auto fill list of names of 10 cities. Such list is called?

A) My List B) City List C) Custom List D) Auto List

Q18. The moving dashed lines around a selection in MS Excel are removed by pressing:

A) Esc key B) Ctrl + C C) Spacebar D) Tab key

B. Fill in the blanks.

Q19. Column width or row height can be changed by using command or __________.

Q20. Using AutoFill, we can create series of numbers, month names and __________ etc.

Q21. Duplicating the data is called __________.

Q22. Changing the original location of the data to a new one is called __________.

Q23. Move or Copy actions are complete after __________ is done.

C. Tick (✔) the correct statement and cross (✘) out the wrong one.

Q24. AutoFill feature can fill the data in scattered, non-adjacent cells.

Q25. Using mouse, the height of a column can be adjusted.

Q26. Deleting a column makes one column less in a sheet.

Q27. In an AutoFill series of numbers 1, 4, the next number will be 8.

Q28. Pressing Escape key removes the moving dotted line around a selection in Excel.

D. Answer the following questions.

Q29. What is the significance of Undo and Redo commands.

Q30. Write the steps to fill the series using AutoFill handle from Wed to Tue from cell A1.

Q31. Write the steps to copy data in cells A1, A2, A3 and A4 to cells B5, B6, B7, B8.

Q32. Write the shortcut keys to do the following. i. Moving data ii. Redoing an undone action iii. Insert a row or column iv. Delete a row or column

Section 3: Exhaustive Objective Bank (The Factual Baseline)

Multiple-Choice Questions (MCQs)

Q33. What is the default command on the Ribbon used to relocate selected data to another cell?

A) Copy B) Cut C) Format Painter D) Redo

Q34. Which group on the Home tab of the Ribbon contains the Copy, Cut, and Paste commands?

A) Clipboard group B) Font group C) Cells group D) Styles group

Q35. When data is copied, the moving dashed line that surrounds the cell selection is often referred to in standard practice as:

A) Wandering ants B) Moving dots C) Marching ants D) Blinking border

Q36. What is the physical keyboard shortcut to perform the Undo action in Excel?

A) Ctrl + Y B) Ctrl + U C) Ctrl + Z D) Ctrl + X

Q37. What keyboard shortcut is used to copy the selected data to the clipboard?

A) Ctrl + P B) Ctrl + V C) Ctrl + X D) Ctrl + C

Q38. What mouse pointer symbol indicates that Excel is ready to move selected cells to a new location?

A) Solid plus sign B) Four-headed arrow (move pointer) C) Double-headed arrow D) White cross pointer

Q39. In order to create a custom mathematical series using AutoFill, how many values must be typed into adjacent cells?

A) One B) Two C) Three D) Four

Q40. Which of the following is NOT a built-in AutoFill sequence that can be generated using a single-value entry?

A) Mon, Tue, Wed… B) Jan, Feb, Mar… C) Apple, Orange, Banana… D) Sun, Mon, Tue…

Q41. In which section of the Excel Options dialog box can you find the Edit Custom Lists button?

A) Advanced section under the General heading B) Proofing section under AutoCorrect Options C) Customize Ribbon section D) Save section under Default File Locations

Q42. Which dialog box allows you to add or delete custom sequences for sorting and filling?

A) List Entries Box B) Advanced Options Dialog C) Custom Lists Dialog Box D) AutoFill Settings Dialog

Q43. Which shortcut key sequence is used to paste the contents of the Clipboard?

A) Ctrl + P B) Ctrl + V C) Ctrl + C D) Ctrl + Esc

Q44. To insert a row or column using a keyboard shortcut, which key combination is used on selected headers? A) Ctrl + – B) Ctrl + I C) Ctrl + + D) Alt + I

Q45. When you click Insert Sheet Rows from the Cells group, where does Excel place the new blank row?

A) Below the selected row B) Above the selected row C) To the left of the selected row D) At the very top of the worksheet

Q46. When you click Insert Sheet Columns from the Cells group, where does Excel place the new blank column?

A) To the right of the selected column B) To the left of the selected column C) At the very end of the worksheet D) In the middle of Column A and B

Q47. If you select cell C5 and click Insert Cells… and choose “Shift cells right,” where does the existing data in C5 go?

A) It is deleted B) It shifts to C6 C) It shifts to D5 D) It remains in place and is overwritten

Q48. Which option in the Delete dialog box overwrites content by shifting the data from the cell below to the selected cell? A) Shift cells left B) Shift cells up C) Entire row D) Entire column

Q49. Which menu command is used to set a column to a specific numeric width value in Excel?

A) Format > AutoFit Column Width B) Format > Column Width… C) Insert > Column Width D) Delete > Column Width

Q50. What is the maximum width of a column that can be specified in Microsoft Excel?

A) 100 characters B) 150 characters C) 255 characters D) 409 characters

Q51. What is the maximum height of a row that can be specified in Microsoft Excel?

A) 255 points B) 409 points C) 500 points D) 15 points

Q52. To change the width of multiple columns at the same time using the Format menu, what must you do first?

A) Double-click the Format button B) Select the columns using their headers C) Right-click on the Quick Access Toolbar D) Enter a column width of 0

Q53. When you select a column header and press Ctrl + minus (-), what happens to the worksheet structure?

A) The entire column is deleted and remaining columns shift left B) The column contents are cleared but the column remains blank C) A dialog box opens asking for shift direction D) The column width is set to 8.43

Q54. What happens when a user releases the mouse button after dragging the AutoFill Handle to fill a range of cells?

A) Excel immediately saves the file B) An AutoFill icon is displayed with a customizable sub-menu C) The worksheet is automatically formatted D) The Undo command is deactivated

Fill-in-the-Blanks

Q55. Excel displays a moving __________ line around selected cells when copying or cutting them.

Q56. To remove the moving dashed lines after pasting, a user should press the __________ key.

Q57. Moving refers to __________ data from its current location to another.

Q58. To duplicate data in adjoining cells using a mouse, position the cursor until it turns into a solid __________ sign.

Q59. The mouse pointer changes into a four-headed arrow called the __________ pointer when hovering over selection edges.

Q60. AutoFill helps you quickly fill adjacent cells with a pattern or a __________ series of data.

Q61. If a row has a height of 0 (zero), the row is __________.

Q62. Creating lists for use in sorts and fill sequences is managed via the __________ button.

Q63. The shortcut keys to Undo an action are __________.

Q64. The option __________ is the default choice when you open the Insert dialog box.

Q65. To delete a cell, row, or column, you can select it and press the keyboard shortcut __________.

Q66. The default column width in Excel is __________ characters.

Q67. By default, the row height is 15 points in MS Office __________.

Q68. You can specify a row height from 0 (zero) to __________ points.

Q69. In an AutoFill series beginning with numbers 5 and 10, the next calculated value will be __________.

True/False Questions

Q70. AutoFill can only fill data in a horizontal direction across columns. (If False, correct the statement)

Q71. When you delete a row using the “Entire row” delete option, the row content is overwritten by shifting data from the cells below. (If False, correct the statement)

Q72. The keyboard shortcut for Redoing an action is Ctrl + Z. (If False, correct the statement)

Q73. Column width can be changed only after entering data into cells. (If False, correct the statement)

Q74. Double-clicking on the right border of a column header automatically adjusts its width based on the cell containing the maximum characters. (If False, correct the statement)

Q75. The default row height is 12.75 points in MS Office 2019. (If False, correct the statement)

Q76. Inserting multiple rows at a time is impossible in Microsoft Excel. (If False, correct the statement)

Q77. Deleting a column in Excel physically reduces the total column count available in the grid structure. (If False, correct the statement)

Q78. In the Custom Lists dialog box, the Add button is clicked to transfer typed entries from the List entries box to the Custom lists box. (If False, correct the statement)

Q79. Pressing the Escape key deletes the content inside the pasted cells. (If False, correct the statement)

Section 4: Subjective & Competency Bank (Higher-Order Thinking)

Short-Answer Questions (Write each question strictly on a single line)

Q80. Explain the visual representation of active clipboard data in Excel and how to properly clear this state.

Q81. How does the default behavior of Excel differ when inserting a cell versus inserting an entire worksheet row?

Q82. Why is typing only the number “1” and dragging the AutoFill handle down insufficient to create a sequence of 1, 2, 3, 4, 5?

Q83. Describe the technical steps to modify column widths using the Ribbon command method rather than the manual mouse dragging method.

Q84. Explain the difference between deleting a cell’s contents and deleting the cell itself from the worksheet grid.

Q85. Why does Excel have different default row heights in MS Office 2016 (12.75 pt) compared to MS Office 2019 (15 pt)?

Q86. How does the “Shift cells left” delete command affect adjacent cells in the same row?

Q87. Explain the “Amazing Fact” concerning how you can insert multiple rows or columns in a single operation.

Q88. Why is the “AutoFit Column Width” command considered critical when preparing spreadsheets for high-density data printing?

Q89. Explain how the Redo command acts as a dependent counterpart to the Undo command on the Quick Access Toolbar.

Scenario-Based / Competency Questions (Write each question strictly on a single line)

Q90. Scenario: An accountant imports a financial ledger where some columns display a series of “###” instead of numbers. Explain the cause of this display issue and outline the exact keyboard and mouse-based actions to fix it automatically.

Q91. Scenario: A project manager wants to create a progress tracker starting on Wednesday and ending on Tuesday of the following week. Write down the precise AutoFill steps to create this series in column B starting at B2.

Q92. Scenario: A school clerk enters a student roster. They accidentally omitted a student between row 15 (Roll No 14) and row 16 (Roll No 15). Write down the exact steps to insert a new row above row 16 using both Ribbon commands and keyboard shortcuts.

Q93. Scenario: A user has copied a column of calculations from Column A to Column F. After pasting, they notice that the moving dashed lines are still active around Column A. Explain the steps to deactivate this border without modifying the pasted data.

Q94. Scenario: A laboratory assistant wants Excel to recognize a custom cycle of five chemical names: “Hydrogen”, “Helium”, “Lithium”, “Beryllium”, “Boron”. Detail the exact configuration path they must follow to save this list permanently in their software environment.

Long-Answer / Essay Questions (Write each question strictly on a single line)

Q95. Detail three different methods to copy cell contents from one worksheet location to another, comparing their operational steps, mouse cursor states, and efficiency.

Q96. Analyze the structure and options of the Insert Dialog Box versus the Delete Dialog Box. Provide a full technical breakdown of the four shift directions, how they modify the grid coordinates, and their structural defaults.

Q97. Write a detailed procedural guide on how to create, register, and apply a Custom AutoFill List in Microsoft Excel, listing the precise navigation paths and dialog box interactions.

Q98. Evaluate the role of column width and row height adjustments in data presentation. Explain the physical limits (0-255 characters, 0-409 points), default settings across versions, and how a setting of 0 is used functionally.

Q99. Explain the technical differences between mouse-based “drag-and-drop” operations for copying data versus moving data. Detail the exact cursor changes and the mechanical actions needed for each.

Section 5: The Master Answer Key & Marking Rubric

Section 5.1: Answer Key for Section 1 (Hidden In-Text Questions)

Q1. Answer: Entering data is the simple act of inputting text or numbers into cells. Worksheet operations involve manipulating the underlying structure, layout, and position of cells, rows, columns, and datasets to organize, format, and manage data efficiently.

  • Marking Rubric:
    • 1 Mark: Explaining data entry (inputting data).
    • 1 Mark: Explaining worksheet operations (manipulating structure/layout/position of cells/rows/columns).
    • 1 Mark: Specifying the purpose (efficiency, organization, management).

Q2. Answer: Copying refers to duplicating data (text, numbers, or formulas), leaving the original data in its source location intact. Moving involves cutting or transferring the data from its original source location to a brand new destination, leaving the source location vacant.

  • Marking Rubric:
    • 1.5 Marks: Defining copying as duplicating text, numbers, or formulas.
    • 1.5 Marks: Defining moving as transferring data from its original location to a new one.

Q3. Answer: The moving dashed line indicates that the selected cell contents are currently copied or cut and saved to the Clipboard. To remove this line, the user must press the Esc (Escape) key on the keyboard.

  • Marking Rubric:
    • 1.5 Marks: Identifying the dashed line as the clipboard active selection.
    • 1.5 Marks: Stating that the Esc key must be pressed to remove it.

Q4. Answer: The right-click method provides a context-sensitive menu that directly shows “Paste Options” (such as Paste, Values, Formulas, Transpose, Formatting, and Paste Link) under the click cursor, allowing the user to choose the format of the pasted data immediately without moving up to the Ribbon.

  • Marking Rubric:
    • 1.5 Marks: Explaining right-click brings up the pop-up/context menu directly at the cursor location.
    • 1.5 Marks: Explaining that “Paste Options” are immediately accessible at the cursor.

Q5. Answer: The mouse pointer transitions from a thick white cross to a solid black plus sign (+). This coordinate point is technically referred to as the AutoFill Handle.

  • Marking Rubric:
    • 1.5 Marks: Stating the cursor transitions to a solid black plus sign +.
    • 1.5 Marks: Naming the coordinate point as the AutoFill Handle.

Q6. Answer: The cursor changes into the move pointer symbol (a four-headed arrow) when hovered over the selection boundary. The AutoFill handle only appears at the bottom-right corner as a solid black plus sign (+) and is used to duplicate or extend patterns, whereas the move pointer appears anywhere along the outer edge of the selection and transfers data.

  • Marking Rubric:
    • 1.5 Marks: Describing the move pointer cursor (four-headed arrow) on the outer selection edge.
    • 1.5 Marks: Contrasting it with the AutoFill cursor shape (black plus sign) and its corner placement.

Q7. Answer: For built-in lists like weekdays or months, Excel has pre-saved lists and only needs a single value to extend the sequence. For numbers, Excel cannot assume the sequence spacing (e.g., whether the user wants odd numbers, even numbers, or increments of 1). Therefore, numbers require typing the first two values to establish the step value (pattern spacing).

  • Marking Rubric:
    • 1 Mark: Explaining single-value entry for built-in text lists.
    • 1 Mark: Explaining double-value entry for numbers to calculate step value.
    • 1 Mark: Grounding with an example (e.g., establishing pattern intervals).

Q8. Answer: The correct navigation path is: Click File tab -> Select More (if Options is hidden) -> Click Options -> Select Advanced in the left pane of the Excel Options dialog box -> Scroll down in the right pane to the General section -> Click the Edit Custom Lists… button.

  • Marking Rubric:
    • 1 Mark: File tab > Options.
    • 1 Mark: Advanced section.
    • 1 Mark: General section > Edit Custom Lists… button.

Q9. Answer: The Undo command cancels the last performed worksheet action. The Redo command reverses the Undo command (re-applies the undone change). Both buttons are located on the Quick Access Toolbar at the top of the Excel window.

  • Marking Rubric:
    • 1 Mark: Defining Undo (cancels last action).
    • 1 Mark: Defining Redo (reverses Undo).
    • 1 Mark: Locating them on the Quick Access Toolbar at the top of the screen.

Q10. Answer: “Shift cells down” shifts existing cells down to make room for a new blank cell (this is Excel’s default insert behavior). “Shift cells right” shifts existing cells in that row to the right. Unlike row/column insertions which affect the entire grid line, cell shifting only offsets the selected cell block, which can cause row/column misalignment.

  • Marking Rubric:
    • 1 Mark: Detailing Shift cells down (shifts cells down, default).
    • 1 Mark: Detailing Shift cells right (shifts cells right).
    • 1 Mark: Noting that cell shifting does not insert an entire structural row or column.

Q11. Answer: According to the textbook, “Shift cells left” overwrites the content of the selected cell by shifting the data from the left cell into the selected cell. “Shift cells up” overwrites the content by shifting the data from the cell below to the selected cell.

  • Marking Rubric:
    • 1.5 Marks: Wording Shift cells left as overwriting by shifting data from the left cell (as per text).
    • 1.5 Marks: Wording Shift cells up as overwriting by shifting data from the cell below.

Q12. Answer: The default column width is 8.43 characters. The maximum column width you can specify is 255 characters. Setting the column width to 0 (zero) hides the column completely from view.

  • Marking Rubric:
    • 1 Mark: Identifying default width of 8.43 characters.
    • 1 Mark: Identifying maximum width of 255 characters.
    • 1 Mark: Detailing that a width of 0 hides the column.

Q13. Answer: The default row height is 15 points in Microsoft Office 2019 and 12.75 points in Microsoft Office 2016. The maximum row height you can specify is 409 points.

  • Marking Rubric:
    • 1 Mark: Office 2019 default is 15 points.
    • 1 Mark: Office 2016 default is 12.75 points.
    • 1 Mark: Maximum height of 409 points.

Section 5.2: Answer Key for Section 2 (Textbook Exercise Integration)

A. Choose the correct answer.

  • Q14. Answer: C) AutoFit Column Width
  • Q15. Answer: A) 30-9-2023 (Step calculations: 06-10 to 03-10 is a decrease of 3 days. Subtracting 3 days from 03-10-2023 results in 30-09-2023)
  • Q16. Answer: A) AutoFill Handle
  • Q17. Answer: C) Custom List
  • Q18. Answer: A) Esc key

B. Fill in the blanks.

  • Q19. Answer: mouse
  • Q20. Answer: dates (or days of week)
  • Q21. Answer: Copying
  • Q22. Answer: moving
  • Q23. Answer: pasting (or paste)

C. Tick (✔) the correct statement and cross (✘) out the wrong one.

  • Q24. Answer: ✘ (AutoFill feature can only fill data in adjacent, continuous cells, not scattered or non-adjacent ones)
  • Q25. Answer: ✘ (Using the mouse, the width of a column can be adjusted, and the height of a row can be adjusted, but you cannot adjust the height of a column)
  • Q26. Answer: ✘ (Deleting a column in Excel overwrites its content by shifting data from the column on the right. The total number of columns in the worksheet remains constant)
  • Q27. Answer: ✘ (In an AutoFill series of 1, 4, the step value is +3, so the next number will be 7, not 8)
  • Q28. Answer: ✔

D. Answer the following questions.

Q29. Answer: The Undo command lets you cancel your last action (e.g., if you delete something by mistake), restoring the worksheet to its previous state. The Redo command reverses the Undo command, re-applying the change that was rolled back.

  • Marking Rubric:
    • 1 Mark: Significance of Undo (restores previous state/cancels last mistake).
    • 1 Mark: Significance of Redo (reverses Undo).
    • Found in Section: “Undo and Redo Commands”.

Q30. Answer:

  1. Type the starting value Wed in cell A1.
  2. Place the cursor on the bottom-right corner of cell A1 until the pointer changes to a solid black plus sign (+) known as the AutoFill Handle.
  3. Click and drag the handle downward or across adjacent cells to cell G1 (or A7).
  4. Release the mouse button. The days of the week will populate sequentially as Wed, Thu, Fri, Sat, Sun, Mon, Tue.
  • Marking Rubric:
    • 1 Mark: Input “Wed” in cell A1.
    • 1 Mark: Position cursor to get the solid black plus sign (+) AutoFill Handle.
    • 1 Mark: Drag across adjacent cells and release.
    • Found in Section: “Using AutoFill Feature”.

Q31. Answer:

  1. Select the range of cells A1:A4.
  2. Click on the Home tab, and in the Clipboard group, click the Copy button. (Moving dashed lines will appear around the cells A1:A4).
  3. Click on the destination cell B5.
  4. Click the Paste button inside the Clipboard group on the Home tab.
  5. Press the Esc key to clear the moving dashed lines.
  • Marking Rubric:
    • 1 Mark: Select cell range A1:A4.
    • 1 Mark: Use Copy command via Ribbon (Home > Clipboard > Copy).
    • 1 Mark: Navigate to B5 and click Paste (Home > Clipboard > Paste).
    • 1 Mark: Deactivate Clipboard border using Esc.
    • Found in Section: “Copying/ Moving the data”.

Q32. Answer:

  • i. Moving data: Ctrl + X (Cut) and Ctrl + V (Paste)
  • ii. Redoing an undone action: Ctrl + Y
  • iii. Insert a row or column: Ctrl + + (after selecting row/column header)
  • iv. Delete a row or column: Ctrl + - (after selecting row/column header)
  • Marking Rubric:
    • 1 Mark for each correct shortcut key (Total 4 Marks).
    • Found in Section: Scattered Keyboard Shortcuts throughout the chapter.

Section 5.3: Answer Key for Section 3 (Objective Bank)

Multiple-Choice Questions (MCQs)

  • Q33. Answer: B) Cut
  • Q34. Answer: A) Clipboard group
  • Q35. Answer: C) Marching ants (Common standard practice referenced in note)
  • Q36. Answer: C) Ctrl + Z
  • Q37. Answer: D) Ctrl + C
  • Q38. Answer: B) Four-headed arrow (move pointer)
  • Q39. Answer: B) Two
  • Q40. Answer: C) Apple, Orange, Banana… (Not a built-in series list)
  • Q41. Answer: A) Advanced section under the General heading
  • Q42. Answer: C) Custom Lists Dialog Box
  • Q43. Answer: B) Ctrl + V
  • Q44. Answer: C) Ctrl + +
  • Q45. Answer: B) Above the selected row
  • Q46. Answer: B) To the left of the selected column
  • Q47. Answer: C) It shifts to D5 (Shifting cell right moves column C to column D)
  • Q48. Answer: B) Shift cells up
  • Q49. Answer: B) Format > Column Width…
  • Q50. Answer: C) 255 characters
  • Q51. Answer: B) 409 points
  • Q52. Answer: B) Select the columns using their headers
  • Q53. Answer: A) The entire column is deleted and remaining columns shift left
  • Q54. Answer: B) An AutoFill icon is displayed with a customizable sub-menu

Fill-in-the-Blanks

  • Q55. Answer: dashed
  • Q56. Answer: Esc (or Escape)
  • Q57. Answer: transferring
  • Q58. Answer: plus
  • Q59. Answer: move
  • Q60. Answer: predefined
  • Q61. Answer: hidden
  • Q62. Answer: Edit Custom Lists
  • Q63. Answer: Ctrl + Z
  • Q64. Answer: Shift cells down
  • Q65. Answer: Ctrl + –
  • Q66. Answer: 8.43
  • Q67. Answer: 2019 (15 points)
  • Q68. Answer: 409
  • Q69. Answer: 15 (Step calculation: 5 to 10 is +5; 10 + 5 = 15)

True/False Questions

  • Q70. Answer: False. (AutoFill can fill data in both horizontal and vertical directions across rows and columns)
  • Q71. Answer: True.
  • Q72. Answer: False. (The keyboard shortcut for Redoing an action is Ctrl + Y)
  • Q73. Answer: False. (Column width can be adjusted before or after entering the data)
  • Q74. Answer: True.
  • Q75. Answer: False. (The default row height is 12.75 points in MS Office 2016, and 15 points in MS Office 2019)
  • Q76. Answer: False. (You can insert multiple rows at a time by selecting the desired number of rows and executing the insert command)
  • Q77. Answer: False. (Deleting a column overwrites its content by shifting adjacent columns, but the grid dimensions remain constant)
  • Q78. Answer: True.
  • Q79. Answer: False. (Pressing the Escape key only removes the moving dashed line around the copied/cut cells, keeping pasted data intact)

Section 5.4: Marking Rubric for Section 4 (Subjective & Competency)

Short-Answer Questions

Q80. Answer Rubric:

  • Full Marks (3/3): Must state that clipboard data is visually outlined by a “moving dashed line”. Must mention that the Esc key must be pressed to clear this state. Must note that clearing it stops the active copy/cut selection but does not affect already pasted data.
  • Partial Marks (1.5/3): Mentions only the dashed line or only the Esc key without explaining their connection.
  • Section: “Copying/ Moving the data”

Q81. Answer Rubric:

  • Full Marks (3/3): Must explain that inserting a single cell opens a dialog box prompting direction shift (“Shift cells down” or “Shift cells right”), affecting only the relative columns/rows. Row insertion bypasses options and adds a full horizontal row above the selection, shifting the entire sheet downward.
  • Partial Marks (1.5/3): Explains only cell insertion or only row insertion.
  • Section: “Inserting Cell/Row/Column”

Q82. Answer Rubric:

  • Full Marks (3/3): Must clarify that Excel cannot identify mathematical steps from a single number. Dragging a single number will simply copy the value “1” down. To generate an arithmetic sequence, two numbers (e.g., 1 and 2) must be selected so Excel can calculate the step progression (+1).
  • Partial Marks (1.5/3): States that two values are needed but fails to explain the concept of calculating “step value” or “progression.”
  • Section: “Using AutoFill Feature”

Q83. Answer Rubric:

  • Full Marks (3/3): Detail exact navigation steps: Select columns > Home tab > Cells group > click Format button > select Column Width… option > type precise width in the dialog box > click OK.
  • Partial Marks (1.5/3): Skips the Cells group or the Format menu, describing only the general dialog box.
  • Section: “Changing the Column Width”

Q84. Answer Rubric:

  • Full Marks (3/3): Explain that deleting contents (e.g., using Clear Contents or Delete key) removes the data but leaves the cell structure and surrounding coordinates unchanged. Deleting the cell physically removes the grid space, forcing surrounding cells to shift (left or up) to occupy the void.
  • Partial Marks (1.5/3): Describes deleting content but fails to explain structural cell shifts.
  • Section: “Deleting Cell/Row/Column”

Q85. Answer Rubric:

  • Full Marks (3/3): Must attribute the difference directly to default specifications of software versions (MS Office 2016 defaults to 12.75 points; MS Office 2019 defaults to 15 points). No outside reason should be fabricated; it must simply reflect the default text facts.
  • Partial Marks (1/3): Names only one software version’s default height.
  • Section: “Changing the Row Height”

Q86. Answer Rubric:

  • Full Marks (3/3): Detail that “Shift cells left” deletes the selected cell and overwrites its content by shifting adjacent cells in that row leftward. Explicitly quote the book’s definition: “overwrites the content by shifting the data from the left cell to the selected cell”.
  • Partial Marks (1.5/3): Explains general cell deletion without explaining the direction of shifting.
  • Section: “Deleting Cell/Row/Column”

Q87. Answer Rubric:

  • Full Marks (3/3): Highlight that users can select multiple existing rows or columns before running the insert command. Stating that Excel will insert the exact same number of blank rows or columns as selected, placing them before/above the initial selection.
  • Partial Marks (1.5/3): Describes inserting a single row repeatedly instead of batch insertion.
  • Section: “Deleting Cell/Row/Column – Amazing Fact”

Q88. Answer Rubric:

  • Full Marks (3/3): Explain that AutoFit scales column widths according to the cell containing the maximum number of characters. This prevents visual truncation of numbers or long text strings (avoiding “###” and truncated characters) before printing.
  • Partial Marks (1.5/3): Mentions layout cleanup but lacks reference to maximum characters or truncation prevention.
  • Section: “Changing the Column Width”

Q89. Answer Rubric:

  • Full Marks (3/3): Must clarify that Redo has no independent action unless the Undo command has been used first. Undo rolls back the last change, while Redo reverses that Undo, re-applying the change. Both serve as structural editing recovery tools.
  • Partial Marks (1.5/3): Explains Undo and Redo as separate tools but fails to detail their codependency.
  • Section: “Undo and Redo Commands”

Scenario-Based / Competency Questions

Q90. Answer Rubric:

  • Full Marks (5/5):
    • Identify cause: The columns are too narrow to display the numbers, resulting in a width truncation display issue.
    • Method 1 (Mouse): Double-click the right boundary border of the affected column headers when the pointer changes to “+”.
    • Method 2 (Ribbon): Select the columns > Home tab > Cells group > Format > click AutoFit Column Width.
  • Partial Marks (2.5/5): Identifies the cause but provides only one correction method or skips exact navigation paths.
  • Section: “Changing the Column Width”

Q91. Answer Rubric:

  • Full Marks (5/5):
    • Step 1: Type “Wednesday” or “Wed” in cell B2.
    • Step 2: Hover over the bottom-right corner of cell B2 until the mouse pointer changes to a solid black plus sign (+) AutoFill Handle.
    • Step 3: Click and drag the handle down across column B to cell B8.
    • Step 4: Release the mouse. The cells will automatically populate “Thursday”, “Friday”, “Saturday”, “Sunday”, “Monday”, “Tuesday”.
  • Partial Marks (2.5/5): Fails to specify the exact coordinate ranges (B2 to B8) or ignores the solid plus cursor description.
  • Section: “Using AutoFill Feature”

Q92. Answer Rubric:

  • Full Marks (5/5):
    • Target element: Select Row 16 (which currently contains Roll No 15).
    • Method 1 (Ribbon): Home tab > Cells group > Click drop-down of Insert button > Select “Insert Sheet Rows”.
    • Method 2 (Keyboard Shortcut): Press Ctrl + + to insert a row above selected row.
    • Method 3 (Right-click): Right-click row header 16 and select Insert.
  • Partial Marks (2.5/5): Recommends shifting single cells instead of inserting a whole row, or misses the keyboard shortcuts.
  • Section: “Inserting Cell/Row/Column”

Q93. Answer Rubric:

  • Full Marks (5/5):
    • Explain that the moving dashed lines indicate that Column A’s data is still saved on the active Clipboard.
    • To remove this visual indicator, the user must press the Esc key.
    • Note that pressing Esc will not delete the already pasted data in Column F.
  • Partial Marks (2.5/5): Recommends deleting Column A or suggests undoing the action.
  • Section: “Copying/ Moving the data”

Q94. Answer Rubric:

  • Full Marks (5/5):
    • Step 1: Navigate to File > More > Options > Advanced.
    • Step 2: Scroll down to General section and click Edit Custom Lists….
    • Step 3: Click in the List entries text box.
    • Step 4: Type “Hydrogen”, “Helium”, “Lithium”, “Beryllium”, “Boron”, pressing Enter after each.
    • Step 5: Click Add to copy them to the Custom lists box.
    • Step 6: Click OK on both dialog boxes to apply.
  • Partial Marks (2.5/5): Misses the precise options sub-path (More > Options > Advanced > General) or forgets to click “Add.”
  • Section: “Creating Custom Lists”

Long-Answer / Essay Questions

Q95. Answer Rubric:

  • Full Marks (10/10):
    • Method 1 (Ribbon): Detailed steps (Select > Home > Clipboard group > Copy > Destination > Home > Clipboard > Paste). Visual states: moving dashed line appears.
    • Method 2 (Mouse Drag): Detailed steps (Select > bottom-right corner > Solid black plus sign ‘+’ > drag and release). Visual states: solid black plus. Note: This is specifically for adjoining cells.
    • Method 3 (Right-Click): Detailed steps (Select > Right-click > Copy > Right-click destination > Paste Option).
    • Comparison: Ribbon is best for large non-adjoining blocks; Right-click is local and rapid; Mouse drag is fastest but restricted to adjacent cell rows/columns.
  • Partial Marks (5/10): Misses one complete method or fails to contrast the mouse cursor visual transitions.
  • Section: “Copying and Moving cell contents”

Q96. Answer Rubric:

  • Full Marks (10/10):
    • Insert Dialog Box options:
      • Shift cells right: moves existing data right to make room.
      • Shift cells down: moves existing data down (Default).
      • Entire row: inserts complete blank row above.
      • Entire column: inserts complete blank column to the left.
    • Delete Dialog Box options:
      • Shift cells left: overwrites content by shifting data from the left (as per book).
      • Shift cells up: overwrites content by shifting data from below.
      • Entire row: overwrites row content by shifting rows below upward.
      • Entire column: overwrites column content by shifting columns to the right leftward.
    • Grid Coordination: Cell shifting affects only a portion of the table, whereas entire rows/columns shift the global grid lines.
  • Partial Marks (5/10): Lists the options but fails to compare their logical opposites or identify the default settings.
  • Section: “Inserting Cell/Row/Column” & “Deleting Cell/Row/Column”

Q97. Answer Rubric:

  • Full Marks (10/10):
    • Part 1: Setup: Path to options: File > More > Options > Advanced > General > Edit Custom Lists.
    • Part 2: Registration: Details typing entries sequentially in “List entries” box, hitting Enter, clicking Add button to register, and clicking OK on both Option boxes.
    • Part 3: Application: Explains entering the first item in any worksheet cell, using the AutoFill Handle (solid black plus sign) to drag, releasing to auto-populate the custom sequence.
  • Partial Marks (5/10): Explains how to use lists but fails to detail the system path to configure them.
  • Section: “Creating Custom Lists” & “Using AutoFill Feature”

Q98. Answer Rubric:

  • Full Marks (10/10):
    • Column Width limits & defaults: Default width is 8.43 characters. Limits range from 0 to 255 characters.
    • Row Height limits & defaults: Default row height is 15 pt in MS Office 2019, 12.75 pt in MS Office 2016. Limits range from 0 to 409 points.
    • The Zero Setting Functionality: Setting either height or width to 0 hides the row or column from active view. This is critical for hiding calculations or intermediate columns without corrupting formulas.
  • Partial Marks (5/10): Skips the default row height differences across Office versions or fails to explain the zero visibility function.
  • Section: “Changing the Column Width” & “Changing the Row Height”

Q99. Answer Rubric:

  • Full Marks (10/10):
    • Mouse Copying (Drag): Must select cells, hover bottom-right corner to get the solid black plus sign ‘+’ (AutoFill Handle), click and drag over adjacent cells. This duplicates data.
    • Mouse Moving (Drag): Must select cells, hover over any border edge of the selection to get the move pointer symbol (four-headed arrow), click and drag outline to new location, release. This transfers data.
    • Cursor Contrast: Move cursor is a four-headed arrow; Copy cursor is a solid plus sign. Drag-to-copy is limited to adjoining cells; drag-to-move can place content anywhere.
  • Partial Marks (5/10): Conflates the edge hover cursor with the corner hover cursor, or skips the mechanical limitations.
  • Section: “Copying the data in adjoining cells using mouse” & “Moving the data using mouse”

Leave a Comment