MS excel set 1 Detailed Explanation And More Example

Question : 1

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

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

In Excel if you press …….., the cell accepts your typing as its contents.

a) TAB

b) Enter

c) Insert

d) Ctrl + Enter

Question : 4

In Excel which symbol must all formula begin with?

a) @

b) (

c) +

d) =

Question : 5

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

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