NEW
Font size
Worksheets1ST QUARTER EMTECH- REVIEWER
Total questions: 50
Worksheet time: 50mins
Which of the following best describes Web 1.0?
Highly interactive platforms with user-generated content
Static, read-only web pages with little user interaction
Semantic machines that learn user preferences
Cloud-based collaborative apps (e.g., Google Docs)
A defining feature of Web 2.0 is:
Static HTML pages only
Rich user participation and content contribution (comments, uploads)
Full decentralization using blockchain
Machines interpreting content semantically with no human input
Web 3.0 (semantic web) aims primarily to:
Replace HTML with plain text documents
Make websites static and less dynamic
Allow machines to understand and deliver content tailored to users
Prevent any user-generated content on sites
Which example is MOST representative of a Web 2.0 site?
A personal HTML page with fixed text and images
An online encyclopedia that allows community editing and comments
A single-file company brochure posted on a server
A PDF manual hosted statically for download
According to the slides, "folksonomy" in Web 2.0 refers to:
Machine-generated summaries of webpages
Users tagging and categorizing content with freely chosen keywords
A proprietary metadata standard for websites
A method of compressing images for the web
Which claim about Web 3.0 is accurate per the material?
Web 3.0 eliminates user accounts entirely.
Web 3.0 uses semantics for machines to predict user preferences.
Web 3.0 is the same as Web 1.0.
Web 3.0 only refers to mobile apps.
Technological convergence refers to:
The split of one device into many single-purpose gadgets
Integration of different applications and media into unified devices or systems
The exclusive use of desktop computers for all tasks
Avoiding interoperability between devices
Which item is listed as a type of social media?
Spreadsheet databases
Bookmarking sites (e.g., Pinterest)
Programming IDEs
FTP servers
Which operating system is described as "open source developed by Google"?
iOS
Android
Blackberry OS
Windows Mobile
Assistive media examples include:
Screen readers and braille embossers for visually impaired users
Social network moderation tools only
Static HTML templates
Low-resolution JPEGs for faster loading
Which of the following is the best tip from the slides for staying safe on public Wi-Fi?
Always share your password with friends
Avoid logging in to important accounts while on public networks
Disable antivirus to increase speed
Post your vacation dates on social media for visibility
Which online threat specifically impersonates trusted entities to steal credentials?
Adware
Phishing
Compression software
Image hosting
What does “pharming” typically exploit?
The DNS system to redirect users to fake sites
Graphic formats to alter colors
Mail merge features in Word
Spreadsheet sorting functions
A key difference between a virus and a worm (as described) is:
Worms are always harmless while viruses are not
Viruses require user action to spread; worms can self-replicate and spread automatically
Viruses only affect images, worms only affect audio
Worms cannot be transmitted via email attachments
Which of the following is an example of rogue security software?
Legitimate OS update from a vendor
Fake malware removal tool that installs malware after charging the user
A licensed antivirus with frequent signature updates
A browser extension created by a known vendor
Netiquette suggests that online users should:
Spam others to increase traffic
Respect others’ privacy and avoid posting offensive comments
Always post full addresses and phone numbers for transparency
Use all-caps to emphasize points in every comment
When planning an online search, the slides recommend narrowing your topic and identifying key concepts. Which next step improves search relevance?
Typing the whole question verbatim into the search box
Using Boolean operators like AND and OR between keywords
Avoiding synonyms to reduce results
Only using one search engine ever
What symbol should you use in searching for exact phrase or names on the web?
- (minus sign)
+ (plus sign)
* (asterisk)
“” (quotation)
Using quotation marks in a search helps to:
Exclude a word from the results
Search for the exact phrase enclosed in the quotes
Automatically translate the phrase to another language
Replace spaces with wildcards
Which of the following is NOT a recommended website evaluation question in the material?
Who wrote the article and what are their credentials?
What is the domain type of the website?
How many colors are used in the page’s CSS?
When was the document published or updated?
In MS Word Mail Merge, what are the two main components required?
A main document and a data source
A screenshot and a SmartArt only
A hyperlink and a chart
A picture and a clip art gallery
Which sequence correctly begins the Mail Merge process in Word?
File → Save As → Export Mail Merge
Mailings tab → Start Mail Merge → Select Recipients
Insert tab → Pictures → Mail Merge
Review tab → Protect Document → Mail Merge
To insert a SmartArt graphic in Word, you should:
Go to Insert → SmartArt, choose a graphic, then enter text into the Text pane
Only copy and paste images from the web with no editing
Use Mailings tab → SmartArt Wizard
Use Page Layout tab → SmartArt Styles
Which of the following illustration file types supports animation and is limited to 256 colors?
PNG
JPEG
GIF
TIFF
The slide notes recommend which resolution for images to be uploaded on the web?
72 dpi
600 dpi
300 dpi
1200 dpi
Which image format is best when you need transparency and good color for line art and logos?
JPEG
PNG
TIFF
BMP
When cropping an image for better composition, the slides recommend following:
The Rule of Thirds to organize composition
Always cropping to a square only
Avoiding any standard composition rules
Increasing DPI to 1200 before cropping
Which characteristic is NOT part of a good infographic according to the material?
Clear thesis/story
Well-organized data and sources cited
Excessive text blocking most of the visual space
Simplicity in color, style, and illustrations
Which online graphics software was listed in the slides as a web-based option for creating infographics?
In Excel, which function returns the largest value in a set of values?
MIN
COUNT
MAX
SUM
The correct syntax for SUMIF includes:
SUMIF(range, criteria, sum_range
SUMIF(criteria_range, sum_range)
SUMIF(cell)
SUMIF(range)
Which Excel function would you use to count cells that meet a single criterion (e.g., count "YES" answers)?
COUNT
COUNTIFS
COUNTIF
COUNTA
Given cell references are preferred in formulas because:
They make formulas dynamic so results update when referenced cell values change
They prevent any formula from changing its result
They are required only for charts
They always speed up the computer
Which Excel function performs a logical test and returns one value if TRUE and another if FALSE?
SUM
IF
COUNTIF
AVERAGE
What does "active cell" refer to in Excel?
The cell currently selected and ready for editing (outlined in bold)
Any cell with a formula only
The top-left cell only
A cell that has been locked by protection only
Which advanced Excel feature would be most appropriate for summarizing registration data by category (e.g., by city or age group)?
Pivot Table
Screenshot tool
Mail Merge
SmartArt
When entering a formula in Excel, what must you type first?
# (hash)
= (equal sign)
@ (at sign)
% (percent sign)
In PowerPoint, which view displays thumbnails of all slides for rearranging?
Notes Page View
Slide Sorter View
Outline View
Normal View
Which animation categories are in MS Powerpoint?
Entrance, Emphasis, Exit, and Motion Paths
Import, Export, Compress, and Crop
Slide, Transition, Table, and Chart
Bold, Italic, Underline, and Strikeout
What is the shortcut key to insert a new slide in PowerPoint?
Ctrl + N
Ctrl + M
Alt + F4
Ctrl + S
To create a motion path animation for an object in PowerPoint, you should use:
Animations → Add Animation → More Motion Paths
Insert → Picture → Motion Path
File → Options → Motion Settings
Slide Show → Rehearse Timings → Motion Path
Hyperlinks in PowerPoint can link to all EXCEPT:
Another slide in the current presentation
An email address with subject prefilled
Change the file format of the linked file automatically
An external webpage URL
When compressing images for the web per the slides, which two operations are most important?
Compression and resizing to reduce file size for web use
Converting to TIFF and increasing DPI to 1200
Embedding fonts in images and encrypting them
Converting images to spreadsheet format
Which image file format is noted as “very lossy” but popular for photographs on the web?
PNG
GIF
JPEG
TFF
Which hosting site from the list is described as an image social networking site with 1 TB storage?
Imgur
Photobucket
Flickr
SlickPic
According to the slides, which principle of graphics/layout refers to the flow that guides the viewer’s eyes around the page?
Balance
Movement
Proximity
Emphasis
If your website’s content must be objective and accurate, which evaluation question from the material is most relevant?
What is the domain type of the website?
How many images are on the site?
What is the author’s name and credentials?
What font size is used in headings?
A student team wants to send personalized invitation letters to 200 community members using Word. Which workflow is MOST efficient based on the slides?
Use Word Mail Merge with an Excel data source containing names and addresses
Manually type 200 letters and print individually
Put all names in a single PDF and mail it as one document
Use PowerPoint to create 200 slides and export each as an invitation
You must prepare a 3-slide presentation with consistent design, minimal text, clear visuals, and speaker notes. Which slide design tip from the slides is most relevant?
Use many fonts and colors to make each slide unique
Keep slide counts to a minimum, use clear fonts and simple bullets; use visuals sparingly for clarity
Put full paragraphs on slides for thorough reading by the audience
Use maximum animations to keep audience attention at all costs
Design challenge: For the community campaign you need an infographic that is clear, cites sources, and is easily shareable on social media. Which combination of the following from the slides best supports this objective?
Simplicity, data organization, branding/shareability, and citing sources
High DPI TIFF images and excessive text blocks
No data, only decorative stock photos with no attribution
Embedding raw spreadsheets into an image with tiny unreadable text
