Spreadsheet
Excel is a program that helps organise and use information in a fast way especially with all the functions and formulas. Formulas are a long line of text, numbers and strange signs we use to command Excel to do the things we want. It is similar to Microsoft Access, a database program but it works more with numbers and calculations.This are parts that you should know about spreadSheet
Here are some Simple & Basics Functions that you'll need to know...
SYNTAX= the format of writing functions and formulae, if the function is incorrect, it won’t work.
SUM: functions used to add a range of number
=SUM(number : number)
Average: A function used to find the average in a range of numbers (it works the same way like SUM did, both of them have the same syntax)
=AVERAGE(number : number)
COUNT: A function used to count the number of times a number appears in a range of value.
=COUNT(number : number)
MIN: A function used to find the smallest number in a range of numbers.
=MIN(number : number)
MAX: A function used to find the largest number in a range of numbers.
=MAX(number : number)
ROUND: A function used to round number a number to a certain number of decimals places.
=ROUND(number,num_digit) *num_digit tells the decimal places
INT: A function used to convert a decimal number into a whole number. Be Careful because this function just deletes the decimal part of the number.(It doesn’t round the answer)
=INT(number)
SUMIF: This functions adds a range of number depending on a condition(if something is true or false). You need to use “” around your criteria.
=SUMIF(range,”criteria”)
COUNTIF:this function is used to count number of times a value appears in a range of numbers depending on a certain condition. You need to use “” around your criteria.
=COUNTIF(range,”Criteria”)
VLOOKUP: (V stands for vertical) this function will show specific data from another range of cells(Advanced)
=VLOOKUP(lookup_vlaue,table_array,col_index-num,false/true)
it can tells us:
=function name(what do you want to find,where do you want to look, which column do you want, do you want to find exactly what you are looking for)
lookup_value> the cell you want the data to be in
table_array>the table that has the data you want to insert, exclude the heading.
col_index_num>THe column that has the data(1,2,3,4…)
false/true> true= will find the next smallest number if the number you are looking for does not exist approximate match, False= exact match
LOOKUP(For basic range of column exp: 1-2 columns) unlike VLOOKUP(For bigger range of column)
LOOKUP:This function will show specific data from another range of cells which has been sorted.: It will only work if it is sorted.
IF: THis function will show different data depending on a condition.(Only 2 condition)
=IF(Logical_test, “value of true”,”Valueof_false”) if there s text in the function put it in a “”
=(B113>=40,”Pass”,”Fail”)
Nested IF : THis function will show different data depending on many condition(putting the value of TRUE not false)(the number of closing brackets= #logical test)
=IF((Logical_test, “value of true”,IF(Logical_test, “value of true”,IF(Logical_test, “value of true”,IF(Logical_test, “value of true”,IF(Logical_test, “value of fail”))))
Use the fill handle to “ Fill Handle”. It changes the range of the cell that are active.
relative Cell reference; Setting the cell by default. Does not LOCK the cell reference ** more info.
Absolute Cell references: Lock the cell reference. the symbol is “$” will be place in front of the range of cell that you want to lock.
The Excel 2003 Program Window
When you first launch the Microsoft Office application program Excel (versions 2003 and earlier), the following program window appears, containing three blank worksheets. You can build your new spreadsheet using any of the pages, which follow the general Excel Worksheet template.
Psssttttt......here are some more information about the spreadsheet.
The Excel 2003 Program Window
When you first launch the Microsoft Office application program Excel (versions 2003 and earlier), the following program window appears, containing three blank worksheets. You can build your new spreadsheet using any of the pages, which follow the general Excel Worksheet template.
The Standard toolbar in Excel contains a variety of buttons
for doing things like opening a new workbook, zooming in and out on your
current worksheet, and sorting selected items. Get to know the buttons for
performing common tasks on the Standard toolbar of Excel versions 2003 and
earlier by using the helpful figure below.
Excel 2003 Formatting Toolbar
The Formatting toolbar in Excel 2003 and earlier versions
holds a variety of buttons for commonly used formatting operations on your
average spreadsheet, like changing text size or style, formatting numbers, and
placing borders around cells. On the Formatting toolbar, the tools are arranged
into six groups of buttons (from left to right).
Excel Editing Shortcut Keys
A large part of the work you do in Excel is editing the cell
contents in worksheets. To save time editing, learn the following Excel
shortcuts, including the key combinations and their functions:
Press To
F2 Edit current
cell entry and position insertion point at the end of cell contents
Shift+F2 Edit
comment attached to current cell and position insertion point in comment box
Backspace Delete
character to left of insertion point when editing cell entry
Delete Delete character
to right of insertion point when editing cell entry: otherwise, clear cell
entries in current range
Esc Cancel editing
in current cell entry
Enter Complete editing
in current cell entry
Ctrl+C Copy cell
selection to the Windows Clipboard
Ctrl+X Cut cell
selection to the Windows Clipboard
Ctrl+V Paste last
copied or cut cells from the Windows Clipboard
Ctrl+hyphen (-) Open
Delete dialog box to delete cell selection and shift remaining cells left or up
Ctrl+Shift+plus (+) Open
Insert dialog box to insert new cells and shift existing cells right or down
Ctrl+Z Undo last action
Ctrl+Y Redo last undone
action
Excel Data Entry Shortcut Keys
When you're working in Excel and entering data in a cell,
it's essential to complete the entry either by clicking another cell with the
mouse pointer or by using one of the handy shortcut keys shown here to move the
cell cursor:
Press To
Arrow keys (↑, ↓, ←,
→) Complete cell entry and move cell cursor one
cell in direction of the arrow
Enter Complete cell
entry and move cell cursor down one row
Shift+Enter Complete
cell entry and move cell cursor up one row
Ctrl+Enter Complete
cell entry in all cells in selected range
Alt+Enter Begin a
new line in a cell entry
Tab Complete cell
entry and move cell cursor right one column
Shift+Tab Complete
cell entry and move cell cursor left one column
Esc Cancel current
cell entry
Ctrl+' (apostrophe) Copy
formula in cell above into current cell entry
Ctrl+Shift+" (quotation) Copy value from cell above into current cell entry
Ctrl+`(accent) Toggle
between displaying cell values and cell formulas in worksheet
Ctrl+; Insert current
date into current cell entry
Ctrl+Shift+; Insert
current time into current cell en
