computer applications exam study guide latest 2022 with
complete solution
Which scenario would best benefit from a page break?
a paragraph with four lines on one page and one line on another
Rico is working on a document titled 'Document1'. Which is most likely the case
for Rico's document?
He has not saved the document yet
Which best describes the Quick Access Toolbar and the Ribbon tabs?
The Quick Access Toolbar is customizable, and the Ribbon tabs are collapsible.
Rose has a list of two columns of information separated by tabs. She wants to
input this information into a table. What is the fastest way for Rose to do this?
clicking Convert Text to Table
Amitha writes up a one-page summary of a novel during her summer internship at
a publishing company. When she reads over the page, she realizes she used the
word "foreshadow" seven times, and she would like to reduce the repetition.
Thesaurus
Kyle has created a table but realizes that he wants to add one more row to the
bottom. How can he do this?
by right-clicking the bottom row, clicking Insert, then clicking Insert Row Below
Lee wants to format a paragraph that he just wrote. What are some of the options
that Lee can do to his paragraph? Check all that apply.
aligning text
adding borders
applying bullets
applying numbering
Which correctly shows the configuration of boxes in the View tab that allow the
indents to be changed?
ruler
Which best compares portrait and landscape orientations?
Portrait is taller than it is wide, and landscape is wider than it is tall.
What formatting has been applied to this document?
bullets, left alignment, and font color
Which segment is most likely set at 1.0 spacing?
b
Azzam is reviewing a paper he just wrote about kinetic friction for his physics
class. On the third page, he realizes that every time he wrote "coefficient of
friction," he should have written "coefficient of kinetic friction." He uses the Find
and Replace tool and clicks on "Replace All" to fix the issue, but then when prints
out the paper, he sees "coefficient of friction" in the first paragraph.
What is most likely the reason why the phrase was not fixed?
Azzam used the tool while he was on the third page.
Which tasks can be completed within the File tab?
saving a file, opening a file, and viewing the author of a document
, Which steps will create a new blank Word document?
Click File, click New, then double-click Blank document.
How do you change a Word document to an .html file?
Save it as a Web page
The AutoRecovery feature would be useful for which situations? Check all that
apply.
You closed a file without saving it then realized that you do need the file.
You were working on a file when Word quit unexpectedly.
Which steps will open the Help system so that you can enter a question and do a
search for help?
Click the File tab, click Help, then click Microsoft Office Help.
Lee only wants to print columns A-D of a spreadsheet he is working on. What
sequence should he use to accomplish this?
select A-D with his mouse, File, Print, Print Active sheets, Print Selection, Print
Haan creates this table to track his income. Which would give him the total
income for the year?
=SUM(B2:B13)
Stacey wants to change her document to landscape view instead of portrait.
Jesse wants to change the scale of his document. Which best describes all of the
options that Stacey and Jesse each have?
Stacey and Jesse can both look under Page Layout or under File and select Print.
This spreadsheet shows an invoice for hours worked. If a user copies the formula
from D15 into D16, what would the formula read in D16?
=B16*C16
Garrett has a column of data. What can he do at the bottom of that column of data
using an Auto function? Check all that apply.
SUM
AVERAGE
MIN
MAX
COUNT
Wendy wants to format the cells of a spreadsheet but not the text. Which
formatting tools should Wendy use? Check all that apply.
row height
row width
border
Uri would like to change the font color in a group of cells. In which part of the
Excel window should he look for font color controls?
the ribbon
Fran is changing the font, background color, and size of some text in a cell. She
also makes it bold and italicized. She then leaves a comment in a cell. Which are
all examples of Fran using text formatting?
font, size, bold, italicize
Anandi has been working with Excel to record data from an extensive physics
experiment at her university. She has hundreds of columns representing different
trials, and many rows showing different pieces of data from each trial. A handful
complete solution
Which scenario would best benefit from a page break?
a paragraph with four lines on one page and one line on another
Rico is working on a document titled 'Document1'. Which is most likely the case
for Rico's document?
He has not saved the document yet
Which best describes the Quick Access Toolbar and the Ribbon tabs?
The Quick Access Toolbar is customizable, and the Ribbon tabs are collapsible.
Rose has a list of two columns of information separated by tabs. She wants to
input this information into a table. What is the fastest way for Rose to do this?
clicking Convert Text to Table
Amitha writes up a one-page summary of a novel during her summer internship at
a publishing company. When she reads over the page, she realizes she used the
word "foreshadow" seven times, and she would like to reduce the repetition.
Thesaurus
Kyle has created a table but realizes that he wants to add one more row to the
bottom. How can he do this?
by right-clicking the bottom row, clicking Insert, then clicking Insert Row Below
Lee wants to format a paragraph that he just wrote. What are some of the options
that Lee can do to his paragraph? Check all that apply.
aligning text
adding borders
applying bullets
applying numbering
Which correctly shows the configuration of boxes in the View tab that allow the
indents to be changed?
ruler
Which best compares portrait and landscape orientations?
Portrait is taller than it is wide, and landscape is wider than it is tall.
What formatting has been applied to this document?
bullets, left alignment, and font color
Which segment is most likely set at 1.0 spacing?
b
Azzam is reviewing a paper he just wrote about kinetic friction for his physics
class. On the third page, he realizes that every time he wrote "coefficient of
friction," he should have written "coefficient of kinetic friction." He uses the Find
and Replace tool and clicks on "Replace All" to fix the issue, but then when prints
out the paper, he sees "coefficient of friction" in the first paragraph.
What is most likely the reason why the phrase was not fixed?
Azzam used the tool while he was on the third page.
Which tasks can be completed within the File tab?
saving a file, opening a file, and viewing the author of a document
, Which steps will create a new blank Word document?
Click File, click New, then double-click Blank document.
How do you change a Word document to an .html file?
Save it as a Web page
The AutoRecovery feature would be useful for which situations? Check all that
apply.
You closed a file without saving it then realized that you do need the file.
You were working on a file when Word quit unexpectedly.
Which steps will open the Help system so that you can enter a question and do a
search for help?
Click the File tab, click Help, then click Microsoft Office Help.
Lee only wants to print columns A-D of a spreadsheet he is working on. What
sequence should he use to accomplish this?
select A-D with his mouse, File, Print, Print Active sheets, Print Selection, Print
Haan creates this table to track his income. Which would give him the total
income for the year?
=SUM(B2:B13)
Stacey wants to change her document to landscape view instead of portrait.
Jesse wants to change the scale of his document. Which best describes all of the
options that Stacey and Jesse each have?
Stacey and Jesse can both look under Page Layout or under File and select Print.
This spreadsheet shows an invoice for hours worked. If a user copies the formula
from D15 into D16, what would the formula read in D16?
=B16*C16
Garrett has a column of data. What can he do at the bottom of that column of data
using an Auto function? Check all that apply.
SUM
AVERAGE
MIN
MAX
COUNT
Wendy wants to format the cells of a spreadsheet but not the text. Which
formatting tools should Wendy use? Check all that apply.
row height
row width
border
Uri would like to change the font color in a group of cells. In which part of the
Excel window should he look for font color controls?
the ribbon
Fran is changing the font, background color, and size of some text in a cell. She
also makes it bold and italicized. She then leaves a comment in a cell. Which are
all examples of Fran using text formatting?
font, size, bold, italicize
Anandi has been working with Excel to record data from an extensive physics
experiment at her university. She has hundreds of columns representing different
trials, and many rows showing different pieces of data from each trial. A handful
