MS Excel mcq Questions and Answer | Microsoft Excel-9
excel-9
Question 1
In order to arrange the countries from those with the highest population to those with the lowest, you need to sort on the population field in...............
A
(1) ascending order
B
(2) descending order
C
(3) alphabetical order
D
(4) random order
Question 2
. In order to perfo rm a calculation in a spreadsheet, youneed to use a:
A
(1) table
B
(2) formula
C
(3) field
D
(4) variable
Question 3
The box on the chart that contains the name of each Individual record Is called the__.
A
(1) cell
B
(2) title
C
(3) axis
D
4) legend
Question 4
. If you want all of the white cats grouped together In the database, you need to sort by__.
A
(1) Color, then Gender
B
(2) Pet Type, then Col or
C
(3) Pet Type, then Gender
D
(4) Color, then Pet Name
Question 5
You accidentally erased a record In the sheet, What command can be used to restore It Immediately?
A
(1) Insert
B
(2) Copy
C
(3) Undo
D
(4) Replace
Question 6
Where a row and a column meet, what do you call that?
A
(1) A eel I
B
(2) A block
C
(3) A box
D
(4) None of the above
Question 7
How do you tell one cell from another?
A
1) By numbers
B
(2) By letters
C
(3) By its address
D
(4) by color
Question 8
. Give me an example of a cell address.
A
(1) 1125
B
(2) 911
C
(3) 41A
D
(4) A21
Question 9
Which Is an example of a formula?
A
(1) =A1+A2
B
(2) =add(AI:A2)
C
(3) A1+A2
D
(4) SUM{A1:A2)
Question 10
Which is an example of a function?
A
(1) =add(AI:A2)
B
(2) =A1+A2
C
(3) »SUM(A1:A2)
D
(4) A1+A2
Question 11
What la the symbol for multiplying?
A
(1) >
B
(2) /
C
(3) !
D
(4) *
Question 12
What Is the symbol for dividing?
A
(1) /
B
(2)=%
C
(3) &
D
(4) fl
Question 13
All formula In Excel start with
A
(1) .>
B
(2) +
C
(3) =
D
(4)
Question 14
You can use a function to combine text from two cells into one cell. But you can use an opera-tor to do the same thing. Which operator is that?
A
(1) & (ampersand)
B
(2) = (equal sign)
C
(3) (space)
D
(4) All of the above
Question 15
Two common wildcard characters that Excel recognizes are
A
(1) * and?
B
(2) < and >
C
(3) * and /
D
(4) + and –
Question 16
The divide symbol is
A
(1) /
B
(2) D
C
(3) \
D
(4) )
Question 17
The multiplication arithmetic operator Is represented by which of the following symbols?
A
(1) a
B
(2) *
C
(3) /
D
(4) X
Question 18
To add two cells (Al and A(2) together you use the following formula
A
(1) =A1 + A2
B
2) =Add(AI+A(2)
C
(3) together (A 1:A(2)
D
(4) AlplusA2
Question 19
To make a number In cell Cl 10% smaller than the number In C3 you enter
A
(1) -03*1.10
B
(2) +C3*110
C
(3) -C3%10
D
(4) -C3*.90
Question 20
On an excel sheet the active cell In Indicated by...
A
(1) A dark wide boarder
B
(2) A dotted border
C
(3) A blinking border
D
(4) None of above
Question 21
On an Excel sheet the active cell in indicated by
A
(1) A dark wide border
B
(2) A dotted border
C
(3) A blinking border
D
(4) None of above
Question 22
Using the Fl 1 shortcut key to create a chart on chart sheet creates
A
(1) A default chart
B
(2) A 2-dimensional column chart
C
(3) A 2-dimensional bar chart
D
(4) A 3-dimensional line chart
Question 23
You can print
A
(1) A range of cells by range name
B
(2) An entire worksheet
C
(3) A single worksheet
D
(4) All of the above
Question 24
. You can create only a horizontal page break by first selecting
A
(1) A row below the row where you want the page break to occure
B
(2) A cell in row 1
C
(3) A cell in column A
D
(4) a and c
Question 25
You can create hyperlinks from the Excel workbook to
A
(1) A webpage on company internet
B
(2) A web page on the internet
C
(3) Other Office 97 application documents
D
(4) All
Question 26
The cell reference fro a range of cells that starts in cell Bl and goes over to column G and down to row lOis......
A
(1) DB1-G10
B
(2) B1.G10
C
(3) B1;G10
D
(4) B1:G10
Question 27
The advantage of using a spreadsheet is :
A
(1) calculations can be done automatically
B
(2) changing data automatically updates calculations
C
(3) more flexibility
D
(4) all of the above
Question 28
The intersection of a row and column is called :
A
(1) data
B
(2) afield
C
(3) a cell
D
(4) an equation
Question 29
There are three types of data found in a spreadsheet
A
(1) data, words, numbers
B
(2) equations, data, numbers
C
(3) words, numbers, labels
D
(4) numbers formulas, labels
Question 30
To select a column the easiest method is to........
A
(1) Double click any cell in the column
B
(2) Drag from the top cell in the column to the last cell in
the column
C
(3) click the column heading
D
(4) click the column label
Question 31
To select a column the easiest method is to........
A
(1) Double click any cell in the column
B
(2) Drag from the top cell in the column to the last cell in
the column
C
(3) click the column heading
D
(4) click the column label
Question 32
If you press...... the cell accepts your typing as its contents.
A
(1) Enter
B
(2) Ctrl+Enter
C
(3) Tab
D
(4) Insert
Question 33
which of the following special function keys allow the content in cell
A
(1) esc
B
(2) shift
C
(3) return
D
(4) Tab
Question 34
Which is not an advantage of using computerized spread sheets?
A
(1) flexibility of moving entries
B
(2) speed of calculation
C
(3) ability of generate tables
D
(4) cost of initial setup
Question 35
To select several cells or ranges that are not touching each other, you would ... while selecting
A
(1) hold down the Ctrl key
B
(2) hold down the Shift key
C
(3) hold down the Alt key
D
(4) hold down Ctrl + Shin key
Question 36
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
(1) nothing will print because some cells with data have
been omitted
B
2) only the cells with gray back-ground will print
C
4) only the cells with white background will print
Question 37
. A constant is another name for this type of data:
A
(1) number
B
(2) equation
C
(3) formula
D
(4) description
Question 38
The view that puts a blue a blue line around each page that would be printed is the......
A
(1) Print Preview
B
(2) Normal View
C
(3) Page Break Preview
D
(4) Split View
Question 39
Auto Calculate will quickly add selected cells if you.......
A
(1) right click on the status bar and select Sum
B
(2) click the AutoCalculate but-ton on the toolbar
C
(3) use the key combination Ctrl+$
D
(4) Double click the selection
Question 40
The cell labeled 23. 54 the cell labeled F5 refers to
A
(1) row F column 5
B
(2) column F row 5
C
(3) function available in cells
D
(4) function key F4
There are 40 questions to complete.
You have completed
questions
question
Your score is
Correct
Wrong
Partial-Credit
You have not finished your quiz. If you leave this page, your progress will be lost.