FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 8: Excel

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 191

Multiple Choice

Review LaterAdd Note

Review Later

In which of the following dialog boxes will you click Load/Save to save a problem model?

A) Options
B) Solver Results
C) Solver Parameters
D) Show Trial Solution

E) A) and B)
F) None of the above

Correct Answer

verified

Show Answer

Question 192

Multiple Choice

Review LaterAdd Note

Review Later

To apply a cell style, you would use the Cell Styles command on the _____ tab.

A) Layout
B) Insert
C) View
D) Home

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

Correct Answer

verified

Show Answer

Question 193

Multiple Choice

Review LaterAdd Note

Which of the following properties is used to specify the way the control is attached to the cells below it, while inserting a command button (ActiveX control) into a worksheet?

While creating a two-variable data table in Excel, you need to enter two ranges of possible input values, one in a row and another in a column.

One can use the InputBox function in Excel VBA to prompt a user to enter a value.

To print your worksheet at its actual size, which of the following would you select?

Which of the following will you select as X in the series of clicks to add a color scale to a range of cells: (Select) Range of cells > Home tab > Styles group > Conditional formatting > X > (select) Subtype ?

When you copy cell contents, the data is removed from its original location and placed on the Clipboard.

Ariana wants to view data from two workbooks at the same time so that one of them opens in a new window.What can she click to display one workbook in a new window?

A student is asked to find the difference between two values of time entered in cells A1 and B1, where A1 is the greater value and B1 the lesser value.In order to do so, he will type the formula =A1-B1 in an empty cell.

Alejandro wants to change the color of a Pivot Chart he has created to make it a little more impactful.To do so, he clicks the chart he wants to change, then clicks Chart Styles in the upper right corner next to chart, clicks X and selects the color scheme he wants.What can X be in the series of clicks?

A teacher creates a table that contains data about winners of a Sports Day events in 4 columns, A to D under headings : Event, Rank, First name, Last name and Grade, respectively.To sort the table by Event and then by Rank, she can select a cell in the column A, select the Data tab on the Ribbon, then select the Sort command.Under the Sort dialog box, in the Sort by drop down menu, she can select Event, click Add Level and then select Rank in the Then by drop down menu and finally click OK.

Which of these combination of keys will you press to switch between two workbook windows?

How many items in a Pivot table can you drill down at a time?

The Error Alert Style, Stop in the dropdown list that opens under Error Alert tab highlights the invalid entry that can be overtyped.

To rotate cell contents, you use the Alignment tab in the Format Cells dialog box.

Currency is an example of a number format.

Jenny wants to change the style of a SmartArt in her worksheet.To do so, she clicks the shape in the SmartArt graphic.She then clicks on an option under SmartArt Tools, on the Format tab, in the Shape Styles group and then selects the thumbnail she wants.What can the option that she selected under SmartArt Tools be?

Nolan wants to group data in a Pivot table to analyze a subset of data.Which of these series of clicks/ selections/ entries should he follow to do so?

To format the cell value 44.54 as 44.540, you can use the Increase Decimal button.