Electronic Spreadsheet Flashcards
Spreadsheet
a long sheet of rows and columns on the computer screen to do data analysis and calculations. It can also store,manipulate and create graphical representations of data.
Invoice
a document between a buyer and a seller.
Title Bar
shows the name of the current spreadsheet.
Menu Bar
The Menu Bar is located just below the title bar. Contains commands for various tasks.
Each Menu has a sub-menu called
pull down menu
File
contains commands applied to the entire document. Examples are save,open,wizards,export as pdf, print,digital signatures and so on
View
contains commands for modifying UI - toolbars, column and row headers,full screen,zoom etc
Format
commands for modifying a spreadsheet- cells,rows, columns,page,styles and formatting, alignment and so on.
Data
contains commands for manipulating data- define range, sort etc.
XY chart
comparing data in pairs
Chart area
contains all the components in a chart
Chart title
descriptive text of what the chart says
Plot area
location of the chart that shows the actual area
legend
describes the parts that make up a chart