CCJ3011 Final Exam Guide With
Complete Solution
You would use what field if you want to change the file type so the document
will be in a file type compatible with Word 2000? - ANSWER File type field
When does Word open a document in Protected Mode? - ANSWER When you
open an attachment and that attachment was sent via email.
Kelly has several documents open on her laptop, and is working concurrently
in each one. She is about to leave for several hours to attend an off-site
social function, but will return to her documents later in the day. Which
option below would save the most power and still ensure that she can pick
up right where she left off? - ANSWER Hibernating the laptop.
How can you tell if an image or object has been selected to be manipulated? -
ANSWER It shows handles around its perimeter.
Harlene wishes to pair her Bluetooth headset with her laptop. Which of the
following must she do? - ANSWER Put the headset into discovery mode.
How can you identify the margins on the horizontal or vertical ruler? -
ANSWER The margins are the darker areas of either rulers.
What is the view that appears when you start any Microsoft Office program?
- ANSWER Backstage
From which of the following areas in Windows 10 can you access Desktop
customization settings? - ANSWER Control Panel.
, You just changed the spacing after a paragraph to 10pt and would like this
spacing on two other paragraphs on page 3 of the document. Which option
would you use? - ANSWER Repeat
Which view mode appears when you open a document sent as an
attachment? - ANSWER Read Mode
Why would you enter labels into the worksheet? - ANSWER Labels identify
the values and help outline the mathematical relationships.
If your worksheet had a list of subjects along with the first crime that they
had committed, what feature would you use to summarize the information to
give you a list of the offenses and the number of people who committed
those crimes? - ANSWER PivotTable
Freezing a row means you block any changes in the future on that row. -
ANSWER True, it does block any changes
An easy way to make all columns size to fit their contents is to select the
entire worksheet and then double-click on a border between columns. -
ANSWER True, it is an easy way
Why might you prefer to apply a background color to a cell instead of
applying a pattern? - ANSWER Patterns can make it harder to read the data
than using a solid color.
"dddd" in a date format means: - ANSWER The day of the week
Cell A1 has a value in it. You want to place a formula in B1 that tests the
value of the number in A1, and does one of two things: If the value in A1 is
<$5000, then B1 should be.01 * A1. If the value in A1 is >=$5000, then B1
should be 0. What formula would you type into B1? - ANSWER
Complete Solution
You would use what field if you want to change the file type so the document
will be in a file type compatible with Word 2000? - ANSWER File type field
When does Word open a document in Protected Mode? - ANSWER When you
open an attachment and that attachment was sent via email.
Kelly has several documents open on her laptop, and is working concurrently
in each one. She is about to leave for several hours to attend an off-site
social function, but will return to her documents later in the day. Which
option below would save the most power and still ensure that she can pick
up right where she left off? - ANSWER Hibernating the laptop.
How can you tell if an image or object has been selected to be manipulated? -
ANSWER It shows handles around its perimeter.
Harlene wishes to pair her Bluetooth headset with her laptop. Which of the
following must she do? - ANSWER Put the headset into discovery mode.
How can you identify the margins on the horizontal or vertical ruler? -
ANSWER The margins are the darker areas of either rulers.
What is the view that appears when you start any Microsoft Office program?
- ANSWER Backstage
From which of the following areas in Windows 10 can you access Desktop
customization settings? - ANSWER Control Panel.
, You just changed the spacing after a paragraph to 10pt and would like this
spacing on two other paragraphs on page 3 of the document. Which option
would you use? - ANSWER Repeat
Which view mode appears when you open a document sent as an
attachment? - ANSWER Read Mode
Why would you enter labels into the worksheet? - ANSWER Labels identify
the values and help outline the mathematical relationships.
If your worksheet had a list of subjects along with the first crime that they
had committed, what feature would you use to summarize the information to
give you a list of the offenses and the number of people who committed
those crimes? - ANSWER PivotTable
Freezing a row means you block any changes in the future on that row. -
ANSWER True, it does block any changes
An easy way to make all columns size to fit their contents is to select the
entire worksheet and then double-click on a border between columns. -
ANSWER True, it is an easy way
Why might you prefer to apply a background color to a cell instead of
applying a pattern? - ANSWER Patterns can make it harder to read the data
than using a solid color.
"dddd" in a date format means: - ANSWER The day of the week
Cell A1 has a value in it. You want to place a formula in B1 that tests the
value of the number in A1, and does one of two things: If the value in A1 is
<$5000, then B1 should be.01 * A1. If the value in A1 is >=$5000, then B1
should be 0. What formula would you type into B1? - ANSWER
