CBSE Class 4 Computer Studies MS Excel MCQs

Question. When you are typing an equation into a cell the first thing that must be entered is ?
a) the first cell referenced
b) parenthesis
c) quotation marks
d) an equal sign

Answer : D

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

Answer : A

Question. You can create hyperlinks from the Excel workbook to ?
a) A webpage on company internet
b) A web page on the internet
c) Other Office 97 application documents
d) All

Answer : D

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

Answer : A

Question. Macros are "run" or executed from the ...... menu ?
a) Insert
b) Frmat
c) Tools
d) Data

Answer : C

Question. A function inside another function is called a .......... function ?
a) Nested
b) Round
c) Sum
d) Text

Answer : A

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

Answer : B

Question. To move to the previous worksheet, press ?
a) Alt + PgUp
b) Ctrl + PgUp
c) Ctrl + PgDn
d) Shift + Tab

Answer : B

Question. Your German supplier still invoices 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-Ins, and select the Euro Currency Tools check box
c) Apply a selected background color
d) All of above

Answer : B

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

Answer : D

Question. The intersection of a row and column is called ?
a) data
b) a field
c) a cell
d) an equation

Answer : C

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

Answer : A

Question. To select several cells or ranges that are not touching each other, you would ....... while selecting ?
a) hold down the Ctrl key
b) hold down the Shift key
c) hold down the Alt key
d) hold down Ctrl + Shift key

Answer : A

Question. The cell labeled 23.54 the cell labeled F5 refers to ?
a) row F column 5
b) column F row 5
c) function available in cells
d) function key F4

Answer : B

Question. Which function calculates your monthly mortage payment ?
a) PMT (payments)
b) NPER (number of periods)
c) PV (presént value)
d) All of above

Answer : A

Question. There are three types of data found in a spreadsheet ?
a) data, words, numbers
b) equations, data, numbers
c) words, numbers, labels
d) numbers formulas, labels

Answer : D

Question. On an excel sheet the active cell in indicated by ......... ?
a) A dark wide boarder
b) A dotted border
c) A blinking border
d) None of above

Answer : A

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

Answer : C

Question. Using the AutoSum button will replace in the selected cell ...... ?
a) the sum of values in the cell's column
b) nothing until you select a range of cells
c) the sum of the cell's row unless you change the range
d) a formula which will add values in the range Excel guesses you want to add

Answer : D

Question. The worksheet contains _________ rows ?
a) 65536
b) 256
c) 400
d) 17

Answer : A

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

Answer : D

Question. To copy formatting from one area in a worksheet and apply it to another area you would use ?
a) The Edit>Copy Format and Edit>Paste Format commands form the menu.
b) The Copy and Apply Format- ting dialog box, located un- der the Format>Copy and Apply menu.
c) There is no way to copy and apply formatting in Excel - You have to do it manually
d) The Format Painter button on the standard toolbar

Answer : D

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

Answer : C