Free MO-210 Exam Flashcards

Confirm the delimiter, file origin or encoding, detected column data types, header handling, and destination. A wrong delimiter or automatic type conversion can corrupt the structure before the data reaches the worksheet.

Excel creates a query-backed connection that can preserve transformation steps and refresh from the source. Loading copied web text directly creates only a static snapshot.

Find searches workbook content such as text or values. The Name Box jumps directly to a cell address, named range, table, or other defined workbook element when you enter its name.

It can open an existing file, create an email message, or jump to a cell or named location in the current workbook. Removing the hyperlink can leave the displayed text intact.

Orientation, paper size, margins, print area, page breaks, and scaling. Use print preview to confirm that fitting the sheet does not make the content unreadably small.

AutoFit sizes the row or column to its current contents. Assigning a specific measurement creates a fixed size that does not automatically expand when longer content is entered.

They appear on printed pages and in Page Layout view, not as ordinary worksheet cell content. They can include text plus fields such as page number, date, file name, or sheet name.

It keeps selected commands available regardless of the active ribbon tab. Add commands you use repeatedly; this changes the interface, not the workbook's data or formulas.

Rows above and columns to the left of the active-cell boundary remain visible while you scroll. Freeze Top Row and Freeze First Column are simpler presets for one direction.

It lets you display different sheets or distant areas of one workbook at the same time. Arrange or View Side by Side changes the windows; it does not create another workbook copy.

Properties store descriptive metadata such as title, author, tags, and subject. Show Formulas switches the worksheet display from calculated results to the formulas stored in cells.

Print Area selects which cells will print from the workbook. Exporting to PDF creates a separate fixed-layout file, using the current print area and print settings unless you change the export options.

Use inspection tools for hidden properties, personal information, accessibility, and compatibility as required; then resolve comments and review legacy notes. Comments support threaded discussion, while notes are simple cell annotations.

Paste Values. Other Paste Special choices can preserve only formulas or formatting, apply arithmetic, skip blanks, or transpose rows and columns, so choose the option that matches the requested result.

It copies a value or formula, extends a recognized series, or follows a pattern based on the selected seed cells and fill option. Relative references adjust when formulas are filled.

An inserted row shifts every column in that row position. Inserting selected cells shifts only the chosen area right or down, which can misalign a dataset if the wrong scope is selected.

It returns a random integer from 10 through 20, inclusive. RANDBETWEEN is volatile, so the result can change whenever Excel recalculates the workbook; paste values to freeze a result.

A 3-row by 2-column array containing 10, 15, 20, 25, 30, and 35 in row order. The four arguments are rows, columns, starting value, and step.

Excel keeps the upper-left cell's content and discards content from the other selected cells after warning you. Unmerging later restores separate cells but does not restore discarded values.

Wrap Text displays content on multiple lines within the cell width; orientation rotates the displayed content; indentation offsets it from the cell edge. These are alignment formats and do not alter the stored value.

No. Number formatting changes how the value appears, while formulas still use the stored number. Format Painter copies formatting from one selection to another without copying its value.

A cell style applies a reusable bundle of formatting such as number format, font, fill, border, and alignment. Clear Formats removes formatting while leaving values and formulas in place.

The same edit can be applied to corresponding cells on every grouped sheet. Ungroup immediately afterward, because later typing, deletion, or formatting would otherwise affect all grouped sheets.

It replaces an address with a meaningful stable name, such as =SUM(SalesAmount). A name can have workbook or worksheet scope, so choose the correct scope when defining or referencing it.

A sparkline is a miniature line, column, or win/loss chart inside one cell that summarizes a row or column of values. Its location cell is separate from its source data range.

Excel reevaluates the rule against the cell's current value or formula. Rule order and Stop If True can affect conflicts; removing a rule removes the visual format, not the underlying data.

A header-aware structured object with filtering, sorting, styles, calculated-column behavior, structured references, and automatic expansion. Confirm whether the source already has headers when creating it.

The style supplies the overall visual design. Options such as Header Row, Total Row, First or Last Column, Banded Rows, and Banded Columns toggle structural emphasis within that design.

The data and current formatting remain, but table functionality is removed: structured table behavior, automatic expansion, table-name references, and built-in table filter controls no longer operate as a table.

Insert table rows or columns from within the table, or enter data directly next to its boundary when the adjacent area is clear. Verify the selection so an entire worksheet row or column is not inserted accidentally.

SUBTOTAL can ignore rows hidden by a table filter, so the result reflects visible records. Use the Total Row dropdown to choose Sum, Average, Count, or another supported calculation per column.

Filtering temporarily hides records that fail criteria without rearranging the remaining data. A multi-level sort reorders all records using prioritized keys, such as Department first and Sales descending second.

A1 lets both row and column move; $A$1 locks both; $A1 locks only the column; A$1 locks only the row. F4 cycles these forms while editing a selected reference.

It is a structured reference to the Amount value in the current table row. By contrast, Table1[Amount] refers to the data cells in the entire Amount column.

SUM totals numeric values, AVERAGE returns their arithmetic mean, MIN returns the smallest numeric value, and MAX returns the largest. Text and blanks in referenced ranges are generally ignored by these calculations.

COUNT counts cells containing numbers; COUNTA counts nonempty cells of any type; COUNTBLANK counts blank cells in the specified range. Choose based on the stored content, not how a formatted cell looks.

A logical test, a result if the test is TRUE, and a result if it is FALSE: =IF(logical_test,value_if_true,value_if_false). Text results need quotation marks.

A dynamically spilled, sorted copy of an array or range. It does not rearrange the source data; optional arguments choose the sort index, order, and whether to sort by row or column.

It returns distinct values as a dynamic array while leaving the source unchanged. The result spills into neighboring cells, so occupied cells in the spill area cause a #SPILL! error.

Use LEFT for characters from the beginning, RIGHT for characters from the end, and MID for characters beginning at a specified position. MID requires both a starting position and a character count.

UPPER and LOWER change letter case; LEN counts characters including spaces; CONCAT joins text without a delimiter argument; TEXTJOIN can insert a chosen delimiter and optionally ignore empty cells.

Choose the data and the comparison the chart must communicate. Column or bar charts compare categories, line charts emphasize change over an ordered axis, and pie charts are best limited to a simple part-to-whole relationship.

Excel uses the selected values and nearby headers to infer series names and category labels. Select the intended range first, then verify the resulting series and axis labels rather than accepting the inference blindly.

A chart sheet contains a chart as the sheet's primary content. An embedded chart is an object positioned on a worksheet alongside cells and can be moved or resized there.

Provide the series name and the range containing its values, then confirm the category labels still align. A mismatched range size can produce misleading categories or missing points.

It swaps the chart's interpretation of source rows and columns as series versus category groups. It does not transpose or alter the worksheet source data.

The legend maps colors or markers to series. Axis titles describe the meaning or units of an axis; a chart title states the chart's overall message or subject.

Data labels place values, percentages, category names, or series names next to individual points. Use only the information needed, because excessive labels can obscure the chart.

A Quick Layout changes the arrangement and presence of elements such as titles, legends, and labels. A chart style changes coordinated colors and visual formatting without redefining the source data.

State the chart's purpose and the essential trend, comparison, or conclusion a viewer needs. Do not merely repeat 'chart' or list decorative details; alt text exists for users who cannot see the visual.