Accenture MS Office

Important Excel Formulas :

1. SUMIFS

Adds up all numbers in a range based on multiple criteria.

Syntax: `=SUMIFS(sum_range, criteria_range1, criteria1,

[criteria_range2, criteria2], ...)`

Example:

UF
=SUMIFS(A1:A10, B1:B10, ">10", C1:C10, "Active")

2. INDEX and MATCH

Used together to look up values in a table.

O
Syntax for INDEX: `=INDEX(array, row_num, [column_num])`

Syntax for MATCH: `=MATCH(lookup_value, lookup_array,

KN

[match_type])`

Example:

=INDEX(A1:C10, MATCH(E1, A1:A10, 0), 2)

TE

This finds the row where `E1` matches a value in `A1:A10` and
returns the value from the 2nd column of `A1:C10`.

3. VLOOKUP

Looks up a value in the first column of a range and returns a value

in the same row from a specified column.

Syntax: `=VLOOKUP(lookup_value, table_array, col_index_num,

[range_lookup])`

UBK ANNA
 Accenture MS Office

Example:

=VLOOKUP(E1, A1:C10, 3, FALSE)

4. IF and Nested IF

Performs logical tests and returns different values based on the

UF
results.

Syntax: `=IF(logical_test, value_if_true, [value_if_false])`

Example:

=IF(A1 > 10, "High", IF(A1 > 5, "Medium", "Low"))

O
5. SUMPRODUCT
KN

Multiplies corresponding elements in arrays and returns the sum

of those products.

Syntax: `=SUMPRODUCT(array1, [array2], [array3], ...)`

Example:
TE

=SUMPRODUCT(A1:A10, B1:B10)

6. ARRAYFORMULA

Allows for array operations in Google Sheets.

Syntax: `=ARRAYFORMULA(array_formula)`

UBK ANNA
 Accenture MS Office

Example:

=ARRAYFORMULA(A1:A10 * B1:B10)

7. OFFSET

Returns a reference to a range that is a specified number of rows

and columns from a cell or range of cells.

UF
Syntax: `=OFFSET(reference, rows, cols, [height], [width])`

Example:

=SUM(OFFSET(A1, 1, 1, 3, 1))
O
8. INDIRECT

Returns the reference specified by a text string.

KN

Syntax: `=INDIRECT(ref_text, [a1])`

Example:
TE

=INDIRECT("A" & B1)

9. CHOOSE

Returns a value from a list of values based on a given position.

Syntax: `=CHOOSE(index_num, value1, [value2], ...)`

Example:

UBK ANNA
 Accenture MS Office

=CHOOSE(A1, "Red", "Blue", "Green")

10. TEXT Functions

TEXT: Converts a number to text in a specified format.

UF
Syntax: `=TEXT(value, format_text)`

Example:

=TEXT(A1, "0.00")
O
CONCATENATE: Joins multiple text strings into one.

Syntax: `=CONCATENATE(text1, [text2], ...)`

KN

Example:

=CONCATENATE(A1, " ", B1)

TE

11. LOGICAL Functions

AND: Returns TRUE if all arguments are TRUE.

Syntax: `=AND(logical1, [logical2], ...)`

Example:

=AND(A1 > 10, B1 < 5)

OR: Returns TRUE if any argument is TRUE.

UBK ANNA
 Accenture MS Office

Syntax: `=OR(logical1, [logical2], ...)`

Example:

=OR(A1 > 10, B1 < 5)

UF
12. Financial Functions

NPV: Calculates the net present value of an investment.

Syntax: `=NPV(rate, value1, [value2], ...)`

Example:
O
=NPV(0.1, A1:A10)
KN

IRR: Calculates the internal rate of return for a series of cash

flows.

Syntax: `=IRR(values, [guess])`

Example:
TE

=IRR(A1:A10)

13. Date and Time Functions

DATE: Returns the serial number of a particular date.

Syntax: `=DATE(year, month, day)`

Example:

UBK ANNA
 Accenture MS Office

=DATE(2023, 7, 11)

NETWORKDAYS: Returns the number of whole working days

between two dates.

Syntax: `=NETWORKDAYS(start_date, end_date, [holidays])`

UF
Example:

=NETWORKDAYS(A1, B1)

14. Statistical Functions

O
AVERAGEIF: Returns the average of all cells that meet a given
criteria.

Syntax: `=AVERAGEIF(range, criteria, [average_range])`

KN

Example:

=AVERAGEIF(A1:A10, ">5", B1:B10)

TE

COUNTIF: Counts the number of cells that meet a given criteria.

Syntax: `=COUNTIF(range, criteria)`

Example:

=COUNTIF(A1:A10, ">5")

UBK ANNA
 Accenture MS Office

