NEW
Font size
WorksheetsComputer Apps Exam 2019 Part I
Total questions: 60
Worksheet time: 30mins
Which of the following can you easily do in Powerpoint?
duplicate a slide
add a slide
delete a slide
all of the above
You can animate all of the following EXCEPT what in Powerpoint?
a chart
an image
a color
a text placeholder
The way each new slide appears on the screen is a:
duplication
animation
transition
none of these
The first slide you see in Powerpoint is called the:
Slide sorter slide
title slide
animation slide
main slide
Which sign represents multiplication in Excel?
/
-
+
*
Which sign represents division in Excel?
/
-
+
*
Which formula multiplies the value in cell D3 by F7 and then divides the product by the value in cell B20?
=D3/F7/B20
=D3*(F7/B20)
=(D3*F7)/B220
=F7/D3*B20
Which will work when moving a range in Excel?
highlight the column, move your mouse to the border of the range of cells and drag and drop them to the desired location
highlight the column, press CUT on the HOME ribbon, and click the desired cells and drag and drop them to the desired location
either of these will work!
neither of these will work!
To edit a cell in Excel:
Click on the formula bar and type in the desired words or numbers
go to the desired cell and press F2 to edit it
either of these will work
neither of these will work
A function formula has _________ parts.
2
3
4
5
Which formula multiplies B10 by 30?
=B10/30
=B10*30
=B10+30
=B10-30
Which function will determine the largest or highest value?
Min
Max
Sum
Total
If you were to subtract the value in cell A20 from B60, the formula would look like this:
=B60/A20
=A20-B60
=B60-A20
none of these is correct
Which formula will divide the value in cell D8 by 8?
=D8*8
=(D8)8
=D8/8
none of these
A resume should never include your:
email address
street address
name
driver's license number
Which of the following is NOT an appropriate email to use on any business document, including a resume:
lconte@ plps.org
lori.conte@plps.org
sweetiepie@plps.org
all of these are appropriate
In Excel, an example of a range would be:
B20@B45
B20?B45
=B20:B45
=B20+B45
WIth the fill handle in Excel, you can easily copy:
numbers
months
formulas
all of these
Which of the following are function formulas?
=AVERAGE
=MAXIMUM
=MINIMUM
all of these are function formulas
In Excel, the cell that you are currently in and entering data or text in is called the _________________ cell.
primary
secondary
function
active
In Word, when you change a document, you _______ it.
delete
modify or edit
remove
none of these
What is the first line of text in a flyer called?
signature line
headline
header
heading
When you type words continuously in Word without having to hit ENTER/RETURN at the end of every line, you are using:
spell check
drop and drag
fill
wordwrap
Twelve complimentary colors for text, background, and links in a document are known as ________________________in Word.
design schemes
color schemes
modification schemes
none of these
Parts of a business letter do NOT include:
inside address
headline
complimentary close
salutation
Your high school transcript and report cards are included in your resume.
TRUE
FALSE
The first slide in a Powerpoint presentation is called the:
main slide
slide sorter slide
title slide
none of these
Can you change fonts and colors in a theme when you use Powerpoint?
No, the themes are set with specific colors and won't change
Sure, change the colors you would like!
Google Slides will enable student to work collaboratively.
TRUE
FALSE
There is more than one way in Powerpoint to advance a slide.
TRUE
FALSE
You can insert videos into a Google Slides presentation, but not into Microsoft Powerpoint.
TRUE
FALSE
You can print out slides in Google Slides and Powerpoint.
TRUE
FALSE
When one slide moves off of the screen and another enters, this is known as a:
animation
transition
presentation
none of these
Google Slides and Microsoft Powerpoint have the same template designs.
TRUE
FALSE
You can animate graphics, text and pictures in both Powerpoint and Google Slides.
TRUE
FALSE
You can print out each slide individually on a page or you can print out several slides on one page in Powerpoint and Slides.
TRUE
FALSE
Microsoft Powerpoint has more features than Google Slides.
TRUE
FALSE
You cannot delete slides in slide sorter view.
TRUE
FALSE
Which of the following are part of animation in Powerpoint?
exit
entrance
emphasis
all of these are part of animation in Powerpoint
Which of the following have pre-made templates that can assist you in creating a presentation?
Google Slides
Powerpoint
both Google Slides and Powerpoint
neither Google Slides or Powerpoint
You can do the following in an Excel spreadsheet:
rotate text
insert pictures/images
change the amount of decimal places in a number
all of these can be done in Excel
How do you select cells in Microsoft Excel?
use the "point-and-click" method
type a cell reference in the "Name" box and hit enter
either use the "point-and-click" method or type a cell reference in the "Name" box
select Cell-select Cell
Which formula will add the numbers in cells A3, B3, and C3?
=sum(A3:C3)
=A3+B3+C3
both of these formulas will work
neither of these will work
Which formula will add the sums A15 through A30?
=sum(A15:A30)
=sumA15:A30
=sum(A15+A30)
none of these
Microsoft Excel, Word and Powerpoint will work together if you choose to use them together.
TRUE
FALSE
When there is an error in Excel, the program will tell you about it!
TRUE
FALSE
The "point-and-click" method lets you:
type a cell reference in the name box
click on a cell to select it
delete a cell
insert an image
Which of the following can you do in Excel, Word and Powerpoint?
rotate text
color text
underline text
all of these can be done in Excel, Word and Powerpoint
In a formula in Excel, which is performed FIRST?
the item to the left
the item to the right
the item in parentheses
the item that is last
Worksheets can be inserted into your Excel Workbook.
TRUE
FALSE
When working with image/pictures in Word, Excel and Powerpoint, you can use picture styles and artistic effects to change the picture and recolor it.
TRUE
FALSE
Which of the following are in a function formula?
the equals sign
the function name
the argument
all of these are in a function formula
You cannot edit the chart type in Excel after you have already created the chart.
TRUE
FALSE
A ____________________ shows a collection of _________________ that combine to form a workbook.
worksheet, spreadsheets
spreadsheet; worksheets
cell; columns
cell; rows
A picture representation of data is called a ______________.
worksheet
spreadsheet
image
chart
You can delete or add worksheets in an Excel workbook.
TRUE
FALSE
In Excel, what should you do to print a section of your spreadsheet?
File-Print
File-Print Area-Set Print Area and then File-Print
Hit PRTSCRN
none of these is correct
=D7:G7 is called a:
column
row
merged cell
range
To merge cells in Excel:
highlight the cells you want to merge over and select the"Merge Cells" button
you cannot merge cells in Excel spreadsheets
select File-Merge cells
none of these
Which determines the best width for a column or the best height for a row in Excel?
Merge cells
automerge
autofit
bestwidth
