211
78.4k

580+ Microsoft Excel (MS Excel) Solved MCQs

These multiple-choice questions (MCQs) are designed to enhance your knowledge and understanding in the following areas: Common Topics in Competitive and Entrance exams , Microsoft Office .

351.

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
Answer» B. Click the insert menu and then click function
352.

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
Answer» C. Left click on the gray column title button
353.

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
Answer» A. rotate text on the chart
354.

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
Answer» C. Speed
355.

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
Answer» D. Copy the worksheet
356.

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
Answer» A. Select both cells, and then drag the fill handle over the range you want, for instance 18 more rows
357.

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.
Answer» C. Select columns E, F and G
358.

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. Widen the columns
C. Select the cells containing the title text and use the fill handle to center the text across a range of cells
D. Widen the column
Answer» C. Select the cells containing the title text and use the fill handle to center the text across a range of cells
359.

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

A. Server
B. Source
C. Client
D. None
Answer» C. Client
360.

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
Answer» D. b and c
361.

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
Answer» B. Appears t the left of the formula bar
362.

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
Answer» B. Double click the boundary to the right of the column heading
363.

when you work with large worksheets, you may need to

A. size the worksheet to fit on the specific number of pages
B. add and remove page breaks
C. specify only certain print areas
D. all of above
Answer» D. all of above
364.

Hyperlinks cannot be

A. Special shapes like stars and banners
B. Drawing objects like rectangles ovals
C. Pictures
D. All can be hyperlinks
Answer» D. All can be hyperlinks
365.

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
Answer» B. View different rows and columns
366.

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
Answer» A. Spreadsheet program
367.

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
Answer» D. Picture
368.

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

A. Hyperlink
B. Index
C. Transpose
D. Rows
Answer» C. Transpose
369.

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
Answer» B. Placed in a word table
370.

Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result

A. IF
B. AND
C. OR
D. NOT
Answer» A. IF
371.

Macros are “run” or executed from the ….. menu.

A. Insert
B. Frmat
C. Tools
D. Data
Answer» C. Tools
372.

You can open the consolidate dialog box byt choosing Consolidate from the ….. menu.

A. Insert
B. Format
C. Tools
D. Data
Answer» D. Data
373.

Which types of charts can excel produce?

A. Line graphs and pie charts only
B. Only line graphs
C. Bar charts, line graphs and pie charts
D. Bar charts and line graphs only
Answer» C. Bar charts, line graphs and pie charts
374.

How are data organized in a spreadsheet?

A. Lines and spaces
B. Layers and planes
C. Rows and columns
D. Height and width
Answer» C. Rows and columns
375.

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. Finds related records
376.

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. a, b and c
377.

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. a and c
378.

Which of the following is a correct order of precedence in a formula calculation?

A. Multiplication and division, exponential positive and negative value
B. Multiplication and division, positive and negative values, addition and subtraction
C. Addition and subtraction, positive and negative values, exponentiation
D. None of above
Answer» D. None of above
379.

A function inside another function is called a ….. function.

A. Nested
B. Round
C. Sum
D. Text
Answer» A. Nested
380.

How should you print a selected area of a worksheet, if you’ll want to print a different area next time?

A. On the file menu, point to print area, and then click set print area.
B. On the file menu, click print, and then click selection under print what
C. On the view menu, click custom views, then click add
D. All of above
Answer» B. On the file menu, click print, and then click selection under print what
381.

Youar 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. On the tools menu, click Add-Ins, and select the Euro Currency Tools check box
382.

Which function calculates your monthly mortage payment?

A. PMT (payments)
B. NPER (number of periods)
C. PV (present value)
D. All of above
Answer» A. PMT (payments)
383.

If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracy. How do you activate this feature?

A. Point to speech on the tools menu, and then click show text to speech toolbar.
B. Click validation on the data menu
C. Point to speech on the tools menu, and then click speech recognition
D. All of above
Answer» A. Point to speech on the tools menu, and then click show text to speech toolbar.
384.

Which of the following methods can not be used to enter data in a cell?

A. Pressing an arrow key
B. Pressing the tab key
C. Pressing the Esc key
D. Clicking the enter button to the formula bar
Answer» C. Pressing the Esc key
385.

Which of the following will not set text in selected cells to italics?

A. Pressing Ctrl + I on the keyboard
B. Using the Tools – Wizard – Web Form menu item
C. Using the Format – Cells – Font menu item
D. None of the above
Answer» B. Using the Tools – Wizard – Web Form menu item
386.

Which of the following methods cannot be used to edit the content of cell?

A. Pressing the Alt key
B. Clicking the formula bar
C. Pressing F2
D. Double clicking the cell
Answer» A. Pressing the Alt key
387.

Which of the following is not an option in the spelling dialog box?

A. Edit
B. Ignore
C. Ignore all
D. Change
Answer» A. Edit
388.

You can quickly change the appearance of your work by choosing Auto Format from the …. Menu

A. Edit
B. View
C. Format
D. Tools
Answer» C. Format
389.

To protect a worksheet, you can choose Protection and the Protect Sheet from the ….. menu

A. Edit
B. Format
C. Tools
D. Data
Answer» C. Tools
390.

You can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.

A. Edit
B. Insert
C. Format
D. Tools
Answer» D. Tools
391.

Which of the following is not a worksheet design criterion?

A. Efficiency
B. Auditability
C. Description
D. Clarity
Answer» C. Description
392.

To copy cell contents using drag and drop, press the

A. End key
B. Shift key
C. Esc key
D. None of above
Answer» D. None of above
393.

If you press …., the cell accepts your typing as its contents.

A. Enter
B. Ctrl + Enter
C. TAB
D. Insert
Answer» A. Enter
394.

The autofill feature

A. Extends a sequential series of data
B. Automatically adds a range of cell values
C. Applies a boarder around selected cells
D. None of above
Answer» A. Extends a sequential series of data
395.

What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?

A. F3
B. F5
C. F7
D. F11
Answer» D. F11
396.

you can use the formula palette to

A. format cells containing numbers
B. create and edit formulas containing functions
C. entered assumptions data
D. copy a range of cells
Answer» B. create and edit formulas containing functions
397.

What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chas changed

A. Format Report
B. Pivot Table
C. Refresh Data
D. Show Detail
Answer» C. Refresh Data
398.

What is an expression that tells how the numbers in a determined set of cells are to be calculated?

A. Formula
B. Field
C. Data
D. Query Correct Answer:
Answer» A. Formula
399.

“Qtr 1, Qtr 2, Qtr 3” is an example of a

A. Formula
B. Function
C. Series
D. Syntax
Answer» C. Series
400.

You can edit existing Excel data by pressing the

A. F1 key
B. F2 key
C. F3 key
D. F4 key
Answer» B. F2 key

Done Studing? Take A Test.

Great job completing your study session! Now it's time to put your knowledge to the test. Challenge yourself, see how much you've learned, and identify areas for improvement. Don’t worry, this is all part of the journey to mastery. Ready for the next step? Take a quiz to solidify what you've just studied.