WorksheetsTypes of Apps and Development Trends
Total questions: 71
Worksheet time: 36mins
Which statement best describes application software on a computer or mobile device?
Programs that help perform specific user tasks
Programs that run automatically without user input
Programs that install the operating system firmware
Programs that manage hardware resources only
Which app category focuses on creating documents and presentations for business or personal use?
Graphics apps for visual editing
Productivity apps for task creation
Device management apps for updates
Communications apps for messaging
Which feature is typical of many apps across platforms?
Disable on-screen buttons by default
Require external storage media
Open in a window with menus
Always run full-screen only
Which statement accurately differentiates local and portable applications?
Local apps run in browsers; portable apps require an app store
Local apps install on the hard drive; portable apps run from removable storage
Local apps are mobile-only; portable apps are desktop-only
Local apps are cloud-only; portable apps are offline-only
Which description fits web apps used on mobile devices?
Requires an app store for installation
Runs only when connected to external storage
Accessed in a browser and often responsive
Installed to the device and uses native APIs
Which statement describes a native app advantage?
Always stores data only in the cloud
Never needs any Internet access
Can use device-specific features
Runs on all devices without changes
Which is a realistic con of some mobile web apps compared to native apps?
They always require external keyboards
They cannot be created quickly at all
They never support voice input interactions
They are slower and have fewer features
Which mobile interaction method simplifies entering information on smartphones?
Physical keyboard with wired connector
Barcode scanner built into every phone
Voice input and smart on-screen keyboard
Mouse pointer with right-click menus
Developers adopting mobile first design primarily aim to achieve which outcome?
Increase file sizes for high-resolution media
Restrict apps to a single operating system
Ensure streamlined content and simple interactions
Prioritize desktop content with rich menus
Which statement best explains cross-platform development tools?
Tools that build apps to run on multiple systems
Tools limited to one brand of mobile device
Tools that focus solely on hardware drivers
Tools that only design for web browsers
Which scenario demonstrates m-commerce on a phone?
Using a calendar to schedule classes
Organizing apps into folders by category
Purchasing goods through a mobile app
Editing photos offline on the device
Which difference between native and web apps affects offline use most directly?
Web apps always use device-specific hardware APIs
Native apps can store data locally for offline use
Web apps always install from an app store
Native apps must run in a browser window
Which app in a productivity suite is best for creating and sharing slide-based presentations?
Graphics software for image drawing
Spreadsheet software for data tables
Presentation software for slide shows
Database software for records lists
What is a primary use of spreadsheet software in basic coursework?
Designing vector graphics
Sending and receiving email
Managing basic workbooks
Editing long text reports
Which tool is intended to manage basic databases within a productivity suite?
Cloud storage drive
Database management app
Word processor application
Presentation slide tool
Which statement best describes a productivity suite available in the cloud?
Runs only on desktop installs
Accessible through a web browser
Requires local file storage
Cannot support collaboration
Why do web and mobile versions of productivity suites often appeal to students?
They require expensive licenses
They lack cross-platform support
They are simpler with basic features
They include only advanced features
Which pair correctly matches suite and word processor?
Apple iWork – Writer
G Suite – Google Docs
OpenOffice – Keynote
Microsoft Office – Pages
Which suite integrates OneDrive for cloud storage?
Apple iWork
Microsoft Office
OpenOffice
G Suite
If a team needs real-time collaboration in a browser, which suite is the best fit?
Microsoft Office desktop only
Apple iWork macOS only
G Suite web apps
OpenOffice offline apps
Which feature appears when you start a word processing program with a new blank document?
Hyperlinks and references
Insertion point and scroll bars
Tables and graphics
Mail merge and templates
What is the primary purpose of document management tools in word processors?
Protect and organize files
Resize images quickly
Convert text to HTML
Create numbered lists
Which control lets you move through a document that is longer than the window?
Hyperlinks and references
Alignment and line spacing
Headers and footers
Vertical and horizontal scroll bars
Which user group most likely creates agendas, memos, and proposals with word processing?
Business executives and office workers
Personal users at home
Students and teachers
Web designers and developers
Students commonly use word processing to produce which items?
Network topology maps
Web server scripts
Invoices, payroll checks
Essays, reports, resumes
Which formatting action changes how text looks, such as font type, size, and color?
Convert to numbered lists
Format text properties
Insert mail merge fields
Create bibliography entries
Page orientation controls which aspect of a document?
How references list citation sources
Where headers and footers appear
How hyperlinks display embedded URLs
Whether pages are portrait or landscape
Templates in word processors are best described as:
Prebuilt document layouts
Cloud backup settings
Automatic spelling corrections
Image compression profiles
Which feature adds photos, icons, charts, or screenshots to a document?
Headers and footers
Line spacing controls
Reference manager
Graphics insertion tools
Headers and footers are primarily used to:
Insert clickable web links
Align paragraphs centrally
Organize data into rows
Display information at page edges
Which option specifies the amount of white space between lines of text?
Line spacing setting
Mail merge wizard
Margins property
Alignment choice
What does Mail Merge enable you to do?
Generate automatic footnotes
Insert dynamic website links
Lock a document to read-only
Create customized letters or emails
Margins control which region of the page?
The blank space along the edges
The area for footnotes only
The spacing within paragraphs
The center alignment of text
Which feature organizes content into rows and columns?
Alignment menu
Tables tool
Hyperlink tool
Graphics panel
When storing a document in the cloud, what additional capability becomes possible?
Insert citations without internet
Share for simultaneous viewing and commenting
Automatically convert all text to HTML
Increase local printer speed instantly
In a spreadsheet, which statement best describes an absolute cell reference?
A reference that changes only across worksheets
A reference locked so copying keeps the exact cell
A reference that points to a relative position nearby
A reference that adjusts when copied to new rows
Which spreadsheet feature automatically changes cell formatting based on rules?
Conditional formatting with criteria rules
Manual formatting with style presets
Absolute formatting with fixed colors
Relative formatting with copied styles
What is the primary purpose of pivot tables in spreadsheets?
To draw charts with decorative styles
To lock cells from accidental edits
To summarize and analyze large datasets
To record steps for repeating tasks
In a spreadsheet, which tool visualizes trends directly within cells as tiny charts?
Filters for selective views
Formulas for calculations
Sparklines for cell mini-charts
Macros for automated actions
Which spreadsheet action helps compare outcomes by changing input values?
Record a macro script
Apply absolute references
What-if analysis scenarios
Sort and filter records quickly
What do spreadsheet macros primarily enable?
Automate repetitive worksheet tasks
Encrypt files with strong passwords
Prevent formula errors permanently
Create 3D bar charts instantly
Which option best describes a slide master in presentation software?
A hidden slide storing backup images
A single slide with extra animations
A tool for recording narration only
A layout template controlling global styles
Transitions in a slide show are used to:
Store presentations in the cloud
Control movement between slides
Change text size inside a slide
Apply formulas to chart data
Animations in presentations are best used to:
Replace headers and footers
Resize graphics across slides
Switch between slide masters
Reveal or emphasize slide elements
Which best practice improves overall presentation organization?
Hide titles to avoid clutter
Mix many topics on each slide
Organize with a beginning, middle, end
Use random fonts and colors
To add consistent design across slides, you should:
Copy text placeholders between slides
Format each slide separately by hand
Edit the slide master for global changes
Insert more transitions to unify style
Which action sets slide width, height, and orientation?
Layout placeholders editing
Slide size and orientation settings
SmartArt diagram gallery
Theme color palette selection
When embedding an external file into a slide, what is accurate?
It inserts the file as an embedded object
It creates a permanent live copy
It must be recorded as audio
It only links to a web address
Which approach is recommended for using graphics in slides?
Only use screenshots for accuracy
Use graphics wisely for clarity
Fill every slide with multiple photos
Avoid graphics entirely for focus
What is the main difference between transitions and animations?
Animations affect slide-to-slide changes; transitions affect objects
Both change fonts and colors across slides
Transitions affect slide-to-slide changes; animations affect objects
Both only work when exporting to video
Which practice helps deliver an effective presentation?
Check equipment in advance
Avoid audience involvement
Read slides word-for-word
Stand still behind the podium
To maintain professionalism, which tool should be used before presenting?
Random transitions generator
Chart auto-format assistant
Macro recorder for slides
Grammar and spelling checks
When adding content to slides, what do placeholders primarily provide?
Permanent links to databases
Cloud backups of design themes
Predefined areas for text or media
Automatic animations for headers
Which statement best describes a relational database management system (RDBMS)?
Stores data as linked tables with rows and columns
Saves files as compressed images for quick sharing
Creates animated graphics using layers and filters
Manages network devices and internet connections
In a relational database, what is a record?
A report layout used for printing summaries
A query that filters data based on criteria
A row containing related field values for one item
A column name that labels a data category
What is the primary purpose of a query in database software?
Extract data based on specified criteria or conditions
Assign field names to each column in a table
Design the screen layout for data entry forms
Export tables into spreadsheet programs
Which component is typically used to enter data into a database?
A form with a set of controls for input
A report for summarizing grouped records
A server used to host large databases
A bitmap used to represent visual fields
Which action helps ensure data integrity in a database?
Control how data is entered, formatted, and stored
Crop or resize an image to match screen size
Use filters and effects to adjust brightness
Draw shapes with a stylus or calligraphy pen
What is a key reason enterprise databases run on a server?
GIF files support transparency in images
Many users may need simultaneous access
Video editing apps need audio capabilities
Vector graphics require mathematical formulas
Which task is part of managing databases?
Establish security to protect data from attacks
Add text to graphics for visual interest
Use color palettes for shapes and lines
Create two-dimensional images with drawing apps
Bitmap images are based on what fundamental unit?
Layers used for photo edits
Frames used for video clips
Vectors defined by formulas
Pixels arranged in a raster grid
Vector graphics primarily rely on which principle?
Recorded frames across a timeline
Stacked layers for non-destructive edits
Compressed blocks of color pixels
Mathematical formulas describing shapes
Most clip art images are stored as which type of graphic?
Vector graphics with scalable shapes
Bitmap graphics with fixed pixels
Raw data captured by professionals
JPEG files with lossy compression
Which key feature is commonly found in graphics software?
Run SQL commands to filter table rows
Use shape tools to create lines and circles
Assign field names for database columns
Manage database backup plans regularly
Which task would a photo and image editing app typically allow?
Design form controls for data entry
Enhance and modify existing photos and images
Create tables and define relational keys
Write SQL queries to join multiple tables
Which graphics file format is usually uncompressed and can be very large?
PNG files with transparent backgrounds
TIFF files used for print publishing
GIF files supporting simple animations
JPEG files optimized for web sharing
Which graphics format supports transparency and is common on webpages?
TIFF format for professional printing
BMP format with uncompressed pixels
PNG format with lossless compression
RAW format used by photographers
What is a typical use for a report in database software?
Define the mathematical rules behind vector shapes
Present a user-designed layout of database content
Compress images to reduce file size for email
Control access to parts of an application
What challenge is associated with Big Data in relation to RDBMS?
Collections are so large they are difficult to process
Images have too many pixels for vector conversion
Files require formats that support animations
Videos need clips with audio editing support
Which statement accurately contrasts bitmap and vector graphics?
Both rely on frames arranged on timelines
Bitmap use formulas; vector use pixels
Both store raw sensor data from cameras
Bitmap use pixels; vector use formulas
Which app type typically lets you create simple two-dimensional vector images?
Database apps with query builders
Paint apps with audio features
Video editing apps with timelines
Drawing apps with vector tools
