WorksheetsAE_Excel and Powerpoint Essentials Review
Total questions: 50
Worksheet time: 25mins
How can you force a certain order of operations in a formula?
By using simple formulas
By using parentheses
They cannot be forced
By positioning the operations from left to right
Which of the following is NOT a way to change the column width in Excel?
Click and drag the column's boundary line to the desired width.
Double-click the column's boundary line.
Right-click the column header and then click Column Width.
Double-click the column header and then click Delete.
All of the above
3. Which keyboard shortcut underlines text in a cell?
Ctrl+X
Ctrl+I
Ctrl+U
Ctrl+B
You accidentally delete a large portion of you spreadsheet. How do you get the information back?
Press Ctrl+C
Press Ctrl+Z
Press Ctrl+V
Press Backspace
You cannot
Using the correct order of operations, what does this formula equal? =(4-2)*6/2.
=4
=6
=8
=2
Define the following operator: /
Addition
Division
Subtraction
Multiplication
What are the pieces of information that describe the appearance of a cell's content?
Active attributes
Format attributes
Edit attributes
Paste attributes
8. In the formula "=D10+15", what part of the formula is the "15"?
An operand
An operator
9. What is the argument in this function? =COUNT(B11:H14)
H14
COUNT
B11:H14
B11
Which formula is a complex formula?
=C3+10+E3
=5+A1*B1
=10-(A3-D13)
=D6/5
A cell has a very long formula that you must edit. What would be the best way to edit the formula.
Double-click on the cell and edit the formula in the cell.
Select the cell and edit the formula in the Formula Bar.
What does a theme contain?
Coordinating colors, matching backgrounds, fonts, and effects
Music and decorations
Various colors and several different styles
Masks, favors, food, and fun
What is a temporary storage for copied information called?
Tablet
Notepad
Slide notes
Clipboard
What happens when information is copied?
It duplicates to the clipboard
It is automatically duplicated
It is permanently removed
It appears on the next slide
What is an aspect ratio?
The relationship between the width and height of a slide
A precisely measured alignment
A combination of keystrokes
The size of the blank space around a slide
What is a copy of a theme with different color schemes called?
The template
The variant
The theme
The alignment
What is a bounding box?
A box that appears around an object when its selected
The first slide in a presentation
A box with dotted borders that holds a place for content
A secondary title
16:9 is an example of what?
A time
An aspect ratio
A theme
An alignment
Which button allows you to preview the presentation as the audience will see it?
Slide Sorter
Normal View
Slide Show
Notes Page
What is a box with dotted border that holds a place for content on a slide called?
A bounding box
A subtitle
A placeholder
A layout
What is a template?
A predefined set of colors, fonts, effects and layouts
A predefined slide to maintain a standard layout and look and feel
A predefined arrangement of placeholders for text, videos, pictures, charts, and more
A view that allow you to see the presentation as your audience will see it
You would like the title text for your slide to be blue. What would you change?
Paragraph Style
Font
Font Style
Font Effect
What does it mean to distribute horizontally?
The selected objects will be arranged into a neat column
The selected objects will be evenly spread out across the page
All objects on the page will be evenly spread out across the page
All of the above
Why would you zoom in when working on a publication?
You are working on a small area of the screen and want to see the details
You are arranging objects on the page and need to see the entire page
How do you delete a single element from the publication?
Right-click and select Delete Object
Double click and type the word DELETE
Press CTRL-A and then the Delete key
Why would you use the group feature to combine shapes?
To keep them together as they are moved
So they can be copied and pasted together
To make it easier to work with complex diagrams
All of the above
None of the above
How can page guides help you design a publication?
They can help get everything lined up on the page
They are used to combine multiple shapes into a single object
They can be used to rotate text boxes
They can be used to make clip art larger or smaller
What application is Publisher most similar to?
Microsoft Access
Microsoft Excel
Microsoft Word
What is WordArt?
Another term for Clip Art
Text with special effects
Text imported from Microsoft Word
Another term for Text Box
What kind of documents does Publisher handle best?
Balance Sheet
Term Paper
Newsletter
Customer List
Which function would you enter to return the number 45.1?
=MAX(A2:B5)
=SUM(A2:B5)
=MIN(A2:B5)
=AVERAGE(A2:B5)
32. Which letter on the image is a Column?
A
B
C
D
What Clear command would you use to make cell A2 look like cell B3?
Clear All
Clear Format
Clear Content
Which command would you use, if you wanted to move row 6 in between row 3 and 4, without overwriting any data.
Insert copied cells
Insert
Paste
Merge
What is the best formula for finding the total value for cells B2 through B5?
=B2+B3+B4+B5
=SUM(B2:B5)
=B1++B5
=13.5+6.08+7.53+45.1
In the image, what do the yellow handles do?
Adjust the length of the shape, but not the width
Resize the shape without distortion
Resize the shape with distortion
Adjust visual features of the shape
Where would you click and drag to resize the image without distorting it?
A
B
C
You want to change the layout on an existing slide. Where would you click?
A
B
C
D
Which of the following is a Title and Content slide?
A
B
C
D
You would like to insert a new slide with a specific layout. Where would you click?
A
B
C
D
Which of the following is a Comparison slide?
A
B
C
D
What would you click and drag to rotate the clip art?
A
B
C
D
What would you click to add an image to the page?
A
B
C
D
What is the highlighted portion of the screen called?
Print Preview
Document Area
Page Navigation
Home Ribbon Tab
The purple rectangle is selected. What would you click to show the animal clip art over the purple rectangle?
Send Forward
Wrap Text
Send Backwards
Align
What would you click to add a block of text to the page?
A
B
C
D
What is the arrow pointing to?
Sizing Handle
Word Art
Page Boundary
Guideline
What would you click and drag to move the clip art to a different part of the page?
A
B
C
D
What are the light green grid lines, indicated by the red arrow, called?
Boundaries
Guides
Objects
Margins
What tab group would you use to change the format of cell A2 to match cell A3?
Alignment
Cells
Number
Font E. Styles
