NEW
Font size
WorksheetsComputer Apps Final Exam Review Part II
Total questions: 61
Worksheet time: 31mins
You can do the following tasks with Microsoft Office:
insert a Word document into a PowerPoint Presentation
insert an Excel spreadsheet into a Word document
insert a table from Word into a Power Point presentation
all of these can be done using Word, Power Point and Excel
You can insert images into which of the following in Microsoft Office?
Word
Excel
Power Point
all of these
Picture Styles and Artistic Effects are used with images in Word to enhance your document.
true
false
What function will give you the current date and time displayed in your document in Excel?
=DATENTIME
=SUM()
=NOW()
=DATE
Which are options when printing an Excel spreadsheet?
include row and column headings
add gridlines
use print preview to see what you are printing
all of these
In Microsoft Excel, what will freezing panes do?
keeps your header from showing when you scroll in the worksheet.
keeps specific rows or columns visible when you scroll in the worksheet.
keeps your footer from showing when you scroll in the worksheet.
none of these
When using Accounting or Currency formats, you can:
not worry about typing in any dollar signs
adjust decimal places
select either format by right-clicking and selecting FORMAT-CELLS
all of these can be done when using Accounting or Currency formats
Which of the following is a cell reference?
=G7
(G7)
G7
=G7!
Which adjusts to a new location when copied or moved to another cell?
relative cell reference
absolute cell reference
The Autosum command will automatically insert a formula needed to sum a group of cells together.
True
False
In Excel, you can print only a portion of your spreadsheet by using:
FIle-Print
Set Print Area
File-Page Setup-Margins
none of these
When you first create a new Power Point slideshow the first slide will be a:
Two Content
Title and Content
Comparison
Title Slide
The text on a Title Slide should be__________________ than the content text featured in the body of the presentation.
smaller
skinnier
narrower
larger
In Microsoft Office, you can group objects. This allows you to:
insert color
work with several items as if they were one object
create tables
cut and paste images
Built-in button shapes you can add to a presentation and set to link to another slide, play a sound, or perform a similar action are called:
advancement buttons
action buttons
moving buttons
movement buttons
In a color theme, you can change fonts and colors.
True
False
You can insert the following into Google:
a video that has been saved to your computer
a video from YouTube
an image
any of these
There is more than one way to advance a slide in Power Point.
True
False
One of the advantages of using Google Docs, Slides, and Sheets is that you can work on them collaboratively.
True
False
When one slide moves off of the screen and another moves onto the screen in a presentation, this is called:
collaboration
animation
transition
SmartArt
You can animate graphics, text or pictures in:
Google Slides
Powerpoint
Google Slides or Powerpoint
none of these
Which are options to print out your slides in Google Slides or Powerpoint?
one slide per page
four slides per page
six slides per page
all of these are options for printing
Both Microsoft Word and Power Point contain the following features:
Smart Art
WordArt
Online Pictures
all of these are options
Exit, Entrance and Emphasis are all parts of motion paths in Power Point.
True
False
Which of the following can you do in Slide Sorter View?
delete a slide
add a slide
change the order of a slide
all of these
Both Google and Microsoft Office have pre-made templates that make it easy to create documents.
True
False
Slide Sorter view is the only place where you can make changes to the order of your slides in Power Point.
True
False
You can print "thumbnails" or little pictures of your slide.
True
False
Which has more features, Google Slides or Power Point?
Google Slides
Power Point
In PowerPoint you can use more than one template design in your slide show.
True
False
You can do the following with Google Slides:
use a template
print out your slides
add transitions
all of these can be done with Google Slides
You can crop pictures in both Google Slides and Microsoft Power Point.
True
False
When you change a document, spreadsheet or slideshow, you _____________it.
delete
remove
modify or edit
none of these
This is the first line of text in a flyer:
Footer
Headline
Signature Line
Body Copy
When you type words continuously without pressing ENTER at the end of each line, it is called:
design theme
editing
word wrap
Smart Art
Twelve complimentary colors for text, background accents and links in a document are called:
color additions
modifications
design applications
color schemes
Which of the following is NOT a part of a business letter?
inside address
complimentary close
saluatation
headline
When preparing a resume you should include all of the following except:
skills/abilities
employment
education
report card grades
A resume should never include:
name
address
email address
driver's license number
Which email address is unacceptable and should not be used on a resume?
smithl@optonline.com
lsmith09@gmail.com
smith50@aol.com
sweetiecakes20@gmail.com
In Excel, where do you type numbers or words?
row
column
range
active cell
In Excel, the fill handle is used for which of the following?
formulas
days of the week/months of the year
formulas
all of these
Which of the following will Microsoft Word NOT pick up when using Spell Check?
when a word is typed more than one time
when a word is misspelled
when a Proper Name is typed
an ALL CAPS word
Which of the following is an example of a range?
B5:B10
B5+B10
B5?B10
B%@B10
Which is NOT a function formula in EXCEL?
MAXIMUM
AVERAGE
COUNT
LIKEWISE
How many parts does a function formula have?
2
3
4
5
Which function formula calculates the largest value in a range?
=SUM(B4:B20)
=MIN(B4:B20)
=MAX(B4:B20)
=TOTAL(b4:B20)
Which formula calculates the smallest value in a range?
=sum(G7:G20)
=min(G7:G20)
=max(G7:G20)
=IF(G7:G20)
Which function displays text or values if certain conditions exist?
SUM
LOOKUP
AVERAGE
IF
What will =A29-B29 do?
subtract the value in cell A29 from B29
subtract the value in cell B29 from A29
multiply the value in cell A29 from B29
multiply the value in cell B29 from A29
Which symbol is used in Excel for multiplication?
/
+
*
@
What does the absolute reference of cell D10 look like?
$D10
$D$10
=ABSREF(D10)
=AR$D10
When you first begin a Power Point presentation you will see a Title Slide.
True
False
The way each slide appears on the screen is known as:
animation
transition
Smart Art
none of these
Which of the following can you easily do in Power Point?
delete a slide
add a slide
duplicate a slide
all of these
You can animate all of the following on a slide EXCEPT:
Charts
Colors
Images
Text placeholders
Which of the following applies to using Power Point effectively?
keep slides interesting so your audience won't be bored
never read slides to your audience
keep statements brief and not wordy
all of these apply when using Power Point
When you create a slide, you normally are working in:
notes view
slide sorter view
outline view
normal view
Which of the following are types of animation used in Power Point?
emphasis
exit
entrance
all of these
A sample document that already has some details in place and can be edited is called a:
template
spreadsheet
cell
slide
What does CTRL+HOME do in Word, Power Point, or Excel?
takes you to the bottom of the document where you left off
takes you to the beginning of the document
takes you to the header in the document
takes you to the footer in the document
