CSCI Excel
All of the following are valid Excel arithmetic operators EXCEPT ____.
>
The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.
AVERAGE
The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.
Auto Fill Options
Which of the following Option buttons gives options for filling cells following a fill operation?
Auto Fill Options
The ____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.
Formula
Which of the following keys moves the insertion point to the beginning of data in a cell?
HOME
Which of the following keys toggles between Insert mode and Overtype mode?
INSERT
The ____ function displays the highest value in a range.
MAX
The ____ function determines the lowest number in a range.
MIN
Pressing the ____ key to complete an entry activates the adjacent cell to the right.
RIGHT ARROW
Now Anna wants to know the longest total time she has run. By looking at the total time values, she finds the longest total time to be 54 minutes. Instead of manually entering that value in a cell below the total time data, Anna decides to use the MAX function to determine the longest total time. Why did Anna prefer to use the MAX function?
The MAX function recalculates the highest value each time a new value is entered into the worksheet.
The ____ button allows you to erase recent cell entries.
Undo
The date you change a file is an example of a(n) ____ property.
automatically updated
A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.
exploded
The person or persons requesting the worksheet should supply their requirements in a ____ document.
requirements
Perry decides that before either of his employees creates a new workbook he must give them a ____.
requirements document
Pressing the ____ keyboard shortcut key(s) selects cell A1.
CTRL+HOME
Leo wants the sales numbers for rye bread, onion rolls, and bagels to look different each time the sales for each exceeds $500. What Excel feature can Leo use to accomplish this?
Conditional formatting
To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key.
ESC
After three months, Anna wants to the know the average distance she runs. What should she do to calculate the average distance?
Enter the text =av in a cell at the end of the distance data; then select the AVERAGE function from the Formula AutoComplete list and then enter the function's argument.
Which of the following happens when you enter the formula =G15 into a cell?
Excel assigns the value in cell G15 to the active cell
Excel remembers the last ____ actions you have completed.
100
How many chart types does Excel offer?
15
The ____ button lists error-checking options following the assignment of an invalid formula to a cell.
Trace Error
____ is/are used to place worksheet, column, and row titles on a worksheet.
text
A company or department may standardize with a specific ____ so that all of their documents have a similar appearance.
theme
You use ____ to view an XPS file.
XPS Viewer
Perry also decides that he should approve ____ of any proposed worksheet.
a sketch
A ____ is text and graphics that print at the top of each page.
header
A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.
indirect
When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.
26
If you do not assign a format to a cell or cells in a column, the column width will remain ____ characters.
8.43
Which of the following calculations multiplies 23 by 0.01?
=23%
Which of the following is the Ribbon path to the Cell Styles button?
(HOME tab | Styles group)
When you decrease the row height to ____, the row is hidden.
0
The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.
Accounting number format
The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu.
AutoCalculate
The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.
AutoCorrect
Which of the following features helps Anita be more productive by automatically reducing the number of misspelled or mistyped words?
AutoCorrect
You can click the ____ button to undo an automatic correction.
AutoCorrect Options
Press ____ to select the entire worksheet.
CTRL+A
You can apply the Bold font style by pressing the ____ keyboard shortcut keys.
CTRL+B
After Leo enters the sales numbers into the cells, he decides he does not want the fixed dollar sign to appear on the far left of the cell, separated by spaces from the actual value. He would prefer that the dollar sign appear immediately to the left of the first digit of the value. To specify a floating dollar sign, which of the following formats should Leo apply?
Currency style
What effect does the Comma Style format have on the selected cells?
Displays cell contents with two decimal places and commas as thousands separators
What effect does the Accounting Number Format have on the selected cells?
Displays cell contents with two decimal places that align vertically
Which of the following Excel features helps Anita be more productive by helping her more easily organize and identify her workbook files?
Document properties
Which of the following keys moves the insertion point to the end of data in a cell?
END
The ____ Option button lists formatting options following an insertion of cells, rows, or columns.
Insert
The default view in Excel is called ____ view.
Normal
____ view allows you to create or modify a worksheet while viewing how it will look in printed format.
Page Layout
You can use the ____ to check which cells are referenced in the formula assigned to the active cell.
Range Finder
____ properties are associated with all Microsoft Office files and include author, title, and subject.
Standard
To enter data in a cell, you must first select the ____.
cell
You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.
colon(:)
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.
operations
The range of cells receiving the content of copied cells is called the ____.
destination area
A ____ is text and graphics that print at the bottom of every page.
footer
You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
format
A ____ is a prewritten formula that is built into Excel.
function
Combining two or more selected cells into one cell is called ____ cells.
merging
The range of cells receiving copied content is called the ____ area.
paste
A ____ reference is an adjusted cell reference in a copied and pasted formula.
relative
The adjusted cell references in a copied and pasted formula are called ____ cell references.
relative
Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.
right parenthesis
The first step in creating an effective worksheet is to make sure you ____.
understand what is required
An Excel ____ allows data to be summarized and charted easily.
worksheet