SI (Excise) — Past Questions

SI (Excise) • 2024 • Paper-I

How can you sum the values in cells A1 through A10 in Excel?

A) =SUM(A1:A10)

B) =TOTAL(A1:A10)

C) =ADD(A1:A10)

D) =SUMMARY(A1:A10)

Option B is correct: =TOTAL(A1:A10).

SI (Excise) • 2024 • Paper-I

The largest natural number which divides every natural number of the form (n^2-n)(n-2), where n is a natural number greater than 2 is -

A) 6

B) 48

C) 12

D) 24

Option A is correct: 6.

SI (Excise) • 2024 • Paper-I

The SUMIF function is a premade function in Excel, which calculates the sum of values in a range based on which condition?

A) True

B) False

C) True or False

D) None of the above

Option A is correct: True.

SI (Excise) • 2024 • Paper-I

A and B can do a piece of work separately in 30 days and 20 days. How long will it take for both A and B together to do the work?

A) 12 days

B) 20 days

C) 24 days

D) 25 days

Option A is correct: 12 days.

SI (Excise) • 2024 • Paper-I

An extremely fast memory type that acts as a buffer between RAM and the CPU.

A) Auxiliary

B) Main

C) Cache

D) Virtual memory

Option C is correct: Cache.

SI (Excise) • 2024 • Paper-I

In a college, there are 54 girls who have car. If these constitute one fifth of the girls and the total number of girls is two-fifth of the total number of students in the college, what is the number of boys in the college?

A) 420

B) 410

C) 415

D) 405

Option D is correct: 405.

SI (Excise) • 2024 • Paper-I

A huge capital letter with the width of two or more lines of conventional text that appears at the start of a text block or a paragraph in MS Word.

A) Footnote

B) Drop cap

C) Tab stop

D) Heading

Option B is correct: Drop cap.

SI (Excise) • 2024 • Paper-I

A functionality in Excel which helps you organize and analyze data, and lets you add and remove values, perform calculations, and to filter and sort data sets?

A) Chart

B) Color Scales

C) Data bars

D) Pivot Table

Option D is correct: Pivot Table.

SI (Excise) • 2024 • Paper-I

If a presentation contains one or more macros, PowerPoint automatically saves it as a-

A) .xps

B) .pptm

C) .pptx

D) .ppt

Option B is correct: .pptm.

SI (Excise) • 2024 • Paper-I

An Excel command which lets you copy formatting from one cell to another.

A) Copier

B) Formatter

C) Format painter

D) Duplicator

Option A is correct: Copier.

SI (Excise) • 2024 • Paper-I

A premade function in Excel, which calculates the average of a range based on one or more true or false condition?

A) AVERAGEIFS

B) AVERAGEIF

C) AVERAGE

D) AVG

Option A is correct: AVERAGEIFS.

SI (Excise) • 2024 • Paper-I

In MS Word, a text field where you can enter words and phrases about what you want to do next and quickly get to features you want to use or actions you want to perform.

A) Tellme

B) Search

C) Find

D) Find Me

Option A is correct: Tellme.

SI (Excise) • 2024 • Paper-I

A Window OS utility program that locates and eliminates unnecessary fragments and rearranges files and unused disk space to optimize operations.

A) Disk Defragmenter

B) Task manager

C) Disk Cleanup

D) Backup

Option A is correct: Disk Defragmenter.

SI (Excise) • 2024 • Paper-I

The first wide-area packet-switched network with distributed control and one of the first networks to implement the TCP/IP protocol suite.

A) NSFNET

B) ARPANET

C) DDN

D) SATNET

Option B is correct: ARPANET.

SI (Excise) • 2024 • Paper-I

A typical program creates some remote objects, makes references to these objects accessible, and waits for clients to invoke methods on these objects.

A) Server

B) Client

C) Thread

D) Agent

Option A is correct: Server.

SI (Excise) • 2024 • Paper-I

The main objective of CELL in a cellular mobile system is-

A) Handoff

B) Simple modulation technique

C) Frequency reuse

D) Higher bandwidth

Option C is correct: Frequency reuse.

SI (Excise) • 2024 • Paper-I

The first web browser was invented in 1990 called World Wide Web which was later renamed to

A) Nexus

B) Netscape Navigator

C) Internet Explorer

D) Mosaic

Option A is correct: Nexus.

SI (Excise) • 2024 • Paper-I

An industry consortium that seeks to promote standards for the evolution of the Web and interoperability between www products by producing specifications and reference software.

A) World Wide Web Content

B) World Wide Web Centre

C) World Wide Web Consortium

D) World Wide Web Commission

Option C is correct: World Wide Web Consortium.

SI (Excise) • 2024 • Paper-I

Rose is now a quarter as old as her mother Mary. Four years hence, Mary will be three times as old as her daughter. The age of Mary in years is-

A) 32

B) 34

C) 36

D) 38

Option A is correct: 32.

SI (Excise) • 2024 • Paper-I

When would you use the Ctrl+Alt+Delete keyboard shortcut Windows OS?

A) When a program first opens

B) When you first boot up your computer

C) When a program is unresponsive

D) When you want to delete a file

Option C is correct: When a program is unresponsive.

SI (Excise) • 2024 • Paper-I

If 3, x, 4 are in A.P. The value of x is—

A) 3.5

B) 3

C) 4

D) 5

Option A is correct: 3.5.

SI (Excise) • 2024 • Paper-I

What rate percent is one minute 12 seconds to an hour?

A) 2%

B) 3%

C) 4%

D) 5%

Option A is correct: 2%.

SI (Excise) • 2024 • Paper-I

The mean of 50 numbers was found to be 45. Later on, it was detected that a number 26 was misread as 76. Find the correct mean of the given numbers.

A) 44

B) 46

C) 48

D) 50

Option A is correct: 44.

SI (Excise) • 2024 • Paper-I

Which of the following is not alignment in MS Word?

A) Left alignment

B) Right alignment

C) Middle alignment

D) Center alignment

Option A is correct: Left alignment.

SI (Excise) • 2024 • Paper-I

A private network contained within an enterprise that is used to securely share company information and computing resources among employees.

A) Internet

B) Intranet

C) Extranet

D) Ethernet

Option B is correct: Intranet.

Past Questions — 2024