Introduction to Spreadsheet D100 PDF Questions 2025/ 2026 Chapterwise with Solution

Introduction to Spreadsheet D100

Which arithmetic operator is evaluated first in an D. Parentheses
Excel arithmetic expression?
A. Addition and Subtraction
B. Exponents
C. Multiplication and Division
D. Parentheses


Excel would evaluate the expression =25-15/5*2+7 to A. 26
the value of?
A. 26 This is the answer when the order of operations is followed with division,
B. 11 multiplication, subtraction, and addition.
C. 8
D. 18




Excel would evaluate the expression =(18+15)/4*2+3 A. 19.5
to the value of?
A. 19.5 This is the result of evaluating the expression according to the order of
B. 7.1 operations.
C. 28.5
D. 22.8

, Introduction to Spreadsheet D100
What is the process of analyzing a calculation in a B. Forumla Auditing
spreadsheet to ensure it is correct?
A. Freezing Panes
B. Forumla Auditing
C. Cell Referencing
D. Filtering Data


What kind of calculation contains an error caused D. A calculation that includes inaccurate or incomplete data
by poor input?
A. A calculation that responds to changes in the
cells referenced in the calculation
B. A calculation that includes an inaccurate or
incomplete algorithm
C. A calculation that does not respond to changes
in the cells referenced in the calculation
D. A calculation that includes inaccurate or
incomplete data