MS excel set 1 Detailed Explanation And More Example

Question : 1

In Excel you can activate a cell by

a) Pressing an arrow key

b) Pressing the Tab key

c) Clicking the cel

d) All of the above

Question : 2

Right clicking something in Excel

a) Nothing the right mouse button is there for left handed people

b) Deletes the objec

c) Selects the object

d) Opens a shortcut menu listing everything you can do to the object

Question : 3

In Excel Multiple calculations can be made in a single formula using

a) array formula

b) standard formulas

c) smart formula

d) complex formulas

Question : 4

In Excel the following describes how to select all the cells in a single column?

a) Use data – text to columns menu item

b) Right click on column and select Pick from list

c) Pressing Ctrl + A on the keyboard

d) Left click on the gray column title button

Question : 5

There are three types of data found in a spreadsheet

a) numbers formulas, labels

b) words, numbers, labels

c) equations, data, numbers

d) data, words, numbers

Question : 6

In Excel suppose you have columns of data that span more than one printed page. How can you automatically print the column headings on each page?

a) Click page setup on the file menu, click the page tab, click the options button, then enter your choices.

b) Click page setup on the finle menu, click the sheet tab, and make a selection under the print heading.

c) Click page setup on the file menu, click the sheet tab, and enter the row that contains these column headings under print titles

d) All of above