General Knowledge Flashcards

Which keyboard shortcut saves the current workbook in Excel?

Answer: Ctrl+S

Ctrl+S saves the active workbook, prompting for a filename if it hasn't been saved before.

What does the AutoFill handle look like in Excel?

Answer: A small square at the bottom-right corner of a selected cell

The AutoFill handle is the small green square that appears at the bottom-right corner of a selected cell or range.

What is the default file extension for Excel workbooks in Excel 2016 and later?

Answer: .xlsx

The .xlsx format is the default XML-based format introduced in Excel 2007 and used in all modern versions.

How many rows are available in an Excel 2019 worksheet?

Answer: 1,048,576

Since Excel 2007, each worksheet supports exactly 1,048,576 rows (2^20).

Which tab on the Excel ribbon contains the 'Freeze Panes' option?

Answer: View

Freeze Panes is located in the Window group on the View tab.

What happens when you press Ctrl+Z in Excel?

Answer: Undoes the last action

Ctrl+Z undoes the most recent action, and can be pressed repeatedly to undo multiple actions.

Which of the following is NOT a valid Excel chart type?

Answer: Pyramid Bar

Excel does not have a 'Pyramid Bar' chart type; the standard types include Line, Scatter, Pie, Bar, Column, and others.

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.

What is the purpose of the Excel 'Flash Fill' feature?

Answer: Automatically fills data based on a detected pattern in adjacent cells

Flash Fill (Ctrl+E) recognizes patterns from examples you type and automatically fills the remaining cells accordingly.

Which function would you use to find the position of a value in a list?

Answer: MATCH

MATCH returns the relative position (row or column number) of a value within a range.

What does 'Wrap Text' formatting do to a cell?

Answer: Displays the cell content on multiple lines within the same cell

Wrap Text increases the row height and displays long text on multiple lines within the cell rather than overflowing into adjacent cells.

Which Excel function returns the current date and time, updating every time the worksheet recalculates?

Answer: NOW()

NOW() returns the current date and time as a serial number and recalculates dynamically; TODAY() returns only the date.

What does a green triangle in the top-left corner of a cell typically indicate?

Answer: A potential error detected by Excel's error checking

The green triangle is Excel's error indicator, alerting you to a potential issue like a number stored as text or an inconsistent formula.

Which Excel feature allows you to set rules that automatically change cell background color based on the cell's value?

Answer: Conditional Formatting

Conditional Formatting applies formatting rules — such as color scales, data bars, or custom rules — based on cell values.