Application Software (Chapter 4)
Convergence
Distinction between categories of application software is becoming more blurred
Macros
Mini program that performs predefined action
Formula
Calculation that specifies operation to be formed
Hyperlinks
Directs readers to related docs
Absolute reference
Fixed cell location (never changes)
Relative reference
Identifies cell by location relative to other cells and changes when formula is moved or copied
Page orientation
Portrait or landscape
Native application
Program designed to run on specific operating systems
Web based applications
Programs you can access over the internet on a computer or on an app from mobile device
Web application
Resides on a server on the internet and it is run by a user through a web browser
Local applications
Application installed in the computers hard drive. Lots of features and functionality
Portable applications
Application thats stored on and run from portable removable storage devices. Connect the storage device to computer to run application. Saves valuable space on computer
Mobile applications
Applications that work on a smartphone or a tablet
Slide masters
Applies new formatting to all slides in presentations
File management
Controls how you save files in other formats; multiuser
Reference features
Footnotes, bibliographies, endnotes
Vector
Graphic format that uses math formulas to define appearance
Cell range
Group of cells. Can make active with one click
Bitmap
Images based on picture elements (pixels)
Records
Rows of data
Thumbnails
Small versions of each slide
What if analysis
Tests scenarios by changing variables to see effect on related calculations
Format
To change text by font, size, style, color and effects
Document management
Tools protect and organize files lets you collaborate with others
Relational databases
Two or more tables related
Pivot table
Used to create meaningful data summaries to analyze worksheets
Forms
Used to enter and navigate records, database screen used for mainly entry
Queries
Used to retrieve data based on criteria query creator specifies
Report
User designed layout of database content
Argument
Values involved in calculation
