MS Excel

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

Tab

Ctrl+Enter

Enter

Alt+Enter

Enter

The default style for new data keyed in a new workbook is?  

Comma

Normal

Currency

Percent

Normal

Which of these will not select all the cells in a document?  

Using the Edit – Select All menu

Pressing Ctrl + A on the keyboard

Clicking three times with the right mouse button in the spreadsheet

None of above

Clicking three times with the right mouse button in the spreadsheet

How can we view a cell comment?  

Position the mouse pointer over the cell

Click the comment command on the view menu

Click the edit comment commands on the Insert menu

Click the Display comment command on the window menu

Position the mouse pointer over the cell

What term describes explanatory text attached to a cell?  

Context

Callout

Comment

Dialog

Comment

On an excel sheet the active cell in indicated by ?  

A dotted border

A dark wide border

A blinking border

By italic text

A dark wide border

With which of the following all formulas in excel starts?  

/

*

$

=

=

Which of the following keyboard shortcut can be used for creating a chart from the selected cells?  

F11

F10

F4

F2

F11

Formula palette is used to?  

format cells containing numbers

create and edit formulas containing functions

entered assumptions data

copy all cells

create and edit formulas containing functions

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

Constant

Cell address

Varaible

Static

Constant

A Spreadsheet contains?  

columns

rows

rows and columns

None of above

rows and columns

To open an existing workbook, click the Open button on the ___ toolbar?  

Form

Standard

Drawing

Formatting

Standard

Which among following is not associated with spelling dialogue box?  

Edit

Ignore

Ignore All

Change

Edit

What term describes a background that appears as a grainy, non-smooth surface?  

Pattern

Gradient

Texture

Velvet

Gradient

Macros can be executed from the which of the following menu?  

Format

Home

Insert

Tools

Tools

Except which of the following function, a formula with a logical function shows the word "TRUE" or "FALSE" as a result?  

NOT

OR

IF

AND

IF

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

Transpose

Index

Rows

Hyperlinks

Transpose

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

Pivot Table Report

You can convert existing Excel worksheet data and charts to HTML document by using the?  

Internet Assistant Wizard

Intranet Wizard

Import Wizard

Export Wizard

Internet Assistant Wizard

The cell reference for a range of cells that starts in cell C1 and goes over to column H and down to row 10 is?  

C1:10H

C1:H10

C1:H-10

C1:H:10

C1:H10

Which among following is associated with excel?  

Graphic program

Word Processor

Presentation

Spreadsheet

Spreadsheet

How is data organized in a spreadsheet?  

Rows and columns

Layers and planes

Lines and spaces

Height and width

Rows and columns

Which types of charts can excel produce?  

Line graphs and pie charts only

Bar charts, line graphs and pie charts

Bar charts and line graphs only

Only line graphs

Bar charts, line graphs and pie charts

Which function calculates your monthly mortage payment?  

PV

NPER

PMT

All of above

PMT

How can we set Page Border in Excel?  

From Edit menu

From Home

You can not set page border in Excel

From Tools menu

You can not set page border in Excel

You can check the conditions against ____ when applying conditional formatting?  

Cell Value

Formula

Both of above

None of above

Both of above

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

10

100

300

500

500

Protection and the Protect Sheet options can be selected from?  

Data

Tools

Edit

Format

Tools

VLOOKUP function used to?  

Finds related records

Looks up text that contain "v"

Check if two cells are identical

None of above

Finds related records

Gridlines may be turned off for display but turned on for printing.  

True

False

.....

.....

True

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

Double click the boundary to the right of the column heading

To insert three columns between columns A and B you would  

Select column A

Select A and B

Select B

All of above

Select A and B

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

Ctrl key

Shift key

Alt key

Tab key

Ctrl key

You can activate a cell by?  

Pressing the Tab key

Clicking the cell

Pressing an arrow key

All of above

All of above

A function inside another function is known as?  

Round function

Sandwich function

Switch function

Nested function

Nested function

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

Auto Complete

Data Form

Set Form

Auto Text

Data Form

Which function is used for creating a data table?  

Sum

Table

Add

Count

Sum

The accounting style shows negative numbers in?  

Bold

Italics

Parentheses

Quotes

Parentheses

3-D reference in a formula?  

Spans worksheets

Can not be modified

Only appears on summary worksheets

Limits the formatting options

Spans worksheets

Which among following wildcard characters are recognized by excel ?  

+ and -

! and ^

* and ?

< and >

* and ?

Which of the following is divide symbol in excel?  

/

D

Div

\

/

Shortcut to delete the selected column?  

