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 34

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
Decimal 47 in octal?
57
click to copy
Binary 10111011 in decimal?
187
click to copy
2's complement of 00000101?
11111011
click to copy
Binary AND: 10101010 AND 11001100?
10001000
click to copy
Binary OR: 10101010 OR 01010101?
11111111
click to copy
Binary XOR: 1111 XOR 0101?
1010
click to copy
Binary 0.001 in decimal?
0.125
click to copy
Decimal 300 in binary?
100101100
click to copy
Boolean expression A + A'B simplifies to?
A + B
click to copy
De Morgan: NOT(A + B)?
NOT A AND NOT B
click to copy
How many unique values can 4 bits represent?
16
click to copy
Which storage technology uses magnetism?
HDD and magnetic tape
click to copy
CD-RW can?
Be erased and rewritten multiple times
click to copy

Computer Fundamentals → Number System 6

Hexadecimal 7F in decimal?
127
click to copy
Decimal 200 in hexadecimal?
C8
click to copy
Binary 11111110 in hexadecimal?
FE
click to copy
Hexadecimal BB in decimal?
187
click to copy
Convert 0.75 decimal to binary?
0.11
click to copy
Hexadecimal 12C in decimal?
300
click to copy