CBSE Class 8 Computer Science MS Excel MCQs

Question. The view that puts a blue a blue line around each page that would be printed is the......
a) Print Preview
b) Normal View
c) Page Break Preview
d) Split View
e) None of these

Answer : C

Question. When you link data maintained in an excel workbook to a word document
a) The word document can not be edit
b) The word document contains a reference to the original source application
c) The word document must contain a hyperlink
d) The word document contains a copy of the actual data
e) None of these

Answer : B

Question. You can open the consolidate dialog box byt choosing' Consolidate from the...... menu.
a) Insert
b) Format
c) Tools
d) Data
e) None of these

Answer : A

Question. You can insert labels for
a) All the data markers on a chart
b) A data series
c) A selected data marker
d) All
e) None of these

Answer : D

Question. Which types of charts can excel produce?
a) Line graphs and pie charts only
b) Only line graphs
c) Bar charts, line graphs and pie charts
d) Bar charts and line graphs only
e) None of these

Answer : C

Question. Which area in an excel window allows entering values and formulas
a) Title bar
b) Menu bar
c) Formula bar
d) Standard toolbar
e) None of these

Answer : C

Question. Which button do you click to add up a series of numbers?
a) The autosum button
b) The Formula button
c) The quicktotal button
d) The total button
e) None of these

Answer : A

Question. To edit in an embedded excel worksheet object in a word document
a)Use the excel menu bar and toolbars inside the word application
b) Edit the hyperlink
c) Edit the data in a excel source application
d) Use the word menu bar and toolbars
e) None of these

Answer : A

Question. If you press...... the cell accepts your typing as its contents.
a) Enter
b) Ctrl+Enter
c) Tab
d) Insert
e) None of these

Answer : A

Question. Which of the following is the oldest spreadsheet package?
a) VisiCalc
b) Lotus 1-2-3
c) Excel
d) StarCalc
e) None of these

Answer : A

Question. Rounding errors can occur
a) When you use multiplication, division, or exponentiation in a formula
b) When you use addition and subtraction in a formula
c) Because excel uses hidden decimal places in computation
d) When you show the results of formulas with different decimal places that the calculated results
e) None of these

Answer : A

Question. Which of the following is a popular DOS based spreadsheet package?
a) Word
b) Smart cell
c) Excel
d) Lotus 1-2-3
e) None of these

Answer : D

Question. Each excel file is called a work-book because
a) It can contain text and data
b) It can be modified
c) It can contain many sheets including worksheets and chart sheets
d) You have to work hard to create it
e) None of these

Answer : C

Question. An excel workbook is a collection of
a) Workbooks
b) Worksheets
c) Charts
d) Worksheets and charts
e) None of these

Answer : D

Question. Which of the following displays the contents of the active cell?
a) Active cell
b) Formula bar
c) Menu bar
d) Name box
e) None of these

Answer : B

Question. You can use the format painter multiple times before you turn it off by
a) You can use the format painter button only one time when you click it
b) Double clicking the format painter button
c) Pressing the Ctrl key and clicking the format painter button
d) Pressing the Alt key and clicking the format painter button
e) None of these

Answer : B

Question. What function displays row data in a column or column data in a row?
a) Hyperlink
b) Index
c) Transpose
d) Rows
e) None of these

Answer : C

Question. You can copy data or formulas
a) With the copy, paste and cut commands on the edit menu
b) With commands on ta shortcut menu
c) With buttgns on the standard toolbars
d) All of the above
e) None of these

Answer : D

Question. 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
e) None of these

Answer : B

Question. which of the following special function keys allow the content in cell
a) esc
b) shift
c) return
d) Tab
e) None of these

Answer : C

Question. You can not link excel worksheet data to a word document
a) With the right drag method
b) With a hyperlink
c) With the copy and paste special commands
d) With the copy and paste buttons on the standard toolbar.
e) None of these

Answer : A

Question. Which is not an advantage of using computerized spread sheets?
a) flexibility of moving entries
b) speed of calculation
c) ability of generate tables
d) cost of initial setup
e) None of these

Answer : D

Question. Excel files have a default extension of
a) Xls
b) Xlw
c) Wkl
d) 123
e) None of these

Answer : A

Question. Macros are "run" or executed from the...... menu.
a) Insert
b) Format
c) Tools
d) Data
e) None of these

Answer : C

Question. Auto Calculate will quickly add selected cells if you.......
a) right click on the status bar and select Sum
b) click the AutoCalculate but-ton on the toolbar
c) use the key combination Ctrl+$
d) Double click the selection
e) None of these

Answer : B

Question. How are data organised in a spreadsheet?
a) Lines and spaces
b) Layers and planes
c) . Height and width
d) Rows and columns
e) None of these

