Vocabulary
Functions
Excel Commands
100

What does the term "cell" refer to in Excel?

A "cell" is an intersection of a row and column in a table.

100

What is the function that calculates the answer of an addition formula?

=SUM

100

What does "copy" do?

"Copy" creates a duplicate of the selected cell(s) contents for pasting.

200

What does the term "formula" mean in Excel?



What should it always begin with?

The term "formula" refers to the mathematical statement used to calculate a value.


A formula should always begin with an equal sign.


200

What does the ''IF Function" do?

The "IF Function" performs a calculation that makes a decision based on a comparison.

200

Where is the "Protect Workbook" option found?

It is found on the Review Tab.

300

What does the term "sparklines" refer to in Excel?

"Sparklines" refers to mini charts that can be displayed in a cell.

300

What function changes a value by rounding it to a specific number of decimal places?

=ROUND

300

What is 'landscape"?

"Landscape" is a print orientation that prints a worksheet across the widest part of the page.

400

What does the term "embedded object" refer to in Excel?

The term "embedded object" refers to an object that keeps the features of the application it was created on.

400

What lookup function is used to return a value form a list of values?

=CHOOSE

400

Lis the steps required to insert a chart title above a chart.

Click Layout--Chart Title--Above Chart.

500

What does the term "relative cell reference" refer to?

A "relative cell reference" refers to a cell reference that reflects the row or column it has been copied to.

500

What does the "VLOOKUP Function" do?

The "VLOOKUP Function" returns a value from a table of values.

500

How do you name a range of cells?

Select the cells, type a descriptive name in the name box, and click Enter.