Question 1

When you link an object, you can edit the object separately from the source document.

Accepted Answer

- embed
 - Embed
 - EMBED

Question 2

To ungroup a range of cells in a row in a worksheet, select the rows or columns you wish to ungroup, then click the Group command in the Outline group on the Data tab.In the Group dialog box, select Rows and click OK .

Accepted Answer

To ungroup a range of cells in a row or column, you should select the rows or columns you wish to ungroup, then click the Ungroup command in the Outline group on the Data tab, not the Group command.

Question 3

To customize the status bar, right-click the status bar, then click the options you want to show or hide .

Accepted Answer

This is correct. You can customize the status bar by right-clicking and selecting the options you want to show or hide.

Question 4

To outline data, select the rows or columns you want to group, then click the Group button on the Data tab.

Accepted Answer

This is true. To outline data, one needs to select the rows or columns that they want to group, and then click the "Group" button located in the "Data" tab.

Question 5

Steffie wants to change the margins of a worksheet to Normal to align it better on a printed page.To do this, what can she do after selecting the worksheet for this purpose?
A) Click Margins in the Page Setup group on the Page Layout tab and then click on Normal.
B) Set Width and Height to Automatic and Scale to 100% in the Scale to Fit group on the Page Layout tab.
C) Click Orientation and then select from the drop down menu in the Page Setup group on the Page Layout tab.
D) Check the boxes beside Gridlines View Point and Headings View Point in the Sheet Options group on the Page Layout tab.

Accepted Answer

To change the margins to Normal on a worksheet, Steffie should select the worksheet and then click on Margins in the Page Setup group on the Page Layout tab. From there, she can select Normal to change the margins. Option B is incorrect because it relates to adjusting the size of the worksheet on the page, not the margins. Option C refers to changing the orientation of the page, which is not related to changing the margins. Option D is incorrect because it refers to displaying certain elements on the worksheet, not adjusting the margins.

Question 6

One advantage of exporting a workbook as a PDF file is that a PDF preserves formatting and fonts but still lets readers edit the data.

Accepted Answer

A PDF file preserves formatting and fonts but does not allow readers to edit the data.

Question 7

To retrieve data values from a comma-separated values (CSV) file, you use the From Text/CSV button in the Get & Transform group on the Data tab.

Accepted Answer

The statement is true.

Question 8

Dante uses a worksheet to list sales data from five stores he manages.The worksheet includes a column named Product Type, and Dante wants to calculate subtotals for each product type.What must he do before using the Subtotal feature?
A) Sort the data in the Product Type column.,
B) Convert the range to a table.
C) Outline the data.
D) Remove calculated columns.

Accepted Answer

Before using the Subtotal feature, Dante must sort the data in the Product Type column to group all the entries for each product type together. This will ensure that subtotals are calculated accurately for each product type.

Question 9

Tomoko lists monthly sales for each region in a worksheet.Before adding subtotals for each region, she needs to sort the values in the Region column.

Accepted Answer

It is easier to add subtotals for each region after the data has been sorted by the region column.

Question 10

You can import text data into Excel and save the imported data in Excel format.

Accepted Answer

Text data can be imported into Excel using the "Text Import Wizard" and can be saved in Excel format after importing.

Question 11

When you get and transform data from an external source, you must add it to a worksheet without any changes.

Accepted Answer

When you get and transform data from an external source, it is common to make some changes to the data before adding it to a worksheet, such as cleaning up formatting, deleting unnecessary rows or columns, or summarizing the data. Transforming the data allows you to make it more useful and relevant to your analysis.

Question 12

You can import a text file that uses a divider such as a space, comma, or semicolon between columns of data.

Accepted Answer

- delimiter
- Delimiter
 - DELIMITER

Question 13

When you import an Access database table, you can use the Power Query Editor to remove a column or row from the table.

Accepted Answer

The Power Query Editor allows you to perform various transformations on data, including removing columns or rows from a table.

Question 14

You can use the Update Links button on the Data tab to manage links in an Excel workbook.

Accepted Answer

- edit
- Edit
 - EDIT

Question 15

Before importing data into Excel, you can use the Power Query Editor to remove columns.

Accepted Answer

Power Query Editor allows you to manipulate and clean up data before importing it into Excel, including removing unnecessary columns.

Question 16

Which tab and button do you use to edit document properties ?
A) File tab, Info Button
B) View tab, Show button
C) Review tab, Changes button
D) Home tab, Alignment button

Accepted Answer

To edit document properties, you need to go to the File tab, which is where information about the document is stored. From there, you can click on the Info button and then select the Properties option to edit the document's properties such as Title, Author, and Keywords.

Question 17

Which of the following can you change in SmartArt? Select all the options that apply.
A) Style
B) Color scheme
C) Size of shapes
D) Artistic effect

Accepted Answer

In SmartArt, you can change the style, color scheme, and size of shapes. However, you cannot apply artistic effects to SmartArt.

Question 18

Michelle finished a 5 kilometer run in 180th position.The organizers shared an Excel spreadsheet with names of all the participants and the time they took to complete the race.The top 15 finishers are listed in rows 2 to 16.Michelle wants to compare her time against theirs.How can she do so?
A) Select row 17 and click View tab > Window group > Split.
B) Select rows 2 to 16 and click View tab > Window group > Split.
C) Select rows 2 to 16 and click View tab > Window group > New Window > Split.
D) Select row 16 and click View tab > Window group > Split > Arrange All.

Accepted Answer

The answer of Michelle finished a 5 kilometer run in...

Question 19

Soledad is working with a worksheet that groups data by quarter.The Quarter 4 details are hidden.She can click the Auto Outline button to display the hidden data.

Accepted Answer

The Auto Outline button is used to automatically create an outline for grouped data, but it does not specifically display hidden data. To display hidden data, she would need to use the expand (+) button next to the group or use the "Show Detail" option.

Question 20

Nisha wants to set rows 1 and 2 so that they remain visible as she scrolls through the worksheet.After clicking in row 3, which option should she select on the View tab?
A) Freeze Panes
B) Set Rows
C) Arrange All
D) View Side by Side

Accepted Answer

Nisha should select Freeze Panes to keep rows 1 and 2 visible as she scrolls through the worksheet. This option will allow her to freeze the top two rows so that they remain visible even as she scrolls down the worksheet. Option B (Set Rows) and Option C (Arrange All) do not provide a way to freeze rows, while option D (View Side by Side) is not relevant to Nisha's problem.

Quiz 7: Excel