lesson 3.3 Flashcards
is an interactive computer application for organization, analysis and storage of data in tabular form. ——- are widely used in various fields: finance, accounting, engineering, science, and business management, for tasks such as data entry, calculations, and data visualization
SPREADSHEET
A ——- can be used as a worksheet to compile data for a purpose, or multiple sheets can be combined to create an entire workbook.
single spreadsheet
A spreadsheet is generally designed to hold numerical data and short text strings.
In a spreadsheet program, spaces that hold items of data are called spreadsheet blocks.
tt
tf
ft
ff
A spreadsheet is generally designed to hold numerical data and short text strings. In a spreadsheet program, spaces that hold items of data are called spreadsheet cells.
tf
o Built-in tools to showcase your data visually, including bar charts, graphs and pie charts in
a variety of styles and colors
Visual Design
o It automatically recalculates all dependent formulas every time any value, formula, or name
referenced in those formulas is changed
Automatic Calculations
o It is the Syntax of the operation to be used o Used to perform calculations
Formulas
o It provides a set of data analysis tools which you can use to save steps when you develop
complex statistical analyses.
Data Analysis
o It automatically updates values in cells or ranges in a worksheet that is reference from
another worksheet or program.
Dynamic Updates
o Like Grammar in English language o Pre-made formulas
Function
o collection of worksheets
Workbook
o collection of rows and columns
Worksheet
when was microsoft excel introduced
late 1980s`
often viewed as the gold standard of spreadsheets and offers many features, from basic mathematical formulas to more complex automations and programming solutions via Visual Basic for Applications (VBA) macros.
excel
When the formula contains some incorrect cell references. Happens mainly when a row or column is mistakenly deleted.
REF! (Reference Error)-
When the formula contains numeric values that are not valid.
NUM!
