E
X
C
E
L
100
Lines that run between the cells in a workbook.
What is Gridlines
100
This treats the cell value as text even when the cell contains numbers.
What is Text format
100
Small graphic characters based on text characters that can be formatted as text.
What is Character graphics
100
This may be used as a placeholder for a digit when formatting cell contents.
What is Pound sign (#)
100
Where do you find the Number Format Cells dialog box, where you would be able to custom format text and numbers. (Tell me the Tab, Group, and icon)
What is Home tab, Number Group, and the Number Dialog Box Launcher
200
A list of items that are preceded by symbols.
What is Bulleted List
200
In Excel 2010, this is a character not found on the keyboard.
What is Symbol
200
A command that copies formatting from one place and applies it to another.
What is Format Painter
200
Is a set of colors, fonts, lines, and fill effects that can be applied to entire worksheets or individual cells.
What is Document Theme
200
Give two ways to insert a row into a worksheet.
What is right click on row heading and select insert, or go to Home Tab and Cells group, select Insert sheet rows
300
Is the shading assigned to a cell.
What is Cell fill color
300
This technique changes the appearance of a cell range based on the underlying cell values.
What is Conditional formatting
300
Where is the Cell styles icon located on the tool bar? ( give me Tab and group)
What is Home Tab and Styles Group
300
This is a saved and named set of formatting options applied to cell.
What is Style
300
This is where custom styles are saved.
What is Workbook
400
To classify a range of data into 3 to 5 categories, you would use:
What is Icon Set
400
These call attention to cells on a worksheet.
What is Cell Borders
400
Heading Fonts override theme fonts. (True or False)
What is True
400
Where is the border button located on the toolbar? (give me tab and group)
What is Home Tab and Font Group
400
To reuse custom cell styles in a new workbook you may do this:
What is Copy it
500
Microsoft Office applications, including Word, Excel, Access, and Power Point, share the same:
What is Themes
500
Where is the Wrap Text button located on the toolbar? (give me group)
What is Alignment group
500
Where is the Increase and Decrease decimals button located on the toolbar? (give me the group)
What is Numbers Group
500
Name the four buttons in the Clipboard group on the Home Tab (you must name all four correctly)
What is Paste, Cut, Copy, Format Painter
500
How many alignment options are there in the Alignment group on the Home Tab? Name them.(you must be able to tell me how many and name them all)
What is 6. Top align, Middle align, bottom align, left align, center, right align
M
e
n
u