Spreadsheets and presentations
Bar graphs (column charts)
compare and contrast discrete sets of data
Broadcast Slide Show
feature would give remote employees the opportunity to participate in a meeting delivered via presentation software
Tasks Panel
includes design tools, such as the slide layout templates
Embedding a video
useful when you want to include a video and you may not have an Internet connection available at the time of your presentation
introduction
which establishes the general topic of the presentation
outline
which specifically describes what will be covered in the presentation
conclusion
which summarizes the body of the presentation
Go To tool
will enable you to navigate to the location of a cell, page, or object
MAX
yields the highest value from a set of values
MIN
yields the lowest value from a set of values
Some examples of functions include:
-AVERAGE -SUM -MIN -MAX
Which of the following correctly describes the Filter procedure for managing spreadsheet data?
-Filter allows you to view only the information you want to see -Filter allows you to filter text and numeric data -Filter temporarily hides rows of data that you do not need to view
Examples of charts and graphs:
-Line charts -Pie charts -Bar graphs
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
components in presentation software:
-Slide and slide show -Ribbon -Tabs, groups, and commands -Slide layouts -Design themes -Slide views -Slide master
nine basic slide layouts:
-Title slide -Title and content -Section header -Two content -Comparison -Title only -Blank -Content with caption -Picture with caption
basic components of a spreadsheet include:
-Workbook -Sheet -Column -Row -Cell
Which of the following accurately describe the Video from Website feature used in presentation software?
-allows you to put a hyperlink for an Internet video in your presentation -a good alternative to embedded video when file size is an issue -a better option than embedding a video when you do not have rights to a video
Charts and graphs
-are used in spreadsheet programs to present data visually in an easily understood format -can help you convey your data more clearly and quickly, especially when you are working with complex data -can also help you reach a wider audience by appealing to multiple learning styles
Common business uses of spreadsheets:
-bookkeeping -predicting future outcomes -presenting information -tracking information
Which of the following is an example of a tracking activity using a spreadsheet?
-calculating total sales for the month -entering income and expenses -monitoring time spent on projects
Which of the following features are used to create a design theme?
-choosing a font -inserting an image -adding a color scheme
Which of the following describe design themes in PowerPoint?
-color scheme -colors, fonts, and formatting that coordinate -set of elements that unify your slides and complement your topic
presentation software:
-conduct a meeting -train employees -propose a business idea -demonstrate a product -conduct an interview
How can the charts and graphs feature in spreadsheet software help businesses present data more effectively?
-conveying large amounts of numerical data in a more understandable format -supplying a variety of charts and graphs to present information in the best way
Which of the following is an advantage of using the filter procedure?
-displays only the data you would like to view -saves time -prevents you from having to create multiple tables to analyze data
Spreadsheets can be used to track a variety of important information:
-employee time-sheets: number of hours each employee worked -project management tasks: projects completed and timelines -invoices: products sold or services rendered
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
advanced features:
-format Painter -animation Painter -video from Website -video from File -create a Video -broadcast Slide Show -create Handouts -action
Why might a business use spreadsheet software for bookkeeping?
-monitor expenses -track income -keep a budget
two types of filtering
-numeric -text
Which of the following is an advantage of using the sort procedure?
-preserves cell formatting and formulas -saves time -avoids copy-paste -organizes data so it is easier to draw comparisons
In what ways can you sort data by using the sort procedure?
-sort ascending -sort descending -sort by font color -sort by background color -sort by rows -sort by columns
How can presentation software be used in a business or professional setting?
-to automate the ticket-purchasing process at movie theaters through a kiosk -to teach lessons to high school students -to deliver a sales presentation to clients
Some examples of formulas include:
=SUM(K4:K10) =3+5+71+45 =27+C4 =MAX(D1:D4)+2.5
Which of the following is a locate tool that will enable you to navigate to cell M291?
Go to
tab
a broad category of actions you can perform in a presentation program -ten tabs: File, Home, Insert, Design, Transitions, Animations, Slide Show, Review, View, and Format
command
a button that performs a specific action -are grouped in tabs
formula
a calculation entered by the user, which may contain cell references, numerical values, and functions -must begin with an equal sign (=)
group
a cluster of related actions called commands
Format Painter
a command used to apply multiple formatting changes simultaneously -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
spreadsheet
a computer file consisting of rows and columns within a grid or table -used for organizing, analyzing, manipulating, and storing data
independent variable
a factor whose value is not based on the values of other factors -columns
dependent variable
a factor with values that vary based on the independent variable -the result or outcome -rows
image map
a graphic object on a slide that contains one or more hotspots -features can be used to enhance user interactivity through audio and visual elements
kiosk
a machine that allows users to interact with its audio-visual display -ATMs -twenty-four-hour movie rental -instant photo print
function
a preprogrammed calculation in spreadsheet software -each function is listed in all caps followed by a pair of parentheses -user enters values or cell references to be used in the function calculation
slide show
a series of slides used in a presentation. Several slides are used to create a slide show -the "audience mode" in presentation software programs
slide
a single page within a presentation
sheet
a single page within a workbook -when you open a new workbook in Excel, you will find three sheets by default
What is a series of slides used in a presentation?
a slide show
workbook refers
a spreadsheet file
animation
a visual action or motion assigned to one or more objects on a slide -used to make a presentation more dynamic
sort procedure
allows you to quickly and easily organize data in a logical way
filter procedure
allows you to temporarily hide rows of data you do not want to view, based on specifications you set
cell
an individual unit for storing data in a sheet -occurs at the intersection of a column and a row
hotspot
an invisible hyperlink embedded in a slide
A presentation has bullet points that move. The presenter wants to use these bullet points in several other places in the presentation. Which command would the presenter use to copy the feature to other places?
animation painter
AVERAGE
calculates the arithmetic mean
SUM
calculates the sum
Which feature of spreadsheet software can display numerical data in a visually appealing and easily understood format?
charts and graphs
Presentation software
computer software used to create, edit, and deliver presentations -educators use it to create and present lesson plans -may have used presentation software at school to present a group project or deliver a speech -businesses use it to present business plans, propose business ideas, and sell products or services to clients
Animation Painter
copies the animation properties of an object to be applied to another object
Which presentation software feature would allow a business to convert a short marketing presentation into an ad that can be streamed on various websites?
create a video
Parameters
criteria used to limit or refine data management results -can use simple or multiple parameters to locate, sort, and filter data
Search parameters
criteria used to limit or refine data management results -can use simple or multiple parameters to locate, sort, and filter data
Line charts
display data that changes over time -can also show or chart single or multiple lines of data
cell reference (cell address)
each cell is identified by its corresponding column letter followed by its row number
Action
feature allows you to create hotspots and image maps in your presentation
Video from File
feature allows you to embed a video from a file on your computer into your presentation
Video from Website
feature allows you to insert a hyperlink for an Internet video into your presentation
Broadcast Slide Show
feature allows you to show your presentation to other people who are located remotely -allows you to share your presentation with people around the globe, as long as they can view your presentation through an Internet connection
Create Handouts
feature allows you to transfer a presentation into a Word document
Create a Video
feature allows you to turn your slide show into a video -can be useful for presentations without a speaker present, such as a presentation housed in an unattended kiosk or an online product demonstration
Which tool can be used so that the spreadsheet shows information only for students older than 20?
filter by age on values greater than 20
Which function in spreadsheet software can be used to predict future sales or inventory needs?
forecast
ribbon
formerly known as the toolbar, is located at the top of the window -used to make all modifications, customizations, and specifications of a presentation
Formatting spreadsheets
makes it easier to use and present data -also makes working with spreadsheets more efficient
Multiple parameters
more than one condition used to locate, sort, or filter results -using the Find tool to locate the number 381 in a cell with a yellow background utilizes two parameters (381 and yellow background) -the list is sorted by room and by paint choice
simple parameter
one condition used to locate, sort, or filter results -using the Find tool to locate the number 381 uses a simply locate parameter (381) -sort ascending A-Z is a simple parameter
row
organizes data horizontally -labeled with a number
column
organizes data vertically -labeled with a letter
locate data
procedure uses search tools to find specific data quickly
cell range
several adjacent cells can be referenced simultaneously by listing the upper left cell followed by a colon and the lower right cell
Pie charts
show parts of a whole -provide a snapshot of the size of each part and can also include percentages
Center Panel
shows the current slide -can add or format text and objects in the Normal View
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
Find and Replace tool
simplest tool you can use to locate data
Seth, a zoologist, has a spreadsheet containing data on all the animals in a zoo. He wants to sort the column that contains the weights of all of the animals. Which sort tool could he use to reorganize the numbers so they are listed from smallest to largest?
sort ascending
Custom
sort by one or more columns and rows, by color, and other options
Ascending
sort text alphabetically A to Z; sort numbers smallest to largest, and dates oldest to most recent
Descending
sort text alphabetically Z to A; sort numbers largest to smallest, and dates most recent to oldest
design theme
the choice of colors, fonts, and formatting to give your presentation an overall look and feel
body
the content of the talk
Slide views
the different ways to view your presentation
Slide master
the overall design theme for a presentation -specifies fonts, colors, and the position of text and graphic placeholders
Handout master
the overall layout and design of a presentation as a printed handout
Notes master
the overall layout and design of the notes page
slide layout
the placement of objects on a slide, including the slide title, text, images, audio, video, and charts
data management
the process of working with information efficiently
