Unit 3 - Spreadsheets and Presentations
preprogrammed function examples
-AVERAGE -SUM -MIN -MAX AVERAGE calculates the arithmetic mean. SUM calculates the sum. MIN yields the lowest value from a set of values. MAX yields the highest value from a set of values.
parts of a good presentation
-an introduction, which establishes the general topic of the presentation. -an outline, which specifically describes what will be covered in the presentation. -a body, or the content of the talk. -a conclusion, which summarizes the body of the presentation.
common spreadsheet formatting
-font: type, size, and color. -alignment: left, center, or right. -number type: currency, decimal places, date, time, and percentage. -theme: colors, fonts, and layouts. -border: entire cell or selected sides of a cell.
cell
A cell is an individual unit for storing data in a sheet. Each cell occurs at the intersection of a column and a row. Numbers, text, formulas, and functions are entered in individual cells. Because a sheet may contain hundreds or thousands of cells, a system is used to identify individual cells.
column
A column organizes data vertically. Each column is labeled with a letter (A, B, C, etc.). Multiple letter labels (e.g., AA, ZZZ) are used when more than twenty-six columns are needed.
command
A command is a button that performs a specific action. Commands are grouped in tabs.
dependent variable
A dependent variable is a factor with values that vary based on the independent variable. The dependent variable is the result or outcome. Rows usually display dependent variables.
formula
A formula is a calculation entered by the user, which may contain cell references, numerical values, and functions. Formulas must begin with an equal sign (=).
function
A function is a preprogrammed calculation in spreadsheet software. Each function is listed in all caps followed by a pair of parentheses. The user enters values or cell references to be used in the function calculation. For example, the function AVERAGE() calculates the average of the values or cell references within the parentheses.
group
A group is a cluster of related actions called commands.
hotspot
A hotspot is an invisible hyperlink embedded in a slide. When a hotspot is clicked, it can take you to another part of the presentation or to a website. It can also play audio or open another computer program.
kiosk
A kiosk is a machine that allows users to interact with its audio-visual display.
sheet
A sheet is a single page within a workbook. When you open a new workbook in Excel, you will find three sheets by default. If you need more than three sheets, more can be added.
simpler parameter
A simple parameter is one condition used to locate, sort, or filter results. For example, using the Find tool to locate the number 381 uses a simple locate parameter (381).
spreadsheet
A spreadsheet is a computer file consisting of rows and columns within a grid or table. Spreadsheets are used for organizing, analyzing, manipulating, and storing data.
tab
A tab is a broad category of actions you can perform in a presentation program. There are ten tabs: File, Home, Insert, Design, Transitions, Animations, Slide Show, Review, View, and Format. Each tab is named according to the type of actions contained within.
animation
An animation is a visual action or motion assigned to one or more objects on a slide. For example, bullet points can be animated so that they appear on a slide when the presenter clicks the mouse.
image map
An image map is a graphic object on a slide that contains one or more hotspots. These features can be used to enhance user interactivity through audio and visual elements.
independent variable
An independent variable is a factor whose value is not based on the values of other factors. Columns usually display independent variables.
animation painter
Animation Painter works in the same way as Format Painter. The difference is it copies the animation properties of an object to be applied to another object.
Ascending
Ascending: sort text alphabetically A to Z; sort numbers smallest to largest, and dates oldest to most recent
bar graphs
Bar graphs, also called column charts, compare and contrast discrete sets of data.
bookkeeping
Bookkeeping, or keeping track of a company's cash flow, is arguably one of the first and foremost uses of spreadsheets. Spreadsheets allow businesses to track income, expenses, payroll, taxes, and budgets. All incoming and outgoing cash is tracked on the spreadsheet, and can be used to calculate sums and averages and make projections for future sales and expenses. Spreadsheet data can also be used to generate a chart or graph to provide a visual of income and expenses.
common business uses of spreadsheets
Common business uses of spreadsheets include bookkeeping, predicting future outcomes, presenting information, and tracking information.
custom
Custom: sort by one or more columns and rows, by color, and other options
Descending
Descending: sort text alphabetically Z to A; sort numbers largest to smallest, and dates most recent to oldest
cell reference/ address
Each cell is identified by its corresponding column letter followed by its row number. For example, the intersection of column B and row 3 is cell B3.
format painter
Format Painter is a command used to apply multiple formatting changes simultaneously. It allows you to copy the formatting from text in one place of your presentation and apply it to text in another place of the presentation.
handout master
Handout master is the overall layout and design of a presentation as a printed handout.
examples of spreadsheet graphs
Line charts Pie charts Bar graphs
line charts
Line charts display data that changes over time. They can also show or chart single or multiple lines of data.
multiple parameters
Multiple parameters are more than one condition used to locate, sort, or filter results. For example, using the Find tool to locate the number 381 in a cell with a yellow background utilizes two parameters (381 and yellow background).
notes master
Notes master is the overall layout and design of the notes page.
parameter
Parameters are criteria used to limit or refine data management results. You can use simple or multiple parameters to locate, sort, and filter data.
pie charts
Pie charts show parts of a whole. They provide a snapshot of the size of each part and can also include percentages.
cell range
Several adjacent cells, called a cell range, can be referenced simultaneously by listing the upper left cell followed by a colon and the lower right cell. For example, A1:A10 is the range of cells in column A that includes rows 1 through 10.
slide master
Slide master is the overall design theme for a presentation. A slide master specifies fonts, colors, and the position of text and graphic placeholders. When a change is made to the slide master, it affects all slides in the presentation except the title slide.
slide views
Slide views are the different ways to view your presentation. There are five slide views: -Normal: default view with the selected slide enlarged and a scroll bar containing all slides -Outline: text view of all slides on left side of window -Slide sorter: thumbnail view for rearranging slides -Notes page: printout view containing speaker's notes -Reading view: screen reading view of slide show
predicting future outcomes
Spreadsheets can be used to analyze a company's financial history to predict future outcomes. For example, tracking a company's profits and losses will help the company predict how it will fare in years to come. The forecasting function in spreadsheet software analyzes data to predict inventory needs and potential sales based on market trends.
tracking information
Spreadsheets can be used to track a variety of important information such as: -employee timesheets: number of hours each employee worked. -project management tasks: projects completed and timelines. -invoices: products sold or services rendered.
action tool
The Action feature allows you to create hotspots and image maps in your presentation.
broadcast slideshow tool
The Broadcast Slide Show feature allows you to show your presentation to other people who are located remotely. This allows you to share your presentation with people around the globe, as long as they can view your presentation through an Internet connection.
center panel
The Center Panel shows the current slide. You can add or format text and objects in the Normal View. Tabs in the Center Panel provide additional tools.
create handout tool
The Create Handouts feature allows you to transfer a presentation into a Word document. You may want to use this feature to get a count of the total words in a presentation. Another reason may be to distribute your presentation in a smaller file size, or to recipients who just want to see text or do not have presentation software.
create a video tool
The Create a Video feature allows you to turn your slide show into a video. This feature can be useful for presentations without a speaker present, such as a presentation housed in an unattended kiosk or an online product demonstration.
slides panel
The Slides Panel shows the order in which slides are presented. Each slide is numbered. To rearrange the slide order, drag a slide within the panel.
tasks panel
The Tasks Panel includes design tools, such as the slide layout templates. Impress uses preformatted slide templates that allow you to quickly build a professional-looking presentation. By selecting slides from the Slide Layout, you can rearrange the format of the title textbox and the body textbox.
video from file tool
The Video from File feature allows you to embed a video from a file on your computer into your presentation.
video from website tool
The Video from Website feature allows you to insert a hyperlink for an Internet video into your presentation.
basic components of spreadsheets
The basic components of a spreadsheet are workbook, sheet, column, row, and cell.
design theme
The design theme is the choice of colors, fonts, and formatting to give your presentation an overall look and feel. The purpose of a design theme is to unify all slides within a presentation with design elements that complement each other and your topic.
filtering
The filter procedure allows you to temporarily hide rows of data you do not want to view, based on specifications you set.
locate data
The locate data procedure uses search tools to find specific data quickly.
presentation software ribbon
The ribbon, formerly known as the toolbar, is located at the top of the window. It is used to make all modifications, customizations, and specifications of a presentation.
Find and Replace Tool
The simplest tool you can use to locate data is the Find and Replace tool. This tool is accessible on the ribbon through the Home tab, by clicking on Find & Select. You can also locate data by background or font color through the Options button.
workbook
The term workbook refers to a spreadsheet file. Within each workbook there may be one or more sheets.
Go To Tool
This tool will enable you to navigate to the location of a cell, page, or object. For example, you can type a specific cell reference, such as R22, into the Go To dialog box and you will be taken directly to this cell, and will become the active cell.
basic slide layouts
Title slide Title and content Section header Two content Comparison Title only Blank Content with caption Picture with caption
presentation uses in business
To conduct a meeting To train employees To propose a business idea To demonstrate a product To conduct an interview
row
a row organizes data horizontally. Each row is labeled with a number (1, 2, 3, etc.).
data management
data management is the process of working with information efficiently.
presenting information
spreadsheet software makes it easy to generate graphical representations so data is easier to convey. This is especially helpful for spreadsheets containing large amounts of numeric data.
