CBSE Class 6 Computer Science MS Excel MCQs

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

Answer : D

Question. When the formula bar is active, you can see ?
a) The edit formula button
b) The cancel button
c) The enter button
d) All of the above

Answer : D

Question. The advantage of using a spreadsheet is ?
a) calculations can be done automatically.
b) changing data automatically updates calculations
c) more flexibility
d) all of the above

Answer : D

Question. Which of the following special function keys allow the content in cell ?
a) esc
b) shift
c) return
d) Tab

Answer : C

Question. You can open the consolidate dialog box by choosing Consolidate from the ...... menu ?
a) Insert
b) Format
c) Tools
d) Data

Answer : D

Question. All macro keyboard shortcuts include the ________ key ?
a) Alt
b) Ctrl
c) F11
d) Shift

Answer : A

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

Answer : A

Question. Two common wildcard characters that Excel recognizes are ?
a) * and ?
b) < and >
c) ^ and /
d) + and -

Answer : A

Question. All formula in Excel start with ?
a) %
b) +
c) =
d) -

Answer : C

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

Answer : C

Question. To add two cells (Al and A(2) together you use the following formula ?
a) =A1+A2
b) =Add(A1+A(2)
c) =together(A1:A(2)
d) Al plus A2

Answer : A

Question. To make a number in cell C1 10% smaller than the number in C3 you enter ?
a) =C3 1.10
b) +C3*110
c) =C3%10
d) =C3*.90

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

Answer : D

Question. You can use a function to combine text from two cells into one cell. But you can use an operator to do the same thing. Which operator is that ?
a) & (ampersand)
b) = (equal sign)
c) (space)
d) All of the above

Answer : A

Question. In a worksheet you can select ?
a) The entire worksheet
b) Rows
c) Columns
d) All of the above

Answer : D

Question. To centre a paragraph using shortcut keys, press ?
a) CTRL+C
b) CTRL+E
c) CTRL+L
d) CTRL+R

Answer : B

Question. A data map is helpful ?
a) When you have too much data to chart
b) To show a geographic distribution of data
c) To compare data points
d) To show changes in data over time

Answer : B

Question. Book1 is an example of how ... are numbered and named during each work session ?
a) Active cell
b) Formula bar
c) Menu bar
d) Name box

Answer : D

Question. What does SUMIF function do ?
a) Adds up cell values based on a condition
b) Adds all the numbers in a range of cells
c) Returns a subtotal in a list or database
d) All of above

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

Answer : D

Question. A __________ is rectangular grid of rows & columns used to enter data ?
a) cell
b) worksheet
c) spreadsheet
d) Both (2) and (3)

Answer : D

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

Answer : D

Question. The view that puts 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

Answer : C

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

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 labels

Answer : D

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

Answer : B

Question. Hyperlinks can be ?
a) Text
b) Drawing objects
c) Pictures
d) All of above

Answer : D

Question. Using the F11 shortcut key to create a chart on chart sheet creates ?
a) A default chart
b) A 2-dimensional column chart
c) A 2-dimensional bar chart
d) A 3-dimensional line chart

Answer : B

Question. You can copy data or formulas ?
a) With the copy, paste and cut commands on the edit menu
b) With commands on ta short-cut menu
c) With buttons on the standard toolbars
d) All of the above

Answer : D

Question. Comments put in cells are called.....
a) Smart Tip
b) Cell Tip
c) Web Tip
d) Soft Tip
e) None of these

Answer : B

Question. Comments can be added to cells using.....
a) Edlt-> Comments
b) Insert •> Comment
c) Fl I e-> Qomments
d) Vlew-> Comments
e) None of these

Answer : B

Question. The default and maxium number of sheets for a new workbook in Excel 2003 is
a) 3 and 255
b) 3 and 256
c) 1 and 255
d) 1 and 256
e) None of these

Answer : B

Question. When you enter Sunday and fill right, Excel fill in with Monday, Tuesday and so on. From where Excel knows what to fill in next?
a) Auto Complete
b) AutoFormat
c) Custom List
d) Calculation Automatic
e) None of these

Answer : C

Question. The minimum and maximum value you can set for Save AutoRecovery Info in Excel are
a) 1 and 120 minutes
b) O and 120 minutes
c) 2 and 60 minutes
d) 1 and 10 minutes
e) None of these

Answer : A

Question. Which of the following can not be hidden from Tools >> Options then View tab?
a) Startup Task Pane
b) Formula bar
c) Status bar
d) Scroll Bar
e) None of these

