Data and Analysis Quiz

What is a spreadsheet?

• A large sheet of paper that is spread out

• An electronic document where data is displayed in columns and rows

• A Microsoft Word document

What is data analysis?

• The process of changing the font in a document and making different items bold.

• The process of sorting and graphing information to find patterns, see trends, and draw conclusions.

• The process of typing information in a paragraph

The horizontal areas on a spreadsheet which are labeled with a number.

• Cell

• Row

• Column

A mathematical equation written by the user and entered into a cell which will tell the computer how to calculate the value of the cell such as.... =A2-B12

• Text

• Value

• Formula

• Function

A pre-defined equation you can enter into a cell to perform a complex computation such as =SUM(A2:A10)

• Text

• Value

• Formula

• Function

Each box on a spreadsheet where a row and column intersect.

• Cell

• Row

• Column

What should all formulas begin with?

• SUM

• the equals sign (=)

• the plus sign (+)

If I wanted to create a chart to show what percent of my total expenses were spent on a specific person, which type of chart should I insert?

• Column

• Line

• Pie

Which function should be chosen to determine the lowest number in a given range?

• Sum

• Max

• Min

This feature continues a pattern into adjacent cells in any direction thus copying a cell's contents to the highlighted cells while adjusting column letters or row numbers accordingly.

• Copy/Paste

• Autofill

• Autofit