FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 7: Excel 2: Working With Formulas and Functions

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Matching

Review LaterAdd Note

Review Later

Identify the letter of the choice that best matches the phrase or definition.

Premises

Responses

Predesigned workbook files that contain labels, values, formulas, and formatting.

Paste list arrow

relative

template

AVERAGE

$G6

$G$6

drag-and-drop method

COUNT

Premises

Predesigned workbook files that contain labels, values, formulas, and formatting.

Responses

Paste list arrow

relative

template

AVERAGE

$G6

$G$6

drag-and-drop method

COUNT

Show Answer

Correct Answer

Premises

Responses

Paste list arrow

relative

template

AVERAGE

$G6

$G$6

drag-and-drop method

COUNT

Premises

Paste list arrow

relative

template

AVERAGE

$G6

$G$6

drag-and-drop method

COUNT

Responses

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

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?

A) [F1]
B) [F4]
C) [F10]
D) [F12]

E) C) and D)
F) A) and C)

Correct Answer

verified

Show Answer

Question 33

True/False

Review LaterAdd Note

An Excel complex formula uses more than one arithmetic operator.

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

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.

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

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

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

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

Identify the letter of the choice that best matches the phrase or definition.

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

Which keyboard shortcut turns on Edit mode?

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's ____________________ feature suggests functions depending on the first letters typed by the user.

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

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

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

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

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