1.

Which function calculates periodic loan payments in Excel?

a) FV
b) NPV
c) PMT
d) SUM

2.

Which tab in Microsoft Word is used to change the scale of measurements?

a) Home
b) File
c) Layout
d) Insert

3.

What does XML stand for?

a) eXtensible Markup Language
b) eXtra Modern Language
c) Extended Markup Language
d) Extended Modern Language

4.

What is a Primary Key in MS Access?

a) Field with unique values identifying each record
b) Sorting field
c) Duplicate values
d) Most important data

5.

What is the shortcut key to open VBA Editor?

a) Ctrl + V
b) Alt + F11
c) Ctrl + B
d) Alt + VBA

6.

Which function calculates the average of a range of values?

a) SUM
b) MAX
c) AVERAGE
d) MIN
7.

Which option allows you to merge and center cells in Excel?

a) Format Cells
b) Alignment Options
c) Merge & Center Dropdown
d) Cell Styles

8.

File extension for Access 2007 database?

a) .mdb
b) .accdb
c) .dat
d) .adp

9.

What is the purpose of filtering in tables?

a) Automatically add new data
b) Display specific data based on filter criteria
c) Merge similar cells
d) Change format

10.

Which function combines text from different cells?

a) CONCATENATE
b) LEFT
c) RIGHT
d) LEN

11.

Which formula references cell A1 on Sheet2?

a) =Sheet2!A1
b) =Sheet1!A1
c) =A1(Sheet2)
d) =Sheet2(A1)

12.

Which is NOT a component of Access database?

a) Tables
b) Forms
c) Spreadsheet
d) Macros
13.

Primary function of Pivot Table?

a) Data entry
b) Data summarization and analysis
c) Data formatting
d) Data manipulating

14.

Full form of CAAT?

a) Computer-Assisted Audit Techniques
b) Computer-Assigned Auto Techniques
c) Computer-Assisted Auto Techniques
d) None

15.

Which menu option allows you to create a new workbook in Excel?

a) File > New
b) Edit > New
c) View > New
d) Format > New

16.

Purpose of protecting a worksheet in Excel?

a) Prevent viewing
b) Restrict unauthorized access/modifications
c) Delete contents
d) Change formatting

17.

Which function finds the position of an item in dataset?

a) VLOOKUP
b) HLOOKUP
c) INDEX
d) MATCH

18.

What does the formula =SUM(A1:A10) do?

a) Adds values in A1 to A10
b) Subtracts values
c) Multiplies values
d) Divides values

19.
Which field links to another table’s primary key?
a) Primary Key
b) Foreign Key
c) Duplicate Key
d) Hyperlink

20.

Which function calculates end of month from a date?

a) EOMONTH
b) TODAY
c) DATE
d) MONTH

21.

What does conditional formatting allow you to do?

a) Automatically highlight cells based on criteria
b) Change font style only
c) Add formulas
d) Adjust alignment

22.

Which step initiates Mail Merge?

a) Selecting Recipients
b) Inserting Fields
c) Starting Mail Merge Wizard
d) Preview Documents

23.

Example of CAAT?
a) Excel
b) Oracle
c) IDEA
d) Tally

24.

Functions start with ____ in IDEA.

a) =
b) #
c) @
d) *

25.
Database format in IDEA?
a) ACCDB
b) IMD
c) XLS
d) None

26.

What is the purpose of Mail Merge?

a) Formatting text
b) Creating bulk personalized documents
c) Sorting data
d) Adding images

27.

Which function calculates days between dates?

=DATEDIF(B2,C2,"d")

a) Days between dates

b) Time difference
c) Average
d) None

28.

Which function performs logical operations?

a) IF
b) SUM
c) MAX
d) COUNT

29.

Purpose of slicers in Pivot Tables?

a) Add color
b) Filter data interactively
c) Create charts
d) Calculate fields

30.

What is stratification in IDEA?

a) Creating stack
b) Creating stocks
c) Creating bands
d) None
31.

Equal chance of selection involves:

a) Random sampling
b) Systematic sampling
c) Stratification
d) None

32.

Which function sets random seed in IDEA?

a) @Val
b) @Rand
c) @Seed
d) None

33.

Which field type is used for custom calculations in Pivot Tables?

a) Value Fields
b) Label Fields
c) Calculated Fields
d) Summary Fields

34.

How can you add new slides in PowerPoint?

a) Slide sorter right click
b) Ctrl + D
c) Insert → New Slide
d) Copy paste

35.

Which part can be modified in Notes Master?

a) Slide titles
b) Slide transitions
c) Presenter notes
d) Slide background

