Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Worksheet Questions – Grade 13

Total questions: 80

Worksheet time: 40mins

Name
Class
Date
1.

In MS Access, which situation BEST justifies creating a relationship between two tables?

a)

When both tables share identical field names but store unrelated data

b)

When a field in one table must determine which records appear in another table

c)

When tables contain repeated rows of the same data

d)

When a form must display fields from a single table only

2.

A query returns no records even though the table contains matching data. Which reason is MOST likely?

a)

The query field list is too long

b)

Incorrect criteria using AND logic is filtering out valid rows

c)

Query design view was not refreshed

d)

The table is not indexed

3.

When designing a calculated field in Access, which combination is valid?

a)

Field1 – ("Text1")

b)

2 * [Price] + [Quantity]

c)

[Name] / [Address]

d)

"Total" = [Price]

4.

Which statement about Parameter Queries is TRUE?

a)

They permanently store the user’s input

b)

They allow users to enter criteria every time the query runs

c)

They can only be created using Query Wizard

d)

They require macros to function

5.

A macro fails to open a form. Which configuration is MOST likely incorrect?

a)

The View mode was set to Datasheet

b)

The form name field in the macro action is empty

c)

The macro was named incorrectly

d)

The database was not compacted

6.

Why is a switchboard used in Access?

a)

To accelerate query execution

b)

To ensure users do not interact directly with database objects

c)

To permanently lock database tables

d)

To encrypt forms and reports

7.

A user wants to display items with cost > 10 and quantity < 5. Which operator is correct?

a)

OR

b)

BETWEEN

c)

LIKE

d)

AND

8.

In Word, which feature allows automatic update of citations and bibliography?

a)

Footnotes

b)

Header/Footer

c)

Harvard-style citation manager

d)

SmartArt

9.

Which component of a research paper must appear on a page by itself?

a)

Body

b)

Conclusion

c)

Abstract

d)

Figure list

10.

A student enters 018 in Excel and it becomes 18. What should be done?

a)

Increase column width

b)

Format the cell as Text

c)

Use conditional formatting

d)

Use Data Validation

11.

Which Excel function identifies the smallest value?

a)

MIN

b)

COUNT

c)

AVG

d)

SMALLEST

12.

What limitation of VLOOKUP is stated in the lecture?

a)

Cannot handle numbers

b)

Only works on exact matches

c)

Can only look up data to the right

d)

Cannot search text

13.

Which Excel feature prevents invalid data entry?

a)

Conditional Formatting

b)

Data Validation

c)

Chart Tools

d)

AutoFit

14.

What happens when using absolute referencing in formulas?

a)

All references shift

b)

Columns change but rows stay fixed

c)

The referenced cells remain fixed

d)

Formulas become text

15.

Which scenario requires a Nested IF?

a)

Displaying multiple outcomes based on several conditions

b)

Formatting a chart

c)

Merging cells

d)

Adding shapes

16.

In PowerPoint, which view edits the entire layout at once?

a)

Slide Sorter

b)

Notes Page

c)

Slide Master

d)

Handout Master

17.

A video in PowerPoint does not autoplay. What must be adjusted?

a)

Text Alignment

b)

Animation Speed

c)

Movie Playback Options

d)

Slide Layout

18.

A user wants all slides to share the same background image. Which method is correct?

a)

Insert → Picture on each slide

b)

Design → Background Styles (Slide Master)

c)

Format → Replace Background

d)

Home → Apply Background

19.

Which Word feature is essential for labels or envelopes?

a)

Mail Merge

b)

SmartArt

c)

Styles

d)

Track Changes

20.

Where is the Watermark option in Word?

a)

Insert tab

b)

Home tab

c)

Design → Page Background

d)

View tab

21.

A form displays duplicate entries. What is the MOST likely reason?

a)

No primary key

b)

Form Wizard was used

c)

Navigation pane hidden

d)

Form in Design View

22.

Which Access view allows editing field properties?

a)

Report View

b)

Form View

c)

Datasheet View

d)

Design View

23.

Which setting forces a field to always require an entry?

a)

Caption

b)

Input Mask

c)

