Basic and Advance Flashcards
7 cards from real Microsoft Excel practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Basic and Advance flashcards as text
What is the purpose of the IFERROR function in Excel?
Answer: It returns a custom value when a formula produces an error
IFERROR(value, value_if_error) evaluates an expression and returns a specified result if any error occurs, keeping the spreadsheet clean.
Which keyboard shortcut inserts the current date as a static value in a cell?
Answer: Ctrl+;
Ctrl+; inserts today's date as a fixed value that does not change when the workbook is recalculated.
What does the SUMPRODUCT function do?
Answer: Multiplies corresponding elements of arrays and returns the sum of those products
SUMPRODUCT multiplies corresponding values in two or more arrays and then sums all those products in a single step.
How do you freeze the top row in Excel so it remains visible while scrolling down?
Answer: View tab → Freeze Panes → Freeze Top Row
On the View tab, clicking Freeze Panes and then Freeze Top Row locks row 1 in place during vertical scrolling.
Which Excel tool applies different formatting to cells automatically based on the values they contain?
Answer: Conditional Formatting
Conditional Formatting changes a cell's appearance (color, font, borders) dynamically based on rules tied to the cell's value.
What does the INDEX function return when given an array, a row number, and an optional column number?
Answer: The value at the specified row and column intersection
INDEX(array, row_num, [col_num]) returns the value at the intersection of the given row and column within the specified range.
Which function finds the position of the first occurrence of a substring within a text string and is case-sensitive?
Answer: FIND
FIND is case-sensitive and returns the starting position of one text string inside another; SEARCH is the case-insensitive alternative.