36.

How can you add data to table in Access?

a) Import only
b) Manual entry only
c) Forms only
d) Import or manual entry

37.

Which design aspect is crucial for chart effectiveness?

a) Data labels
b) Gridlines and axes
c) Chart colors
d) Legend placement

38.

Which step creates a new table in Access?

a) File → Open
b) File → New → Blank desktop database
c) Create tab → Tables
d) Tables tab

39.

Which step selects recipients in Mail Merge?

a) Designing template
b) Defining document
c) Providing dataset information
d) Inserting fields

40.

Which function extracts characters from left side?

a) LEFT
b) RIGHT
c) MID
d) LEN

41.

Which view in MS Word shows the document as it will appear when printed?
a) Draft View
b) Web Layout
c) Print Layout
d) Outline View

42.
Which shortcut key is used to copy text in MS Word?
a) Ctrl + C
b) Ctrl + X
c) Ctrl + V
d) Ctrl + P

43.

Which tab is used to insert tables in MS Word?

a) Home
b) Insert
c) Layout
d) References

44.

Which Excel function returns the largest value in a range?

a) MAX
b) MIN
c) SUM
d) COUNT

45.

Which Excel function counts numeric values in a range?

a) COUNT
b) COUNTA
c) SUM
d) LEN

46.

Which function returns the number of characters in text?

a) LEN
b) LEFT
c) RIGHT
d) MID

47.

Which key edits the active cell in Excel?

a) F1
b) F2
c) F3
d) F4

48.
Which key repeats the last action in Excel formula reference?
a) F1
b) F2
c) F3
d) F4

49.

Which Excel feature allows restricting the type of data entered?

a) Filter
b) Data Validation
c) Conditional Formatting
d) Pivot Table

50.

Which Excel feature helps summarize large datasets?

a) Charts
b) Pivot Tables
c) Tables
d) Graphs

51.

Which command is used to check spelling errors in Word?

a) Grammar Check
b) Spell Check
c) Review Check
d) Language Check

52.

Which Word feature tracks edits made by reviewers?

a) Comments
b) Track Changes
c) Proofing
d) Edit Mode

53.

Which tab contains the Table of Contents option?

a) Insert
b) Home
c) References
d) Review

54.
Which option allows adding page numbers in Word?
a) Insert
b) Design
c) Layout
d) Home

55.

Which Excel function joins multiple text strings?

a) CONCATENATE
b) SUM
c) COUNT
d) IF

56.

Which Excel function returns today's date?

a) DATE
b) TODAY
c) NOW
d) DAY

57.

Which Excel chart compares categories?

a) Line Chart
b) Column Chart
c) Pie Chart
d) Area Chart

58.

Which chart displays proportions of a whole?

a) Column Chart
b) Line Chart
c) Pie Chart
d) Scatter Chart

59.

Which Excel function returns smallest value?

a) MAX
b) MIN
c) SUM
d) AVERAGE

60.
Which Excel function counts non-empty cells?
a) COUNT
b) COUNTA
c) COUNTIF
d) SUM

61.

Which Access object stores data?

a) Query
b) Form
c) Table
d) Report

62.

Which Access object retrieves data based on criteria?

a) Table
b) Query
c) Form
d) Report

63.

Which Access object is used to enter data easily?

a) Table
b) Query
c) Form
d) Report

64.

Which Access object presents data in printable format?

a) Query
b) Table
c) Report
d) Macro

65.

Which window manages relationships in Access?

a) Table View
b) Relationships Window
c) Query View
d) Data Window
66.

Which key inserts a page break in Word?

a) Ctrl + Enter
b) Ctrl + Shift
c) Alt + Enter
d) Shift + Enter

67.

Which Word tool allows inserting decorative text?

a) SmartArt
b) WordArt
c) ClipArt
d) Shapes

68.

Which tab contains page margin settings?

a) Insert
b) Layout
c) Home
d) References

69.

Which Word feature automatically corrects spelling?

a) AutoCorrect
b) SpellCheck
c) Grammar Tool
d) Dictionary

70.

Which command selects the entire document?

a) Ctrl + S
b) Ctrl + A
c) Ctrl + P
d) Ctrl + D

71.

Which Excel feature sorts data alphabetically?

a) Sort
b) Filter
c) Pivot
d) Chart
72.

Which Excel feature displays only selected records?

a) Sort
b) Filter
c) Table
d) Format

73.

Which Excel function checks a condition?

a) IF
b) SUM
c) AVG
d) MAX

74.

Which Excel formula begins every function?

a) @
b) #
c) =
d) $

75.

Which Excel formula combines values from cells?

