Digital Nepal69
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
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+ ‘