Required

d)

Default Value

24.

When do you use an Input Mask?

a)

To capitalize names

b)

To enforce phone number format

c)

To prevent duplicate IDs

d)

To sort alphabetically

25.

What is the first step when creating a macro?

a)

Add arguments

b)

Select Macro Design View

c)

Assign a button

d)

Create a dummy form

26.

Which feature helps fix cut-off margins before printing?

a)

Print Preview

b)

Outline View

c)

Slide Sorter

d)

SmartArt Layout

27.

Which Excel feature highlights unusual values?

a)

VLOOKUP

b)

Data Validation

c)

Conditional Formatting

d)

Merge & Center

28.

Which command moves a chart to another sheet?

a)

Change Chart Type

b)

Move Chart

c)

Insert Chart

d)

Paste Special

29.

What determines which data appears in a form?

a)

The selected theme

b)

The fields chosen from tables/queries

c)

Form size

d)

Report settings

30.

Which tool ensures all cited sources appear in the reference list?

a)

Footnotes

b)

Automatic Bibliography

c)

Quick Styles

d)

Compare Documents

31.

What is the purpose of a table in Access?

a)

To create animations

b)

To store data in rows and columns

c)

To insert audio files

d)

To print reports

32.

A single row of data in Access is called:

a)

Field

b)

Record

c)

Table

d)

Object

33.

Which view allows editing field names and data types?

a)

Form View

b)

Datasheet View

c)

Report View

d)

Design View

34.

What is the unique identifier of a table?

a)

Caption

b)

Primary Key

c)

Field Size

d)

Data Type

35.

What does a query do?

a)

Creates new tables

b)

Filters and displays specific data

c)

Designs forms

d)

Prints the database

36.

Which tool helps you ask a question to the database?

a)

Report

b)

Form

c)

Query

d)

Macro

37.

Which object is used to print an organised output of data?

a)

Query

b)

Form

c)

Report

d)

Macro

38.

Excel formulas must begin with:

a)

@

b)

#

c)

=

d)

$

39.

Which function adds a list of numbers?

a)

MIN

b)

SUM

c)

COUNT

d)

MAX

40.

A cell is the intersection of:

a)

Row and workbook

b)

Column and worksheet

c)

Row and column

d)

Worksheet and workbook

41.

Which feature adjusts column width automatically?

a)

AutoFit

b)

Data Validation

c)

Sort

d)

Cut & Paste

42.

The IF function returns:

a)

Always TRUE

b)

Only FALSE

c)

A value based on a condition

d)

A random number

43.

Which tab in Word inserts pictures and shapes?

a)

Insert

b)

Home

c)

Review

d)

Layout

44.

Which Word feature creates consistent formatting?

a)

SmartArt

b)

Styles

c)

Header

d)

Mail Merge

45.

Which tab controls margins and orientation?

a)

Home

b)

Insert

c)

Layout

d)

Review

46.

The top bar showing the file name is the:

a)

Ribbon

b)

Title Bar

c)

Status Bar

d)

Quick Access Toolbar

47.

Which component appears at the end of a research paper?

a)

Abstract

b)

References

c)

Cover Page

d)

Acknowledgment

48.

Slide Master controls:

a)

Slide animations

b)

Theme and layout

c)

Speaker notes

d)

Print settings

49.

Which view shows slides as thumbnails?

a)

Notes Page

b)

Outline View

c)

Slide Sorter

d)

Slide Show

50.

To add a new slide:

a)

Insert → New Slide

b)

File → Save

c)

Home → Format

d)

View → Sort

51.

Shortcut to undo last step:

a)

Ctrl + P

b)

Ctrl + S

c)

Ctrl + Z

d)

Ctrl + X

52.

What prints at the top of each Word page?

a)

Footer

b)

Header

c)

Title

d)

Caption

53.

AutoSum performs:

a)

Delete text

b)

Sort data

c)

Calculate totals quickly

d)

Split cells

54.

Which Access object is used for easier data entry?

a)

Query

b)

Report

c)

Form

d)

Macro

55.

Zoom allows you to:

a)

Change font

b)

Adjust display size