1. There can be many ways to insert page numbers in a document.

Which of the following lets you insert page number ?

Page number from Insert menu

Footnote from Insert menu
Page Setup from file menu
Both a & c

Ans : A

UF
2. You can jump to the next column by?

Press Alt + Down-arrow

Both of above
Clicking with your mouse on the next column
None of above

Ans : B
O
3. How to insert a sound file in a word document ?

From insert -> sound menu option

KN

From insert -> subject menu option

From insert -> object menu option
From insert -> file menu option

Ans: B
TE

4. Which of the following options is not available in Insert >>

Picture?

Chart
Graph
Clip Art
Word Art

Ans : B

UBK ANNA
 Accenture MS Office

What should you do if you require pasting the same format in

many places?

Double click the format painter then go on pasting in many places

Click the format painter then go on pasting to many places
holding Ctrl Key
Click the Format painter and go on pasting in many places holding
Alt Key All of above

Ans: A

UF
Which of the given combinations of File type and its extension is
incorrect?

MS Word - .doc
MS Excel - .xis
MS PowerPoint - .ppt|
MS Outlook - .out
O
Ans : D

Name the Desktop Database application that is part of MS Office

KN

suit.

MS word
MS Access
MS PowerPoint
MS Excel
TE

Ans : B

lock in an MS Excel spreadsheet where a column and row

intersects each other is called What shall come in place of the
blank?
Keyblock
Cell
Square
Box
Ans : B

UBK ANNA
 Accenture MS Office

If you need to double underline a word, how will you do that?

From Format menu choose Font option and then from Font tab
open Underline Style and select double Underline
Click double underline tool on formatting toolbar
Go to Format menu and then Font option. Open Underline Style
and choose Double Underline
Select the text then choose Format >> Font and on Font tab open
Underline Style and choose Double Underline

UF
Ans : D

How to use Format Painter multiple times ?

By Click on Lock Format Painter Icon

By Double Click on the Format Painter Icon
Format Painter cannot be use multiple time
None of above
O
Ans : B

Which menu / group will we use if we want to change the typeface

KN

of selected text ?

Edit
View
Format
Tools
TE

Ans : C

What is the default font used in MS Word documents?

Calibri
Algerian
Arial
None of the above

Ans : A

UBK ANNA
 Accenture MS Office

It is possible to___a data source before performing a merge.

Modify
Create
Sort
All of the above

Ans : D

Which is not a type of margin ?

UF
Top
Right
Left
Center

Ans : D
O
what is a portion of a document in which you set certain page
formatting options?

Page Setup
KN

Section
Page
Document

Ans : B
TE

Can we edit a Macro programmatically after recording it ?

Yes
Don't know
No
Might be

Ans : A

UBK ANNA
 Accenture MS Office

What is gutter margin ?

Margin that is added to right margin when printing

Margin that is added to the outside of the page when printing
Margin that is added to the left margin when printing
Margin that is added to the binding side of page when printing

Ans : D

Office 365 is now the most popular cloud application in the world.

UF
But when did it debut?

2008
2010
2001
2014

Ans : C
O
Starting with Microsoft Office 2003, Photo Editor was renamed to
:
Photo manager
KN

Paint Editor
Picture Manager
Picture Editor

Ans : C
TE

Digital Circuits are made up of:

Logic Gate
Transistors
Di-ods
All of the above

Ans : D

UBK ANNA
 Accenture MS Office

E-Commerce is :

Online Shopping
Buying and Selling of products over an electronic system
Digital Marketing
All of the above

Ans : B

A Web browser deals with:

UF
Internet
Web Surfing
HTML
All of the above

Ans : D
O
What connects various components within the computer:

Registers
Flip flop
KN

System Bus
None of the above

Ans : C

Which of the following is not a type of Random Access Memory:

TE

DRAM
SRAM
PROM
None of the above

Ans : C

UBK ANNA
 Accenture MS Office

The motherboard consists of :

RAM
CPU
ROM
All of the above

Ans : D

Which of the following is the output device:

UF
Microphone
Monitor
Keyboard
All of the above

Ans : B
O
What is writing:

process of copying data from memory location

process of fetching data from input devices
KN

process of putting data into a memory location

None of the above

Ans: C

Main Memory is commonly known as:

TE

ROM
HDD
RAM
SSD

Ans : C

UBK ANNA
 Accenture MS Office

What is Computer Virus?

Hardware
USB
Software
Bacteria

Ans : C

What allows a computer to store data electronically:

UF
ROM
Cache
RAM
BUS

Ans : C
O
It holds frequently requested data and instructions so that they
are immediately available to the CPU when needed:

Register
KN

RAM
BUS
Cache

Ans : D
TE

Integrated Circuits are made of :

