Excel review (e-school)

To set the print area, I would use which of the following tabs?

Which is the intersection of a row and column?

Which is a bar near the top of the Excel window where you can enter or edit cell entries

Hyperlinks enables you to go to a web page, another file, or to a specific location in a file

You can use mathematical operators (+ - * / ) in a function?

How do you remove a hyperlink?

The small green square in the lower-right corner of a selected cell you use to create a series?

Which of the following do you use to open Backstage view?

Which Paste Special option pastes only the result of a formula rather than the formula itself?

Listing the students from shortest to tallest is an example of what type of sort?

When you split a window, the window is divided into how many panes?

You can create a new range by selecting the cells and typing a name in the Name box

When you add a range of cells then divide by the # of cell entries,determining the mean.

Which of the following is not an arithmetic (mathematical) operator?

You can apply multiple conditional formatting to the same range of cells.

The order of operations determines which parts of a formula are calculated before other parts

Which of the following calculates the total amount of a range of cells?

The columns in a worksheet are identified by numbers.

To allow Excel to distinguish formulas from data, all formulas begin with an equal sign (=).

You want to find the largest number in a range, you use which function?

Deleting a cell is the same as clearing a cell’s content.

Which of the following can you not copy using Format Painter?

Conditional Formatting is found under which tab?

Ctrl + F displays Backstage view.

Finding entries that match a certain criteria is called