Spreadsheet Essentials Practice

Abby opens an attachment from one of her friends related to their science project. The document has their experiment data stored in a series of rows and columns. This is referred to as a:

• text document

• spreadsheet

• graphics file

• presentation

Paul realized that he forgot to add a whole column of data. He needs to add the missing column between E and F. What should he do?

• Right-click column F and click the Insert command

• Right-click column E and click the Insert command

• Double-click the line that separates column E and F and click the Insert command

• Double-click column F and click the Insert command

What type of graph is shown?

• Line chart

• Pie chart

• Bar chart

• Column chart

Alex has been asked to select cells C5 through K5 during her spreadsheet lesson. What has she been asked to select?

• A row

• A row range

• A column

• A column range

When you insert a column in a spreadsheet, where does the new column appear?

• Immediately to the left of the selected column

• Immediately to the right of the selected column

• At the first column in the spreadsheet

• At the last column in the spreadsheet

Rows within a spreadsheet are identified by:

• icons

• Roman numerals

• numbers

• letters

Bjorn has created a large spreadsheet. His boss has requested to ensure there are no duplicates in the spreadsheet. What could Bjorn use to automatically highlight cells containing specific text within his spreadsheet?

• Absolute reference

• Minimum value

• Conditional formatting

• Cell shading

Which function is used to total the values of a series of cells?

• Sum

• Max

• Count

• Average

Which of the following is an example of an absolute cell reference?

• F5:E5

• F4

• $A$5

• D5+F5

What changes in this absolute cell reference? $A$5

• Column A

• Row 5

• Nothing