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 36

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
Primary key in MS Access?
Uniquely identifies each record in a table
click to copy
Which Access object is used to retrieve data?
Query
click to copy
Access Form is used to?
Provide user-friendly interface for data entry and viewing
click to copy
Access Report is used to?
Present data in formatted printable layout
click to copy
Relationship in Access between tables uses?
Linked fields (Primary key - Foreign key relationship)
click to copy
IP address 127.0.0.1 is called?
Loopback/localhost address
click to copy
Which HTML tag is used for the largest heading?
<h1>
click to copy
What does CSS stand for?
Cascading Style Sheets
click to copy
Which HTML attribute specifies a hyperlink's destination?
href
click to copy
JavaScript is used for?
Client-side interactive web functionality
click to copy
PHP stands for?
PHP: Hypertext Preprocessor (recursive acronym)
click to copy
Which CSS property changes text color?
color
click to copy
Meta tag in HTML is used for?
Providing metadata about the document (charset, viewport, description)
click to copy
Responsive web design adjusts layout based on?
Screen size and device type
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

Computer Fundamentals → Internet Basics 2

The first search engine was?
Archie (1990)
click to copy
Which protocol is used by web browsers to access websites?
HTTP/HTTPS
click to copy