MS excel set 7 Detailed Explanation And More Example

Question : 1

All macro keyboard shortcuts include the...... key

a) Alt

b) Ctrl

c) F11

d) Shift

e) None of these

Question : 2

In Excel numeric value can be treated as a label value if it precedes with

a) Apostrophe (‘)

b) Exclamation (!)

c) Hash (#)

d) Ampersand (&)

Question : 3

In Excel you can use the horizontal and vertical scroll bars to

a) Split a worksheet into two panes

b) View different rows and columns

c) Edit the contents of a cell

d) View different worksheets

Question : 4

In Excel the auto calculate feature

a) Can only add values in a range of cells

b) Provides a quick way to view the result of an arithmetic operation on a range of cells

c) Automatically creates formulas and adds them to a worksheet

d) (A) and (C)

Question : 5

Which of the following options is not located in the Page Setup dialog box?

a) Page Break Preview.

b) Page Orientation

c) Margins

d) Headers and Footers

e) None of these

Question : 6

In Excel this type of software is similar to an accountant’s worksheet

a) Word processing

b) Database

c) Spreadsheets

d) Graphics