____ appear at the bottom of the Excel window.
(A) Title bar
(B) Formula bar
(C) Work sheet tabs
(D) Name box
What are the basic rectangular building blocks of a
spreadsheet?
(A) Cells
(B) Zoom slider
(C) Help button
(D) All of these
Another name for a pre-programmed formula in Excel
is
(A) Cell
(B) Graph
(C) Function
(D) Range
Excel is a program that is used to prepare a
(A) Slide presentation
(B) Spreadsheet
(C) Text document
(D) Database
In which tab wrap text feature is present in MS Excel
2007?
(A) Formulas
(B) View
(C) Insert
(D) Home
Which term is used to join the selected cells in to one
cell?
(A) Filter
(B) Wrap
(C) Pivot
(D) Merge
Which of the following Excel charts represents only
one value for each variable?
(A) Bar
(B) Pie
(C) Line
(D) Function
A formula in Excel always begins with an ____
(A) Equal sign
(B) Colon
(C) Comma
(D) Space
A(n) ____ is a series of two or more adjacent cells in a
column or row or rectangular group of cells.
(A) List
(B) Section
(C) Range
(D) Area
What is the extension of saved file in MS Excel?
(A) .xls
(B) .xks
(C) .xos
(D) .xbs
Which command is used to close the window of Excel?
(A) Alt+ F4
(B) Ctrl + W
(C) Ctrl +R
(D) Ctrl+ C
What is the total region surrounding the chart?
(A) Chart area
(B) legend
(C) Clipart area
(D) Plot area
What is the total region surrounding the chart?
(A) Chart area
(B) legend
(C) Clipart area
(D) Plot area
Which bar show the used formula of selected active
cell?
(A) Formula bar
(B) Ribbon
(C) Menu bar
(D) Scroll bar
Typed text showed in active cell and also in ___
(A) Formula bar
(B) Ribbon
(C) Title bar
(D) Scroll bar
Excel documents are stored as files called
(A) Workgroups
(B) Worktables
(C) Worksheets
(D) Workforce
What refers to the horizontal cells which can contain
information?
(A) Ribbon
(B) Rows
(C) Columns
(D) Horizontal scrollbar
What refers to the vertical cells which can contain
information?
(A) Ribbon
(B) Rows
(C) Columns
(D) Horizontal scrollbar
To minimize the currently selected window, press
(A) Ctrl+ F11
(B) Ctrl+ F12
(C) Ctrl+ F9
(D) Ctrl+ F10
When we can create a chart on a separate sheet in the
same workbook, it is called a
(A) Chart sheet
(B) Embedded chart
(C) View sheet
(D) View chart
____ sign is used to create an absolute cell reference.
(A) $
(B) @
(C) &
(D) %
# VALUE! Refers to ___
(A) Font value
(B) Error in value
(C) Subscript of the number value
(D) Addition of value
You can undo and redo up to ____ action in Microsoft
Office Excel, even after a worksheet is saved.
(A) 50
(B) 99
(C) 100
(D) 500
You can undo and redo up to ____ action in Microsoft
Office Excel, even after a worksheet is saved.
(A) 50
(B) 99
(C) 100
(D) 500
What is the short cut key of save as ?
(A) F12
(B) F13
(C) F11
(D) F5
To displays the open dialog box to open or find a file,
press
(A) Alt + O
(B) Ctrl + O
(C) Esc + O
(D) Tab + O
Which of the following function used to adds the
values in the function argument or the values in the all
references in the argument?
(A) ADD
(B) SUM
(C) TOTAL
(D) LIST
When a chart is placed on this, it is much larger and
there is no other data on it.
(A) Reference sheet
(B) Primary sheet
(C) Exclusive sheet
(D) Chart sheet
Formulas in Excel are made up of ___
(A) Arithmetical operators and functions
(B) Only arithmetic operators
(C) Only symbols
(D) Only functions
The result is a ___ value either TRUE or FALSE.
(A) Logical
(B) Arithmetic
(C) Algorithm
(D) Logarithm
Which of the following is the comparison operator?
(A) *
(B) ^
(C) =
(D) +
On an Excel sheet, the active cell is indicated by
(A) A dark wide border
(B) A dotted border
(C) A blinking border
(D) None of the above
The letter and number of the intersecting column and
row is the
(A) Cell location
(B) Cell position
(C) Cell address
(D) Cell coordinates
Which sign indicate to multiplication?
(A) Asterisk
(B) Caret
(C) Percent sign
(D) Forward slash
In a spreadsheet, a ____ is a number you will use in a
calculation.
(A) Value
(B) Cell
(C) Field
(D) Label
What is the intersection of a column and a row on a worksheet called ?
(A) Column
(B) Value
(C) Address
(D) Cell
What type of chart is useful for comparing values over categories ?
(A) Pie chart
(B) Line chart
(C) Column chart
(D) Dot graph
Which functionin Excel tells how many numeric entries are there ?
(A) Num
(B) Sum
(C) Count
(D) If
A features that displays only the data in column (s) according to specified
criteria
(A) Formula
(B) Sorting
(C) Filtering
(D) Pivot
Statistical calculations and preparation of tables and graphs can be done
using
(A) Excel
(B) Power point
(C) Word
(D) Photoshop
