Unit Test — Unit test Answers

7 verified answers3 views
21
Free Preview

When preparing a spreadsheet that contains population data for different nations, what is the best way to provide a visual comparison of the nations’ population sizes?

A
apply a yellow background color to the spreadsheet
B
enter a formula to yield total populations for each nation
C
create a bar graph that shows population totals for each nation
D
use the AVERAGE function to calculate the average population size of a nation
22
Free Preview

What is the best use of a line chart?

A
to show parts of a whole while emphasizing specific data
B
to compare and contrast discrete categories of data
C
to display data that changes over time
D
to display data points that are unconnected and distinct
23

Which best describes the difference between a desktop publishing program and a word processing program?

A
A desktop publishing program allows for control over the look of a document, and a word processing program primarily focuses on text manipulation.
B
A desktop publishing program provides control over graphics, and a word processing program primarily focuses on text.
C
A desktop publishing program creates documents with minimal input from a writer, and a word processing program requires a writer to input all information.
D
A desktop publishing program does not use templates, and a word processing program can use templates.
25

Lookup functions allow spreadsheet users to

A
show quantities of distinct, discrete categories of data.
B
present data that changes as a function of time.
C
keep track of IF statements and nested IF statements.
D
reduce the amount of manual searching and data entry.

Did you find these answers helpful?

Unit Test — Unit test Answers — CHS…