Font size
WorksheetsIC3 GS5 - KEY APPLICATION [EXERCISE 2]
Total questions: 20
Worksheet time: 10mins
Each table in a database must have:
an ID field.
at least one record
a unique name
at least five fields
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
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
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 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
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
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
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
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
Which of the following file types stores tabular data and uses fields separated by commas?
.ai
.txt
.csv
Which of the following are metadata for a text file? (Choose three)
Date created
Date modified
Account user
File permissions
Text editor
Which of the following aspects of a website typically uses a database?
Style sheets
Static content
Image files
Authentication
You recently had to factory reset your phone. How can you recover any paid apps that you lost without having to pay for them again?
Download it again from the app store
Message the developer and ask them to restore it
Purchase it again from the app store
Get them in your phone's application settings
Having a visually striking and well-designed web page can increase business for your online store. Which of the following groups of applications would be best for web design.
Adobe Illustrator, Adobe Dreamweaver, Microsoft Excel
Adobe Photoshop, Adobe Illustrator, Adobe Premiere Pro
Microsoft Word, Microsoft PowerPoint, Adobe Premiere Pro
Microsoft Word, Adobe InDesign, Adobe Acrobat Pro
In Microsoft Excel, which Protect Workbook option allows you to restrict users from adding new columns while allowing them to make other changes?
Add a Digital Signature
Always Open Read Only
Protect Current Sheet
Protect Workbook Structure