Answer : D

Question. What happens if you remove the check mark from Row & Column headers on Options dialog box?
a) This will remove row headings and column headings of your data
b) This will remove the column headings (A, B, C,
c) This will remove row and column heading of chart
d) This will remove row and column heading of table
e) None of these

Answer : B

Question. The default font size in Excel worksheet is
a) 10 points
b) 12 points
c) 14 points
d) None of above .
e) None of these

Answer : A

Question. The default font used In Excel is
a) Arlal
b) Algerial
c) Times New Roman
d) Preetl
e) None of these

Answer : A

Question. What do you call the chart that shows the proportions of how one or more data elements relate to another data element?
a) XY Chart
b) Line Chart
c) Pie Chart
d) Column Chart
e) None of these

Answer : C

Question. Which menu option can be used to split windows Into two?
a) Format •> Widow
b) VI ew •> Widow=> Split
c) Wlndow->Spllt
d) Vlew->Spllt
e) None of these

Answer : C

Question. Getting data from a cell located in a different sheet is called.
a) Accessing
b) Referencing
c) Updating
d) Functioning
e) None of these

Answer : B

Question. Which key do you press to check spelling?
a) F3
b) F5
c) F7
d) F9
e) None of these

Answer : C

Question. What will be the output If you format the cell containing 5436.8 as '#,##0.00'?
a) 5,430.00
b) 5,436.80.
c) 5,436.8
d) 6.8
e) None of these

Answer : B

Question. Which elements of a worksheet can be protected from accidental modification?
a) Contents
b) Objects
c) Scenarios
d) All of the above
e) None of these

Answer : D

Question. Multiple calculations can be made In a single formula using....
a) Standard Formulas
b) Array Formula
c) Complex Formulas
d) Smart Formula

Answer : B

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. How do you rearrange the data In ascending or descending order?
a) Data, Sort
b) Data, Form
c) Data, Table
d) Data Subtotals
e) None of these

Answer : A

Question. What do you mean by a Workspace?
a) Group of Col umns
b) Group of Worksheets
c) Group of Rows
d) Group of Workbooks
e) None of these

Answer : D

Question. To select an entire column in MS-EXCEL, press?
a) CTRL + C
b) CTRL + Arrow key
c) CTRL + S
d) All of the above
e) None of these

Answer : D

Question. How do you display current date and time In MS Excel?
a) date( )
b) Today ( )
c) now( )
d) time( )
e) None of these

Answer : C

Question. To return the remainder after a number Is divided by a divisor In EXCEL we use the function?
a) ROUND ( )
b) FACTQ
c) MODQ
d) DIV()
e) None of these

Answer : C

Question. Which function Is not available In the Consolidate dialog box?
a) Pmt
b) Average
c) Max
d) Sum
e) None of these

Answer : A

Question. Which Is not tha function of "Edit, Clear" command?
a) Delete contents
b) Del ete notes
c) Delete eel Is
d) Del ete formats
e) None of these

Answer : C

Question. Which of the following tool you will use in Excel to see what must be the value of a cell to get required result?
a) Formul Auditing
b) Research
c) Track Change
d) Goal Seek
e) None of these

Answer : D

Question. Hyperlinks can be
a) Text
b) Drawing objects
c) Pictures
d) All of above
e) None of these

Answer : D

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) a, b, and c
e) None of these

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

Answer : D

Question. Using the AutoSum button will replace in the selected cell......
a) the sum of values jn the cell's column.
b). nothing until'ybu select a range of cells
c) the sum of the cell's row unless you change the range
e) None of these

Answer : A

Question. Status indicators are located on the
a) Vertical scroll bar
b) Horizontal scroll bar
c) Formula bar
d) Standard toolbar
e) None of these

Answer : C

Question. Bookl is an example of how …... are numbered and named during each work session
a) Active cell
b) Formula bar
c) Menu bar
d) Name box
e) None of these

Answer : D

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

Answer : C

Question. What does SUMIF function do?
a) Adds up cell values based on a condition
b) Adds all the numbers in a range of cells
c) Returns a subtotal in a list or database
d) All of above
e) None of these

Answer : A

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

Answer : D

Question. A certain spreadsheet shows in Page Break Preview that cells in Rows 1-25 have white background. 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 back-ground will print
c) the whole sheet will print
d) only the cells with white background will print
e) None of these '-'v

Answer : D

Question. All macro keyboard shortcuts include the...... key
a) Alt
b) Ctrl
c) F11
d) Shift
e) None of these

Answer : A