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 24

If you press ____, the cell accepts your typing as its contents?

Tab

Ctrl + Enter

Enter

Alt + Enter

SHOW ANSWER

Formula palette is used to?

Format cells containing numbers

Create and edit formulas containing functions

Entered assumptions data

Copy all cells

SHOW ANSWER

A value used in a formula that does not change is called a____

Constant

Cell address

Variable

Static

SHOW ANSWER

To create an interactive pivot Table for the web, you use a Microsoft office web component called?

HTML

Pivot Table Field List

Pivot Table Report

Pivot Table List

SHOW ANSWER

What function displays row data in a column or column data in a row?

Transpose

Index

Rows

Hyperlinks

SHOW ANSWER

Expect which of the following function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result?

NOT

OR

IF

AND

SHOW ANSWER

Which of the following is not a valid zoom percentage in Excel?

10

100

300

500

SHOW ANSWER

How can we set Page Border in Excel?

From Edit menu

From Home

You cannot set page border in Excel

From Tools menu

SHOW ANSWER

VLOOKUP function used to?

Finds related records

Looks up text that contain “V”

Check if two cells are identical

None of the above

SHOW ANSWER

How do you change column width to fit the contents?

Single – click the boundary to the left to the column heading

Double – click the boundary to the right of the column heading

Press Alt and single click anywhere in the column

All of above

SHOW ANSWER

To drag a selected range of data to another worksheet in the same  Workbook, use the?

Ctrl Key

Shift Key

Alt Key

Tab Key

SHOW ANSWER

What excel feature  can you uses if you want to work with one record at a time?

Auto complete

Data Form

Set Form

Auto Text

SHOW ANSWER

Which function in excel counts the numbers of characters in a cell? 

LENGTH

LGT

LT

LEN

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