Practice Library
All MCQs
Browse exam-wise, subject-wise, and country-wise MCQs with explanations.
Choose an option to check your answer.
A.
=MAX(D2:D40)
B.
=SUM(D2:D40)
C.
=IF(D2:D40)
D.
=MIN(D2:D40)
Show Answer
Correct Answer: D. =MIN(D2:D40)
Explanation:
MIN returns the smallest numeric value in the selected range.
Choose an option to check your answer.
A.
MIN
B.
COUNT
C.
MAX
D.
CONCAT
Show Answer
Correct Answer: C. MAX
Explanation:
MAX examines the supplied values and returns the greatest one.
Choose an option to check your answer.
A.
=SUM(B2:B8)
B.
=AVERAGE(B2:B8)
C.
=MIN(B2:B8)
D.
=COUNTIF(B2:B8)
Show Answer
Correct Answer: B. =AVERAGE(B2:B8)
Explanation:
AVERAGE adds the numeric values and divides by the number of included values.
Choose an option to check your answer.
A.
=SUM(A1:A10)
B.
=AVERAGE(A1:A10)
C.
=COUNT(A1:A10)
D.
=MAX(A1:A10)
Show Answer
Correct Answer: A. =SUM(A1:A10)
Explanation:
SUM returns the total of the numeric values in the specified range.
Choose an option to check your answer.
A.
With a question mark (?)
B.
With a postal address
C.
With a slide number
D.
With an equals sign (=)
Show Answer
Correct Answer: D. With an equals sign (=)
Explanation:
The equals sign tells Excel to evaluate the entry as a formula.
Choose an option to check your answer.
A.
A worksheet always contains several workbook files
B.
They refer only to printed paper
C.
A workbook is the file, while a worksheet is one sheet inside it
D.
A workbook is a single cell
Show Answer
Correct Answer: C. A workbook is the file, while a worksheet is one sheet inside it
Explanation:
An Excel workbook can contain multiple worksheets organized within one file.
Choose an option to check your answer.
A.
7C
B.
C7
C.
C-7
D.
RowCColumn7
Show Answer
Correct Answer: B. C7
Explanation:
Spreadsheet cell references normally combine the column letter with the row number.
Choose an option to check your answer.
A.
Organizing, calculating, and analyzing data in spreadsheets
B.
Writing only long narrative essays
C.
Hosting physical classroom furniture
D.
Operating a projector without software
Show Answer
Correct Answer: A. Organizing, calculating, and analyzing data in spreadsheets
Explanation:
Excel stores data in tabular form and provides formulas, analysis, and visualization tools.
Choose an option to check your answer.
A.
The recipient’s email password
B.
The router’s firmware version
C.
The health tracker’s step count
D.
Page layout, breaks, margins, and whether content is cut off
Show Answer
Correct Answer: D. Page layout, breaks, margins, and whether content is cut off
Explanation:
Print Preview shows how pages are expected to appear on paper.
Choose an option to check your answer.
A.
Page Color
B.
Translate only
C.
Compare documents
D.
Insert Symbol
Show Answer
Correct Answer: C. Compare documents
Explanation:
Document comparison identifies changes between versions of similar files.
Choose an option to check your answer.
A.
To make the text impossible to read
B.
To preserve layout and make viewing more consistent across devices
C.
To convert the report into a spreadsheet formula
D.
To remove every image automatically
Show Answer
Correct Answer: B. To preserve layout and make viewing more consistent across devices
Explanation:
PDF generally maintains page appearance independently of the viewer’s word-processing setup.
Choose an option to check your answer.
A.
To describe the image for users who rely on assistive technologies
B.
To increase the image file size
C.
To hide the image from all readers
D.
To replace the document title
Show Answer
Correct Answer: A. To describe the image for users who rely on assistive technologies
Explanation:
Alt text communicates the image’s meaning to screen-reader users.