a) CONCATENATE
b) COUNT
c) SUM
d) MAX

76.

Which IDEA analysis detects abnormal digit distribution?

a) Gap Detection
b) Benford's Law
c) Stratification
d) Summarization

77.

Benford’s Law analyzes which digits?

a) First digits
b) Random digits
c) Last digits
d) All digits
78.

Which IDEA command groups values into ranges?

a) Stratification
b) Extraction
c) Join
d) Sampling

79.

Which sampling technique selects records at equal intervals?

a) Random Sampling
b) Systematic Sampling
c) Stratified Sampling
d) Judgment Sampling

80.

Which IDEA feature extracts specific records?

a) Extraction
b) Import
c) Index
d) Join

81.

Which Access key uniquely identifies records?

a) Primary Key
b) Foreign Key
c) Index
d) Hyperlink

82.

Which Access key links two tables?

a) Primary Key
b) Foreign Key
c) Composite Key
d) Secondary Key

83.

Which Access view allows editing table structure?

a) Datasheet View
b) Design View
c) Layout View
d) Form View
84.

Which Access view displays data in rows and columns?

a) Design View
b) Datasheet View
c) Query View
d) Report View

85.

Which Access feature speeds up search?

a) Index
b) Query
c) Form
d) Macro

86.

Which shortcut saves a document in Word?

a) Ctrl + S
b) Ctrl + A
c) Ctrl + P
d) Ctrl + O

87.

Which shortcut opens print dialog in Word?

a) Ctrl + S
b) Ctrl + P
c) Ctrl + O
d) Ctrl + W

88.

Which Word element appears at the bottom of page?

a) Header
b) Footer
c) Margin
d) Border

89.

Which Word feature allows inserting citations?

a) References Tab
b) Review Tab
c) Insert Tab
d) Layout Tab
90.

Which Word feature displays document structure?

a) Navigation Pane
b) Status Bar
c) Ruler
d) Toolbar

91.

Which Excel function returns position of text?

a) MATCH
b) FIND
c) INDEX
d) LOOKUP

92.

Which Excel function extracts middle characters?

a) MID
b) LEFT
c) RIGHT
d) LEN

93.

Which Excel chart shows trends over time?

a) Line Chart
b) Pie Chart
c) Column Chart
d) Area Chart

94.

Which Excel chart shows relationships between variables?

a) Scatter Chart
b) Pie Chart
c) Line Chart
d) Column Chart

95.

Which Excel feature highlights duplicates?

a) Conditional Formatting
b) Filter
c) Pivot Table
d) Chart
96.

Which Access object automates tasks?

a) Macro
b) Query
c) Form
d) Table

97.

Which Access object retrieves grouped data?

a) Query
b) Table
c) Form
d) Macro

98.

Which Access field type stores large text?

a) Memo
b) Number
c) Date
d) Currency

99.

Which Access field stores date values?

a) Date/Time
b) Text
c) Currency
d) Number

100.

Which Access field stores numeric data?

a) Number
b) Text
c) Date
d) Memo

101.

Which tab in MS Word contains the Font formatting options?

a) Insert
b) Home
c) Layout
d) Review

102.

Which Word feature allows adding comments to a document?

a) Insert Comment
b) Review Comment
c) Comments (Review Tab)
d) Notes

103.

Which Word feature automatically generates a list of headings?

a) Index
b) Table of Contents
c) References
d) Navigation Pane

104.

Which option changes the orientation of a page in Word?

a) Margins
b) Orientation
c) Columns
d) Breaks

105.

Which Word feature allows dividing text into multiple columns?

a) Columns
b) Layout
c) Paragraph
d) Page Setup

106.

Which Excel function returns the current date and time?

a) TODAY()
b) NOW()
c) DATE()
d) TIME()

107.

Which Excel function returns the future value of an investment?

a) FV
b) PMT
c) NPV
d) IRR

108.

Which Excel function calculates Net Present Value?

a) FV
b) PMT
c) NPV
d) RATE

109.

Which Excel function calculates the rate of return?

a) RATE
b) NPV
c) FV
d) SUM

110.

Which Excel feature displays only rows meeting specific criteria?

a) Sort
b) Filter
c) Pivot Table
d) Data Validation

111.

Which Excel feature groups large datasets for analysis?

a) Pivot Table
b) Charts
c) Conditional Formatting
d) Tables

112.

Which Excel function returns TRUE or FALSE based on a condition?

a) SUM
b) IF
c) COUNT
d) MAX

113.
Which Excel operator means not equal to?
a) =
b) <>
c) >
d) <

114.

