AnswersCHS- TX-Professional Communications CRUnit Test

Unit Test — Unit test Answers

7 verified answers3 views
1
Free Preview

Which of the following formulas would use an absolute row reference when filled?

A
=B4*B6
B
=B4/$B6
C
=$B4*B6
D
=B$4*B6
2
Free Preview

Using the spreadsheet below, which formula can be used to determine Albert’s hourly wage?

Question illustration
A
=average(B2:C2)
B
=average(C2:B2)
C
=(C2/B2)
D
=(B2/C2)
3

A teacher uses the spreadsheet below to determine the average quiz score of each student. The teacher inserts this information into column E. In column F, which function can be cut and pasted into different cells to tell the teacher if each student exceeded the satisfactory average?

Question illustration
A
=IF(E3>E8, “Exceeded”)
B
=IF(E3>$E$8, "Exceeded")
C
=IF(AVERAGE(E3:E6)>E8, “Exceeded”)
D
=IF(AVERAGE(E3:E6)>$E$8, “Exceeded”)
4

The formula =B2/A2 is inserted into cell C2. Which of the following is true when this formula is copied and pasted into cell C3?

Question illustration
A
The formula changes to =B3/A3.
B
The formula remains =B2/A2.
C
The contents of cell C2 are moved to C3.
D
The contents of cell C2 and C3 are merged.
5

Which wizard allows a writer to import addresses and then generate individual address blocks for everyone in a database?

A
Mail Merge wizard
B
Formatting wizard
C
Print wizard
D
Copy and Paste wizard
6

Which type of chart or graph shows data with distinct x and y values?

A
a bar graph
B
a scatter plot
C
a line chart
D
a pie chart
7

Which word processing feature allows you to align text and create bullet points or numbered lists?

A
Font
B
Editing
C
Paragraph
D
Paste
8

You are reluctant to write an extra credit book report because you are afraid that your language and punctuation skills are not good enough. Which function of a word processor will convince you to try it?

A
header and footer
B
spelling and grammar check
C
document views
D
templates
9

When creating a chart or graph, which should be completed first?

A
selecting, by clicking and dragging, the data to be included in the data display
B
using Chart Wizard to determine the type of data display
C
selecting Insert and then selecting Chart
D
adjusting the data series
10

Choose the list of the best uses for word processing software.

A
lists, resumes, writing a book, and payroll data
B
letters to your friends, resumes, spreadsheets, and school papers
C
resumes, cover letters, databases, and crossword puzzles
D
book reports, letters to your friends, resumes, and contracts
11

A real-world use of a word processing software template is

A
a contract for leasing an apartment.
B
a bulleted list of books that are needed for a professor’s classes.
C
a science fiction short story.
D
an accounting of how you spent your money.
12

Read the spreadsheet formula below, then answer the question.cell B5=A5*2If this formula is filled into cell B6, what will the new formula be?

A
=B5*B5
B
=B5*2
C
=A5*B6
D
=A6*2
13

When is it appropriate to use an absolute reference?

A
when the information in a formula always relates to the same cell
B
when the information in a formula changes to relate to the cells next to the specified location
C
when the value of a specified cell must remain a positive number
D
when the value of a specified cell must be the same as the value of the cell immediately preceding it
14

What are the two parts of a cell reference?

A
column intersection and row range
B
column range and row intersection
C
column letter and row number
D
column number and row letter
15

Look at the spreadsheet below, then answer the question that follows.Which of the following was most likely used to apply red background and font to some of the cells in column D?

Question illustration
A
cell attribution
B
subtotal calculation
C
VLOOKUP functions
D
conditional formatting
16

What tools manage formatting for certain types of documents, including font choices, spacing, and margins?

A
stylistic tools
B
document tools
C
grammar tools
D
block tools
17

You are writing an article for the school newspaper. You want the font to appear straight on the left and right margins. Which formatting feature should you use to make that happen?

A
merge formatting
B
center alignment
C
justified alignment
D
line spacing
18

In the blank LibreOffice Writer document, to start the process of entering a date field into a letter, click on the

A
Insert menu.
B
Edit menu.
C
File menu.
D
Fields menu.
19

In a particular spreadsheet, the data in each cell is password protected. When cells are selected, the formula is visible in the formula bar. Which is true?

A
The cells are locked and hidden.
B
The cells are locked and unhidden.
C
The cells are unlocked and hidden.
D
The cells are unlocked and unhidden.
20

The group of data that will be used in a chart or graph is called the

A
chart type.
B
data range.
C
data series.
D
chart elements.

Did you find these answers helpful?

More from this Course

Quiz
1 verified answers

21st-Century Skills: Interview Skills

Instruction
10 verified answers

Listening to and Critiquing Public Speeches

Quiz
10 verified answers

Listening to and Critiquing Public Speeches