Exam 7: Creating Templates, importing Data, and Working With Smartart, images, and Screenshots

Kimani is working on a data set in which she has to add pictures into cells adjacent to the respective names of objects in her file.To do so,she clicks on the following series: Insert tab > X > Pictures > Insert Picture dialog box > Locate the picture that she wants to insert into a cell in Excel > Insert > Format tab > Y > Edit height and width to fit into cell > Place picture into cell.What can X and Y in the series of clicks/entries be?

(Multiple Choice)

4.8/5

(36)

Question 41

Which of the following will you select as X in the following series of clicks to add a data table to a chart: Data Chart > Chart Tools > X > Data table > (Select check box)Show Data table?

(Multiple Choice)

4.8/5

(44)

Question 42

Kathy wants to add the numbers entered in a range of selected cells.To do this,which tab will she click on the menu that appears after clicking on Totals in the Quick Analysis option?

(Multiple Choice)

4.8/5

(38)

Question 43

Braydon wants to sharpen a picture to the maximum limit to make it more appealing.He clicks on the picture,then clicks on Corrections in the Adjust group on the Format tab under Picture Tools.What should he select from the drop-down menu that appears on clicking Sharpen/Soften?

(Multiple Choice)

4.9/5

(31)

Question 44

To embed an object from another application,click Insert > Object > (Dialog box)> Create New > Object Type (select the application you want to use)> OK.

(True/False)

4.8/5

(37)

Question 45

A workbook template has which of the following file extensions?

(Multiple Choice)

4.9/5

(37)

Question 46

To switch chart rows and columns,we can click anywhere in the chart containing the data series that we want to plot on different axes,click on the Design tab in Chart Tools,then in the Data group,and finally click Switch Row/Column.

(True/False)

4.8/5

(40)

Question 47

Brielle wants to increase the size of a SmartArt graphic in her worksheet.To do so,she clicks the following series: Shape > Format tab > SmartArt tools .What should she do next to resize the object proportionally?

(Multiple Choice)

4.9/5

(34)

Question 48

While moving a picture in Excel,one can select it and hover the mouse over it until the pointer changes into a particular shape,then click the image and drag it to the required location.What is the shape into which the mouse pointer changes during this procedure?

(Multiple Choice)

4.8/5

(39)

Question 49

Olivia wants to align a certain shape on her worksheet in a specific manner.To do so,she clicks on the shape,and then clicks on the Format tab under Drawing Tools.She then clicks on Align in the Arrange group.What should Olivia click on next to align the picture to the left?

(Multiple Choice)

4.9/5

(37)

Question 50

Showing 41 - 50 of 50

Which of the following will you select as X in the following series of clicks to add a data table to a chart: Data Chart > Chart Tools > X > Data table > (Select check box)Show Data table?

Kathy wants to add the numbers entered in a range of selected cells.To do this,which tab will she click on the menu that appears after clicking on Totals in the Quick Analysis option?

Braydon wants to sharpen a picture to the maximum limit to make it more appealing.He clicks on the picture,then clicks on Corrections in the Adjust group on the Format tab under Picture Tools.What should he select from the drop-down menu that appears on clicking Sharpen/Soften?

To embed an object from another application,click Insert > Object > (Dialog box)> Create New > Object Type (select the application you want to use)> OK.

A workbook template has which of the following file extensions?

To switch chart rows and columns,we can click anywhere in the chart containing the data series that we want to plot on different axes,click on the Design tab in Chart Tools,then in the Data group,and finally click Switch Row/Column.

Brielle wants to increase the size of a SmartArt graphic in her worksheet.To do so,she clicks the following series: Shape > Format tab > SmartArt tools .What should she do next to resize the object proportionally?

While moving a picture in Excel,one can select it and hover the mouse over it until the pointer changes into a particular shape,then click the image and drag it to the required location.What is the shape into which the mouse pointer changes during this procedure?

Olivia wants to align a certain shape on her worksheet in a specific manner.To do so,she clicks on the shape,and then clicks on the Format tab under Drawing Tools.She then clicks on Align in the Arrange group.What should Olivia click on next to align the picture to the left?

Creating a Worksheet and a Chart

Formulas,functions,and Formatting

Working With Large Worksheets, charting, and What-If Analysis

Financial Functions, data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating, sorting, and Querying a Table

Working With Trendlines, pivot Table Reports, pivotchart Reports, and Slicers

Formula Auditing, data Validation, and Complex Problem Solving

Data Analysis With Power Tools and Creating Macros

User Interfaces, visual Basic for Applications Vba, and Collaboration Features in Excel

Filters