Microsoft Office Excel MCQ Set-7

Microsoft Office Excel MCQ Sets

1. 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


2. 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 than the calculated results


3. You can copy data or formulas

a. With the copy, paste and cut commands on the edit menu

b. With commands on a shortcut menu

c. With buttons on the standard toolbar

d. All of the above


4. You can activate a cell by

a. Pressing the Tab key

b. Clicking the cell

c. Pressing an arrow key

d. All of above


5. Which of the following setup options can not be set in the page setup dialog box?

a. Printer selection

b. Vertical or horizontal placement

c. Orientation

d. Row and column titles


6. What term refers to a specific set of values saved with the workbook?

a. Range

b. Scenario

c. Trend line

d. What-if analysis


7. Got functions? No? You need the insert function dialog box. How do you get it?

a. Right click a cell and then click insert

b. Click the insert menu and then click function

c. Type = in a cell

d. All of the above


8. Which of the following describes how to select all the cells in a single column?

a. Right click on column and select Pick from list

b. Use data – text to columns menu item

c. Left click on the gray column title button

d. Pressing Ctrl + A on the keyboard


9. when you use the fill effects in the format data series dialog box, you can not

a. rotate text on the chart

b. select a fore ground color

c. select a pattern

d. select a background color


10. Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?

a. Rows and columns

b. Headings

c. Speed

d. None


11. Which of the following is not a basic step in creating a worksheet?

a. Save the workbook

b. Modify the worksheet

c. Enter text and data

d. Copy the worksheet


12. What’s a quick way to extend these numbers to a longer sequence, for instance 1 through 20?

a. Select both cells, and then drag the fill handle over the range you want, for instance 18 more rows

b. Select the range you want, include both cells, point to fill on the Edit menu, and then click down.

c. Copy the second cell, click in the cell below it, on the standard toolbar click the down arrow on the Paste button, and then click Paste Special

d. All of above


13. To insert three columns between columns D and E you would

a. Select column D

b. Select column E

c. Select columns E, F and G

d. Select columns D, E, and F.


14. To center worksheet titles across a range of cell, you must

a. Select the cells containing the title text and use the fill handle to center the text across a range of cells

b. Select the cells containing the title text and click on Center button

c. Select the cells in range containing the title text and use the Merge and Center tool

d. Widen the column


15. When integrating Ms-Word and Excel, Word is usually the

a. Server

b. Source

c. Client

d. None


16. Charts tips can

a. Show the formatting of a data label

b. Show the name of a data series

c. Show the value of data point

d. b and c


17. The Name box

a. Shows the location of the previously active cell

b. Appears t the left of the formula bar

c. Appears below the status bar

d. Appears below the menu bar


18. How do you change column width to fit the contents?

a. Single-click the boundary to the left to the column heading

b. Double click the boundary to the right of the column heading

c. Press Alt and single click anywhere in the column

d. All of above


19. when you work with large worksheets, you may need to

a. size the worksheet to fit on the specific number of pages

b. adds and remove page breaks

c. specifies only certain print areas

d. all of above


20. Hyperlinks cannot be

a. Special shapes like stars and banners

b. Drawing objects like rectangles ovals

c. Pictures

d. All can be hyperlinks


21. You can use the horizontal and vertical scroll bars to

a. Split a worksheet into two panes

b. View different rows and columns

c. Edit the contents of a cell

d. View different worksheets


22. What do we call a computer program that organizes data in rows and columns of cells? You might use this type of program to keep a record of the money you earned moving lawns over the summer.

a. Spreadsheet program

b. Database program

c. Word processor program

d. Desktop publisher program


23. You can add an image to a template by clicking the Insert Picture From File button on the …. Toolbar.

a. Standard

b. Formatting

c. Drawing

d. Picture


24. What function displays row data in a column or column data in a row?

a. Hyperlink

b. Index

c. Transpose

d. Rows


25. 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