Create a Presentation — Unit test Answers

What lookup function should be used to search for values in a specific row of a table and return values from adjacent rows?

What is a series of slides used in a presentation?

Which feature of spreadsheet software can display numerical data in a visually appealing and easily understood format?

Read the spreadsheet formula below, then answer the question.=SUM(C6:C9)What does the : symbol in the formula do?

When creating a presentation in LibreOffice Impress, where does the editing of slides take place?

What is relative referencing?

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?

Conditional formatting allows spreadsheet users to

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 operationsFrom which part of the presentation does this slide most likely come?

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.Which tool can be used so that the spreadsheet shows information only for students older than 20?

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 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?

Including AND in an IF statement means

Which of the following is true of operations within a spreadsheet program’s built-in functions?

Which describes the conditions that must be met in order to use Subtotal in a spreadsheet?