# MS Excel mcq Questions and Answer | Microsoft Excel-9

Last updated on December 8, 2021

# 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
 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
 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
 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. Computergk.net is India's Largest Computer MCQ website where you will get about 8000+ computer MCQ objective questions for all competitive exam.

### Latest Posts Previous Story

#### MS Excel mcq Questions and Answer | Microsoft Excel-8 Next Story

Go toTop