CBSE Class 5 Computer Studies MS Excel MCQs

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

Answer : B

Question. To select a column the easiest method is to ........ ?
a) Double click any cell in the column
b) Drag from the top cell in the column to the last cell in the column
c) click the column heading
d) click the column label

Answer : C

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

Answer : C

Question. Graphics objects on a chart are used to ?
a) Add emphasis to chart data
b) Add interest to a chart
c) Help explain the chart data
d) (1), (2) and (3)

Answer : D

Question. You can print ?
a) A range of cells by range name
b) An entire worksheet
c) A single worksheet
d) All of the above

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

Answer : B

Question. To create a formula in Excel, you can use ?
a) Values but not cell references
b) Cell references but not values
c) Values or cell references although not both at the same time
d) Value and cell references

Answer : D

Question. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the ?
a) Unfreeze panes command on the window menu
b) Freeze panes command on the window menu
c) Hold titles command on the edit menu
d) Split command on the window menu

Answer : B

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

Answer : C

Question. To open the Format Cells dialog box, press ?
a) Alt + 1
b) Ctrl + 1
c) Ctrl + Shift + 1
d) F1

Answer : B

Question. Auto Calculate will quickly add selected cells if you ....... ?
a) right click on the status bar and select Sum
b) click the AutoCalculate button on the toolbar
c) use the key combination Ctrl+$
d) Double click the selection

Answer : B

Question. You can add a hyperlink to your worksheet by pressing ?
a) Alt + K
b) Ctrl + H
c) Ctrl + K
d) Ctrl + Shift + K

Answer : A

Question. ____________ cells involves creating a single cell by combining two or more selected cells ?
a) Formatting
b) Merging
c) Embedding
d) Splitting

Answer : B

Question. Which of the following is the latest version of Excel ?
a) Excel 2000
b) Excel 2002
c) Excel ME
d) Excel XP

Answer : D

Question. To activate the previous cell in a pre-selected range, press ?
a) The Alt key
b) The Tab key
c) The Enter key
d) None of the above

Answer : D

Question. The cell reference from a range of cells that starts in cell Bl and goes over to column G and down to row 10 is ...... ?
a) B1:G11
b) B1:G13
c) B1:G12
d) B1:G10

Answer : D

Question. Tab scrolling buttons ?
a) Allow you to view a different worksheet
b) Allow you to view additional worksheet row down
c) Allow you to view additional worksheet columns to the right
d) Allow you to view additional sheet tabs

Answer : D

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

Answer : D

Question. By default, Excel positions text in a cell __________ ?
a) Left-aligned
b) right-aligned
c) centered
d) justified

Answer : A

Question. You can create only a horizontal page break by first selecting ?
a) A row below the row where you want the page break to Occur
b) A cell in row
c) A cell in column
d) a and c

Answer : A

Question. A constant is another name for this type of data ?
a) number
b) equation
c) formula
d) description

Answer : A

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

Answer : A

Question. The multiplication arithmetic operator is represented by which of the following symbols ?
a) ^
b) *
c) /
d) X

Answer : B

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

Answer : B

Question. In MS-Access, a table can have primary key /keys ?
a) One
b) Two
c) Three
d) Four

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

Answer : C

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, and then click selection under print what
c) On the view menu, click custom views, then click add
d) All of above

Answer : B

Question. A certain spreadsheet shows in Page Break Preview that cells in Rows 1-25 have white back- ground. The cells in row 26 that contain data have a dark grey background, when you click the Print button ...... ?
a) nothing will print because some cells with data have been omitted
b) only the cells with gray background will print
c) the whole sheet will print
d) only the cells with white background will print

Answer : D