Jasperactive Excel Lesson 3 quiz answers

Which of the following is the correct order of precedence for standard math operators?

The order of operations is the order you use to work out math expressions: parentheses, exponents, multiplication, division, addition, subtraction.

What's the difference between clicking the format Painter once versus twice?

Double-clicking on the Format Painter will apply the format but leave the mouse as a paint brush allowing you to apply the format to more than one block of text. Single-clicking on the Format Painter will apply the formatting once and the mouse will return to normal.

Which of the following are types of sparkline charts?

There are four types of sparkline charts available in Google Sheets: line charts (the default), column charts, bar charts, and winloss charts.

Which of the following is the quick analysis tool used for?

The Quick Analysis tool helps you quickly format your data into a chart, table, or sparkline. The Quick Analysis function helps you quickly format your data into a chart, table, summary formula, sparkline, or highlighted figures with just a few simple steps.