Excel spreadsheet key terms

Mrs Johnson
Flashcards by Mrs Johnson, updated more than 1 year ago
Mrs Johnson
Created by Mrs Johnson over 5 years ago
187
3

Description

Key words used when working with spreadsheets, and definitions.

Resource summary

Question Answer
Workbook A workbook is a collection of work sheets
Worksheet A worksheets consists of all the cells in the sheet
Formula a formula is a calculation which uses numbers, addresses or cells and mathematical operators
Function a function represents a complex formula that uses reserved words
Border A line that surrounds a cell or group of cells found on the Home tab
Fill Handle A tool used to copy formulas into adjacent cells
Chart Charts are visual representations of worksheet data.
Graph are used to show comparisons between items of data
Autosum AutoSum is a function that automatically enters the appropriate formula to add a column or row of numbers
Cell A cell is a box in which you can enter a single piece of data.
Cell reference A cell reference identifies the location of a cell or group of cells in the worksheet.
Relative The cell referenced in a formula changes when the formula is copied to other cells
Row Rows run across and each row is identified by a number in the .
Column A column runs down and each row is identified by a letter .
Show full summary Hide full summary

Similar

Geography Coasts Questions
becky_e
AS Economics Key Terms
Fred Clayton
All Edexcel GCSE PE key terms
Millie Berrett
| GCSE Busniness Studies | AQA | Key Terms | "Starting A Business" |
Spuddylicious
Computing - OCR - GCSE - Key Terms
Josh Anderson
Rivers, Floods and Management Key Terms
09newkieran31
Business Studies - AQA - GCSE - Business Studies Key Terms
Josh Anderson
Key terms for Russian Revolution
eleanor.faye99
Key terms for Russian Revolution
Darius von Guttner
DipFS Unit 4 Key Terms
Steve Gidley
CeFS Unit 2 Key Terms
Steve Gidley