Create a Presentation — Unit test Answers

Which feature transfers a slide show into a word-processing document?

In a particular spreadsheet, the data in each cell is password protected. When cells are selected, the formula is visible in the formula bar. Which is true?

Which of the following statements best describes cell protection when it is first activated?

How do HLookup and VLookup differ?

The spreadsheet below shows the names, years in office, and number of terms for five US presidents.Which tool could be used to display only rows containing presidents who served two terms?

Look at the spreadsheet below, then answer the question that follows.Which of the following was most likely used to apply red background and font to some of the cells in column D?

A teacher takes the following steps when beginning to apply conditional formatting to a spreadsheet.Format Conditional Formatting Add Condition 1 Equal What should her next step be if she is attempting to highlight cells with values greater than 90 but less than 100?

The spreadsheet below shows a list of fruits with their calorie count, grams of sugar, dietary fiber, and protein.Which set of steps will organize the data to only show foods with more than 100 calories and rank their sugar content from greatest to least?

Which of the following formulas would use an absolute row reference when filled?

Which phrase best describes a spreadsheet?

When is it appropriate to use images in presentations?

What are the two parts of a cell reference?

Which of the following symbols comes first when a formula or function is written in a spreadsheet?

Which steps are most practical when rearranging the order of the slides in a presentation?

When creating a chart or graph, which should be completed first?

Daria would like a certain company to publish her math book. She creates a presentation about the features and benefits of using her book and how her book is unique. She compares her book to competitors’ books on the market, and she shows possible sales figures.This is an example of using presentation software for

Which describes a design theme in PowerPoint?

The group of data that will be used in a chart or graph is called the

Which of the following is a strategy used to enhance communication in a presentation?

Using the spreadsheet below, which formula can be used to determine Albert’s hourly wage?