Applying Theme Style/Cell Style/Finding and Replacing Data
Copying and Moving Worksheet Data/Check Spelling
100
Two features used to enhance the appearance of a worksheet.
What are the formatting and editing features?
100
Click this tab on the Format Cells Dialog Box to add patterned or gradient color to a cell.
What is the Fill tab?
100
A group that has the commands which allow you to work with rows and columns.
What is the Cell Group?
100
Two separate commands that are often used together.
What are the Find and Replace commands?
100
This appears when using the drag and drop method and displays the new location for the data.
What is a screen tip?
200
This can be created at any time from the Backstage View by clicking File, then click New.
What is a NEW workbook?
200
Click this button allows access to the commands that join selected cells together into one larger cell and center the text in the Alignment Group.
What is the Merge and Center button?
200
An action you can take on the right border of a column to automatically resize the column to fit the data currently in the column.
What is double-click?
200
It is useful for locating specific data or moving to a particular location in the worksheet.
What is the Find command?
200
A method that can be used to copy or move a selection using the mouse.
What is the drag and drop method?
300
This can be launched from the Font, Alignment, and Number groups to access additional cell-formatting options.
What is Format Cells Dialog Box?
300
Click this button to remove all the formatting from a cell or range of cells and it is located in the Editing Group.
What is the Clear Button?
300
A command that allows a new row to be inserted above the current selection.
What is Insert Sheet Rows command?
300
This button will replace all occurrences of data at once without confirming each instance.
What is the Replace All button?
300
A group that allows access to the cut, copy, paste, and clipboard task pane launcher commands.
What is the Clipboard Group?
400
It is the design of a set of letters and numbers. Each set has a name.
What is a font?
400
This format is automatically applied when you enter a number in a cell.
What is the General format?
400
This dialog box opens when you click the Insert Cells command.
What is the Insert dialog box?
400
A set of predesigned formatting elements--including colors, fonts, and effects--that can be applied to an entire workbook.
What is a Theme Style?
400
To duplicate a selection so you can paste it into another position without deleting it from its original location.
What is Copy?
500
A group that provides tools to format font, font sizes, font colors, font styles, borders and fill colors.
What is the Font group?
500
This group will allow access to commands to format data to percent, currency, comma style, date, and fractions.
What is the Number Group?
500
An action taken in which the rows beneath the deleted row and the columns to the right of the deleted column automatically shift up OR left to fill in the space.
What is delete rows or columns?
500
A defined combination of formatting characteristics--such as number, alignment, font, border, and fill.
What is a Cell Style?
500
To insert copied or moved contents in another location.