MS excel set 10 Detailed Explanation And More Example

Question : 1

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 : 2

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 : 3

To copy formatting from one area in a worksheet and apply it to another area you would use:

a) The Edit>Copy Format and Edit>Paste Format commands form the menu.

b) The Copy and Apply Formatting dialog box, located under the Format>Copy and Apply menu.

c) There is no way to copy and apply formatting in Excel - You have to do it manually

d) The Format Painter button on the standard toolbar

e) None of these

Question : 4

In Excel Tab scrolling buttons

a) Allow you to view a different worksheet

b) Allow you to view additional worksheet row down

c) Allow you to view additional worksheet columns to the right

d) Allow you to view additional sheet tabs

Question : 5

The Name box on to the left of formula bar

a) shows the name of workbook currently working on

b) shows tne name of worksheet currently working on

c) shows the name of cell or range currently working on

d) All of above

e) None of these

Question : 6

You can open the consolidate dialog box by choosing' Consolidate from the...... menu.

a) Insert

b) Format

c) Tools

d) Data

e) None of these