excel chapter 6 questions
4.9(7)Studied by 102 people
Call Kai
Learn
Practice Test
Spaced Repetition
Match
Flashcards
Knowt PlayCard Sorting
1/9
Earn XP
Description and Tags
Last updated 7:57 AM on 11/25/22
Name | Mastery | Learn | Test | Matching | Spaced | Call with Kai |
|---|
No analytics yet
Send a link to your students to track their progress
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.
