EMTECH 11 - REVIEW QUIZ

What part of Microsoft Excel allows you to create several sheets in your workbook?

These are mathematical operations used in performing calculations

Which of the following is not a conditional function?

This allows you to display and edit lines in horizontal and vertical axes for better representation of data.

What are the two components of the name of a cell?

If you want to show trends over time, it is best to use a __________ chart

Which is the first thing you need to do before choosing the kind of graph or chart you want to use?

These are logical operators used to compare two values. The result of the comparison can either be TRUE or FALSE

Union operator - combines values of multiple cells and creates single reference using multiple references

These are considered to be the most basic way to represent data visually.

It is a function that looks for the lowest value in the range.

What do we call IF(logical_expression, value_if_true, value_if_false)?

What part of Excel shows you different tools for formatting text, formulas, page layout, and other formatting tools?

An excel formula starts with an equal sign.

Considered to be the most pleasing way to represent data which uses different shapes other than the usual x and y axis.

What symbol from the will you use to check if the first number is less than or equal to the second number?

It is a function that adds all the values of the cells in the argument.

This kind of graph or chart shows how one data can affect the other data.

Range operator - used to show reference of the range of selected cells

This allows you to display and edit the legend in different positions