Which keyboard shortcut inserts the current date as a static value in a cell?
Manage Cells And Ranges
Question · Easy
When importing a delimited text file, what should you verify before loading it into Excel?
Manage Worksheets and Workbooks
Flashcard
Which Excel function returns the number of cells in a range that meet a single condition?
Formulas And Functions
Default format for an ordinary Excel workbook, it is XML-based and cannot store VBA macro code.
Workbook management
Guess the Term
Introduction & Exam Overview
About the MO-210 Exam
Study guide
Cheat sheet
A user wants to prevent rows 1 and 2 from scrolling out of view while working in a large worksheet. What is the correct action?
Manage Worksheets And Workbooks
Read the clue and guess the term in 6 tries.
Game
What is the practical advantage of importing an online data source through Get Data?
Which formula correctly sums all values in column B where the corresponding cell in column A equals "East"?
Sections locked by Excel's freeze command that stay visible while the rest of the sheet scrolls.
When a formula returns the error #VALUE!, what is the most likely cause?
Question · Medium
How do Find and the Name Box serve different navigation goals?
Which of the following correctly describes the difference between an absolute cell reference and a relative cell reference?
Text printed at the top of a page, often holding a title or page number.
Performance-Based Exam Strategy
A user applies a conditional formatting rule to highlight cells in B2:B20 greater than 100 in red. She then adds new data in B21. Will the conditional formatting apply to B21?
Swap tiles to line up three of the same term.
Term Match
What can an Excel hyperlink target besides a web page?
Which function returns the value from the 3rd row and 2nd column of the array A1:D10?
Kind of area made of one or more chosen cell ranges that will appear on paper.
Which function pair is most flexible for looking up a product name in column A and returning a price from column C, allowing the return column to be to the left of the lookup column?
Which page-setup choices control how a worksheet fits on printed pages?
Which action renames a worksheet tab in Excel?
Cell annotation with a yellow background that has no Reply box, unlike a threaded discussion.
Import Data & Navigate Workbooks
Import Data from Text Files
A formula =VLOOKUP("Banana",A2:C50,3,FALSE) returns #N/A. What is the most likely cause?
Flip two cards at a time to find matching terms.
Term Pairs
How does AutoFit differ from assigning a row height or column width?
Which function in Excel 365 replaces the combination of INDEX/MATCH with a single cleaner syntax?
Clickable text or picture that opens another page or file.
How do you apply the same formatting to multiple non-adjacent cells at once without using the Format Cells dialog?
Where do custom headers and footers appear in a workbook?
What does the =TRIM function do?
Selected block of cells that can be given a workbook-level label.
Data manipulation
Import Data from Online Sources
Which chart type is best suited for showing how individual parts contribute to a whole?
Charts
Find five hidden terms in a grid of letters.
Term Search
Why customize the Quick Access Toolbar for an MO-210 workflow?
What is the purpose of the =NETWORKDAYS function?
Combine adjacent cells into one larger cell.
A user converts a data range into an Excel Table. Which of the following is an automatic benefit?
Tables And Table Data
What remains visible after you choose Freeze Panes?
Which feature allows you to display only rows in an Excel Table that meet specific criteria without deleting any data?
Display option that makes long text flow onto multiple lines inside a cell to fit the column width.
Loading more…