Home >> MS Excel MCQs >>

MS Excel Set 07

MS Excel Set 07

Q.1 Main window in a computer spreadsheet is called ___________ ?
A. Work book
B. Work
C. Account book
D. Work sheet
ANSWER: A) Work book
Explanation : Workbook is the main window of MS Excel
Q.2 Which of the following will not enter data in a cell?
A. Pressing the Esc key
B. Pressing the Tab Key
C. Both of these
D. None of above
ANSWER: A) Pressing the Esc key
Explanation : Precessing escape key in ms excel, the data entry will be cancelled and data will not be entered in cell.
Q.3 In a computer spreadsheet, cell range A3 through G3 should be keyed in as ________ ?
A. A3-G3
B. A3:G3
C. A3?.G3
D. A3 to G3
ANSWER: B) A3:G3
Explanation : In MS Excel, Cell range is made with the help of ( : ) sign so, cell range A3 through G3 should be keyed in as A3 : G3
Q.4 In a computer spreadsheet, SUM, AVERAGE, MIN and MAX are examples of _____ ?
A. Calculations
B. Formulas
C. Functions
D. Relative addressing
ANSWER: C) Functions
Explanation : All of these are functions.
Q.5 In a computer spreadsheet, each cell contain a __________ ?
A. Label
B. Value
C. Formula
D. All of these
ANSWER: D) All of these
Explanation : In MS Excel, a Cell can contain Lable, value, formula or function.
Q.6 Actual working area of Computer’s Microsoft Excel is ________ ?
A. Workbook
B. Worksheet
C. Note sheet
D. Notebook
ANSWER: B) Worksheet
Explanation : Working area of MS excel workbook is called worksheet.
Q.7 In a computer, element which is not a part of chart is ___________ ?
A. Plot area
B. Fill handler
C. Series
D. Chart area
ANSWER: B) Fill handler
Explanation : Fill handler is nothing in MS Excel Chart.
Q.8 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
ANSWER: D) Charting
Explanation : To generate a chart from data in ms excel is called charting.
Q.9 The term chart wizard data in MS is referring to_________?
A. Vertical axis
B. Horizontal axis
C. Bar data
D. None of these
ANSWER: B) Horizontal axis
Explanation : In a chart in MS Excel, Data is represented on Horizontal Axis.
Q.10 Which of the following is not a valid Zoom percentage in Excel?
A. 10
B. 100
C. 300
D. 500
ANSWER: D) 500
Explanation : MS Excel provide zoom levels from 10 to 400, so 500% is not a valid zoom level in MS Excel.
Test Your Learning

Related Posts

More MCQs