Microsoft Excel - General Knowledge Question and Answer

Microsoft Excel - Question and Answer

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


Tab
Ctrl+Enter
Enter
Alt+Enter

Answer:

Enter

Share Me:

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


Comma
Normal
Currency
Percent

Answer:

Normal

Share Me:

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

Answer:

Clicking three times with the right mouse button in the spreadsheet

Share Me:

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

Answer:

Position the mouse pointer over the cell

Share Me:

What term describes explanatory text attached to a cell?  


Context
Callout
Comment
Dialog

Answer:

Comment

Share Me:

On an excel sheet the active cell in indicated by ?  


A dotted border
A dark wide border
A blinking border
By italic text

Answer:

A dark wide border

Share Me:

With which of the following all formulas in excel starts?  


/
*
$
=

Answer:

=

Share Me:

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


F11
F10
F4
F2

Answer:

F11

Share Me:

Formula palette is used to?  


format cells containing numbers
create and edit formulas containing functions
entered assumptions data
copy all cells

Answer:

create and edit formulas containing functions

Share Me:

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


Constant
Cell address
Varaible
Static

Answer:

Constant

Share Me:

A Spreadsheet contains?  


columns
rows
rows and columns
None of above

Answer:

rows and columns

Share Me:

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


Form
Standard
Drawing
Formatting

Answer:

Standard

Share Me:

Which among following is not associated with spelling dialogue box?  


Edit
Ignore
Ignore All
Change

Answer:

Edit

Share Me:

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


Pattern
Gradient
Texture
Velvet

Answer:

Gradient

Share Me:

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


Format
Home
Insert
Tools

Answer:

Tools

Share Me:

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

Answer:

IF

Share Me:

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


Transpose
Index
Rows
Hyperlinks

Answer:

Transpose

Share Me:

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

Answer:

Pivot Table Report

Share Me:

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


Internet Assistant Wizard
Intranet Wizard
Import Wizard
Export Wizard

Answer:

Internet Assistant Wizard

Share Me:

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

Answer:

C1:H10

Share Me:

Which among following is associated with excel?  


Graphic program
Word Processor
Presentation
Spreadsheet

Answer:

Spreadsheet

Share Me:

How is data organized in a spreadsheet?  


Rows and columns
Layers and planes
Lines and spaces
Height and width

Answer:

Rows and columns

Share Me:

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

Answer:

Bar charts, line graphs and pie charts

Share Me:

Which function calculates your monthly mortage payment?  


PV
NPER
PMT
All of above

Answer:

PMT

Share Me:

How can we set Page Border in Excel?  


From Edit menu
From Home
You can not set page border in Excel
From Tools menu

Answer:

You can not set page border in Excel

Share Me:

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


Cell Value
Formula
Both of above
None of above

Answer:

Both of above

Share Me:

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


10
100
300
500

Answer:

500

Share Me:

Protection and the Protect Sheet options can be selected from?  


Data
Tools
Edit
Format

Answer:

Tools

Share Me:

VLOOKUP function used to?  


Finds related records
Looks up text that contain "v"
Check if two cells are identical
None of above

Answer:

Finds related records

Share Me:

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


True
False
.....
.....

Answer:

True

Share Me:

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

Answer:

Double click the boundary to the right of the column heading

Share Me:

To insert three columns between columns A and B you would  


Select column A
Select A and B
Select B
All of above

Answer:

Select B

Share Me:

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


Ctrl key
Shift key
Alt key
Tab key

Answer:

Ctrl key

Share Me:

You can activate a cell by?  


Pressing the Tab key
Clicking the cell
Pressing an arrow key
All of above

Answer:

All of above

Share Me:

A function inside another function is known as?  


Round function
Sandwich function
Switch function
Nested function

Answer:

Nested function

Share Me:

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

Answer:

Data Form

Share Me:

Which function is used for creating a data table?  


Sum
Table
Add
Count

Answer:

Table

Share Me:

The accounting style shows negative numbers in?  


Bold
Italics
Parentheses
Quotes

Answer:

Parentheses

Share Me:

3-D reference in a formula?  


Spans worksheets
Can not be modified
Only appears on summary worksheets
Limits the formatting options

Answer:

Spans worksheets

Share Me:

Auto calculate feature provides a quick way to view the results of an arithmetic operation on a range of cells.  


