SPREADSHEET SOFTWARE Flashcards
Namo
productivity application that is used for
calculation and organizing data using tables and
functions.
Spreadsheet Software / Microsoft Excel
Started on ________ by__________ and
release the very first name of the
software which is ____________.
1978, Dan Bricklin, VISICALC
Developed by __________ and added 5
Columns and 20 rows called _______.
Mitch Kapor, Lotus 123
Adopted by Microsoft Corporation and
released their own version
Multi-Plan
Single box on the worksheet
Cell
Contains 2 or more cells
Range
the vertical area of the
worksheet that contains letters
Column Heading
these are the horizontal grid of
the worksheet started from no. 1 onwards.
Row Numbers
This shows the inputted formula
on the cell
Formula Bar
displays the name of the cell
Name Box
individual sheets of the worksheet
Sheet Tab
display the
entire worksheet
Vertical and Horizontal Scroll Bar
Addition,
subtraction, multiplication, & division
Math Operations
compute for the total values of a
range
Sum
give the average of a range
Average
function that is used to count
values of a range with criteria and
condition
Countif
used to get the overall total
from a range using a condition
Sumif
getting the average of a
values from a range using certain
condition or criteria
Averageif
a logical test that display
certain condition or criteria
If function
used to put
color markings on the cell or range
using rules and conditions
Conditional Formatting
function that is used
to create dropdown
Data Validation
used to retrieve a value
from a column number
Vlook-up
