Spreadsheet Basics and Text Editing Tips

Unit 14: Moving Text

Cutting and Pasting

Anna: Ben, do you know how I can move this paragraph? I want to put it at the end of this page.

Ben: I think so. First, select the text with your mouse. Then, choose "Cut" from the Edit menu.

Anna: Like this?

Ben: Yes. The text disappears and is copied to the Clipboard. Click where you want the text to go.

Anna: Okay. Is that right?

Ben: Yes, if that's the correct spot. Next, choose "Paste" from the Edit menu, or press CTRL+V.

Anna: Okay, done. Is that all?

Ben: Yes. If you make a mistake, choose "Undo" from the Edit menu to reverse your last action.

Anna: Brilliant! Thanks!

Ben: You're welcome.

Unit 15: Spreadsheet Fundamentals

Introduction

Let's start with the basics. Spreadsheets are used in business for financial planning, accounting, budget analysis, and calculations. They resemble a grid with columns (labeled with letters) and rows (labeled with numbers). A cell is where a column and row intersect (e.g., A1, B6, C5).

Cell Content

Cells hold text, numbers, and formulas. For example, "Sales" might be in cell A2, with values like 890, 487, and 182 in cells B2, B3, and B4. Entering the formula B2+B3+B4 into cell B5 automatically calculates and displays the sum.

Formulae and Functions

Formulae perform operations (addition, subtraction, multiplication, division) on existing values to create new ones. They calculate totals, percentages, and discounts. Changing one cell's value automatically recalculates others. Linking cells updates information across worksheets.

Formatting

The format menu lets you adjust font, number alignment, borders, column width, etc.

Charts and Graphs

Spreadsheets generate graphs (line, bar, pie) and even 3D charts to visualize cell values.

Database Functionality

Some spreadsheets have database features, where columns become fields and rows become records.