M.S.Excel QUIZ-05

In Excel, the Fill Color button on the Formatting toolbar is used for what
To insert a background.
To add borders.
To select a distribution of figures.
To add shading or color to a cell range.


The first cell in EXCEL worksheet is labeled as
AA
A1 
Aa
A0

In help menu of Excel, which of the following tabs are found?
Contents tab
Answer Wizard tab
Index tab
all of the above 

What are the tabs that appear at the bottom of each workbook called?
Reference tabs
Position tabs
Location tabs
Sheet tabs 

In Excel, a Data Series is defined as what?
A type of chart
A cell reference
A collection of related data 
A division of results

A __________ is a grid with labeled columns and rows.
Dialog box
Worksheet 
Clipboard
Toolbar

The active cell:
It is the formula bar
Receives data user enters & defined by a bold border around the cell 

What is represented by the small, black square in the lower-right corner of an active cell or range?
Copy handle
Fill handle 
Insert handle
Border

What happens when dollar signs ($) are entered in a cell address? (ex. $B$2:$B$10)
Cell address will change when it is copied to another cell.
An absolute cell address is created.
The sheet tab is changed.
The status bar does not display the cell address.



No comments:

Post a Comment