c)

Create tables

d)

Insert hyperlinks

56.

Transitions in PowerPoint apply to:

a)

Text only

b)

Images only

c)

Slide changes

d)

Notes

57.

Excel workbooks contain:

a)

One worksheet only

b)

Multiple worksheets

c)

Only charts

d)

Only data types

58.

Table of Contents is created under:

a)

Insert tab

b)

References tab

59.

Which icon copies selected text?

a)

Scissors

b)

Clipboard

c)

Two overlapping papers

d)

Trash can

60.

Purpose of Data Validation?

a)

Highlight cells

b)

Prevent wrong data entry

c)

Create charts

d)

Merge cells

61.

In MS Access, what is a unique identifier for each record in a table?

a)

Primary Key

b)

Foreign Key

c)

Index

d)

Record ID

62.

A single piece of data in a table column is called what?

a)

Field

b)

Record

c)

Tuple

d)

Attribute Set

63.

In Excel, every formula must begin with which symbol?

a)

+

b)

=

c)

#

d)

@

64.

Which Excel function calculates the total of a range of numbers?

a)

AVERAGE

b)

SUM

c)

COUNT

d)

TOTAL

65.

Which Word feature allows you to generate multiple letters using a data source?

a)

Mail Merge

b)

Macro

c)

Styles

d)

Track Changes

66.

In PowerPoint, the view that controls overall layout and theme is called ____ Master.

a)

Slide

b)

Design

c)

Layout

d)

Theme

67.

In Access, a question used to retrieve specific information from data is known as what?

a)

Form

b)

Query

c)

Report

d)

Macro

68.

In Excel, the intersection of a row and a column is called what?

a)

Cell

b)

Field

c)

Record

d)

Node

69.

To shift the contents within a merged block in Excel, which feature is used in ____ & Center?

a)

Merge

b)

Align

c)

Wrap

d)

Indent

70.

The library of pre-designed text effects in Word is called what?

a)

WordArt

b)

SmartArt

c)

Styles

d)

ClipArt

71.

Which Access view is used to adjust field properties such as data type?

a)

Datasheet

b)

Design

c)

Form

d)

Report

72.

A list of sources used in a research paper is called which page?

a)

Appendix

b)

References

c)

Index

d)

Bibliography

73.

In PowerPoint, an effect that plays when switching from one slide to another is called what?

a)

Animation

b)

Transition

c)

Effect

d)

Motion Path

74.

In Excel, which feature restricts user input to specific types of data (Data ____)?

a)

Entry

b)

Validation

c)

Type

d)

Restriction

75.

A graphical interface in Access for entering and viewing data is known as what?

a)

Table

b)

Form

c)

Report

d)

Query

76.

In Word, the section that appears at the bottom of each printed page is the what?

a)

Header

b)

Footer

c)

Caption

d)

Endnote

77.

In Excel, which built-in function finds the largest number in a range?

a)

MIN

b)

MAX

c)

LARGE

d)

TOP

78.

The transparent text or logo placed behind document content in Word is known as what?

a)

Background

b)

Watermark

c)

Overlay

d)

Template

79.

In Access, which object is used to produce printed summaries of data?

a)

Form

b)

Report

c)

Macro

d)

Table

80.

In Excel, a collection of related worksheets stored together is called what?

a)

Workbook

b)

Worksheet

c)

File

d)

Spreadsheet

Similar Resources on Wayground

VR/AR and Multimedia Systems Worksheet

80 questions

VR/AR and Multimedia Systems Worksheet

quiz

Worksheet

•

University

latihan soal teknologi Perkantoran 1

78 questions

latihan soal teknologi Perkantoran 1

quiz

Worksheet

•

University

Microsoft Access worksheet questions

78 questions

Microsoft Access worksheet questions

quiz

Worksheet

•

University

Unit 3

80 questions

Unit 3

quiz

Worksheet

•

University

Summer Year 9 Technology

76 questions

Summer Year 9 Technology

quiz

Worksheet

•

9th Grade - University

Science, Technology, and Society

77 questions

Science, Technology, and Society

quiz

Worksheet

•

University