ACIS 2504 EXAM 1 – EASTERWOOD QUESTIONS AND
VERIFIED ANSWERS
Why do businesses use spreadsheets? - CORRECT ANSWER✅✅✅- Analyze business data
- represent data through charts
- model real-world situations
- provide information to users
Steps to creating effective spreadsheets - CORRECT ANSWER✅✅✅- Determine the purpose of the
spreadsheet
- Design
- Create
- Test
- Maintain / update
Normal View - CORRECT ANSWER✅✅✅The view you use most when editing and building a
worksheet
Page Break View - CORRECT ANSWER✅✅✅Shows margins, print headers/footers, and page breaks
Page layout view - CORRECT ANSWER✅✅✅does not show page margins, headers, footers, but
allows you to manually adjust location of pages
Information that should be included on a printed document - CORRECT ANSWER✅✅✅- Print data
- Print time
- Company name
- Page number
- Total # of pages
- File name and location
,Portable Document Format (PDF) - CORRECT ANSWER✅✅✅A file type that preserves most
formatting attributes of a source document regardless of the software in which the document was
created
Table Style - CORRECT ANSWER✅✅✅Predefined set of formatting properties including:
- total row calculations
- filtering
- sorting
- Banding
Excel Theme - CORRECT ANSWER✅✅✅Collection of
- fonts
- styles
- colors
- effects
*Default theme is "Office"
Functions - CORRECT ANSWER✅✅✅built in operations that perform operations on data
- financial
- statistical
- mathematical
- date and time
- text
Functions included in AUTOSUM - CORRECT ANSWER✅✅✅- SUM
- COUNT
- AVERAGE
- MIN
- MAX
, Formulas - CORRECT ANSWER✅✅✅Allow you to perform basic mathematical calculations
Can contain:
- cell references
- constants
- functions
- mathematical operators
Conditional Formatting - CORRECT ANSWER✅✅✅- Allows the specification of rules when formatting
a cell
- changes the visual presentation of information to add information
- highlights info by changing cell:
~ fill color
~ font color, style, and size
~ border
~ number format
Displaying formulas - CORRECT ANSWER✅✅✅Press "Show formulas" in formula auditing group on
Formula's tab
Merging and Centering two rows - CORRECT ANSWER✅✅✅One the upper-left cell will be merged
and centered
Relative Cell Reference Example - CORRECT ANSWER✅✅✅C3 + D3
Mixed Cell Reference Example - CORRECT ANSWER✅✅✅C$3+$D3
Absolute Cell Reference - CORRECT ANSWER✅✅✅$C$3+$D$3
VERIFIED ANSWERS
Why do businesses use spreadsheets? - CORRECT ANSWER✅✅✅- Analyze business data
- represent data through charts
- model real-world situations
- provide information to users
Steps to creating effective spreadsheets - CORRECT ANSWER✅✅✅- Determine the purpose of the
spreadsheet
- Design
- Create
- Test
- Maintain / update
Normal View - CORRECT ANSWER✅✅✅The view you use most when editing and building a
worksheet
Page Break View - CORRECT ANSWER✅✅✅Shows margins, print headers/footers, and page breaks
Page layout view - CORRECT ANSWER✅✅✅does not show page margins, headers, footers, but
allows you to manually adjust location of pages
Information that should be included on a printed document - CORRECT ANSWER✅✅✅- Print data
- Print time
- Company name
- Page number
- Total # of pages
- File name and location
,Portable Document Format (PDF) - CORRECT ANSWER✅✅✅A file type that preserves most
formatting attributes of a source document regardless of the software in which the document was
created
Table Style - CORRECT ANSWER✅✅✅Predefined set of formatting properties including:
- total row calculations
- filtering
- sorting
- Banding
Excel Theme - CORRECT ANSWER✅✅✅Collection of
- fonts
- styles
- colors
- effects
*Default theme is "Office"
Functions - CORRECT ANSWER✅✅✅built in operations that perform operations on data
- financial
- statistical
- mathematical
- date and time
- text
Functions included in AUTOSUM - CORRECT ANSWER✅✅✅- SUM
- COUNT
- AVERAGE
- MIN
- MAX
, Formulas - CORRECT ANSWER✅✅✅Allow you to perform basic mathematical calculations
Can contain:
- cell references
- constants
- functions
- mathematical operators
Conditional Formatting - CORRECT ANSWER✅✅✅- Allows the specification of rules when formatting
a cell
- changes the visual presentation of information to add information
- highlights info by changing cell:
~ fill color
~ font color, style, and size
~ border
~ number format
Displaying formulas - CORRECT ANSWER✅✅✅Press "Show formulas" in formula auditing group on
Formula's tab
Merging and Centering two rows - CORRECT ANSWER✅✅✅One the upper-left cell will be merged
and centered
Relative Cell Reference Example - CORRECT ANSWER✅✅✅C3 + D3
Mixed Cell Reference Example - CORRECT ANSWER✅✅✅C$3+$D3
Absolute Cell Reference - CORRECT ANSWER✅✅✅$C$3+$D$3
