Level 2 Lesson 11

Created by Bradley Conrad

Which of the following groups would you use to create a list of key terms or information and their location in the document?
b. Group E

1/23

TermDefinition
Which of the following groups would you use to create a list of key terms or information and their location in the document?
b. Group E
Which of the following options is represented in the outlined section of the image below?
b. A footer
Which feature is used to customize how objects enter and exit when a slide is displayed or the mouse is clicked?
d. Animations
Which feature is used to control the way in which each slide is replaced by the next during a presentation?
b. Transitions
Draw a line to match the worksheet element name to its description on the right
Sheet Tabs = Used to select and switch between worksheets in a workbook Insert Function = Used to find and enter a built-in formula Formula Bar = Used to view, enter, and edit data and equations in the active cell Name Box = Indicates the selected cell reference or name Column Headings = Appear across the top of the worksheet and are identified by letters Row Headings = Appear down the left side of the worksheet and are identified by numbers
Draw a line to match the symbol used in a formula to its function on the right
/ = Performs division * = Performs multiplication = - Indicates a formula + = Performs addition : = Indicates a range of cells - = Performs subtraction
Place the mathematical operations in the order the operations are performed in spreadsheet calculations.
_Parentheses_________ Multiplication and division ____Negation_______ Negation __Exponents_________ Addition and subtraction ___Multiplication and division________ Parentheses __Addition and subtraction_________ Exponents
You are working in an Excel workbook that contains multiple worksheets. Which one of the following options is used to switch between worksheets in the workbook?
c. Option 3
Basic image editing includes all of the following EXCEPT _______________________
a. splicing or joining
Draw a line to match each video editing term to its description
Trim = Cut off the beginning and/or ending of a video Split = Cut a video clip into two or more segments Crop = Remove unwanted portions of a video frame Splice = Join two or more video segments together
Draw a line to match the keyboard button to its function on the right
Caps lock = When enabled, all letters are typed in UPPERCASE. May be toggled on and off F1-F12 = Shortcuts used to perform certain functions, such as refreshing a page Fn = Used in combination with other keys to perform the secondary function of the key Esc = Used to cancel, close, or abort an operation Tab = Moves the cursor a fixed distance to the right, usually five spaces, each time it is pressed Shift = A modifier key used with a key to type an uppercase letter or insert a symbol
Draw a line to match the keyboard key to its function on the right.
End = Moves the insertion point to the end of the document, line, web page, or cell Delete = Removes the character to the right of the cursor or insertion point Backspace = Removes the character to the left of the cursor or insertion point Home = Moves the insertion point to the beginning of a document, line, web page, or cell Print Screen = Sends an image of the current screen to the clipboard. May be abbreviated, such as PRTSC or Prt Scrn
In the image below, which option is used to access the Track Changes command?
c. Option 3
Which of the following statements is NOT true about Track Changes?
b. Each change must be reviewed and accepted or rejected individually
Draw a line to match the keyboard shortcut to its function on the right
CTRL (CMD) + V = Pastes the contents of the clipboard CTRL (CMD) + X = Removes (or cuts) the selected text or item and moves it to the clipboard CTRL (CMD) + P = Prints the current document or page CTRL (CMD) + A = Selects everything in the document, folder, or page CTRL (CMD) + N = Opens a new document or window CTRL (CMD) + C = Copies the selected text or item to the clipboard CTRL (CMD) + Z = Reverses the last action performed (Undo)
Using the image below as reference, which option represents the correct path to the Auto Policy JULY-DEC 2021 file?
d. Documents\Insurance\Auto\StateFarm_2021\Auto Policy JULY-DEC 2021. pdf
Which two of the following statements are true about compressing files?
b. Multiple files can be compressed into one file to reduce file size and download time c. Most operating systems include a built-in utility to compress and de-compress files
Which two of the following options are examples of a local storage location?
c. A USB drive connected to your laptop e. C:\Documents\Projects\2021\ABC
Which of the following statements is true about read-write files?
a. Read-write files can be viewed and modified by anyone with access to the file
Using the image below as reference, which of the following options is used to access the command to encrypt a document with a password?
a. Option 1
The process of saving and storing multiple renditions of a file so it can be restored to a previous state is called ________________________.
a. file versioning
Which two design elements should you use to create a unified look in your document?
c. Templates d. Themes
Draw a line to match the file extension to its description on the right
.jpg = An image file format that supports lossless compression, transparency, and a full spectrum of colors .gif = An image file format that supports lossless compression, animation, and transparency .png = An image format that supports lossy compression and a full spectrum of colors; No transparency or animation .txt = A text file that includes only plain text. It does not support formatting, images, or tables .pdf = A file format that preserves document formatting; viewable on any operating system