BASICS
OPERATIONS
SPREADSHEET
GRAPHS & CHARTS
FORMATTING
SPREADSHEET FORMULA
100
A cell is addressed by column letter and row number.
What is a cell?
100
1. Sorts A. Primary Sort B. Secondary Sort 2. Freeze Panes 3. Fill Series 4. Print A. Print Preview B. Print a Selection 5.Linking and Embedding A. Target B. Source
What are the spreadsheets operations?
100
. Charts and Graph are used in business to communicate and clarify spreadsheet information
What is 1 purpose for graphs & charts?
100
APPLIED TO SPREADSHEET COMPONENTS FOR THE PURPOSE OF ORGANIZING AND CLARIFYING INFORMATION
What is FORMATING
100
IS CLASSIFIED ACCORDING TO ITS INTENDED PURPOSE
What is CELL DATA
200
ACTIVE CELL
What is the cell called that u are working in?
200
A Sort is used to arrange data in alphabetical or chronological order data can be sorted in Ascending or Descending Order a -z z-a
What is a sort?
200
Represent sales trends within different departments of a store Represent the contribution of individual employee sales to the total sales for a company
How is a chart used in a business?
200
USED TO ADD IDENTIFYING INFORMATION TO A SPREADSHEET.
What is HEADERS OR FOOTERS
200
THE CLASSIFICATION USED FOR CELLS THAT CONTAIN TEXT OR FOR NUMBERS THAT WILL NOT BE USED IN CALCULATIONS
What is LABELS
300
ROW
What is the horizontal side called on a graph?
300
• Primary sort Indicates the primary sort range of data also known as a sing • Secondary sort - indicates the next sort range of date le sort
What is primary/ secondary sorts
300
GRAPHS The y-axis is: is the left vertical side of the graph 2. The x-axis is: is the bottom horizontal side of the graph 3. Data markers are: are used in a graph to indicate data values 4. A data series is: is a collection of related values,
What are the Components of Graphs and Charts?
300
ARE USED TO CLARIFY INFORMATION BY ADDING EMPHASIS TO TITLES, COLUMN HEADING, AND GRAND TOTALS. ETC
What is FONT SIZE AND STYLE
300
THE CLASSIFICATION INDICATING THE DATA HAS THE POTENTIAL TO BE USED IN CALCULATIONS
What is VALUES
400
column
What is the vertical side called?
400
Allows the user to work in multiple areas of a large spreadsheet and focus the view on specific cell ranges.
How does freeze panes help you?
400
. CHARTS A legend is an object that explains the symbols, colors, or patterns used to differentiate the data. 2. A data label is a single value or text explanation Used to explain the data in a series. It is a piece of 3. A chart title is: is the main heading, which describes the purpose and content of the chart
What are the Components of Graphs and Charts
400
IS ALSO USED TO FORMAT CELL DATA FOR THE PURPOSE OF CLARIFYING AND ORGANIZING INFORMATION
What is JUSIFICATION
400
INSTRUCT THE SOFTWARE TO PERFORM A CALCULATION.
What is FORMULA
500
A spreadsheet is an electronic document in which data is arranged in the rows and columns of a grid and can be manipulated and used in calculations.
What is a spreadsheet?
500
• Printing is used to provide a hard copy. • Print preview is used to view how data is represented on paper. • Print a selection is used to print a portion of a spreadsheet
What is printing a spreadsheet?
500
. An embedded chart is An Embedded chart is one that appears on the same sheet as the spreadsheet/worksheet it represents. A linked chart is one that will change to reflect changes made to the spreadsheet it represents
What is Embedded and Linked
500
ARE USED TO ORGANIZE INFORMATION AND CAN BE APPLIED TO COLUMNS, ROWS, CELL RANGES, OR INDIVIDUAL CELLS.
What is BORDERS AND SHADING
500
PEMDAS PARENTHESES EXPONENTIATION MULTIPLICATION DIVISION ADDITION SUBTRACTION
What is ORDER OF OPERATIONS
M
e
n
u