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 38

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
RANK function in Excel?
Returns relative rank of a number in a list
click to copy
AVERAGEIF function?
Averages cells in range that meet a specified condition
click to copy
F4 key in Excel?
Repeats last action or toggles absolute/relative references in formula bar
click to copy
DATEDIF function in Excel calculates?
Difference between two dates in years, months, or days
click to copy
Text to Columns in Excel splits?
Text data in one column into multiple columns by delimiter
click to copy
Flash Fill in Excel (Ctrl+E)?
Automatically fills data based on detected patterns from examples
click to copy
INDIRECT function in Excel?
Returns reference specified by a text string — dynamic cell referencing
click to copy
NETWORKDAYS function in Excel?
Counts working days between two dates excluding weekends and holidays
click to copy
The default file extension for MS PowerPoint 2016 is?
.pptx
click to copy
Slide Master in PowerPoint?
Controls the design and layout of all slides in the presentation
click to copy
Which PowerPoint view shows all slides as thumbnails?
Slide Sorter view
click to copy
Presenter View in PowerPoint shows?
Speaker notes, next slide preview, and timer on presenter's screen
click to copy
Transition in PowerPoint is?
Visual effect when moving between slides
click to copy
Animation in PowerPoint applies to?
Individual objects (text, images, shapes) within a slide
click to copy
The Morph transition in PowerPoint (2016+) creates?
Smooth animation between slides with same objects
click to copy
Which PowerPoint feature embeds a live Excel chart?
Object Linking and Embedding (OLE)
click to copy
Section in PowerPoint is used to?
Organize slides into named groups for easier management
click to copy
Which tab contains animation settings in PowerPoint?
Animations
click to copy
Rehearse Timings in PowerPoint?
Records time spent on each slide for automatic slide advancement
click to copy
The .PPSF or .PPSX format in PowerPoint?
Opens directly in slide show mode (bypassing editing)
click to copy
SmartArt Layout 'Hierarchy' in PowerPoint is used for?
Organizational charts and hierarchical relationships
click to copy
MS Access is a?
Relational Database Management System (RDBMS)
click to copy

Computer Fundamentals → Input Devices 1

What is the keyboard shortcut to select an entire column in Excel?
Ctrl+Space
click to copy

Computer Fundamentals → Memory Units 1

Which shortcut starts a PowerPoint slide show from the beginning?
F5
click to copy