MS excel set 11 Detailed Explanation And More Example

Question : 1

Tab scrolling button

a) Allow you to view a different worksheet

b) Allow you to view additional worksheet rows down

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

d) Allow you to view additional sheets tabs

e) None of these

Question : 2

In Excel Charts tips can

a) Show the formatting of a data label

b) Show the name of a data series

c) Show the value of data point

d) Both (B) and (C)

Question : 3

Which of the following is not a worksheet design criterion?

a) Efficiency

b) Aditibility

c) Description

d) Clarity

e) None of these

Question : 4

Which of the following action removes a sheet from workbook?

a) Select the sheet, then choose Edit > > Delete Sheet

b) Select the sheet then choose Format » Sheet » Hide

c) Press Insert

d) All of above

e) None of these

Question : 5

To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the

a) Unfreeze panes command on the window menu

b) Freeze panes command on the window menu

c) Hold titles command on the edit menu

d) Split command on the window menu

e) None of these

Question : 6

In Excel, a Data Series is defined as what?

a) A type of chart.

b) A eel I reference.

c) A collection of related data

d) Division of results

e) None of these