MICROSOFT
EXCEL
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