Font size
WorksheetsReview for 9wks Test
Total questions: 35
Worksheet time: 18mins
To add a citation, after clicking on the References Ribbon which of the following should be done?
Create a Table of Authorities.
Create a Table of Figures.
Click the Insert Citation button.
Click the Insert Caption button.
To enter a date using a pop-up calendar, which of the following kinds of content control should be used?
A plain text content control
A combo box content control
A date picker content control
A building block content control
To prevent people from editing a document. One should do which of the following?
Enable document editing restrictions
Enable document formatting restrictions
Modify the document properties
Disable macros
What is the first step when inserting a caption on a photograph?
Click References
Enter Caption
Change Position
Select image
To record a macro, what Ribbon/s must be visible?
View
Design
Home
Developer
Which step is right before selecting a special character under the Special button?
Select Replace
Select Home
Select More
Type in a special character to find.
What should you click on after selecting the Home ribbon to replace a special character?
Click on More >>
Click on Replace in the Editing group
Click Replace All
Type in a hyphen in the 'Find what:' field
What is the first step in replacing a hyphen with an Em Dash in an entire document?
Click on Replace in the Editing group
Select Home ribbon
Type in a hyphen in the 'Find what:' field
Click Replace All
What is the final step in replacing a special character?
Click on More >>
Click Replace All
Select the special character under the Special button
Type in a character in the 'Find what:' field
To make a row in Excel to be exactly 1.5 inches tall. You should do which of the following?
Select the row, then enter the desired width in the Width text box.
Select the row, then enter the desired height in the Height text box.
Drag the row border to adjust the width.
Drag the row border to adjust the height.
When retaining the original appearance of a chart while copying it to another document you would select...
Keep Text Only
Merge formatting
Keep Source Formatting & Embed Workbook
Use Destination Theme & Embed Workbook
To edit a content control, which of the following should be done?
Modify the content control properties.
Modify the content control style.
Modify the content control paragraph alignment.
Modify the content control indent.
An Excel _____ allows data to be summarized and charted easily.
worksheet
workflow
document
presentation
Which of the following happens when you enter the formula =G15 into a cell?
Excel recalculates all formulas in the worksheet.
Excel assigns the sum of the values in the previous 15 cells to the active cell.
Excel assigns the value in cell G15 to the active cell.
Nothing; =G15 is an invalid formula.
When using the fill handle, which would create the following output: Qtr4, Qtr1, and Qtr2?
Quarter 1
Qtr1
Qtr3
Quarter 4
Which feature in Microsoft Word allows you to apply a consistent look and feel to headings and text throughout a document?
Quick Parts
Themes
Styles
Watermarks
When using the Mail Merge feature in Microsoft Word, what is the purpose of the main document?
It stores the recipient data for merging
It contains the template with merge fields for personalization
It generates individual documents but does not store data
It automatically sends emails to recipients
Which of the following options allows you to accept all changes at once in a document where Track Changes is enabled?
Click “Review” > “Track Changes” > “Enable All”
Click “Review” > “Accept” > “Accept All Changes”
Click “File” > “Options” > “Enable Editing”
Click “Home” > “Editing” > “Review All”
What is the main purpose of the MAX function?
To track the worst selling items
To analyze sales
To see which items are selling the most
To calculate monthly expenses
What software should be installed to track sales of different types of products?
Microsoft Word
Microsoft PowerPoint
Microsoft Excel
Microsoft Access
When analyzing sales, what is the main purpose of the MIN function?
The product with the least amount of sales
The most and least popular types of products
The number of employees needed
The best marketing strategy
Which function in Excel is used to calculate the average of a set of numbers?
SUM
AVERAGE
MAX
COUNT
In Microsoft Word, which feature allows you to automatically create a table of contents?
Index
References
Table of Contents
Footnotes
Which feature in Microsoft Word allows you to compare two versions of a document?
Track Changes
Document Inspector
Version History
Compare Documents
In Excel, which function would you use to count the number of cells that contain numbers?
COUNTBLANK
COUNT
COUNTIF
COUNTA
What is the purpose of the 'Protect Workbook' feature in Excel?
To track changes made to the workbook
To automatically save the workbook at regular intervals
To prevent unauthorized access to the workbook
To ensure data is not accidentally modified
Which Excel function would you use to find the smallest number in a range?
AVERAGE
MAX
SUM
MIN
Which Excel feature allows you to quickly apply a set of formatting choices to a range of cells?
Data Validation
Cell Styles
Conditional Formatting
Format Painter
In Microsoft Word, what is the purpose of the 'Track Changes' feature?
To highlight changes made to the document
To automatically save document versions
To compare two documents
To protect the document from editing
Which function in Excel would you use to add up a range of numbers?
SUM
ADD
TOTAL
PLUS
In Microsoft Word, which tool would you use to check the spelling and grammar of a document?
Word Count
Track Changes
Thesaurus
Spelling & Grammar
What is the purpose of the 'Freeze Panes' feature in Excel?
To merge multiple cells into one
To hide specific rows or columns
To apply a filter to a range of cells
To lock specific rows or columns in place
