Create an account
A ________ is formatted as a pattern of uniformly spaced horizontal rows and vertical columns.
The ________ allows the user to enter or edit the value or formula contained in the active cell.
The ________ allow(s) the worksheet to be split into two vertical views of the same worksheet.
Vertical Window Split
The current cell mode, the page number, and the view and zoom buttons are displayed on the?
________ generates and extends a series of values into adjacent cells based on the values of other cells.
The ________ feature fills in the remaining characters of a word if what is typed matches an existing entry in the column.
A prewritten formula known as a(n) ________ looks at one or more values, performs an operation, and returns a value
The result of a formula is displayed in the active cell, and the ________ is displayed in the Formula Bar.
Excel's ________ command creates one cell out of the selected cells and centers the contents within the new cell.
Merge & Center
________ are defined as sets of formatting characteristics, such as font, font size, font color, cell borders, and cell shading.
The ________ inserts a thousand comma separator when appropriate, inserts a fixed U.S. dollar sign aligned at the left edge of the cell, applies two decimal places, and provides space for negative numbers to be displayed inside of parenthese
For data to be more easily understood, it can be presented in a ________ instead of a table of numbers.
Labels that display along the bottom of a chart to identify the category of the data are called
On an Excel chart, the ________ identifies the patterns or colors that are assigned to all the categories in the chart.
Each worksheet is identified by the ________ found along the lower border of the Excel window
To widen a column to fit the cell content of the widest cell in the column, the user should utilize
The process of specifying the appearance of cells and the overall layout of a worksheet is called
A cell address used in a formula using a(n) ________ will be adjusted appropriately when the formula is copied to another cell.
Relative Cell Reference
Applying the shape effect ________ causes the edges of a shape to appear to be curved or angled.
) To ________ one or more slices on a pie chart means to pull the slice(s) away from the rest of the chart.
) Why would you explode a slice on a pie chart?
To emphazise the slice to the person viewing the chart
Excel's ________ finds the input needed in one cell for another cell to have a desired value
The ________ is the percent by which one number increases over another during a specified time frame.
Percentage Rate of increase
) The percentage rate of increase is calculated by using this formula: ________.
Base*Amount of increase
Changing a value in a cell to see what effect it has on values in other cells that are calculated using the value is said to be doing a
A(n) ________ is a line that borders the chart plot area and serves as a frame of reference for measurement.
Which Excel function would be used to calculate the total points a student earned on a series of tests?
The Excel function ________ would be used to find the lowest score on a series of student test scores.
Excel's ________ function adds all of its arguments then divides the sum by the number of arguments.
The functions AVERAGE and MEDIAN are examples of ________ functions, which are useful when the user needs to analyze a group of measurements.
If a cell's width is too narrow to properly display the numeric contents of the cell, Excel displays a series of ________ symbols.
Please allow access to your computer’s microphone to use Voice Recording.
Having trouble? Click here for help.
We can’t access your microphone!
Click the icon above to update your browser permissions and try again
Reload the page to try again!Reload
Press Cmd-0 to reset your zoom
Press Ctrl-0 to reset your zoom
It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.
Please upgrade Flash or install Chrome
to use Voice Recording.
For more help, see our troubleshooting page.
Your microphone is muted
For help fixing this issue, see this FAQ.
Star this term
You can study starred terms together