DSS 100 EXCEL Exam Questions and
Answers
Excel provides a variety of tools for designing a spreadsheet, which is referred to as a worksheet in the
Excel application. - Answer-True
The Accounting Number Style displays values with commas and two decimal places, but no dollar signs. -
Answer-False
A function is always structured beginning with the function address and an opening parenthesis mark. -
Answer-False; A function is always structured beginning with the function name and an opening
parenthesis mark.
The function inputs are referred to as arguments. - Answer-True
To use a "general" formula over and over again but with a different set of numbers, use a feature called
absolute cell referencing. - Answer-False; To use a "general" formula over and over again but with a
different set of numbers, use a feature called relative cell referencing.
, The error message ###### means that there is(are) - Answer-insufficient width in cell to display data, or
negative date/time.
The ____ function adds a list of values and/or cell ranges. - Answer-Sum
Each function has its own ____, which specifies the function name and order of the arguments. -
Answer-Syntax
$B$1 is an example of a(n) ____ reference. - Answer-absolute
B1 is an example of a(n) ____ reference. - Answer-relative
Microsoft Excel charts provide a visual representation of quantitative information, giving the viewer an
overall picture of a set of data. - Answer-True
In a line chart, values are indicated by the filled areas below the lines. - Answer-False
The Alternative Data task pane, which is available from the shortcut menu for a selected chart, provides
options for modifying the values used to generate a chart. - Answer-False
You must make changes to the content of data labels using buttons in the Format Data Labels task pane.
- Answer-True
Excel offers two pie chart sub-types, Pie of Pie and Bar of Bar, that can be used to combine many smaller
segments of a pie chart into a separate smaller chart. - Answer-False
The ____ is the vertical axis where data values are plotted. - Answer-y-axis
Answers
Excel provides a variety of tools for designing a spreadsheet, which is referred to as a worksheet in the
Excel application. - Answer-True
The Accounting Number Style displays values with commas and two decimal places, but no dollar signs. -
Answer-False
A function is always structured beginning with the function address and an opening parenthesis mark. -
Answer-False; A function is always structured beginning with the function name and an opening
parenthesis mark.
The function inputs are referred to as arguments. - Answer-True
To use a "general" formula over and over again but with a different set of numbers, use a feature called
absolute cell referencing. - Answer-False; To use a "general" formula over and over again but with a
different set of numbers, use a feature called relative cell referencing.
, The error message ###### means that there is(are) - Answer-insufficient width in cell to display data, or
negative date/time.
The ____ function adds a list of values and/or cell ranges. - Answer-Sum
Each function has its own ____, which specifies the function name and order of the arguments. -
Answer-Syntax
$B$1 is an example of a(n) ____ reference. - Answer-absolute
B1 is an example of a(n) ____ reference. - Answer-relative
Microsoft Excel charts provide a visual representation of quantitative information, giving the viewer an
overall picture of a set of data. - Answer-True
In a line chart, values are indicated by the filled areas below the lines. - Answer-False
The Alternative Data task pane, which is available from the shortcut menu for a selected chart, provides
options for modifying the values used to generate a chart. - Answer-False
You must make changes to the content of data labels using buttons in the Format Data Labels task pane.
- Answer-True
Excel offers two pie chart sub-types, Pie of Pie and Bar of Bar, that can be used to combine many smaller
segments of a pie chart into a separate smaller chart. - Answer-False
The ____ is the vertical axis where data values are plotted. - Answer-y-axis