Silica
Silicon
Chromium
None of the above

Ans : B

UBK ANNA
 Accenture MS Office

Who is Seymour Cray:

Father of Computer
Inventor of Supercomputer
Inventor of Memory Devices
Inventor of ABACUS

Ans : B

Windows is an example of :

UF
Application Software
Package
System Software
Operating System

Ans : D
O
A component of a circuit that allows current to pass in one
direction yet blocks the flow of current in the other direction

Flip flop
KN

Comparator
Diode
Attenuator

Ans : C
TE

Which of the following is Volatile memory?

ROM
Hard Disks
RAM
Floppy

Ans : C

UBK ANNA
 Accenture MS Office

Wien generation of computers was based on integrated circuits?

First Generation
Second Generation
Third Generation
Fourth Generation

Ans : C

____ is a standard network protocol used for the transfer of

UF
computer files between a client and a server on a computer
network.

SMTP
TCP
SNMP
FTP
O
Ans : D

____ draw lines on paper using a pen.

KN

Keyboard
Scanner
Plotter
OMR

Ans : C
TE

Choose the statement that doesn't stand in support of Conditional

Formatting?
You can add more than one condition to check
You can apply Font, border and pattern formats that meets the
specified conditions
You can delete any condition from Conditional Formatting dialog
box if it is not required
You can set condition to look for Bold and apply Italics on them

Ans : D

UBK ANNA
 Accenture MS Office

Which of these option do you use if you need all the numbers
between 0 and 100 in a range to be displayed in Red Color, apply

Use =if() function to format the required numbers red

Apply Conditional Formatting command on Format menu
Select the cells that contain number between 0 and 100 then
click Red color on Text Color tool
All of above

Ans : B

UF
Select the right procedure from the below to remove borders
applied in cells?

Choose None on Border tab of Format cells

Open the list on Border tool in Format Cell toolbar then choose
first tool (none)
Both of above
O
None of above

Ans : C
KN

What is the procedure of selecting one hyperlink after another

during a slide presentation?

Ctrl + K
Ctrl + H
Tab
TE

Ctrl + D

Ans : C

UBK ANNA
 Accenture MS Office

A Power Point slide can include which of these following?

JPS
mp4
gif
All of the above

Ans : D

What happens when you release mouse pointer after you drop the

UF
primary key of a table into foreign key of another table?

A relationship is created
Edit relationship dialog box appears
Error occurs
Nothing happens

Ans : B
O
To specify margins in word, the user has to select Page Setup
option from which menu?
KN

Auto correct
Edit
File
Table

Ans : C
TE

Which of the following options can be used as a collective design

element for your document?

Highlight
Formatting
Line spacing
Theme

Ans : D

UBK ANNA
 Accenture MS Office

A word processor would be used best to

paint a picture
draw a diagram
workout income and expenses
type a story

Ans : D

MS Access is considered to be DBMS. Give the full form of S in

UF
DBMS:

Software
Solution
System
Settings

Ans : C
O
The cell reference for a range of cells that starts in cell F2 and
goes over to column I and down to row 12 is?
KN

F2:I12
F-2:I-12
12:F2
I-12:F-2

Ans : A
TE

Choose the combination of file type and its extension that is

incorrect:

MS Word - doc
MS PowerPoint - ppt
MS Excel - exi
MS Outlook - ost

Ans : C

UBK ANNA
 Accenture MS Office

Which of these shortcut keys can be used to align the text to the
left side of the document in MS Word?

Alt+L
Allt +Spacebar
CtrI+L
Tab+L

Ans : C

UF
Choose one among these options that doesn't form a part of
standard office suite ?

Database
File Manager
Image Editor
Word Processor
O
Ans : B

What is the maximum number of columns that you insert in a word

doc?
KN

63
55
50
65
TE

Ans : A

Which of these keys is used for a spellcheck?

Alt + F5
Alt + F7
Alt + F6
Alt + F8

Ans : B

UBK ANNA
 Accenture MS Office

What is the Short cut key for line break?

CTRL + Enter
Shift + Enter
Alt + Enter
Space + Enter

Ans : B

Choose the option that is not found on the Ruler of MS Word

UF
screen ?

Tab stop box

Right Indent
Left Indent
Center Indent

Ans : D
O
Under which menu can you find Typeface option?

Edit
KN

Format
View
Tools

Ans : B
TE

Which power point view displays each slide of the presentation as

a thumbnail and is useful for rearranging slides ?

Slide Sorter
Slide show
Slide master
Notes Page

Ans : A

UBK ANNA
 Accenture MS Office

You cannot close MS Office application by

Exit from File menu

Clicking the cross Button
Pressing Alt+F4
Close from File Menu

Ans : D