True
False

Answer:

True

Share Me:

Which among following wildcard characters are recognized by excel ?  


+ and -
! and ^
* and ?
< and >

Answer:

* and?

Share Me:

Which of the following is divide symbol in excel?  


/
D
Div
\

Answer:

/

Share Me:

Shortcut to delete the selected column?  


Ctrl + -
Alt + -
Shift + -
Insert + -

Answer:

Ctrl + -

Share Me:

Which shortcut can be used to Switch between open workbooks?  


Ctrl + F2
Ctrl + F6
Ctrl + F8
Ctrl + F10

Answer:

Ctrl + F6

Share Me:

Each excel can contain many sheets including worksheets and chart sheets.  


True
False

Answer:

True

Share Me:

Shortcut to edit the selected cell?  


F3
F8
F4
F2

Answer:

F2

Share Me:

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


Ctrl + ;
Alt + ;
Shift + &
Ctrl + $

Answer:

Ctrl + ;

Share Me:

Which function converts miles to kilometers ?  


Change
Covnert
Shift
Conv

Answer:

Convert

Share Me:

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


LENGHT
LGT
LT
LEN

Answer:

LEN

Share Me:

Shortcut to enter current date?  


Home + ;
Shift + ;
Alt + ;
Ctrl + ;

Answer:

Ctrl + ;

Share Me:

When the formula bar is activated, you can see  


The Edit Formula button
The Cancel button
The Enter button
All of above

Answer:

All of above

Share Me:

Style sheet formats can be applied from?  


Table >> Autoformat
Format >> Autoformat
Table >> Cells
Fromat >> Cells

Answer:

Format >> Autoformat

Share Me:

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


=time()
=nowtime()
=now()
=currentTime()

Answer:

=now()

Share Me:

Merge cells option can be applied from?  


Formatting toolbar
Format Cells dialog box Alignment Tab
Both of above
None of above

Answer:

Format Cells dialog box Alignment Tab

Share Me:

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


3
7
9
15

Answer:

9

Share Me:

The name box appears at the?  


left of the formula bar
right of the formula bar
below the status bar
below the menu bar

Answer:

left of the formula bar

Share Me:

When you use multiplication, division or exponentiation in a formula then there is chance of occurring rounding errors  


True
False

Answer:

True

Share Me:

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

Answer:

Pressing the Alt key

Share Me:

We can cancel marquee by pressing?  


Ctrl + Esc
Alt + Esc
Shift + Esc
Esc

Answer:

Esc

Share Me:

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


Range
File set
Data set
Scenario

Answer:

Scenario

Share Me:

Insert picture option is in which of the following toolbars?  


Standard
Formatting
Drawing
Picture

Answer:

Picture

Share Me:

Where are the status indicators located?  


Horizontal Scroll
Vertical Scroll
Formula bar
Address bar

Answer:

Formula bar

Share Me:

Entire worksheet can not be selected in one time.  


True
False
False

Answer:

False

Share Me:

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


Efficiency
Auditability
Clarity
Description

Answer:

Description

Share Me:

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

Answer:

The active cell must be in row 1

Share Me:

The intersection of row and column is called a ?  


dataset
cell
data
set

Answer:

cell

Share Me:

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

Answer:

Data Form

Share Me:

Which dialogue box we can use to name a constant?  


Create Name
Define Name
Get Name
Create Constant

Answer:

Define Name

Share Me:

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


Format Painter
Format Setting
Format Showing
Format Checking

Answer:

Format Painter

Share Me:

Which among following is types of excel data types?  


Numbers, Formulas, Labels
Data, Words, Numbers
Words, Number, Labels
Equations, Data, Numbers

Answer:

Numbers, Formulas, Labels

Share Me:

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

Answer:

Edit -> Paste Special -> Transpose

Share Me:

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


Divide
Add
Subtract
Square root

Answer:

Square root

Share Me:

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

Answer:

The cells selected are marked for cutting

Share Me:

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

Answer:

Both of above

Share Me:

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

Answer:

Press the Alt key

Share Me:

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

Answer:

towards the bottom left corner

Share Me:

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

Answer:

Click on Merge and Center tool on formatting toolbar

Share Me:

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


Formulas
Validation
Formats
All of above

Answer:

All of above

Share Me: