Call
whatsapp
9447387064 | 9847003556
0471-2335855 | 8089080088 | 0471-2334855
9447387064 | 9847003556
0471-2335855 | 8089080088 | 0471-2334855
Cisco Training in Trivandrum, Trinity Technologies

No.1 Training Institute in Kerala

PCS - QUESTIONS : PART 22

In Excel, by default Numeric Values appears in

Left aligned

Right aligned

Center aligned

Justify aligned

SHOW ANSWER

In Excel _____may not contain in Formula 

Text Constant

Number Constant

Circular Reference

All of the above

SHOW ANSWER

What should be adding before a fraction to avoid entering it as a date?

 //

Zero

Space

None of the above

SHOW ANSWER

In Excel, a Data series is defined as what?

A collection of related data

A type of chart

A cell reference

None of the above

SHOW ANSWER

Text Formula

Replace cell references

Return ASCII value of characters

Concatenate and manipulate text

None of the above

SHOW ANSWER

The Name Box

Appears below the status bar

Appears to the left of the formula bar

Shows the location of the previously active cell

None of the above

SHOW ANSWER

Hyperlinks can be

Text

Picture

Drawing

All of the above

SHOW ANSWER

To create formula, you can use

Values and cell references

Values but not cell references

Cell references but not values

None of the above

SHOW ANSWER

Which of the following is the oldest spreadsheet package?

Excel

Starcalc

VisiCalc

None of the above

SHOW ANSWER

Which of the following is an absolute cell reference?

!A!1

$A$1

#A#1

A1

SHOW ANSWER

What symbol is used before a number to make it a label?

 “(quote)

=(equal)

–(underscore)

‘(apostrophe)

SHOW ANSWER

Which of the following formulas is not entered correctly?

=10+50

=B7*B5

=B7+14

10+15

SHOW ANSWER

Which of the following formulas will Excel Not be able to calculate?

=SUM(Sales)-A3

 =SUM(A1:A5)*.5

=SUM(A1:A5)/(10-10)

=SUM(A1:A5)-10

SHOW ANSWER
BACK | NEXT
TRINITY SOFTWARE SOLUTIONS,IInd floor, Radheyam Towers, Gandhari Amman Kovil Road, Pulimood, Trivandrum - 1
0471-2334855 | 2335855 | 9447387064 | 9847003556 info@trinitytechnology.in