MO-210:Pass with 91 Questions(Excel 365 Apps)

Import a tab-delimited text file using data from text/CSV, select the file, and choose load to place data on a new sheet or an existing worksheet starting at cell E1.

Master the find workflow in Excel 365: search for hyphens, use find next to select cells, and apply orange font color from the home tab font colors.

Select the named range, decorate the area, and apply red fill color; press ctrl+g to open the jump window, then confirm and apply red fill color from the home tab.

Learn how to insert a hyperlink to a specific cell in Excel 365, selecting the cell, using the insert tab link icon, and linking to defined names.

Learn to set a hyperlink in Excel 365 by copying a URL, using the insert tab link icon, and pasting the address into a file's or web page's address field.

Learn to efficiently remove hyperlinks in a link cell by right-clicking the cell and choosing remove hyperlink to simplify your Excel worksheets.

Change the orientation to landscape and set the size to A3 from the page layout tab.

Adjust the margins to wide to apply a one-page layout in Excel 365 apps, highlighting how margins impact page formatting.

Encourage viewers to rate and write comments after viewing, as reviews boost motivation, alleviate loneliness, and provide essential feedback on how the course turned out.

Double-click the right edge of column C in Excel 365 to automatically adjust width, ensuring the longest values display.

Set the 12th row height to 21 by right-clicking the row height; when prompted for column width, copy and paste 20 and press okay in Excel 365.

Display the sheet name in the center of the header using header and footer tools in page layout, then return to normal view.

Learn to add autosave to the quick access toolbar by right-clicking the ribbon to show it, then click the down arrow and select automatically save from the list.

Display the worksheet in page break preview, then on the view tab select page break preview.

Learn to freeze panes in Excel by keeping rows 1 to 5 visible as you scroll, using the View tab, and selecting row six on sheet one x exercises.

Split the sales by employee sheet into two windows, top and bottom, display four rows at the top by selecting row five, and apply split from the view tab.

Learn to add the subject property to a book document by opening the file tab, selecting info, showing all properties, and copying and pasting chapter one exercises from the question text.

Learn to adjust Excel print settings by scaling a worksheet to fit one page, using the page layout options to specify width and height and ensure horizontal fit.

Set the print area to A2:B10 on sheet one, use the Page Layout tab to define the range, and preview with Page Break Preview to confirm the printed range.

Save an Excel worksheet as a PDF using the Save As window (F12), save to the pre-created desktop folder, selecting PDF as the save as type.

Inspect the workbook to remove document properties and personal information, using File Info to inspect documents and delete all under Document Properties and Personal Information, then close.

Perform an accessibility check on a book, fix the missing alt text for graph one by entering 'steadily rising graph' as the image description and close the accessibility assistant window.

Check the compatibility, display results on a worksheet, and copy the sheet with two clicks from the lower left corner, using the file tab to check for issues.

Learn to reply to a cell comment by right-clicking the cell, choosing reply to comment, typing 'confirmed', copying the question text, and clicking the Paper Airplane button.

Add notes to cells using the right-click menu, learn to display notes from the question statement, and understand how to create new notes and comments in Excel 365.

Delete comments in a cell by right-clicking the cell and selecting delete, removing the comment attached to that cell.

Hover over a cell to display comments, then use the three dots icon to resolve the thread; avoid right-clicking and read the question statement carefully.

Learn how to copy cell C2 and paste only the values into D2 using paste special (Ctrl+Alt+V), selecting values, formats, and column widths.

Use autofill to populate date columns in the swim records February table, starting with the first date cell and using the fill handle to fill vertically or horizontally.

Select January cell in the run records table, display crosshair by hovering the black box, and drag the fill handle to the right for horizontal autofill; double-clicking won't work.

Enter a starting number in column f and use fill series from the bottom-right corner to auto number rows 2 to 23 with consecutive values.

Select multiple rows with Ctrl or Shift, then insert new rows above the selected rows in Excel 365. Learn to insert rows and columns, one line at a time.

Delete blank cells in the swim records merge table to make the data complete. Shift cells left to fill gaps in the original table.

Merge cells in Excel 365 without changing text alignment by selecting Merge Cells and using Merge and Center; if alignment must stay, choose Merge Cells instead of Merge and Center.

Display C9 text with right alignment and vertical formatting by selecting C9, using the home tab to apply align right, and choosing vertical text from the layout app icon.

Set the left indent of cell C10 to two characters by selecting C10, opening the home tab alignment, and clicking the increase indent icon twice.

