NEW
Font size
WorksheetsPractical IT Skills Mock Test
Total questions: 47
Worksheet time: 24mins
In MS Access, which scenario BEST demonstrates the advantage of a relational database over a spreadsheet?
When you need to calculate values inside a single sheet
When data duplication must be minimized across multiple related entities
When only one table is required for flat data storage
When visual charts are needed for presentation
A dynaset created by a query updates automatically. This behaviour occurs because the dynaset…
Stores a static copy of data
Regenerates results only when manually refreshed
Is dynamically linked to its underlying tables
Relies on independent cached records
A user wants to enforce that every record must contain a unique value that cannot be left blank. Which field property accomplishes this?
Caption
Default Value
Primary Key
Data Type
When creating a relationship, dragging a field from one table to a matching field in another table performs which function?
Mapping the tables to a macro
Establishing referential joining between tables
Creating a form for both tables
Assigning default values to related fields
Which view allows you to change the field names, data types, and descriptions in MS Access?
Form View
Datasheet View
Design View
Navigation Pane View
A user inserts an input mask for a phone number field. What is the main purpose of using an input mask?
To hide data behind encryption
To force consistent data-entry formatting
To calculate formulas automatically
To replace default values in fields
In Access, a Switchboard is primarily used to…
Perform data sorting
Provide a controlled user interface for opening forms, queries, and tables
Create table relationships
Generate report summaries
Which component is NOT controlled by a PowerPoint Slide Master?
Fonts
Layout
Background
Animation timing
A nested list in PowerPoint requires the user to…
Select “Add Animation”
Click Increase/Decrease Indent
Apply Transition Effects
Insert a new slide layout
When modifying a chart in PowerPoint, which tab provides label and title editing?
Insert
Home
Layout (under Chart Tools)
Design (under Drawing Tools)
A user inserts an Online Picture in PowerPoint. Which ribbon appears automatically afterward for further formatting?
Picture Layout
Format (Picture Tools)
Editing
SmartArt Tools
In Excel, when a value is typed into a cell and Excel does not recognize it, the value is…
Automatically converted into currency
Stored as text and left-aligned
Removed by validation
Auto-corrected to nearest number
The formula `=Sheet2!B5 + A1` demonstrates the concept of…
Absolute referencing
Worksheet linking
Data validation
Conditional formatting
Which Excel function can only search vertically down the first column of a table?
HLOOKUP
SEARCH
VLOOKUP
MATCH
In Excel, an IF statement must contain…
Only one logical test
A logical test, a true value, and a false value
Only numeric comparisons
Text values only
Nested IF statements are used when…
Only one condition must be tested
More than one condition requires different outcomes
Text formatting must change
Charts must be linked to other worksheets
A user applies conditional formatting to highlight sales below RM100. What is the main purpose?
Encrypting values
Visually identifying critical data
Preventing users from editing values
Converting data into charts
Absolute references in Excel use the `$` symbol to…
Prevent changes when a formula is copied
Automatically convert formulas to percentages
Randomize data
Replace invalid references
A user inserts SmartArt in Excel. This is typically used to…
Perform calculations
Display graphical workflows or structures
Apply conditional formatting
Convert worksheets to templates
In Word, the Ribbon contains grouped commands known as…
Panels
Tiles
Chunks
Modules
The Insert Ribbon in Word is used to add…
References and citations
Paragraph formatting
Pictures, tables, SmartArt, links
Page layout and themes
A user wants to insert a watermark behind the main text. Which Ribbon is used?
Insert
Review
Design
View
SmartArt in Word is best applied when the user wants to…
Add numeric calculations
Insert complex page numbers
Illustrate processes or relationships
Add citations in Harvard format
Which Word component prints at the top of every page?
Footer
Header
Title Block
Citation Field
A user adds a Table of Contents in Word. This becomes possible because headings…
Use preset styles recognized by Word
Must be typed manually
Cannot be updated
Must be printed separately
Mail Merge requires two elements:
A pre-designed slide + template
A main document + data source
Charts + formulas
Pictures + captions
A bibliography in Word is created by…
Typing manual text only
Inserting page numbers
Using the Citations & Bibliography tools
Copying a reference list from Excel
In Access, which object is used primarily to view and edit data through a graphical interface?
Query
Form
Report
Table
Which object performs calculations and displays printed-ready output in Access?
Form
Report
Macro
Table
Which action is NOT part of building a calculated field in Access?
Selecting fields
Choosing operators
Running the query
Formatting slide transitions
Query criteria such as `>10 AND <20` use which logical concept?
Exclusive matching
Conjoined conditions
Negation operators
External linking
A parameter query is useful when the user wants to…
Insert new tables during query run
Enter search criteria every time the query runs
Restrict access to the database
Build macros automatically
A macro in Access stores…
Table data
Database actions and commands
Reports
External objects
Which Access command is chosen when a macro needs to open an existing table?
Open Query
Open Table
Load Data
Run Relationship
A Switchboard Manager allows only…
Unlimited switchboards
One switchboard per database
Dynamic reporting
Automatic form creation
In Excel, Data Validation prevents users from…
Formatting cells
Entering invalid data
Saving the file
Editing formulas
Which tool in Excel highlights unusual values with icon sets or color scales?
Formatting
Data Validation
Conditional Formatting
Cell Styles
To duplicate a worksheet, the user must…
Copy and paste cell ranges manually
Use “Move or Copy” on the worksheet tab
Recreate the sheet from scratch
Use SmartArt tools
Hiding a column in Excel is performed from…
Insert tab
Data tab
Format → Hide & Unhide
View → Page Layout
A chart can be moved to a new sheet by selecting…
Insert Hyperlink
Move Chart
Change Chart Type
Picture Tools
Print Area in Excel is used when the user wants to…
Print only selected cells
Print the entire workbook
Add page numbers
Apply conditional formatting
Page Breaks are inserted from which tab?
Insert
Review
Page Layout
View
In PowerPoint, transitions occur…
Within a single object
Between slides
Inside SmartArt
Only during printing
Animations in PowerPoint apply to…
Only the slide background
Objects such as text or shapes
Navigation pane elements
Sound settings only
A user wants every slide to share the same font and background. They should modify…
Individual slides
Slide Sorter
Slide Master
Notes Master
When printing handouts, PowerPoint allows…
Displaying only one slide per page
Only printing in black and white
Printing 1, 2, 3, 4, 6, or 9 slides per page
Printing without margins
In Word, Track Changes allows the user to…
Spell-check documents
Prevent printing
View, accept, or reject edits from collaborators
Insert citations
