Software Apps Excel
Card Set Information
Software Apps Excel
Software Apps Excel
To multiply cells, you would use this symbol:
When you see the ###### in a column, this means that:
The column needs to be wider
Which button allows you to quickly add columns or rows of numbers?
Which feature makes everything in a workbook appear larger or smaller?
Which key should you press to move down one cell in a worksheet?
Which group would you use to insert and delete rows and columns?
Which of the following is a function? (list)
Average, maximum (max.), sum, minimum (min.), count, autosum
The ______ function is a function used to determine the highest number in a range.
By ______ the worksheet, you see exactly how it will look without generating a printout.
______ means the printout is printed horizontally on the page.
Which bar displays the contents of a cell?
When more than one arithmetic operator is involved in a formula, Excel follows the same basic ______ that is used in algebra.
Order of operations
A ______ takes a value or values, performs an operation, and returns a result to the cell.
How do you select a cell that you want to edit?
Double-click the cell
Which would you use to center your table's heading across columns A, B, and C?
Merge and center
After adding a header and/or footer, you would press this button to return to the default view:
You would go to the ______ tab to find the chart group.
Headers and footers are separated into ______ section(s).
When you Autofit a column, you ______ border of the column heading.
Double click the right
The button used to change the direction of text is called:
To save a saved document using a new name:
Click SAVE AS on the Office Button
When changing the row height, you would use the cell's ______ border.
When Excel starts and the blank spreadsheet displays on the screen, all of the columns have a default width of ______.
To rename sheets, double-click the sheet tab in the lower-left corner of the window, type the new sheet name, then ______.
Press the ENTER key
The ______ preceding a formula is important because it alerts Excel that a formula or function is being entered and not text.
A blank cell in Excel has a numerical value of ______.
The ______ function is a function that sums the numbers in the specified range and then divides the sum by the number of non-zero cells in the range.
When a floating dollar sign appears, you are using ______ style.
The formula that tells you how many numbers are in your cell range is:
When a fixed dollar sign appears you are using ______ style.
Accounting style format
Reduces the amount of decimal places.
Holding down this keyboard button will allow you to select more than one cell, row, or column at one time.
Contains a letter and a number.
You can view contents of a cell in this bar.
The function that allows you to add together values in rows and columns.
Creates a single cell by combining two or more selected cells.
Means that the width of a column will be increased or decreased so the widest entry will fit in the column.
Creates a graphic to represent something.
You can ______ new rows between existing rows.
A key that is used for charts.
Contains buttons such as center, merge, and wrap text.
This allows your text to all fit into one cell by changing the height of the row and allowing the text to appear on multiple lines.
Button allowing more decimal places.
The tab you would go to in order to insert a function.
What you always need to do before you print.
You use this feature to fill in a series of numbers instead of typing all of them.
The group with the drop-down arrow that allows you to format numbers and text to formats such as percentage, currency, and general.
The area behind the columns on a column chart.
Section in page setup that allows you to fit a spreadsheet to one page.
A type of graph that can be exploded.