Font size
WorksheetsKey Applications
Total questions: 52
Worksheet time: 26mins
You are going to import spreadsheet data from one application to another. A user input form is an example of data that would work best for which format?
.BAK
.CSV
.DOCX
.TXT
Test scores, student IDs, course listings, and table names are all examples of what?
Integers
Data
Metadata
Strings
In which kind of database table is it required that columns each have a unique attribute name?
Spreadsheet
Flat File Database
Relational Database Table
NoSQL Database
In which kind of database table is it required that columns each have a unique attribute name?
Spreadsheet
Flat File Database
Relational Database Table
NoSQL Database
Searching for specific data, categorizing data, and sorting data are examples of what?
Raw data
Macros
Metadata
Best practices
Identify the correct sequence for uninstalling an app from your Android mobile device.
A. Go to Device Settings and select Apps
B. Tap to open options
C. Confirm uninstall
D. Find the App in your list of installed Apps
E. Select Uninstall at the top of the page
A, B, C, D, E
A, D, B, E, C
E, D, C, B, A
B, E, C, A, D
Which application would you typically use to create videos from recorded presentations?
Microsoft PowerPoint
Microsoft Excel
Microsoft Access
Microsoft OneNote
Google Chrome
Which application would you typically use to Perform mathematical calculations?
Microsoft PowerPoint
Microsoft Excel
Microsoft Access
Microsoft OneNote
Google Chrome
Which application would you typically use to use Database Management System that uses a graphical user interface
Microsoft PowerPoint
Microsoft Excel
Microsoft Access
Microsoft OneNote
Google Chrome
Which application would you typically use to search the internet for images and videos?
Microsoft PowerPoint
Microsoft Excel
Microsoft Access
Microsoft OneNote
Google Chrome
Which application would you typically used for taking notes, gathering images, and screen clippings?
Microsoft PowerPoint
Microsoft Excel
Microsoft Access
Microsoft OneNote
Google Chrome
How can you restore an app that was deleted from your device?
Restore it from the trash
Purchase it again from the app store
Select Undo from the App Settings menue
Download it again from the App store
Which of the following apps is best equipped for editing raster graphics?
Microsoft Excel
Notepad++
Adobe Photoshop
Microsoft Word
Choose the options that sequences the steps for downloading an image from the internet and inserting it into an excel document.
A. Save the image
B. Double-click the saved image file
C. Browse to the saved image
D. Click insert Picture under the Insert tab
E. Place cursor in Excel
A, B, C, D, E
E, D, C, B, A,
A, E, D, C, B
D, C, B, A, E
You want to use the spelling and grammar tool to fix any misspelled words in a document. What do you do first?
Click the Review tab in the Ribbon
Once the check is complete, a window will display saying that you are finished. Click OK.
Ensure that the correct spelling is highlighted and click Change
In the Review ribbon menu, click Spelling & Grammar
You want to use the spelling and grammar tool to fix any misspelled words in a document. What do you do Second?
Click the Review tab in the Ribbon
Once the check is complete, a window will display saying that you are finished. Click OK.
Ensure that the correct spelling is highlighted and click Change
In the Review ribbon menu, click Spelling & Grammar
You want to use the spelling and grammar tool to fix any misspelled words in a document. What do you do Third?
Click the Review tab in the Ribbon
Once the check is complete, a window will display saying that you are finished. Click OK.
Ensure that the correct spelling is highlighted and click Change
In the Review ribbon menu, click Spelling & Grammar
You want to use the spelling and grammar tool to fix any misspelled words in a document. What do you do Last?
Click the Review tab in the Ribbon
Once the check is complete, a window will display saying that you are finished. Click OK.
Ensure that the correct spelling is highlighted and click Change
In the Review ribbon menu, click Spelling & Grammar
Where can you go to format the style of A2:D2 with Accent 1?
In the View tab, Workbook Views, select Custom Views
In the Home tab Styles group, select Cell Styles
True or False: After receiving some feedback, you decide to replace all Bold formatting with italic formatting. This can be done with the Find and Replace tool.
TRUE
FALSE
You want to quickly move some text to a different place in your document. Using only keyboard shortcuts, how would you cut the text June 24, 2015 and paste it somewhere else in your document?
Highlight the text June 24, 2015, press ctrl+x, click where you want to place the cut text, and press ctrl+p
Highlight the text June 24, 2015, press ctrl+c, click where you want to place the cut text, and press ctrl+v
Highlight the text June 24, 2015, press ctrl+x, click where you want to place the cut text, and press ctrl+v
Highlight the text June 24, 2015, press ctrl+c, click where you want to place the cut text, and press ctrl+p
You want to easily read the open document. For best results, change the document to ----------.
Read Mode
Print Layout
Kindle Mode
View Only
When inserting an image named "StickyNote.jpg" into a document, what would you do first?
In the insert tab, Illustrations group, select Pictures
Select the image named StickyNote.jpg
Select Insert
When inserting an image named "StickyNote.jpg" into a document, what would you do Second?
In the insert tab, Illustrations group, select Pictures
Select the image named StickyNote.jpg
Select Insert
When inserting an image named "StickyNote.jpg" into a document, what would you do Third?
In the insert tab, Illustrations group, select Pictures
Select the image named StickyNote.jpg
Select Insert
What tool would you use to arrange the data in a table from Z to A (descending)
Format & Sort
Arrange (Descending)
Sort & Filter
Find and Select
What method can you use to swap the positions of slide 2 and 3 in the presentation?
Arrange
Drag and Drop
Sort and Filter
Switch Windows
True or false: To simplify your workflow, you decide to change some properties of the Normal style. You can modify the Normal style by changing the font to Arial and the font size to 14.
TRUE
FALSE
How can you change the row height for a cell range? Choose two
Right click on the selected cell range
Change the Size in the Page setup group
Change cell size in the View tab
Use the Format menu an the Cells group
If you set your presentation to Presented by a Speaker (Full screen), your presentation slides will advance in what way?
Manually
Automatically
On a timer
True or False: You've finished making changes to your workbook and want it to be read only. To do so, you would click File >Info> Protect Workbook > Encrypt with Password
TRUE
FALSE
What is the first step of restricting the editing of a document so that formatting is limited to a selection of styles?
Check the box under 1. Formatting restrictions
In the drop-down, click Restrict Editing.
Click yes, Start Enforcing Protection
Click File, go to the Info section, and click Protect Document
In the start Enforcing Protection window that appears, leave all the defaults and Click OK
What are two ways you can undo a change you just made? Choose two
ctrl+u
The scissors in the Clipboard section of the Home tab
ctrl+z
The curved arrow in the Quick Access Toolbar
True or False: You would like to print a double-sided document, but there is no way to set that up in Microsoft Word. Your only option is to print one side, reload the paper, and then print the other side.
TRUE
FALSE
Which of the following statements are accurate regarding PowerPoint? Choose two
You can only use one theme in your presentation
When choosing a slide layout, placeholder containers will appear as dotted lines and content can be added later
When you edit the slide master, all slides based on that master will receive those changes
You can't modify the built-in slide layouts that PowerPoint provides
Which of the statements below is true
When you change the screen resolution, it affects all users who log on to the computer
Having fewer items on the screen at a larger size generally means there is a high screen resolution.
Which of the following accurately describes the Microsoft Word Track Changes feature
It alerts you if the document is opened on an unfamiliar computer
It allows you to make edits to the Quick Access toolbar
It changes the editing restrictions to Read Only
The track Changes feature keeps a record of changes, edits, and comments you make while reviewing a document.
You need to send your Microsoft Word document ot a client for approval, but you don't want them to have the ability to make any edits to the document. Which of the following options will allow them to access the document without being able to edit it?
Password protect the document
A user cannot view a document without having permission to edit the document
Change the editing restrictions to Track Changes
Change the editing restrictions to Read Only
True or False: In Microsoft Office applications, adding a word to the Dictonary will prevent the Spell Checker from flagging the word.
True
False
Select the options that are TRUE>
A pie chart is a visual way to display groups of data in a project document.
You can create a pie chart in Excel but not in Word
You can create 2D or 3D pie charts
Which of the following cannot be added as a slide background in a PowerPoint presentation?
Image
Video
Gradient
Solid Color
Select the options that are correct
You cannot delete automatic page breaks in Word
You can see all the Page Breaks in a document by viewing the non-printing characters
A section break is the same thing as a Page Break
Which of the following statements are accurate regarding adding and removing rows/columns in Excel? Choose two
You can hide an entire column without deleting it
When you delete a row, any data contained in that row will be added to existing rows below
Clearing a row's contents deletes data inside the row but not the row itself.
A newly inserted column appears to the right of the selected column.
Which of the following is a benefit of installing VLC media player to use in PowerPoint?
VLC media player supports video and audio formats that PowerPoint doesn't.
VLC media player allows you to save your presentation in a smaller file size.
VLC media player backs up a save file of your presentation so you don't accidentally lose it.
VLC media player automatically scans your presentation for viruses.
Select the correct responses
The effect option allows you to fine-tune an animation
You can only have one animation per object
You can specify triggers that tell each animation when to start
You have decided to change the overall appearance of your document. Which of these would you change to affect the whole document at once?
Theme
Properties
What are two ways you can adjust column width? Choose two
Use the Format menu in the cells group
Change the cell size in the View tab
Change the text alignment of the column
Right click the cell range
Which of these options is not a Timing setting you can add to a slide transition?
Effects
Sound
Duration
On Mouse Click
True or false: You can copy all of the data from a column in one worksheet and paste those values into another column of the same worksheet, but you can't paste those values into another column in a separate worksheet
True
False
What feature would you use if you wanted to change all instances of reader with readers
Replace
Find
Insert
Cut
How would you change the style of an entire table?
View
Cell Style
Format as Table
Format
What would you select to replace the left rounded rectangle on slide 4 with a plain rectangle
Shape outline
Shape effects
Change Shapes
Design
