General Knowledge 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 General Knowledge flashcards as text
What does the $ symbol do when placed before a column letter in a cell reference, such as $A1?
Answer: Locks the column so it doesn't change when the formula is copied
A $ before the column letter creates an absolute column reference, keeping the column fixed when the formula is copied horizontally.
Which function returns the number of cells in a range that contain numbers?
Answer: COUNT
COUNT counts only cells containing numeric values, ignoring text, blanks, and logical values.
What is the result of entering =5+3*2 in a cell?
Answer: 11
Excel follows standard order of operations (PEMDAS), so multiplication (3*2=6) is performed before addition (5+6=11).
Which Excel feature allows you to define a meaningful name for a cell or range to use in formulas?
Answer: Name Box / Named Ranges
Named Ranges (defined via the Name Box or Name Manager) let you assign descriptive names like 'TaxRate' to cells for use in formulas.
Which of the following paste options keeps only the calculated values without formulas?
Answer: Paste Values
Paste Values (Ctrl+Shift+V or via the Paste Special menu) pastes the result of formulas as static numbers.
What does the TRIM function do in Excel?
Answer: Removes extra spaces from text, leaving only single spaces between words
TRIM removes leading, trailing, and extra internal spaces from a text string, leaving only single spaces between words.
How do you quickly select an entire column in Excel?
Answer: Click the column header letter
Clicking the column header (the letter at the top of the column) selects the entire column instantly.