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

Which network type covers a metropolitan area?
MAN (Metropolitan Area Network)
click to copy
PAN (Personal Area Network) range is approximately?
10 m
click to copy
RJ-45 connector is used for?
Ethernet (wired LAN) connections
click to copy
RJ-11 connector is used for?
Analog telephone lines (4-pin or 6-pin)
click to copy
Cat5e cable supports speeds up to?
1 Gbps (with bandwidth up to 100 MHz)
click to copy
PoE standard IEEE 802.3af provides?
15.4W maximum to powered device
click to copy
SNMP MIB stands for?
Management Information Base — database of manageable network objects
click to copy
Which routing protocol has lowest Administrative Distance?
Connected interface (0)
click to copy
VLSM (Variable Length Subnet Masking) allows?
Different subnet sizes within the same network — efficient IP allocation
click to copy
NAT (Network Address Translation) allows?
Multiple private IP devices to share one public IP for internet access
click to copy
DNSSEC protects against?
DNS cache poisoning and spoofing by adding cryptographic signatures
click to copy
How many usable hosts in a /30 subnet?
2
click to copy
Subnetting divides a network to?
Create smaller network segments and reduce broadcast traffic
click to copy
In MS Word, Ctrl+Enter inserts a?
Page break
click to copy
Table of Contents in MS Word updates when?
When right-clicked and Update Field selected, or F9 pressed
click to copy
In MS Excel, a formula always starts with?
=
click to copy
Excel ROUND(3.456, 2) returns?
3.46
click to copy
Absolute cell reference in Excel prevents?
Cell reference from changing when formula is copied
click to copy
Which Excel function checks if a cell is empty?
ISBLANK()
click to copy
PowerPoint Shift+F5 starts slide show from?
Current slide
click to copy
In Access, Datasheet View shows?
Table data in rows and columns like a spreadsheet
click to copy
Which Access query type modifies existing data?
Update query
click to copy
In Excel, what does #VALUE! error mean?
Wrong data type in formula — text where number expected
click to copy
Excel VLOOKUP fourth argument FALSE means?
Exact match — only returns result if exact value found
click to copy
Excel POWER(2,10) returns?
1024
click to copy
Excel MOD(17,5) returns?
2
click to copy
ABS() function in Excel?
Returns absolute value (removes negative sign)
click to copy
MS Word Page Orientation is found under?
Layout tab
click to copy
Which shortcut selects entire row in Excel?
Shift+Space
click to copy
MS Word Outline view is useful for?
Organizing and structuring document by heading levels
click to copy
In Excel, pressing Delete key on a cell?
Clears cell contents but keeps formatting
click to copy
SQRT() in Excel?
Returns square root of a number
click to copy
Excel RAND() function generates?
Random decimal number between 0 and 1
click to copy
Convert decimal 75 to binary?
1001011
click to copy
Binary 1100110 in decimal?
102
click to copy
Octal 57 in decimal?
47
click to copy

Computer Fundamentals → Internet Basics 1

Which protocol is used for email authentication SPF?
DNS TXT records containing SPF policy
click to copy

Computer Fundamentals → Number System 3

Hexadecimal 7F in decimal?
127
click to copy
Decimal 200 in hexadecimal?
C8
click to copy
Binary 11111110 in hexadecimal?
FE
click to copy