MS excel set 10 Detailed Explanation And More Example

Question : 1

Which of the following methods can not be used to edit the contents of a cell?

a) Press the Alt key

b) Clicking the formula bar

c) Pressing the F2 key

d) Double clicking the cell

e) None of these

Question : 2

In Excel when a label is too long to fit within a worksheet cell, you typically must

a) Shorten the label

b) Increase the column width

c) Decrease the column width

d) Adjust the row height

Question : 3

Which of the following types of tables constraints will prevent the entry of duplicate rows?

a) Primary key

b) Unique

c) Null

d) Foreign key

e) None of these

Question : 4

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

e) None of these

Question : 5

In Excel you can select a single range of cells by

a) Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells

b) Pressing the Ctrl key while dragging over the desired cells

c) Pressing the Shift key and an arrow key

d) Dragging over the desired cells .

Question : 6

Which function will you use to enter current time In a worksheet cell?

a) =today( )

b) -now ( )

c) -time ( )

d) =CurrentTime ( )

e) None of these