microsoft excel q/a Practice Questions Answers Test with Solutions & More Shortcuts

Question : 41

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

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

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

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

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