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
Which keyboard shortcut opens the Format Cells dialog box in Excel?
Answer: Ctrl+1
Ctrl+1 opens the Format Cells dialog where you can set number formats, alignment, font, borders, and fill.
What does the CONCATENATE function (or the & operator) do in Excel?
Answer: Joins two or more text strings into one
CONCATENATE (or the & operator) combines multiple text values into a single string, for example =A1&" "&B1.
When you sort a table by a column in Excel, what happens to the other columns in the same row?
Answer: They move together with the sorted column to keep each row's data intact
Excel sorts entire rows together, so related data in each row stays aligned regardless of which column is sorted.
What is the maximum number of columns in a single Excel worksheet?
Answer: 16,384
Since Excel 2007, worksheets support 16,384 columns (2^14), labeled A through XFD.
Which function calculates the average of values that meet a specific condition?
Answer: AVERAGEIF
AVERAGEIF calculates the average of cells in a range that meet a single specified criterion.
What does pressing F4 do when editing a cell formula in Excel?
Answer: Toggles between absolute and relative cell reference modes for the selected reference
While your cursor is on a cell reference in a formula, F4 cycles through all four reference types: relative, absolute, mixed row, and mixed column.
Which of the following best describes an Excel 'Table' (created with Ctrl+T)?
Answer: A structured data range with automatic filtering, sorting, and dynamic formula references
Excel Tables automatically expand when you add data, include filter drop-downs, support structured references, and apply consistent formatting.