MS excel set 7 Detailed Explanation And More Example

Question : 1

How do you display current date only in MS Excel?

a) date ( )

b) Today ( )

c) now( )

d) time( )

e) None of these

Question : 2

The autofill feature

a) extends a sequential series of data

b) automatically adds range of cell values

c) applies a boarder around the selected cells

d) All the above

e) None of these

Question : 3

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

e) None of these

Question : 4

In Excel Book1 is an example of how … are numbered and named during each work session

a) Active cell

b) Formula bar

c) Menu bar

d) Name box

Question : 5

The numbers in our worksheet look like this: 1000. You want them to look like this: $1,000.00. How can you accomplish this?

a) Click the Currency Style button on the formatting toolbar

b) You have to retype everything and manually add the dollar signs, commas, and decimals.

c) Select Format > Money from the menu

d) All the above

e) None of these

Question : 6

Documentation should include

a) Destination and users of the output data

b) Source of input data

c) Information on the purpose of the workbook

d) All the above

e) None of these