Quick Revision

GK One-Line Question & Answer

15541+ short questions with short answers, covering every category and sub-category on the site — no long articles to scroll through. Good for a fast recap before an exam, or a few minutes of daily practice.

Looking for exam process/strategy questions instead? Try the Exam Preparation FAQ →

Computer Fundamentals → Introduction to Computer 40

The maximum number of columns in MS Excel 2016 is?
16,384
click to copy
Which Excel function returns the current date?
TODAY()
click to copy
VLOOKUP function in Excel stands for?
Vertical Lookup
click to copy
HLOOKUP searches?
Horizontally in first row
click to copy
Which Excel function counts cells containing numbers?
COUNT()
click to copy
SUMIF function in Excel?
Sums cells that meet a specified condition
click to copy
The $ symbol in Excel cell reference (e.g., $A$1) creates?
Absolute reference that doesn't change when copied
click to copy
Which Excel function returns the largest value?
MAX()
click to copy
IF function in Excel syntax is?
IF(condition,value_if_true,value_if_false)
click to copy
Pivot Table in Excel is used for?
Summarizing and analyzing large data sets interactively
click to copy
CONCATENATE() or & operator in Excel?
Joins text strings together
click to copy
Which shortcut adds the SUM formula in Excel?
Alt+=
click to copy
Freeze Panes in Excel is used to?
Keep rows/columns visible while scrolling
click to copy
IFERROR function in Excel?
Returns a custom value if formula returns error, otherwise returns formula result
click to copy
What does ### mean in an Excel cell?
Column too narrow to display the value
click to copy
#REF! error in Excel means?
Invalid cell reference (referenced cell was deleted)
click to copy
#DIV/0! error in Excel means?
Division by zero or empty cell in denominator
click to copy
#NAME? error in Excel means?
Excel doesn't recognize a formula name or range name
click to copy
LOOKUP vs VLOOKUP: LOOKUP?
Searches in one row/column and returns from another (simpler, less flexible)
click to copy
INDEX-MATCH combination in Excel?
More flexible than VLOOKUP — can look left and isn't column-order dependent
click to copy
MATCH function returns?
The position (row/column number) of a value in a range
click to copy
Which Excel function converts text to uppercase?
UPPER()
click to copy
LEN function in Excel returns?
Number of characters in a text string
click to copy
LEFT() function in Excel?
Returns specified number of characters from start of text string
click to copy
RIGHT() function returns characters from?
Right side (end) of text string
click to copy
MID() function in Excel?
Extracts characters from middle of text string given start position and length
click to copy
TRIM() function in Excel?
Removes leading, trailing, and extra spaces from text
click to copy
SUBSTITUTE() function in Excel?
Replaces specific text within a string with new text
click to copy
Conditional Formatting in Excel?
Applies formatting based on cell values or conditions
click to copy
Data Validation in Excel is used to?
Restrict input to specified types or ranges in cells
click to copy
Goal Seek in Excel?
Finds input value needed to achieve a desired formula result
click to copy
Solver in Excel is used for?
Optimization problems — finding optimal values subject to constraints
click to copy
Power Query in Excel is used for?
Importing, transforming, and loading data from various sources
click to copy
Which Excel chart type is best for showing proportions?
Pie chart
click to copy
Sparklines in Excel are?
Tiny charts within a single cell showing data trends
click to copy
SUMPRODUCT function in Excel?
Multiplies then sums arrays element-by-element
click to copy
OFFSET function in Excel returns?
A reference offset from a starting cell by specified rows and columns
click to copy
Array formulas in Excel (Ctrl+Shift+Enter)?
Perform operations on multiple values simultaneously
click to copy
XLOOKUP function (Excel 2019+) advantages over VLOOKUP?
Searches left/right, returns arrays, handles errors natively — more flexible
click to copy
Which Excel function returns the nth largest value?
LARGE(array, n)
click to copy