Study

Final Exam Review - Computer Apps

  •   0%
  •  0     0     0

  • My PowerPoint video doesn't start automatically/ What do I press to fix?
    Start> When Clicked On and switch to Automatically
  • 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)
  • How do you type inside a shape in Word?
    Just click the shape and start typing!
  • Refer to the image - how can you change the picture to square text wrapping?
    Press the icon next to the picture - Wrap Text
  • 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
  • Excel Function - what goes in the blank? Create a formula using a function to average the numbers in column B? =AVERAGE(____)
    B:B
  • 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
  • In Excel, what button would be used if you only wanted to print a part of the spreadsheet, not the whole thing?
    Print Area
  • In Excel, which button is used to HORIZONTALLY align cell contents?
    Center - C
  • How do you edit a header in Word?
    Double click in the white space at the top of the page
  • In Excel, which button is used to VERTICALLY align cell contents?
    Align Middle - B
  • In Excel, if you made the chart on the wrong sheet and need to put it on a different one, press this:
    Move Chart
  • If you need to change to a picture bullet that is not showing on the list, what do you press?
    Define New Bullet
  • 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
  • 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
  • In Windows, pressing the file folder icon at the bottom of the screen opens this:
    Windows File Explorer
  • 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
  • Review the PowerPoint Animations tab - if I wanted it to Fly In from the right, which option should I use?
    Effect Options
  • Excel Function - What function is used to add numbers in a range?
    SUM
  • 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
  • What is button H used to do?
    Show/Hide the document formatting codes, like page breaks, space, and tabs
  • Excel Formula: Divide the value in cell B6 by the value in B18. After the =, what goes first?
    B6 (will be =B6/B18)
  • The animation of my PowerPoint SmartArt is too fast. How can I make it take 2 seconds instead?
    Modify Duration
  • In Excel, how would you Autofit Column D?
    Double click the line between Column D and E
  • 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
  • In which group for the Picture Format tab, would you add ALT TEXT to PICTURES?
    Accessibility
  • These presets, shadows, etc., that can be applied to pictures are called PICTURE:
    Effects
  • 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
  • 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)
  • Which option in the Header/Footer tools shown do you choose under Page Number to add the number after the word PROPOSAL?
    Current Position
  • In Excel, which button would be used to indent the contents of a cell?
    G - Increase Indent
  • In this chart in Excel, which is the HORIZONTAL AXIS - The Client Names or the Dollar Amounts?
    Dollar Amounts
  • To add a SmartArt graphic in Word, what tab/ribbon should be used?
    Insert
  • In PowerPoint, to duplicate a slide, what do you do?
    Right click the slide in the pane, Duplicate Slide
  • If the symbol you want is not listed in Word, what should you do?
    Click More Symbols
  • In this Excel Chart, what is the name of the part at the bottom (the two things that say Project Sales...)?
    Legend
  • After highlighting a group of cells, what button do you press to smash them all into one big row?
    Merge Cells
  • In what group can you change your text wrapping to square?
    Arrange
  • What is button C used for?
    Text Effects, like adding a shadow or transform to text
  • In Word, what ribbon would you switch to if you need to change page margins?
    Layout
  • In Excel, why would you see ##### in a cell?
    The cell is not wide enough to display the numbers
  • Excel Function - What function is used to find the lowest number in a range?
    MIN
  • Excel formulas (and functions) always begin with this character.
    Equals sign =
  • In Excel, under which tab/ribbon would you be able to change Page Margins?
    Page Layout
  • Which is an absolute reference in Excel?
    $B$5
    B5
    B:B
  • Under what ribbon in Word would you find the option to set up COLUMNS?
    Layout tab
  • To add a symbol (like a dot or copyright mark) in Word, what tab/ribbon should be used?
    Insert
  • In which group on the Home tab would you find the Show/Hide command in Word?
    Paragraph
  • 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
  • I added a Wipe transition in PowerPoint, but how do I tell it to go from Top-Left?
    Effect Options
  • Look at the PowerPoint Content Placeholder - which icon should be pressed to insert a picture from file?
    Image with the computer in the corner
  • Before using Find and Replace or Spell Check, what should you always do?
    Go to the top (Control+Home)
  • What does the Windows File Explorer button look like?
    Folder
  • In PowerPoint, press the E button to do this:
    Play the Slideshow full screen
  • 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
  • In which group on the Home tab would you find the Find/Replace command in Word?
    Editing
  • In Word, when sorting a table, which option do you press if you want numbers to go in reverse order 10, 9, 8?
    Descending
  • Excel Function - What function is used to find the highest number in a range?
    MAX
  • Under which ribbon would you be able to insert a picture from a file?
    Insert ribbon
  • What button would you press to "apply the Fill:Blue, Outline:Solid text effect" to text?
    Blue A in Font Group (text effects button)
  • In PowerPoint, I clicked File>Print. How do I specify to print HANDOUTS?
    Click Full Page Slides and set to Handouts
  • 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
  • In which group for the Picture Format tab, would you COMPRESS PICTURES?
    Adjust
  • If I wanted to insert a slide with the Comparison slide layout, which button should be pressed?
    New Slide> then Comparison Layout
  • 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
  • In Excel, press which button to add a Chart Title:
    Add Chart Element (green plus)
  • 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
  • In Word, when sorting a table, which option do you press if you want numbers to go in order 1, 2, 3?
    Ascending
  • In Excel, what option can be set to a range so that all numbers over 1000 are green?
    Conditional Formatting
  • Excel Function - what goes in the blank? Create a formula using a function to average the numbers in B5 through B10? =______(B5:B10)
    AVERAGE
  • When in the File Explorer, which side of your screen contains the Navigation pane where you can select the OneDrive?
    left
  • Excel Function = Create a formula using a function that counts how many of values there are in A5 to A10?
    =COUNT(A5:A10)
  • These are examples of PICTURE __________?
    Styles
  • I need to start a new page in the middle of this document. What do I need to insert?
    Page Break
  • In PowerPoint, press the C button to do this:
    Switch to Slide Sorter view
  • 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
  • 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
  • Explain the purpose of labeled item D in Excel?
    Borders button to add borders to the sides of a cell
  • 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)
  • In Excel, what is located in the NAME BOX?
    The current cell - D4
  • 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