It and information study unit 1 semester 2
Which of the following best describes the subtotal feature in spreadsheet software?
a function that obtains a subtotal on selected data
Which of the following correctly describes the Filter procedure for managing spreadsheet data? Check all that apply.
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.
Which of the following allows you to copy formatting of text from one part of your presentation and apply it to text in another part of your presentation?
Format Painter
Which of the following is a locate tool that will enable you to navigate to cell M291?
Go To
Which lookup function would you use to search for and return values from adjacent rows of a table?
HLookup
Which of the following can be done by using conditional formatting?
Highlight all "no" responses.
Which of the following accurately describe the Video from Website feature used in presentation software? Choose all that apply.
It allows you to put a hyperlink for an Internet video in your presentation. It is a good alternative to embedded video when file size is an issue. It is a better option than embedding a video when you do not have rights to a video.
How can the charts and graphs feature in spreadsheet software help businesses present data more effectively? Choose all that apply.
by conveying large amounts of numerical data in a more understandable format by supplying a variety of charts and graphs to present information in the best way
Which of the following is an example of a tracking activity using a spreadsheet? Choose all that apply.
calculating total sales for the month entering income and expenses monitoring time spent on projects
Which feature of spreadsheet software should you consider using to convey your numerical data in a visually appealing and easily understood format?
charts and graphs
Which of the following features are used to create a design theme? Choose all that apply.
choosing a font inserting an image adding a color scheme
Which of the following describe design themes in PowerPoint? Choose all that apply.
color scheme colors, fonts, and formatting that coordinate set of elements that unify your slides and complement your topic
Which of the following terms is defined as a button that performs a specific action?
command
Which of the following terms is best described as the choice of colors, fonts, and formatting to give your presentation an overall look and feel?
design theme
The image map used in the Action feature of PowerPoint allows you to
embed hotspots
Which of the following are types of formatting you can apply to a spreadsheet? Choose all that apply.
font, alignment, number type, theme, and border.
Which function in spreadsheet software can be used to predict future sales or inventory needs?
forecast
Which feature of spreadsheet software will make it easier for you to find the average number of calls made per hour for each employee?
functions and formulas
When you click on a cell, you can see the data in the cell but nothing shows up in the formula bar. What type of cell protection does this cell have?
hidden
Which term is defined as a single page within a spreadsheet file?
sheet
Pie charts are best used for
showing parts of a whole.
Which of the following terms is best described as the design theme that applies to slides?
slide master
Which sort tool will reorganize the numbers so they are listed from largest to smallest?
sort descending
Which term is defined as a spreadsheet file?
workbook
Which formula, when filled, would use an absolute row reference?
=B$2*B6
Suppose you have a slide where images appear after the mouse is clicked. What tool could you use to quickly apply this formatting to a few other slides in your presentation?
Animation Painter
Which presentation feature would allow a business to include employees in other countries to participate in monthly status meetings?
Broadcast Slide Show
Which of the following correctly describe cell protection in spreadsheet software? Choose all that apply.
Cell protection is a security feature used to limit changes and visibility of data. By default, cells are locked and not hidden.
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
When entering a formula into a cell, you begin with are calculations a spreadsheet program applies to data. are preset calculations within spreadsheet software. are user-entered calculations that may contain cell references, numerical values, and preset calculations.
Equal Sign Functions and Formulas Functions Formulas
Which of the following is a true statement about parameters in data management? Check all that apply.
Parameters are used to limit or refine results. A multiple parameter contains more than one condition to locate, sort, or filter data. Searching for the number 12 in your spreadsheet is an example of a simple parameter.
Which of the following are logical reasons for using a pie chart to show how employees spend their time at ABC Organization? Choose all that apply.
The "other" category contains a sizeable chunk of hours that may be time wasted; managers can use the pie chart to discuss possible lapses in productivity with employees. ABC Organization has twenty-five employees; a pie chart works well to show the breakdown of hours worked by all employees at ABC Organization.
Which lookup function would you use to search for and return values from adjacent columns of a table?
VLookup
What are the basic components of a spreadsheet? Choose all that apply.
Workbook, Sheet, Column , Row, Cell
Which of the following correctly defines a spreadsheet?
a computer file with rows and columns within a grid or table used to organize, analyze, store, and manipulate data
Which of the following best defines a nested IF statement?
an IF function within an IF function
Which of the following best describes a hotspot as used in the Action feature of PowerPoint?
an invisible hyperlink embedded in a slide
What are the advantages of using charts or graphs in spreadsheet software? Choose all that apply.
appeal to visual learners convey information more clearly reach a wider audience
If you used the VLookup function, where would it look for a value?
in a column
Which of the following are characteristics of a cell in spreadsheet software? Choose all that apply.
occurs at the intersection of columns and rows is a single unit for entering data on a spreadsheet is located according to its cell reference or cell address
Which of the following best describesa slide?
one page in a slide show
What is the first operation that is calculated in a formula?
operations in parentheses
Line charts are best used for
presenting data that changes as a function of time.
Which of the following are slide layouts in PowerPoint? Choose all that apply.
title slide title and content blank picture with caption
How can presentation software be used in a business or professional setting? Choose all that apply.
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
Which of the following are reasons to present spreadsheet data in a bar graph? Choose all that apply.
to compare distinct categories of data to show quantities of discrete data
Why might a business use spreadsheet software for bookkeeping? Choose all that apply.
to monitor expenses to track income to keep a budget
Which of the following explains why librarians would apply conditional formatting to the library patron's account spreadsheet?
to quickly locate patrons who have overdue books
Suppose you have a spreadsheet containing population counts collected on an annual basis. You decide to use a scatter plot to present your data. Which of the following reasons support your decision? Choose all that apply.
to show changes over time to show a general trend of data points
