Spreadsheet Formulas, Functions, and Charts/Graphs

What type of chart/graph is used to show changes over a period of time?

• Bar Chart

• Column Chart

• Line Chart

• Pie Chart

What type of chart/graph is used to show the relationship of a part to a whole?

• Bar Chart

• Pie Chart

• Scatter Chart

• Line Chart

What type of chart/graph uses rectangles of varying height to illustrate values in a spreadsheet?

• Pie Chart

• Scatter Chart

• Line Chart

• Bar Chart

To create a chart/graph from data in an Excel spreadsheet what is the first thing you do?

• Change the color of the data to include in your chart

• Highlight the data to include in your chart

• Underline the data to include in your chart

• Highlight the entire spreadsheet

What is the name of the bar where data entered from the keyboard is displayed as it is entered into the cell?

• Formula Bar

• Active Cell

• Bar Chart

• Enter Bar

Which of the following formulas will produce the product of the values located in the cells?

• =A1+A2

• =A1/A2

• =A1*A2

• =A1-A2

What piece of information is vital to getting a function to work correctly?

• Range

• Operator

• Relative Cell Reference

• Absolute Cell Reference

Which spreadsheet function will return the largest value in a range?

• Minimum

• Sum

• Average

• Maximum

Which spreadsheet function will return the smallest value in a range?

• Average

• Minimum

• Sum

• Maximum

What is the order of operations?

• SPEMDA

• DASPEM

• PEMDSA

• PEMDAS