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 ribbon in MS Word 2016 was introduced in?
Office 2007
click to copy
Which view in MS Word shows text without formatting?
Draft
click to copy
Protected Document in MS Word prevents?
Unauthorized editing of specific sections or entire document
click to copy
Insert > Symbol is used to?
Insert characters not on the keyboard
click to copy
Which shortcut makes text bold in MS Word?
Ctrl+B
click to copy
Ctrl+I in MS Word?
Applies italic formatting
click to copy
Ctrl+U in MS Word?
Applies underline formatting
click to copy
Which shortcut centers a paragraph in MS Word?
Ctrl+E
click to copy
Ctrl+J in MS Word?
Justifies text
click to copy
The default font in MS Word 2016 is?
Calibri 11pt
click to copy
Line spacing shortcut Ctrl+2 in MS Word sets?
Double spacing
click to copy
Ctrl+1 in MS Word sets?
Single line spacing
click to copy
Which MS Word feature shows document statistics like word count?
Review > Word Count
click to copy
Building Blocks in MS Word are?
Reusable pre-formatted content snippets (headers, cover pages, equations)
click to copy
Which shortcut saves a document in MS Word?
Ctrl+S
click to copy
The maximum number of rows in MS Excel 2016 is?
1,048,576
click to copy
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