MOS EXAM SG 2 QUESTIONS WITH 100% RATED ANSWERS 2024/2025 LATEST UPDATED/GET A+

MOS EXAM SG 2 QUESTIONS WITH 100% RATED
ANSWERS 2024/2025 LATEST UPDATED/GET A+

Beginning at cell A16 on Sheet1, import the list from the comma delimited source file
MoreToys.csv located in the GMetrixTemplates folder. (Accept all other defaults) - 1. On the
Sheet1 worksheet, click cell A16 to select it.
2. On the DATA tab, in the Get External Data group, click From Text. (Hint: If you do not see
these options listed in the Data Tab you may need to enable the Legacy Import Wizards. To do
this, go to File > Options > Data > Show legacy data import wizards and check From Text. Once
this is complete you can use the Get Data drop-down to select the Legacy Wizards and select
From Text.)
3. Browse to the GMetrixTemplates folder.
4. Select the MoreToys.csv file and click the Import button.
5. In the Text Import Wizard - Step 1 of 3 pop-up window, accept the default data type as
Delimited and click the Next button.
6. In the Text Import Wizard - Step 2 of 3 pop-up, change the Delimiter from Tab to Comma by
clicking on the box next to Tab to clear it, then clicking on the box next to Comma to select it.
(Hint: Notice how you can preview how the data will be separated in the window below).
7. Accept all other defaults and click the Finish button.
8. In the Import Data pop-up accept the defaults and click OK.

(Hint: If you do not see these options listed in the Data Tab you may need to enable the Legacy
Import Wizards. To do this, go to File > Options > Data > Show legacy data import wizards and
check all that apply. Once this is complete you can use the Get Data drop-down to select the
Legacy Wizards and select the Wizard that applies.)

On the Carriers and Coolers worksheet, link the contents in cell C10, C11, and C12 to cell A4 on
the Tackle worksheet. - 1. Select cell C10 on the Carriers and Coolers worksheet
2. On the INSERT tab, in the Links group, click Hyperlink.
3. In the Link to: section, select Place in This Document.
4. In the "Type the cell reference" field, type "A4"
5. In the "Or select a place in this document" field, under Cell Reference, highlight Tackle
6. Click OK.
7. Repeat steps 1 through 6 for cells C11 and C12.

Join cells A1:E1 of the Tackle worksheet. Do not change the alignment of the contents. - 1.
Select cell range A1:E1 on the Tackle worksheet.
2. On the HOME tab, in the Alignment group, click the Merge & Center drop-down arrow and
select Merge Across.

On the Carriers and Coolers worksheet, apply the 3 Flags Icon Set Conditional Formatting to the
contents in the Inventory column. - 1. Select cell range D4:D19 on the Carries and Coolers
worksheet.

,2. On the HOME tab, in the Styles group, click Conditional Formatting to open the menu.
3. Select Icon Sets and click 3 Flags.

On the Carriers and Coolers worksheet, expand the chart data range to include the rest of the
rows in the table - 1. On the Carriers Coolers worksheet, click in the center of the chart to select
it.
2. Click the Chart Tools Design contextual tab.
3. In the Data group, click Select Data.
4. In the Select Data Source pop-up window, in the Chart data range field, change the last value
to $D$19.
(Hint: the entire data range should be ='Carriers & Coolers'!$C$4:$D$19 )
5. Click OK.

Copy only the Carriers and Coolers worksheet into a new workbook. Save it in the
GMetrixTemplates folder as Inventory Report.xlsx. Close the new workbook before proceeding.
- 1. At the bottom of the workbook, right-click the Carriers and Coolers tab, and select Move or
Copy...
2. Click the Create a copy box to enable it.
3. In the To book: field, click the down-arrow and select (new book).
4. Click OK. The new workbook containing only the worksheet Carriers and Coolers should
open.
5. Click the FILE tab and select Save As.
6. Browse to the GMetrixTemplates folder and save the workbook with the File name: Inventory
Report.xlsx
7. Click Save.
8. Close the new Workbook you just saved.

Simultaneously replace all occurrences of the word Choco with Chocolate in the workbook. - 1.
On the HOME tab, in the Editing group, click Find & Select and choose Replace...
2. In the Find and Replace pop-up window, type the following in the fields:
Find what: Choco
Replace with: Chocolate
3. Click the Options button and set the Within: field to Workbook.
4. Click Replace All
5. Click Close to exit the pop-up window.

in the Costs worksheet, repeat the rows containing the company logo and column headings so
they appear on all printed pages. - 1. On the PAGE LAYOUT tab, in the Page Setup group, click
Print Titles.
2. In the Page Setup pop-up window, on the Sheet tab, type the following in the fields:
Rows to repeat at top: $1:$3
(Hint: You can also autopopulate this field by selecting the rows with your mouse.)
3. Click OK
(Hint: You can see the result by clicking Print Titles again, then clicking Print Preview. The first
page will display in the Print Preview window. At the bottom of the window, advance to the
second page by clicking the Next Page arrow located right of 1 of 2. You should see the column

, headings displayed at the top of the table on both pages. Click the return arrow in the upper left
corner of the window to go back to the spreadsheet.)

In cell B28 on the Profits worksheet, insert a formula that displays the number of Sales greater
than 250. - 1. Click the Profits worksheet tab to select that worksheet.
2. Click cell B28 to select it.
3. On the FORMULAS tab, on the far left click Insert Function.
4. In the Insert Function pop-up window, in the Search for a function: field, type COUNTIF.
Click Go.
5. In the Select a function: window, select COUNTIF and click OK.
6. In the Function Arguments pop-up window for COUNTIF, type the following in the fields:
Range: D4:D26
Criteria: ">250"
7. Click OK.
(Hint: The completed entry in the Formula Bar should read =COUNTIF(D4:D26,">250") )

Modify the chart on the Profits worksheet so the Flavors are displayed as Horizontal Axis Labels
and Expense and Income are the Legend Series. - 1. If the Profits worksheet Is not already
displayed, click the Profits worksheet tab to select it.
2. Click the chart to reveal the CHART TOOLS tabs.
3. On the CHART TOOLS DESIGN tab, in the Data group, click Switch Row / Column.

Modify the chart on the Profits worksheet so the Legend appears at the Top. - 1. If the Profits
worksheet Is not already displayed, click the Profits worksheet tab to select it.
2. Click the chart to reveal the CHART TOOLS tabs.
3. On the far left of the CHART TOOLS DESIGN tab, in the Chart Layouts group, click Add
Chart Element, select Legend and click Top.

Simultaneously remove all duplicate records in the Wired Networks table. - 1. Click any cell
within the Wired Networks table.
2. On the DATA tab, in the Data Tools group, click Remove Duplicates.
(Hint: Notice the entire table is automatically selected.)
3. Accept all defaults and click OK.
(Hint: A pop-up window should confirm that 2 duplicate records were removed.)
4. Click OK.

Configure the Q1 Sales worksheet so rows 1 through 3 remain visible as you scroll vertically. -
1. On the Q1 Sales worksheet, select row 4.
(Hint: When freezing frames vertically, select the row below the last row you want to remain
visible.)
2. On the View tab, in the Window group, click the Freeze Panes down-arrow and select Freeze
Panes.

Add the Subject Equipment Draft to the document properties. - 1. Click the FILE tab.
2. In the bottom right corner of the Info page, click the Show All Properties link.
3. In the Subject field, type Equipment Draft.