Which Excel feature automatically applies formatting based on rules?

a) Table Format
b) Conditional Formatting
c) Data Validation
d) Pivot Chart

115.

Which Excel tool removes duplicate values?

a) Remove Duplicates
b) Filter
c) Sort
d) Pivot Table

116.

Which Access object retrieves data using conditions?

a) Table
b) Query
c) Form
d) Report

117.

Which Access feature ensures no duplicate values in a field?

a) Primary Key
b) Foreign Key
c) Index
d) Validation Rule

118.

Which Access feature defines relationships between tables?

a) Relationships Window
b) Table View
c) Form View
d) Query Design

119.
Which Access query retrieves matching records from multiple tables?
a) Select Query
b) Join Query
c) Action Query
d) Parameter Query

120.

Which Access query updates multiple records at once?

a) Select Query
b) Update Query
c) Delete Query
d) Append Query

121.

Which CAAT technique extracts specific records for analysis?

a) Extraction
b) Sampling
c) Stratification
d) Import

122.

Which CAAT technique divides data into groups?

a) Sampling
b) Stratification
c) Summarization
d) Extraction

123.

Which IDEA command combines two databases?

a) Join
b) Import
c) Extract
d) Analyze

124.

Which IDEA command identifies gaps in sequences?

a) Gap Detection
b) Stratification
c) Sampling
d) Extraction

125.
Which IDEA command summarizes totals of fields?
a) Summarization
b) Extraction
c) Join
d) Sampling

126.

Which XML tag defines the root element?

a) First tag in document
b) Last tag
c) Header tag
d) Attribute tag

127.

Which part of XML document defines encoding and version?

a) XML Prolog
b) Root Tag
c) Element
d) Attribute

128.

Which XML feature stores additional information about elements?

a) Tags
b) Attributes
c) Values
d) Nodes

129.

Which XML rule requires closing every opened tag?

a) Tag Matching
b) Nesting Rule
c) Syntax Rule
d) Element Rule

130.

Which XML feature organizes hierarchical data?

a) Tree Structure
b) Table Structure
c) Graph Structure
d) Matrix Structure
131.

Which PowerPoint view allows rearranging slides easily?

a) Normal View
b) Slide Sorter View
c) Reading View
d) Outline View

132.

Which PowerPoint feature applies consistent formatting to slides?

a) Slide Master
b) Themes
c) Layout
d) Templates

133.

Which PowerPoint tab contains slide transition effects?

a) Insert
b) Design
c) Transition
d) Animation

134.

Which PowerPoint feature animates objects on slides?

a) Transition
b) Animation
c) Motion
d) Design

135.

Which key starts slideshow from the beginning?

a) F3
b) F5
c) F7
d) F9

136.

Which key starts slideshow from current slide?

a) Shift + F5
b) Ctrl + F5
c) Alt + F5
d) Shift + Ctrl + F5
137.

Which PowerPoint feature inserts external website links?

a) Hyperlink
b) Bookmark
c) Reference
d) URL

138.

Which PowerPoint element contains speaker notes?

a) Notes Pane
b) Footer
c) Slide Pane
d) Navigation Pane

139.

Which PowerPoint tab inserts charts?

a) Insert
b) Home
c) Design
d) Layout

140.

Which PowerPoint feature organizes slide content layout?

a) Layout
b) Theme
c) Design
d) Format

141.

Which Excel function returns the length of text string?

a) LEN
b) MID
c) LEFT
d) RIGHT

142.

Which Excel function extracts text from the right side?

a) RIGHT
b) LEFT
c) MID
d) LEN
143.

Which Excel function searches vertically in a table?

a) VLOOKUP
b) HLOOKUP
c) MATCH
d) INDEX

144.

Which Excel function searches horizontally?

a) HLOOKUP
b) VLOOKUP
c) INDEX
d) MATCH

145.

Which Excel function returns a value based on position?

a) INDEX
b) MATCH
c) LOOKUP
d) FIND

146.

Which Excel feature creates dropdown lists in cells?

a) Data Validation
b) Filter
c) Table
d) Pivot

147.

Which Excel feature freezes rows or columns?

a) Freeze Panes
b) Lock Cells
c) Split Window
d) Protect Sheet

148.

Which Excel feature protects workbook structure?

a) Protect Workbook
b) Freeze Panes
c) Lock Cells
d) Format Cells
149.

Which Excel feature records repetitive tasks?

a) Macro
b) Formula
c) Pivot Table
d) Chart

150.

Which Excel shortcut creates a new workbook?

a) Ctrl + N
b) Ctrl + W
c) Ctrl + O
d) Ctrl + S