excel Flashcards
what is a spreadsheet?
is a list of data arranged in rows and columns. The primary purpose of organising data in a spreadsheet is to express the relationship between sets of numeric data.
what does a spreadsheet allow?
store
organise
analyse
gain insight into information
examples of spreadsheet programs?
microsoft excel, apple iWork numbers
what is the ribbon in ms excel?
panel at top of workbook, contains all commands needed to perform tasks
multiple tabs with groups
title bar in ms excel?
appears at the top of each excel workbook and workbook window
contains name of document
what is the quick access toolbar in ms excel
appears on left side of title bar
contains frequently used commands
can be customised
what is name box in ms excel
displays position of active cells
located below the ribbon
name of cells can be changed
formula bar in ms excel
displays content of active cells
can do equations, calculations and maths in the formula bar
status bar in ms excel
shows progress of commands
at bottom of worksheet
what is workbook?
Consists of one or more worksheet (excel refers to spreadsheets as worksheet).
what is a worksheet?
A worksheet is simply a grid of columns and rows identified by letters and numbers
what is range in ms excel
Range is a selection of one or more cells. You would need to select a cell and drag it over any numbers of cells to create a range
how to select a range?
-Click and drag over the cells
-Release mouse and cell will be shaded
-Multiple cells appear in a box with a border
difference between absolute and relative cell reference
If you want one or more cell references not to be adjusted or to be absolute
to be absolute click f4
relative means cells can be adjusted when working
