Topic: Spreadsheet Functions
Not finding your answer? Try searching the web for Spreadsheet Functions
Answers to Common Questions
What Are the Functions of Spreadsheets?
A spreadsheet is a grid composed of an indefinite number of rows and columns that cross to make cells where information is entered. Many people use spreadsheets because of their easy-to-operate functions. Spreadsheets once were known as wor... Read More »
Source: http://www.ehow.com/about_5180444_functions-spreadsheets_.html?re...
How to Use the IF Function in Spreadsheets
1 Select the cell where you want to enter the function (usually a blank cell), for example B2 . 2 The first you need to do to type a function is type the equals sign . 3 Type IF 4 Open brackets, for example =IF( 5 Type the statement followe... Read More »
Source: http://www.wikihow.com/Use-the-IF-Function-in-Spreadsheets
What is nested functions in spreadsheet?
A nested function is a function inside another function. It comes from the term nested tables, where you have smaller tables inside other ones. Some calculations need to use several functions and sometimes this may involve using functions i... Read More »
Source: http://wiki.answers.com/Q/What_is_nested_functions_in_spreadsheet
More Common Questions
Answers to Other Common Questions
Function can be used for calculations in a spreadsheet. A simple example of a function is for adding a column of numbers. EXAMPLE: You have a column of 23 numbers in column B, from row 1 to row 23. To add all of those numbers, and display t...
Read More »
Source: http://wiki.answers.com/Q/What_is_a_pre_programmed_function_in_a_...
SUM totals a range of numbers. EXAMPLE: =SUM(A1:A14)
Read More »
Source: http://wiki.answers.com/Q/What_is_the_sum_function_on_spreadsheet...
Count function and counta function are a statistical functions in excels that helps us.. count. The difference between count function to counta function is that count function considers only cells that contains a number and counta function ...
Read More »
Source: http://wiki.answers.com/Q/What_does_the_COUNT_function_do_on_spre...
Collecting Data
Read More »
Source: http://wiki.answers.com/Q/Which_function_cannot_be_done_by_using_...
There is an almost infinite list of things (or functions if you prefer) that can not be achieved using a spreadsheet. I will write some for you to encourage your own imagination. You can not: 1. Achieve escape velocity and launch a rocket i...
Read More »
Source: http://wiki.answers.com/Q/What_function_can_not_be_done_by_using_...
collecting data
Read More »
Source: http://wiki.answers.com/Q/Which_of_these_functions_cannot_be_done...
You can use the SUM function to do it, or you could do it other ways, like just using the + in a formula.
Read More »
Source: http://wiki.answers.com/Q/What_is_the_function_in_a_spreadsheet_t...
