The Worksheet
Formatting
Charts
Cells
Keyboard Shortcuts
100
The information that is created in a worksheet is saved in a file named the ___________
What is workbook
100
copies formats from a selected cell to another cell
What is format painter
100
Excel chart is especially useful in showing a data size in proportion to the total of all points in the data source range.
What is Pie Chart
100
Excel features built-in, preprogrammed formulas called
functions
100
opening the Find & Replace dialog box with the Find tab active
What is Ctrl +F
200
Columns are identified by letters and rows are identified by
What is numbers
200
Changing the color of the fill in a cell is changing this
What is background
200
type of Excel chart is used to depict trends and change over time intervals
What is Line chart
200
Function that returns the largest value in the argument
What is MAX function
200
One way to access Help resources in Excel
What is F1
300
Image that appears on the Microsoft Excel Help button near the upper right corner
What is ? question mark
300
Can be added to the top , bottom , left and right edge of a cell
What is borders
300
Toolbar with Tabs , that appears when clicking on a chart
What is Chart Tools
300
group of adjacent cells in an Excel worksheet.
What is range
300
When editing a cell address, pressing this causes Excel to insert dollar symbols in front of the row and column number immediately to the left of the insertion point.
What is F4
400
part of the Excel screen thaT displays the contents of the active cell
What is Formula Bar
400
contains a group of predefined formatting options stored in a name.
What is cell style
400
Miniature charts that illustrate changes in a row or column of data and fit in a cell
What is sparklines
400
entry in a cell that helps the reader understand the values in the corresponding column or row.
What is label
400
keyboard shortcut for cutting the selection and placing it on the Clipboard
What is Ctrl X
500
You can make Excel Help window larger by clicking this button.
What is Use large Text
500
Will complete text entries for you as you start to type a new entry in a cell
What is AutoComplete
500
A method to edit a chart that will display the context-sensitive shortcut menu.
What is Chart elements
500
All formulas in Excel begin with
What is equal sign =
500
When using this keyboard combination , Excel will check spelling
What is F7
M
e
n
u