excel chapter 6 questions

4.8(4)
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
Card Sorting

1/9

flashcard set

Earn XP

Description and Tags

Study Analytics
Name
Mastery
Learn
Test
Matching
Spaced

No study sessions yet.

10 Terms

1
New cards
Which what-if analysis tool is the best option for complex calculations requiring constrained optimization?
Solver
2
New cards
What tool is used to view existing range names?
Name Manager
3
New cards
Which tool is most effective when comparing the impact of various combinations of production expenses and new customer acquisition on net sales profit?
Two-variable data table
4
New cards
This tool calculates the value required in a single cell to produce a result within a related cell.
Goal Seek
5
New cards
This analysis tool can handle multiple adjustable cells while minimizing, maximizing, or meeting goals.
Solver
6
New cards
Which of the following is an Excel add-in?
Solver
7
New cards
Which of the following is not an acceptable range name?
2021_Rate
8
New cards
What is the keyboard shortcut to open the Paste Name dialog box?
F3
9
New cards
Which of the following tools can incorporate constraints?
Solver
10
New cards
The Solver add-in displays on this tab in the ribbon.
Data tab.