Exam 7: Excel 2: Working With Formulas and Functions

The COUNT function in Excel returns the number of all cells in a range that contain any type of data.

Using the Cut command completely removes data from its original location, while the Copy command leaves information in its original location.

Which function key on the keyboard allows the Excel user to cycle through all possible combinations of relative, mixed, and absolute cell references for a formula?

According to the order of precedence, the formula =(25*2)/5 would calculate the result of 10 . _________________________

Which of the following is NOT a Paste list arrow option?

In the formula =(G15-G14)*$M$3/4, which mathematical operation is performed first?

A(n) ____ cell reference tells Excel to substitute new cell references within the copied formulas as necessary.

Excel's ____________________ feature suggests functions depending on the first letters typed by the user.

An Excel complex formula uses more than one arithmetic operator.

Predefined formulas in Excel are called functions and can be accessed using the Insert Function button.

The Office Clipboard contains up to 24 of the most recently cut or copied items from any Office application, and the items may be viewed using the ____________________ feature of Office.

Which keyboard shortcut turns on Edit mode?

Excel's Formula AutoComplete feature suggests functions depending on the letters typed by the user. _________________________

After you use the fill handle to copy cell contents, the Quick Copy Options button appears, which can be used to fill the cells with only specific elements of the copied cell, if you wish. _________________________

A(n) ____________________ is a predefined worksheet formula that enables Excel users to easily perform complex calculations.

Excel templates make creating a professional looking spreadsheet easier by including all of the following EXCEPT ____ in the template.

The $ symbol placed before a row and column address indicates a(n) ____________________ cell reference.

To insert cells, click the Insert list arrow in the Cells group on the ____ tab, then click Insert Cells.