In PowerPoint, the Header & Footer button can be found on the

UF
insert tab in what group?

Illustrations group
Object group
Text group
Tables group

Ans : C
O
To save an existing file with a new location we
should........command.
KN

save
save and replace
save as
New file

Ans : C
TE

When one of the following software applications would be the

most appropriate for performing numerical and statistical
calculations?

Data base
Document processor
Graphics package
Spreadsheet

Ans : D

UBK ANNA
 Accenture MS Office

Which one is the most suitable reason to use Macro in MS Office

(Word, Excel, PPT, etc)?

To Record Sound
To automate repeatative tasks
To Record Mouse Move
To Record Keystroke

Ans : B

UF
The letter and number of the intersecting column and row is the-

Cell location
Cell address
cell position
Cell coordinates

Ans : B
O
What is the overall term for creating, editing, formatting, storing
retrieving, and printing a text document?
KN

Word processing
Spreadsheet design
Web design
Database management

Ans : A
TE

Which feature is used to make a selected sentence to All Capital

Letters or All Small Letters?

Change Letter
Change Sentence
Change Case
Change Word

Ans : C

UBK ANNA
 Accenture MS Office

The web standard allows programmers on many different

computer platforms to dispersed format and display the
information server. These programs are called

Internet Explorer
Chrome
HTML
Web Browsers

Ans : D

UF
Tools for importing and exporting data in SQL server

PTS
BULK inserts statement
bcp command utility
ALL of the above
O
Ans : D

is the multiplexing technique that shifts each signal to a different

carrier frequency.
KN

PDMI
TOM
FDM
Both FDM & TDM
TE

Ans : C

The difference between T568A and T568B is

Just different length of wires

Just different manufacturer standards
Difference in wire color
Difference in number of wires

Ans : B

UBK ANNA
 Accenture MS Office

ten layer of the OSI reference model does IPsec work at?

Layer 1
Layer 3
Layer 2
Layer 4

Ans : B

Which of the following is not correct for DELETE and TRUNCATE?

UF
TRUNCATE table can have criterial
TRUNCATE table cannot have triggers
DELETE table can be rolled back
DELETE table can have criteria

Ans : A
O
Which organization has authority over interstate and international
commerce in the communications field?

ISOC
KN

FCC
ITU-T
IEEE

Ans : B
TE

A cursor that reflects the changes made to the database table

even after the result set is returned

ORWARD_ONLY
Static
Keyset
Dynamic

Ans : D

UBK ANNA
 Accenture MS Office

The tag used to create a new list item and also include a
hyperlink is

<UL>
<LI>
<DL>
<DD>

Ans : B

UF
Traffic in a VPN is NOT

logically separated from other traffic

Invisible from public networks
Restricted to a single protocol in IPsec
Accessible from unauthorized public networks

Ans : D
O
In the layer hierarchy, as the data packet moves from the upper to
the lower layers, headers are _
KN

Removed
Added
Modified
Rearranged

Ans : B
TE

Choose the incorrect option about the SQL server index

More than one clustered index on a table

Only one clustered index on a table
Two types of indexes - clustered indexes and non-clustered
indexes
Both types use B-TREE for searching data

Ans : A

UBK ANNA
 Accenture MS Office

Any part of the graphic that is not included in another hot zone is
considered to be part of

rect
default
point
polygon

Ans : B

UF
In a network, If P is the only packet being transmitted and there
was no earlier transmission, which of the following delays could
be zero

Queuing delay
Processing delay
Transmission delay
Propagation delay
O
Ans : A

A list of protocols used by a system, one protocol per layer, is

called __
KN

protocol system
protocol architecture
protocol suite
protocol stack
TE

Ans : d

Which of the following rules below are true to use the

ROWGUIDCOL property to define a globally unique identifier
column?

A ROWGUIDCOL column must not be defined by using the unique

identifier data type.
A table can have only one ROWGUIDCOL column
NEWID function to generate a globally unique value.
None

Ans : B
UBK ANNA
 Accenture MS Office

The extensible authentication protocol is an authentication

framework frequently used in _..._

Wired local area network

Wired personal area network
Wireless networks
Wired metropolitan area network

Ans : C

UF
Which type of integrity preserves the defined relationship
between tables when records are entered or deleted?

Domain integrity
Entity integrity
User-defined integrity
Referential integrity
O
Ans : D
KN
TE

Solve this type of formula based problems more

, find the real questions from insta bio

UBK ANNA
AFFORDABLE PLACEMENT MATERIALS

UF
O
69 X 6 = 414/- PAY ONLY
KN

249/-

TO GET 👆🏽
DM - 👇🏽
TE

INSTAGRAM.COM/TEKNO.UF

2025
youtube.com/@teknouf
ubk anna