Ms-Excel

 



MICROSOFT 

EXCEL

 User developed instruction for excel are called__________?

A. Progrms
B. Macros
C. Procedured
D. All of these

Computer spreadsheet cell that is highlighted with a heavy border is a _________ ?

A. Active cell
B. Cell containing a formula
C. Locked cell
D. Cell

Which of these keys are used in Ms Excel to copy value from above cell?

A. Ctrl + “
B. Ctrl+ E
C. Ctrl+ E
D. Ctrl+ D

Which key is used for help in Ms Excel?

A. F1
B. F2
C. F3
D. None of these

Which one is example of spreadsheet software?

A. MS WORD
B. MS EXCEL
C. MS POWERPOINT
D. None of these

 

With which of the following all formulas in excel starts ?

A. /
B. *
C. $
D. =

Comment put on Excel cell which is displayed by taking the Mouse Pointer there, is called__________?

A. Smart tip
B. Soft Tip
C. Web Tip
D. Cell Tip

In MS Excel to delete duplicate values which menu is used?

A. Data
B. Tools
C. Formatting
D. Layout

How many rows are in one Microsoft Excel sheet?

A. 65,536
B. 16,384
C. 1,048,576
D. None of Above

How many columns are in one Microsoft Excel sheet?

A. 65,536
B. 16,384
C. 1,048,576
D. None of Above

To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called?

A. Pivot Table Report
B. Pivot Table List
C. Pivot Table Field List
D. HTML

Which among following is not associated with spelling dialogue box?

A. Edit
B. Ignore All
C. Ignore
D. Change

You can edit existing Excel data by pressing the:________ key?

A. F1 Key
B. F2 Key
C. F3 Key
D. F4 Key

When you insert an Excel file into a word document, the data are?

A. Hyperlinked
B. placed in a word table
C. linked
D. embedded

The Greater Than sign is an example of ________ operation ?

A. Arithmetic
B. Logical
C. Conditional
D. Greater

Which function displays row data into column or column data into row?

A. Hyperlink
B. Index
C. Transpose
D. Rows

Microsoft Office Inter Connect is:

A. An application that supports editing scanned documents
B. None of these
C. Business-relationship database
D. A scanning and OCR application

Microsoft Office Accounting is:

A. A tool for managing business finances
B. None of these
C. Project management software to keep track of events and to create network charts and Gantt charts
D. Diagram and flow-charting software

Microsoft Office Suite spreadsheet program is _________?

A. None of these
B. Microsoft Word
C. Microsoft Excel
D. Microsoft PowerPoint

Move to Next Sheet in Ms Excel:

A. Ctrl + Page Down
B. Shift + Page Down
C. Page Down
D. None of these

Move to next cell in row in Ms Excel:

A. Tab
B. Shift
C. Space
D. None of these

Which of these keys are used in Ms Excel to copy formula from above cell?

A. Ctrl+ ”
B. Ctrl+ ;
C. Ctrl+ :
D. Ctrl+ ‘

Which function calculates the largest value in a set of numbers?

A. Average
B. Count
C. Minimum
D. Maximum

What displays the content of active cell?

A. Name box
B. Row headings
C. Formula bar
D. None of these

Microsoft Excel 2019 files have a default extension of___________?

A. .Xlsx
B. .Xls
C. .excel
D. .123

Which of the following is the latest version of MS Excel?

A. Excel 2016
B. Excel 2017
C. Excel 2019
D. Office 365

Ctrl+Shift+1 shortcut Keys in excel are used to __________?

A. Format number in comma format
B. Format number in currency format
C. Format number in date format
D. Format number in time format

 

Which Shortcut keys are used to strikethrough highlighted selection in Excel?

A. Ctrl+4
B. Ctrl+5
C. Ctrl+6
D. None of the above.

In a computer spreadsheet, first part of number format describes __________ ?

A. Positive number
B. Negative number
C. Zero values
D. Text values

In a computer spreadsheet, value of formula (7-3)x(1+6)/4 is __?

A. 7
B. 1.5
C. 2
D. 12

In a computer, element which is not a part of chart is _______?

A. Plot area
B. Fill handler
C. Series
D. Chart area

Computer spreadsheet capability to allow a pie chart to be generated from data in spreadsheet cells is termed as __________ ?

A. Decoration
B. Data appearance
C. Functions
D. Charting

The term chart wizard data in MS is refer to_________?

A. Vertical axis
B. Horizontal axis 
C. Bar data
D. None of these

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

A. 10
B. 100
C. 300
D. 500

In MS-Excel__________ short cut key is used for hiding rows.

A. Ctrl+H
B. Ctrl+7
C. Ctrl+9
D. None of the above

In Ms Excel, which of the following special function keys allow the content in cell?

A. Shift
B. Esc
C. Tab
D. Space

Which Operation can’t be performed by Queue?

A. Insertion
B. Deletion
C. Retrieving
D. Traversing 

In excel columns are labelled as____________?

A. A, B, C, etc.
B. 1, 2, 3, etc.
C. A1, A2, A3, etc.
D. $A$1, $A$2, etc.

Top open an existing workbook, click the open button on the___________toolbar?

A. form
B. standard
C. Drawing
D. Formatting

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

A. Tab
B. Ctrl+Enter
C. Enter
D. Alt+Enter

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

A. Comma
B. Normal
C. Currency
D. Percent

How we can view a cell comment ?

A. position the mouse pointer over the cell
B. click the comment command on the view menu
C. click the edit comment commands on the Insert menu
D. click the Display comment command on the window menu

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

A. Using the Edit – Select All menu
B. Pressing Ctrl + A on the keyboard
C. Clicking three times with the right mouse button in the spreadsheet
D. None of These

Which of following is not an element of computer spreadsheet interface?

A. Pencil work
B. Active cell
C. Menu bar
D. Workbook

In a computer spreadsheet rows are labeled ________ ?

A. by letters
B. by numbers
C. by cell references
D. by symbols

Basic unit of a computer worksheet in which you enter text and numbers is known as _________?

A. workbook
B. column
C. row
D. cell

 

Post a Comment (0)
Previous Post Next Post

ADS 1

ADS 2