Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Excel Review-TO
Excel Review
| Question | Answer |
|---|---|
| this part of the worksheet is vertical and is identified by a letter at the top | column |
| this part of the worksheet is horizontal and is identified by a number at the left | row |
| the intersection of a column and a row | cell |
| one of the number formats that adds a $ right before numbers | currency |
| what tab is freezing panes located under | view |
| the alignment that centers data in a cell from top to bottom is __________ alignment | vertical |
| the command that removes a row or column from view but does not delete it | hide |
| rows are inserted ________ the cell that is selected | above |
| columns are inserted to the _____ of the cell that is selected | left |
| to freeze rows of data, select the cell that is ______ the last row you want to freeze | below |
| to change the orientation of the worksheet select the __________ tab | pagelayout |
| this command allows rows or columns to be repeated on all worksheet pages of the workbook | print titles |
| what tab contains the option to create a chart from worksheet data | insert |
| Excel opens in what view | normalview |
| use this command to select and print only a portion of the worksheet | print area |
| use this command to navigate to a certain cell in a worksheet | goto |
| the hyperlink command is under the ______ tab | insert |
| the command to hide and unhide columns and rows is under the __________ tab | format |
| modify document properties under the ______ tab | file |
| the command to center across multiple columns is | merge and center |
| the command in Excel to wrap text so it appears on multiple lines in a cell. | wraptext |
| to change the background color of the cell use the ____ command | fill color |
| adding a format like Heading 1 to data in a worksheet is using what command | cell style |
| a type of calculation in Excel that uses a function name instead of a mathematical operator | functions |
| the mathematical operator for multiplication | asterisk |
| the mathematical operator for division | slash |
| the function name used to total a range of numbers | SUM |
| the function name used to find the smallest value in a range of numbers | MIN |
| the function name used to find the largest value in a range of numbers | MAX |
| the function name that is used to combine the contents of different cells | concat |
| all formulas and functions start with an | equal sign |
| the option to create a chart from worksheet data is under the ____ tab | insert |
| when numbers are entered into a cell it is aligned to the ________ of the cell | right |
| insert a CSV file into Excel using the _____ tab | data |
| when text is entered into a cell it is aligned to the ______ side of the cell | left |
| a file that contains one or more related worksheets is a | workbook |
| this paste option that switches the rows and columns of the copied cells is __________ | transpose |
| to arrange data in ascending or descending order | sort |
| the command used to automatically sum a range of values | autosum |
| dragging the green square at the bottom right of a cell to copy data is using the _____ command | fill |
| a set of calculations in a worksheet | formula |
| the abbreviation of the order of calculation in a formula is _______________ | PEMDAS |
| _______________ formatting is a particular formatting that is applied to the contents of a cell if it meets a certain condition | conditional |
| the option to split a worksheet into different panes is under the _____ tab | view |
| the option to inspect document properties of a workbook is under the _____ tab | file |
| the horizontal axis of a chart is the _______ axis | Y |
| the function name used to join different cells containing text | textjoin |
| the function that checks whether a condition is met, and returns one value if TRUE, and another value if FALSE | If |
| a chart that is on the same sheet as the worksheet is called an ___________ chart | embedded |
| a chart that is on a separate sheet from the worksheet is called a _____________ sheet | chart |
| counts the number of a cell that contains numbers | count |
| the function key that changes a cell to an absolute cell | F4 |
| the function that returns the middle number in a set of numbers | median |
| the option for conditional formatting is under the _________ tab | home |
| the vertical axis of a chart is the _______ axis | Y |
| a key that identifies the series of a chart usually by different colors or patterns is called the chart _______ | legend |
| a chart with horizontal bars to represent data in a chart is a ______ chart | bar |
| a chart with vertical bars to represent data in a chart is a ______ chart | column |
| a piece of the pie chart is called a | slice |
| the option to show formulas in a worksheet is under the _____________ tab | formula |
| Heading 1, Heading 2, and Title are examples of cell __________ that can be applied to data in a cell | style |
| the command to create a pivot table in a worksheet is under the __________ tab | insert |
| the subtotal command is under the _______ tab | data |
| a chart that shows the relationship of a part to a whole is the _____ chart | pie |
| this makes a cell absolute | dollar sign |
| the order of evaluation to calculate | PEMDAS |
| a command that copies the format of data in a cell | format painter |
| a cell reference that does not change when copied or moved to a new cell | absolute |
Created by:
DeborahCrenshaw
Popular Business sets