Toggle Navigation
Games
Blog
Class PIN
Join for Free
Sign in
Toggle Navigation
Games
PIN
Join for Free
Blog
Pricing
Contact us
Help center
Sign in
Study
Final Exam Review - Computer Apps
0
%
0
0
0
Back
Restart
My PowerPoint video doesn't start automatically/ What do I press to fix?
Start> When Clicked On and switch to Automatically
Oops!
Okay!
What button would be pressed to add a 3-pt border to a shape from Orange, Accent 2?
Shape Outline (and find the theme color then go to WEIGHT for size)
Oops!
Okay!
How do you type inside a shape in Word?
Just click the shape and start typing!
Oops!
Okay!
Refer to the image - how can you change the picture to square text wrapping?
Press the icon next to the picture - Wrap Text
Oops!
Okay!
In Excel, which option is used if your long words in A1 that you don't want going into Column B need to stay inside A1?
Wrap Text
Oops!
Okay!
Excel Function - what goes in the blank? Create a formula using a function to average the numbers in column B? =AVERAGE(____)
B:B
Oops!
Okay!
In a Word table, to resize a column, do you drag from the left or right side of the column cell to resize it?
right
Oops!
Okay!
In Excel, what button would be used if you only wanted to print a part of the spreadsheet, not the whole thing?
Print Area
Oops!
Okay!
In Excel, which button is used to HORIZONTALLY align cell contents?
Center - C
Oops!
Okay!
How do you edit a header in Word?
Double click in the white space at the top of the page
Oops!
Okay!
In Excel, which button is used to VERTICALLY align cell contents?
Align Middle - B
Oops!
Okay!
In Excel, if you made the chart on the wrong sheet and need to put it on a different one, press this:
Move Chart
Oops!
Okay!
If you need to change to a picture bullet that is not showing on the list, what do you press?
Define New Bullet
Oops!
Okay!
I'm trying to add the "intense quote style" to my paragraph but I don't see it. What do I do?
Press the down arrow in Styles for more
Oops!
Okay!
In Excel, if trying to change the cell Fill color to Blue, Accent 1, Lighter 60%, what happens next (see picture)?
Go down in that column to one of the lighter options to find it
Oops!
Okay!
In Windows, pressing the file folder icon at the bottom of the screen opens this:
Windows File Explorer
Oops!
Okay!
I just clicked the heading and then the Format Painter but now I want Analyze to match. What's the next step?
Paint over the word Analyze
Oops!
Okay!
Review the PowerPoint Animations tab - if I wanted it to Fly In from the right, which option should I use?
Effect Options
Oops!
Okay!
Excel Function - What function is used to add numbers in a range?
SUM
Oops!
Okay!
Which Microsoft Office tool is used to copy the format of text from one pretty text to an ugly one by dragging over it?
Format Painter
Oops!
Okay!
What is button H used to do?
Show/Hide the document formatting codes, like page breaks, space, and tabs
Oops!
Okay!
Excel Formula: Divide the value in cell B6 by the value in B18. After the =, what goes first?
B6 (will be =B6/B18)
Oops!
Okay!
The animation of my PowerPoint SmartArt is too fast. How can I make it take 2 seconds instead?
Modify Duration
Oops!
Okay!
In Excel, how would you Autofit Column D?
Double click the line between Column D and E
Oops!
Okay!
In Excel, if you wanted to insert a new column to the LEFT of Column F, right click and insert when clicked ON WHICH COLUMN - E or F?
F
Oops!
Okay!
In which group for the Picture Format tab, would you add ALT TEXT to PICTURES?
Accessibility
Oops!
Okay!
These presets, shadows, etc., that can be applied to pictures are called PICTURE:
Effects
Oops!
Okay!
In Excel, if you wanted to insert a new page after row 18, click row 19 and then press which button?
Breaks> Insert Page Break
Oops!
Okay!
In Word, what does the LINE SPACING button look like, to make a paragraph double spaced?
Lines with up and down arrow (left of paint bucket)
Oops!
Okay!
Which option in the Header/Footer tools shown do you choose under Page Number to add the number after the word PROPOSAL?
Current Position
Oops!
Okay!
In Excel, which button would be used to indent the contents of a cell?
G - Increase Indent
Oops!
Okay!
In this chart in Excel, which is the HORIZONTAL AXIS - The Client Names or the Dollar Amounts?
Dollar Amounts
Oops!
Okay!
To add a SmartArt graphic in Word, what tab/ribbon should be used?
Insert
Oops!
Okay!
In PowerPoint, to duplicate a slide, what do you do?
Right click the slide in the pane, Duplicate Slide
Oops!
Okay!
If the symbol you want is not listed in Word, what should you do?
Click More Symbols
Oops!
Okay!
In this Excel Chart, what is the name of the part at the bottom (the two things that say Project Sales...)?
Legend
Oops!
Okay!
After highlighting a group of cells, what button do you press to smash them all into one big row?
Merge Cells
Oops!
Okay!
In what group can you change your text wrapping to square?
Arrange
Oops!
Okay!
What is button C used for?
Text Effects, like adding a shadow or transform to text
Oops!
Okay!
In Word, what ribbon would you switch to if you need to change page margins?
Layout
Oops!
Okay!
In Excel, why would you see ##### in a cell?
The cell is not wide enough to display the numbers
Oops!
Okay!
Excel Function - What function is used to find the lowest number in a range?
MIN
Oops!
Okay!
Excel formulas (and functions) always begin with this character.
Equals sign =
Oops!
Okay!
In Excel, under which tab/ribbon would you be able to change Page Margins?
Page Layout
Oops!
Okay!
Which is an absolute reference in Excel?
$B$5
B5
B:B
Oops!
Okay!
Under what ribbon in Word would you find the option to set up COLUMNS?
Layout tab
Oops!
Okay!
To add a symbol (like a dot or copyright mark) in Word, what tab/ribbon should be used?
Insert
Oops!
Okay!
In which group on the Home tab would you find the Show/Hide command in Word?
Paragraph
Oops!
Okay!
In Excel, which choice is accurate for the following - use relative cell references to subtract cell B6 from B5.
=$B$6-$B$5
=SUBTRACT(B5-B6)
=B6-B5
=B5-B6
Oops!
Okay!
I added a Wipe transition in PowerPoint, but how do I tell it to go from Top-Left?
Effect Options
Oops!
Okay!
Look at the PowerPoint Content Placeholder - which icon should be pressed to insert a picture from file?
Image with the computer in the corner
Oops!
Okay!
Before using Find and Replace or Spell Check, what should you always do?
Go to the top (Control+Home)
Oops!
Okay!
What does the Windows File Explorer button look like?
Folder
Oops!
Okay!
In PowerPoint, press the E button to do this:
Play the Slideshow full screen
Oops!
Okay!
Excel IF Function - review the box - what goes in the logical test for this problem? Return a value of yes if E4 is 10 or more and no if not.
E4>=10
Oops!
Okay!
In which group on the Home tab would you find the Find/Replace command in Word?
Editing
Oops!
Okay!
In Word, when sorting a table, which option do you press if you want numbers to go in reverse order 10, 9, 8?
Descending
Oops!
Okay!
Excel Function - What function is used to find the highest number in a range?
MAX
Oops!
Okay!
Under which ribbon would you be able to insert a picture from a file?
Insert ribbon
Oops!
Okay!
What button would you press to "apply the Fill:Blue, Outline:Solid text effect" to text?
Blue A in Font Group (text effects button)
Oops!
Okay!
In PowerPoint, I clicked File>Print. How do I specify to print HANDOUTS?
Click Full Page Slides and set to Handouts
Oops!
Okay!
When adding a footer in PowerPoint, I created the line but I don't want it to show on the first slide. What do I do?
Check "Don't show on title slide" in the dialog box
Oops!
Okay!
In which group for the Picture Format tab, would you COMPRESS PICTURES?
Adjust
Oops!
Okay!
If I wanted to insert a slide with the Comparison slide layout, which button should be pressed?
New Slide> then Comparison Layout
Oops!
Okay!
If creating a Combo chart in Excel, which button will be pressed on the Insert tab? Describe the button.
Combination Chart - looks like a dotted line over columns
Oops!
Okay!
In Excel, press which button to add a Chart Title:
Add Chart Element (green plus)
Oops!
Okay!
The animation of my PowerPoint SmartArt looks funny because the shapes all fly in one by one. How can I modify it so it's all at once?
Effect Options
Oops!
Okay!
In Word, when sorting a table, which option do you press if you want numbers to go in order 1, 2, 3?
Ascending
Oops!
Okay!
In Excel, what option can be set to a range so that all numbers over 1000 are green?
Conditional Formatting
Oops!
Okay!
Excel Function - what goes in the blank? Create a formula using a function to average the numbers in B5 through B10? =______(B5:B10)
AVERAGE
Oops!
Okay!
When in the File Explorer, which side of your screen contains the Navigation pane where you can select the OneDrive?
left
Oops!
Okay!
Excel Function = Create a formula using a function that counts how many of values there are in A5 to A10?
=COUNT(A5:A10)
Oops!
Okay!
These are examples of PICTURE __________?
Styles
Oops!
Okay!
I need to start a new page in the middle of this document. What do I need to insert?
Page Break
Oops!
Okay!
In PowerPoint, press the C button to do this:
Switch to Slide Sorter view
Oops!
Okay!
You accidentally merged the wrong two cells in your Word table! What table command can you use to put them back to 2?
Split Cells
Oops!
Okay!
In a Word table, you have a blue row at the top and your table goes on two pages. What button can you press so that row shows on both pages?
Repeat Header Rows
Oops!
Okay!
Explain the purpose of labeled item D in Excel?
Borders button to add borders to the sides of a cell
Oops!
Okay!
In Excel, I'm changing the color of a font but none of these blues are just plain BLUE? Where would that be?
Below Theme colors are Standard Colors (with no accents)
Oops!
Okay!
In Excel, what is located in the NAME BOX?
The current cell - D4
Oops!
Okay!
In Excel, if you want to set Long Date number style, where do you press?
Down arrow to right of General for the list to pick
Oops!
Okay!
Your experience on this site will be improved by allowing cookies.
Allow cookies