MS excel set 2 Detailed Explanation And More Example

Question : 1

The Cancel and Enter buttons appear In the:

a) Title bar

b) Formula bar

c) Menu bar

d) Sheet tabs

e) None of these

Question : 2

In Excel Hyperlinks can be

a) Text

b) Drawing objects

c) Pictures

d) All of above

Question : 3

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

a) Format Report

b) Pivot Table

c) Refresh Data

d) Show Detail

e) None of these

Question : 4

__ cells involves creating a single cell by combining two or more selected cells.

a) Formatting

b) Merging

c) Embedding

d) Splitting

e) None of these

Question : 5

What is the AutoSummarize feature used for in Word 2000

a) It creates a 250 word, 500 word or 1000 word summary of the document

b) It adds Automatic headers, bold and italic characters as well as' automatic formatting of the document to give the look of a well summarized document

c) it summarizes the statistics of the document into a report such as total words, total characters, total pages, total paragraphs, file size ecs

d) It identifies the key points in a document for your to share with others or quickly scan

e) None of these

Question : 6

In order to perform a calculation in a spreadsheet, you need to use a:

a) table

b) formula

c) field

d) variable

e) None of these