Copy the formatting from cell C2 to cell A1 using paste special, then choose formats and click okay to apply the formatting.

Select cell C12 and click the home tab. Apply wrap text to wrap the string for proper alignment.

Select cell C13, go to the home tab, and click the decrease decimal button three times to display three decimal places; hover the button to confirm its name.

Learn to set the currency display format in cell C14 by selecting the cell and changing the custom format to currency from the home tab.

Format dates in Excel by selecting the cells, opening the cell formatting window from the Home tab, and choosing a display format such as March 14th, 2012, then okay.

Apply the heading one style to cell C16 by selecting the cell and choosing heading one under cell styles on the Home tab.

Clear the formatting in cell c17 by copying nonformatted cells (e.g., in column g) and using paste special with formats. Alternatively, clear formats from the home tab editing group.

Group multiple sheets to apply the total cell style to A1:B1 across all selected sheets, then deselect the group to prevent restricted operations.

Define the name for the first half of the exercise by selecting cells A2:B8, typing the name in the name box, and pressing enter to confirm; verify a2:a8 is selected.

Insert a column sparkline in the change column, select sparklines types lines, columns, and wins losses, set the range January to August, and enable the high point checkbox.

Highlight the August column of run records with conditional formatting for values less than 50, using a light red fill and dark red text.

Apply a green gradient data bar in the January column via conditional formatting in the home tab, using gradient fill to visualize run records.

Remove the conditional formatting from the match column in the table by selecting the column, opening the home tab, and clearing rules from the selected cells.

Convert cell range A125 into a table using the first row as headers; insert the table from the insert tab and check 'table has headers' before clicking okay.

Select a cell in your Excel table, open the table design tab, and apply the gold table style medium five; hover to see the style name.

Learn to remove table formatting from the meals list while preserving cell formatting, and convert the table to a range using the table design tab, noting hidden tab behavior.

Add a column to a table in Excel by selecting the distance column and inserting table columns to the left. Update the header in the added column.

Learn how to name an Excel table by selecting the student list, opening the table design tab, and entering 'student list' in the properties table name field.

Remove stripes from table A1:E5 and highlight the last column using the table design tab's style options. Uncheck banded rows and check last column to apply the formatting.

Enable the total row for table A1:E5, then set distance (m) and time (min) to sum, fatigue level to average, and impressions to none.

Filter the student list to show records whose names begin with dot one by using the text filters begins with, adjust for column type, and press okay.

Apply a date filter to the table to display only records for Feb 1 without deleting data, by using the date header and selecting the appropriate values, then confirm.

Sort table data by time in descending order, then by fatigue level in ascending order, using a custom sort with levels, and learn to clear filters and avoid sorting errors.

Enter a multiplication formula in the total amount column to compute volume times unit price, starting with equals, using the asterisk, and autofill to adjacent cells.

Calculate the discount amount by multiplying the total amount by the discount rate in B1, use an absolute reference with the dollar signs via F4, and autofill the formula down.

Use a formula in the build column to compute total minus discount in Excel 365 by calculating C4 minus D4 in E4, then autofill down.

Use the max function in Excel 365 to enter the highest score in cell C8. Navigate suggestions with tab and arrow keys, and extend ranges with shift down arrow.

Use the min function to display the fastest time as the best record in b8, with unknown entries set to min in d8, then select c2 to c5.

Learn to display the average time in cell B9 by using the average function, selecting average from suggestions, then selecting the range for the time columns c1-c5 and pressing enter.

Demonstrates using the count function in Excel 365 to tally first-time participant entries in a range, displaying the result in cell B11 by selecting the count option and pressing enter.

Use the count blank function to count blank cells in the time column, selecting the range C2 to C5 and pressing enter to display the result in B12.

Count participants by using the counter function to tally non-blank name cells in B13, selecting from suggestions, then pressing tab and entering cells A2 and A5.

Use the IF function in Excel 365 apps to mark beginners when B2 equals one and label experienced otherwise, using the Function Arguments window and autofill.

apply an if formula to display 'failed' for scores under 50 in the evaluation column, using 'failed' for true and blank for false, then autofill down.

Apply the sort function in Excel 365 to sort a table in descending order using H2 as the base, set the sort index, and specify the fourth column of scores.

Learn to use a function to return unique data from the name column of the table, ensuring no duplicates in the practice session participation records, using range B31:B40.

Use the left function to extract the first letter of names into the initial column, then autofill downward while using commas or right/left functions for simple input.

