WorksheetsMicrosoft Office Semester Review
Total questions: 50
Worksheet time: 25mins
A students wants to insert a column sparkline in Excel. To do this, she can click on the cell she wants to insert a Sparkline, then click Insert tab, select the Sparkline type of choice from the Sparklines group and then select OK.
true
false
What should you add to describe the data in a chart?
A legend
A title
A chart style
An animation
To quickly change the shading, borders, and font colors of a table, which of the following should be done?
Apply a Table Style.
Apply Theme Effects.
Apply Text Effects.
Insert a Watermark.
Kyle needs the same text to appear at the top of each page in a document. Which of the following is the best method to achieve this?
Edit the document header.
Manually enter the desired text at the top of each page.
Modify the Document Properties.
Add a comment at the top of each page.
If you want to change the color of the border around a shape, which of the following do you change?
Outline
Fill
Texture
Color
To start entering text on a new page, do which of the following?
Insert a page break.
Insert a line break.
Insert a continuous section break.
Insert a column break.
Which of the following Print settings prints each slide at the top of the paper with blank lines below the slide?
Full Page Slides
Notes Pages
Outline
Handouts
Which of the following functions would you use to calculate the arithmetic mean of a price list?
MAX
COUNT
SUM
AVERAGE
The spell checker flags your company's name as a misspelling. Which of the following will stop the spell checker from flagging later occurrences in the document?
Change All
Change
Ignore Once
Ignore All
Which preset text effect do you apply when you want the text to have a border color?
Outline
Shadow
Reflection
Glow
Where can you see a preview of how your worksheet will look when printed, including headers?
Print tab in Backstage view
Page Break preview
Normal view
File preview
Imani needs to duplicate a picture in her document. She should do which of the following?
Copy and paste the picture.
Rotate the picture.
Change the picture.
Reset the picture.
Jeremiah has inserted a table and needs to fill it with data. After entering a value, he should do which of the following to advance the curser to the next cell in the table?
Press TAB.
Press ENTER.
Press ESC.
Press INSERT.
Joanne needs each page in her document to be numbered. She should do which of the following?
Manually enter the page number at the bottom of each page.
Use the Insert Footnote button.
Use the Cross-reference button.
Use the Page Number button.
Which of the following layouts is best for the slide that contains the title of the presentation?
Title and Content
Title Slide
Text and Content
Blank
To calculate the number of words in a document, do which of the following?
Click the Word Count button.
Click the Thesaurus button.
Click the Translate button.
Click the Check Accessibility button.
To copy a cell's formatting to another cell, which of the following can you use?
Format Cells dialog box
Format Painter
Quick Analysis Tool
Format as Table
Which of the following should you select as X in the following series of clicks to change the chart type to a clustered column chart: Chart > Chart Tools > Design tab > Type group > Change Chart Type > All Charts > X > Clustered Column > OK?
Pie
Bar
Line
Column
Alyssa needs a paragraph to have a dotted border. She should do which of the following?
Insert appropriate SmartArt.
Insert a table.
Apply a paragraph border and change the line style of the border.
Insert appropriate WordArt.
To change the shading of a cell in a table, which of the following should be done first?
Select the table.
Select the desired column.
Select the desired row.
Select the desired cell.
When you drag a photo on a slide, what appears to help you position it?
Gridlines
Smart Guides
Arrows
Rulers
Which of the following commands found on the Align menu evenly space objects horizontally or vertically relative to each other or the slide?
Distribute
Arrange
Space
Align
To align currency symbols and decimal points in a column of numbers, you can apply the ____ number format.
Currency
Accounting
Percentage
General
To correct an error in a comment, do which of the following?
Resolve the comment.
Delete the comment.
Reply to the comment.
Edit the comment.
To select nonadjacent cells or ranges on a worksheet, you can press and hold _____ while selecting each one.
CTRL
ALT
SHIFT
ESC
To indent the first line of every paragraph in a document, do which of the following?
Create a right tab stop.
Create a left tab stop.
Create a hanging indent.
Create a first line indent.
If you want to show data organized into rows and columns, which of the following objects is a good choice?
Table
SmartArt
Chart
Grid
Aamir is preparing a research paper. He needs to insert a parenthetical reference that gives credit to the source
of a quotation. What is the best way for him to achieve this?
Enter the parenthetical reference manually.
Insert a footnote with the source information.
Insert an endnote with the source information.
Insert a citation.
If you want to add a note to a slide to remind you to mention a fact that is related to the slide, where do you place the note?
Reading pane
Normal pane
Notes pane
Thumbnails pane
What feature inserts a function that totals the cells above or to the left of the selected cell?
AutoSum button
absolute reference
reference operator
mode indicator
Which of the following views does not let you change the order of slides in a presentation?
Normal
Outline
Slide Show
Slide Sorter
To see a thumbnail list of pages in a document, do which of the following?
Click the Arrange All button.
Click the Side to Side button.
Open the Navigation pane and select Headings.
Open the Navigation pane and select Pages.
When you select a cell range, the cells must be adjacent to each other.
true
false
If you don't like the speed of a transition that you applied, you cannot change it.
true
false
When you recolor a picture, you use the Paintbrush tool to add color to parts of the picture.
true
false
To quickly change the colors, fonts, and effects in a document, change the document style.
true
false
You cannot change a shape to a different shape.
true
false
Press ALT+P to print a document.
true
false
A citation is a parenthetical reference in the document text that gives credit to the source for a quotation or other information used in a document.
true
false
If you want to move a sentence from one paragraph to another paragraph, you can use the Copy and Paste commands.
true
false
To provide emphasis to text, you can apply bold.
true
false
To add a shadow to a shape, apply a shape outline.
true
false
When you enter a value in a worksheet cell, it is automatically left-aligned.
true
false
Alan is working on a draft document. He wants the document to have more white space. He can do this by changing the line spacing.
true
false
To change the color of a shape, you change the shape fill.
true
false
Decreasing a cell's indent moves its contents to the right one space.
true
false
Raj needs to rearrange the slides in his presentation. Which of the following views would be the best one to use?
Reading
Notes Page
Slide Show
Slide Sorter
Laila needs to change the formatting of a table. To do so, which of the following does she need to do first?
Select a row in the table.
Select the table.
Select a column in the table.
Where can you see a brief description of a selected function?
Formula bar
Insert Function dialog box
Insert dialog box
Insert tab
If you need to present numerical data on a slide, which of the following can you insert to show the data as a graphic?
Table
SmartArt
Chart
Grid
