Executive Solution Overview
**Unit: Spreadsheets and Presentations** **Unit test** **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 small…
Instant Solution Download
$6.99Immediate access to the full model answer, formatted citations, and rubric breakdown.
Need a Fresh Custom Paper?
Have this question answered from scratch according to your specific instructions and deadline.
Order on TutorsGallery →Assignment Prompt & Instructions
**Unit: Spreadsheets and Presentations**
**Unit test**
**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 descending
custom sort – font color
sort ascending
custom sort – columns
**What is relative referencing?**
a system of referring to cells using letters for columns and numbers for rows
a method of formatting text in spreadsheet cells so none of it is cut off
a formula for calculating the optimal width of columns and height of rows
a bulleted list of all of the information included in a spreadsheet
**The spreadsheet below shows the age, grade level, major, and minor of four students in college. A purple background in the Major column indicates that a student has previously changed his or her major.**
A
B
C
D
E
1
**Age**
**Year**
**Major**
**Minor**
2
Student 1
19
Sophomore
Physics
Math
3
Student 2
18
Sophomore
Education
Music
4
Student 3
21
Junior
Engineering
Math
5
Student 4
18
freshman
Engineering
Business
**Which tool can be used so that the spreadsheet shows information only for students older than 20?**
sort by age from smallest to largest
sort by age from largest to smallest
filter by age on values greater than 20
filter by age on values less than 20
**What lookup function should be used to search for values in a specific row of a table and return values from adjacent rows?**
HLOOKUP
VLOOKUP
MAXLOOKUP
TABLOOKUP
**What is a series of slides used in a presentation?**
a slide layout
a slide show
a slide view
a slide master
**Conditional formatting allows spreadsheet users to**
turn cell protection functions on and off.
calculate the average number of people at sporting events.
highlight test scores of below 90% in a grade book.
add additional formatting options to a menu.
**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
Format Painter
Animation
Video from File
**The following is an excerpt from a slide in a presentation.**
**Today, we will address**
**• inverse operations**
**• solving equations using inverse operations**
**• solving inequalities using inverse operations**
**From which part of the presentation does this slide most likely come?**
introduction
outline
body
conclusion
**Which of the following is true of operations within a spreadsheet program’s built-in functions?**
Operations within parentheses, then multiplication and division, and then addition and subtraction are computed.
Operations within parentheses, then addition and subtraction, and then multiplication and division are computed.
Multiplication and division, then addition and subtraction, and then operations within parentheses are computed.
Addition and subtraction, then multiplication and division, and then operations within parentheses are computed.
**An employer uses the spreadsheet below to determine the average hourly salary of her four employees. She begins by determining the hourly salary of each person and displaying that in column D. Which formula can she then use to determine the average hourly salary?**
A
B
C
D
1
Employee
Hours worked
Amount earned
2
Alise
14
$101.50
3
Callie
19
$147.25
4
Chiara
23
$164.45
5
Ming
21
$157.50
=average(D2:D5)
=average(B2:B5)
=average(C2:C5)
=average(B5:D5)
**Read the spreadsheet formula below, then answer the question.**
**=SUM(C6:C9)**
**What does the : symbol in the formula do?**
arranges the formula in the correct order of operations
selects all of the cells in the range C6 to C9
designates cell C6 as the last cell in the formula
triggers the use of the Input line to check work
**Which feature of spreadsheet software can display numerical data in a visually appealing and easily understood format?**
sheets and workbooks
rows and columns
formulas and functions
charts and graphs
**Including AND in an IF statement means**
more than one condition can be included in the statement.
exactly one condition can be included in the statement.
the result may be both true and false at the same time.
a new spreadsheet is generated using only data that meets the conditions in the statement.
**Which describes the conditions that must be met in order to use Subtotal in a spreadsheet?**
The data must be in adjacent cells and organized in rows using headings.
The data must be in adjacent cells and organized in columns using headings.
The data must be distributed in different spreadsheets using the same range of cells.
The data must be distributed in different tabs within the same spreadsheet using the same range of cells.
**When creating a presentation in LibreOffice Impress, where does the editing of slides take place?**
the slides panel
the center panel
the tasks panel, under the master pages tab
the tasks panel, under the layouts tab
**Introduction to Information Technology – Spreadsheets and Presentations – All correct**
NOT RATED
Purchase the answer to view it
–
UnitSpreadsheetsandPresentations-unittest.docx
plagiarism checkPurchase $25
Leave a Reply