Ctrl + -

Alt + -

Shift + -

Insert + -

Ctrl + -

Which shortcut can be used to Switch between open workbooks?  

Ctrl + F2

Ctrl + F6

Ctrl + F8

Ctrl + F10

Ctrl + F6

Shortcut to edit the selected cell?  

F3

F8

F4

F2

F2

What is shortcut to enter current date in cell in excel?  

Ctrl + ;

Alt + ;

Shift + &

Ctrl + $

Ctrl + ;

Which function converts miles to kilometers ?  

Change

Covnert

Shift

Conv

Covnert

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

LENGHT

LGT

LT

LEN

LEN

Shortcut to enter current date?  

Home + ;

Shift + ;

Alt + ;

Ctrl + ;

Ctrl + ;

When the formula bar is activated, you can see  

The Edit Formula button

The Cancel button

The Enter button

All of above

All of above

Style sheet formats can be applied from?  

Table >> Autoformat

Format >> Autoformat

Table >> Cells

Fromat >> Cells

Format >> Autoformat

Which function will you use to enter current time in a woksheet cell?  

=time()

=nowtime()

=now()

=currentTime()

=now()

Merge cells option can be applied from?  

Formatting toolbar

Format Cells dialog box Alignment Tab

Both of above

None of above

Format Cells dialog box Alignment Tab

How many recent files you can display on File menu at maximum?  

3

7

9

15

9

The name box appears at the?  

left of the formula bar

right of the formula bar

below the status bar

below the menu bar

left of the formula bar

Which of the following methods cannot be used to edit the content of cell?  

Pressing F2

Clicking the formula bar

Pressing the Alt key

Double clicking the cell

Pressing the Alt key

We can cancel marquee by pressing?  

Ctrl + Esc

Alt + Esc

Shift + Esc

Esc

Esc

What term refers to a specific set of values saved with the workbook?  

Range

File set

Data set

Scenario

Scenario

Insert picture option is in which of the following toolbars?  

Standard

Formatting

Drawing

Picture

Picture

Where are the status indicators located?  

Horizontal Scroll

Vertical Scroll

Formula bar

Address bar

Formula bar

Which among following can't be considered as worksheet criterion?  

Efficiency

Auditability

Clarity

Description

Description

When creating a vertical page break?  

The active cell must be in row 1

The active cell must be A1

The active cell must be in row 10

The active cell must be in column A

The active cell must be in row 1

The intersection of row and column is called a ?  

dataset

cell

data

set

cell

You will use which feature in excel, if you want to work with one record at a time?  

Auto Complete

Auto Filter

Sub Totals

Data Form

Data Form

Which dialogue box we can use to name a constant?  

Create Name

Define Name

Get Name

Create Constant

Define Name

One cell format can be copied to another cell by using?  

Format Painter

Format Setting

Format Showing

Format Checking

Format Painter

Which among following is types of excel data types?  

Numbers, Formulas, Labels

Data, Words, Numbers

Words, Number, Labels

Equations, Data, Numbers

Numbers, Formulas, Labels

To convert a column of data into the row, which command will you choose  

Edit -> Paste Special -> Transpose

Cut and Paste

Both of above

None of above

Edit -> Paste Special -> Transpose

In Paste Special dialog box, which of the following option is not available?  

Divide

Add

Subtract

Square root

Square root

When you press Ctrl + X after selecting some cells in Excel, what will happen then  

The cell content of selected cells disappear from cell and stored in clipboard

The selected cells are deleted and cells are shifted up

The selected cells are deleted and the cells are shifted left

The cells selected are marked for cutting

The cells selected are marked for cutting

In Excel Worksheet how can you show or hide the gridlines?  

Click Gridline tool on Forms toolbar

Go to Tools -> Options -> View tab and mark or remove the check box named Gridline

Both of above

None of above

Both of above

Choose from the following, which is not the correct method of editing the cell content?  

Press the Alt key

Press the F2 key

Double click the cell

Click the formula bar

Press the Alt key

On Excel screen, Tab scroll buttons are  

towards the top left corner

towards the top right corner

towards the bottom right corner

towards the bottom left corner

towards the bottom left corner

To join some cells and place the content in the middle of the joined cell, which tool you will use?  

From Format Cells dialog box choose Merge and Center check box

Click on Merge and Center tool on formatting toolbar

From Format Cells dialog box select the Centered alignment

From Format Cells dialog box click on Merge Cells check box

Click on Merge and Center tool on formatting toolbar

Using Paste Special command which of the following you can paste selectively  

Formulas

Validation

Formats

All of above

All of above