Learn how to extract two characters from the date in the last participation column using the mid function, by entering =mid(f2,5,2) in h2 and autofilling downward.

Use the upper function to convert names in column b to uppercase in a dedicated uppercase column, starting at cell c2 and autofilling downward.

Learn to count characters using the LEN function in Excel 365 by placing LEN in cell A2, selecting the name column in B2, and autofilling downward to display character counts.

Use the text join function to combine the number and name columns with a hyphen in cell F2, with A2 as text1 and B2 as text2, then autofill downward.

Learn to generate a random number between 1 and 5 using the rand function in Excel 365, with steps to enter and reference cell B2.

Use an Excel function to display numerical data in three rows and two columns starting at cell A25, with the start value 4 increasing by 6 at each step.

Use a defined name to display data from name column in table, eliminate duplicates for event dates and participants starting at B16, and select unique from the defined names group.

Display the formulas on the current sheet by opening the formulas tab and selecting show formulas.

Create a clustered column chart from daily sales table excluding the total, using the insert tab and recommended charts, and place it to the right of column O if needed.

Create a clustered bar chart of totals by name from the test results, place it in the cell range H7-13, and align and resize it precisely using the alt key.

Move the line chart to a chart sheet to create a sales trend analysis chart by copying it to a new sheet and using the Chart Design tab.

Select the clustered column chart and drag the blue box to the right to include physics as a new data series in the chart's data range.

Switch the horizontal axis and legend in a clustered column chart to show subjects on the axis and names in the legend; select the chart and switch row/column.

Display the title subject on the first horizontal axis of a clustered column chart by adding a primary horizontal axis title and entering subject.

Create cloud data labels for the pie chart that display only the classification names or one by selecting the pie chart, clicking plus, and unchecking the percentage box.

Change the pie chart title to 'Percentage of sales by day', edit the text with the cursor, paste daily sales percentages, and click outside the chart to confirm the value.

Select the pie chart, use quick layout to apply layout one from the suggestions in the chart design tab, then hover a layout option to see its name.

Apply style six and set colors to the clustered column chart, using chart style 61 from the chart designer tab, then switch to the monochromatic palette one.

Learn to view and set alternative text for the clustered column chart by student scores in Excel, including copying and pasting the score chart and closing the alt text window.

Import a tab delimited text file into Excel, using the first row as headers, and load the data into a worksheet via Power Query Editor and Close and Load.

Insert a hyperlink into cell c4 pointing to the given url and add a screen tip 'go to the book introduction page' that appears on hover.

Learn to turn autosave on or off in the quick access toolbar for the current workbook by adding the command from more commands and confirming the update.

Save the file as a pdf on the desktop in a folder named chapter one advanced, using the Save As window (F12), selecting pdf, and unchecking open file after publishing.

Navigate to file tab, choose info, and set Excel advanced text in properties. Enter a semicolon to separate properties and copy MOS 365 Excel and Advanced, removing quotation marks.

Insert a page break so line six and below print on page two using the page layout tab and breaks, then verify with page break or print preview.

Set the second line to repeat at the top using print titles in the page layout, select the second row, and click ok; verify with print preview.

Learn to use excel autofill to generate consecutive numbers from A6 through A20 while preserving formatting, by using the fill handle and autofill options to fill without formatting.

Center text across a selection in Excel 365 without merging: select A1 to D1, open home tab alignment, and choose horizontal center across selection.

Apply conditional formatting in excel to highlight values 50 or more by selecting January to April in the A8, F11 table and applying bold font via highlight cells rules.

Configure sparklines in Excel 365 by setting the vertical axis minimum to zero and applying the same maximum for all sparklines, using custom values as needed, and pressing okay.

Apply a red, white, and blue color scale to May–September data (A14:E17) with min as minimum, midpoint as 40 percentile, and max as 60 percentile in Excel 365 conditional formatting.

Select the May column, then choose four ratings under icon sets in the conditional formatting section of the home tab.

Sort the data in the table so single items come before double items by using the contract type column and selecting sort A to Z.

Filter table one to show rows where the address contains Katsushika or Adachi by using text filters, selecting contains, switching to or, and confirming okay.

Create a clustered column chart from the table to show amount of practice by discipline and month, and ensure the month appears in the legend by switching row and column.

Create a 3D pie chart showing the percentage of each category from the table distance for each triathlon, by selecting range A13:B17, then insert, all charts, 3D pie under pie.

Enable axis titles, click the plus button to check axis titles and the primary horizontal axis, rename the axis to distance, and drag it to the lower right.