### 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

A collection of related data

SHOW ANSWER
Text Formula

Replace
cell references

Return
ASCII value of characters

Concatenate and manipulate text

None of the above

Concatenate and manipulate text

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

Appears to the left of the formula bar

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

Values and cell references

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