Font size
WorksheetsKey Applications 1
Total questions: 20
Worksheet time: 10mins
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
Searching for specific data, categorizing data, and sorting data are all examples of what?
Raw data
Macros
Metadata
Best practices
Microsoft PowerPoint would be best used for...
Create videos from recorded presentations
Search the Internet for images and videos
Perform mathematic calculations
Used for taking notes, gathering images, and screen clippings
Database Management System that uses a graphical user interface
Microsoft Excel would be best used for...
Create videos from recorded presentations
Search the Internet for images and videos
Perform mathematic calculations
Used for taking notes, gathering images, and screen clippings
Database Management System that uses a graphical user interface
Microsoft Access would be best used for...
Create videos from recorded presentations
Search the Internet for images and videos
Perform mathematic calculations
Used for taking notes, gathering images, and screen clippings
Database Management System that uses a graphical user interface
Microsoft OneNote would be best used for...
Create videos from recorded presentations
Search the Internet for images and videos
Perform mathematic calculations
Used for taking notes, gathering images, and screen clippings
Database Management System that uses a graphical user interface
Google Chrome would be best used for...
Create videos from recorded presentations
Search the Internet for images and videos
Perform mathematic calculations
Used for taking notes, gathering images, and screen clippings
Database Management System that uses a graphical user interface
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 menu
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
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 + 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 +p
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
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 in 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