Answer : D

Question. Which of the following types of tables constraints will prevent the entry of duplicate rows?
a) Primary key
b) Unique
c) Null
d) Foreign key
e) None of these

Answer : B

Question. A function incite another function is called a .....function.
a) Nested
b) Round
c) Sum
d) Text
e) None of these

Answer : A

Question. Each cell in a Microsoft Office Excel document is referred to by its cell address, which is the
a) cell's column label
b) cell's column label and worksheet tab name
c) cell's row label
d) cell's row and column la-bels
e) None of these

Answer : D

Question. Gridlines
a) May be turned off for display but turned on for printing
b) May be turned on or off for printing
c) The be turned off for display and printing
d) a, b and c
e) None of these

Answer : D

Question. You can print only an embedded chart by
a) Moving the chart to a chart sheet before you print.
b) Formatting the chart before you print
c) Selecting the chart before you print
d) a and c
e) None of these

Answer : D

Question. Which of the following is a cor-rect order of precedence in a formula calculation?
a) Multiplication and division, exponential positive and negative value
b) Multiplication and division, positive and negative values, addition and subtraction
c) Addition and subtraction, positive and negative values, exponentiation
d) None of above
e) None of these

Answer : D

Question. Youar German supplier still in-voices for parts in deutsche marks. How can you .have Excel convert those sums to Euros?
a) On the Insert menu, click Symbol and from the currency symbols subset, select the Euro sign.
b) On the tools menu, click Add-lns, and select the Euro Currency Tools check box
c) Apply a selected background color
d) All of above
e) None of these

Answer : B

Question. Which function calculates your monthly mortage payment?
a) PMT (payments)
b) NPER (number of periods)
c) PV (present value)
d) All of above
e) None of these

Answer : A

Question. You can open the Sort dialog box by choosing Sort from the .... menu
a) View
b) Format
c) Tools
d) Data
e) None of these

Answer : D

Question. Be default, Excel positions text in a cell ___.
a) left-aligned
b) right-aligned
c) centered
d) justified
e) None of these

Answer : A

Question. To centre a paragraph using shortcut keys, press __.
a) CTRL + C
b) CTRL + E
c) CTRL + L
d) CTRL + R
e) None of these

Answer : B

Question. when working in the page break preview, you can
a) view exactly where each page break occurs
b) add or remove page breaks
c) change the print area
d) all of above
e) None of these

Answer : D

Question. A data map is helpful
a) When you have too much data to chart
b) To show a geographic distri-bution of data
c) To compare data points
d) To show changes in data over-time
e) None of these

Answer : B

Question. The horizontal and vertical lines on a worksheet are called
a) cells
b) sheets
c) blocklines
d) gridlines
e) None of these

Answer : A

Question. How are data organized in a spreadsheet?
a) Lines and spaces
b) Layers and planes
c) Rows and columns
d) Height and width
e) None of these

Answer : C

Question. What does the VLOOKUP function do?
a) Looks up text that contain V
b) Checks whether text is the same in one cell as in the next
c) Finds related records
d) All of above
e) None of these

Answer : C

Question. To delete an incorrect character in a document, __ to erase to the right of the insertion point.
a) press the left mouse key
b) double click the right mouse key
c) press the BACKSPACE key
d) press DELETE key
e) None of these

Answer : D

Question. How should you print a selected area of a worksheet, if you'll want to print a different area next time?
a) On the file menu, point to print area, and then click set print are
b) On the file menu, click print, j and then click selection | under print what
c) On the view menu, click custom views, then click add
d) All of above
e) None of these

Answer : B

Question. The most common subtotal used Subtotals command is the __ function, which causes Excel to display a sum each time the corurol field change.
a) ADD
b) SUM
c) TOTAL
d) LIST
e) None of these

Answer : B

Question. Which area in an Excel window allows entering values and formulas
a) Title Bar
b) Menu Bar
c) Formula Bar
d) Standard Tool Bar
e) None of these

Answer : C

Question. If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify ac: curacy. How do you activate this feature?
a) Point to speech on the tools menu, and then click show text to speech toolbar.
b) Click validation on the data menu
c) Point to speech on the tools menu, and then click speech recognition
d) All of above
e) None of these

Answer : A

Question. In MS Access-,-a table can have__ primary key /keys.
a) One
b) Two
c) Three
d) Four
e) None of these

Answer : A

Question. Which of the following is the latest version of Excel?
a) Excel 2000
b) Excel 20.02
c) Excel ME
d) Excel XP
e) None of these

Answer : D

Question. __ cells involves creating a single cell by combining two or more selected cells.
a) Formatting
b) Merging
c) Embedding
d) Splitting
e) None of these

Answer : B