MO-210 Exam Dumps - Microsoft Excel (Microsoft 365 Apps)

To keep rows 1 through 3 visible while you scroll down the "Sold" worksheet, you will use theFreeze Panesfeature.

Step-by-Step Solution

Select Row 4: Click on the row number4on the far left of the screen to select the entire row.

Note: In Excel, "Freeze Panes" freezes everythingabovethe currently selected row.

Navigate to the View Tab: Click on theViewtab in the top Ribbon menu.

Click Freeze Panes: In theWindowgroup, click theFreeze Panesbutton.

Select Freeze Panes: From the drop-down menu, select the first option,Freeze Panes.

Verification

Scroll down the worksheet using your mouse or the scroll bar. You should notice that the "Clearance Sale" header and the "Item Type/Description/etc." header row (rows 1-3) stay locked at the top of the screen while the data in row 4 and below moves.

To completeTask 4, you will use theUPPER functionin Excel. This function converts all characters in a specified cell into capital letters.

Step 1: Navigate to Cell I4

Ensure you are on theEmployee Hoursworksheet and click on cellI4(the first cell under theNamecolumn).

Step 2: Enter the UPPER Function

Type the following formula into cellI4:

=UPPER(A4)

A4: This refers to the cell containing the name "emilio".

UPPER: This command tells Excel to change those letters to "EMILIO".

Step 3: Fill the Column

Since your data is in a table format, Excel may automatically populate the rest of the column. If it does not:

Click on cellI4.

Hover over thebottom-right cornerof the cell until you see thethin black cross (+).

Double-clickthat cross ordrag it downto cellI14to convert the remaining names to uppercase.

Final Result Check:

CellA4shows "emilio".

CellI4should now showEMILIO.