Excel 3 Type-in Questions
You know Excel is in Copy mode when a small plus sign appears next to the block arrow mouse pointer during a(n) ____________________ operation
drag and drop
A(n) _____ is a dot on the screen that contains a color.
pixel
The easiest way to select a cell is to move the block _______________________ pointer to the cell and then click.
plus sign
You can click the Page Layout button on the status bar to switch to ____ ______ view
Page Layout
Excel displays the error message _____ in cells to indicate a cell reference error in a formula
#REF!
Anna is a competitive runner. She wants to improve her performance and decides to keep track of data for six months to determine if the time of day or year she runs affects her performance. Her worksheet contains the following data: start and end time, total time, and distance. After three months, Anna wants to the know the average distance she runs. What should she do to calculate the average distance?
A. 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.
The ____________________ button allows you to choose whether you want to copy the values from the source area to the destination area with or without formatting.
Auto Fill Options
Anita is new to Microsoft Excel 2016. As she uses the application, she is beginning to see that Excel offers many features to help her save time and be more productive. Which of the following Excel features helps Anita be more productive by helping her more easily organize and identify her workbook files?
B
George runs a mid-size accounting practice and recently upgraded to Excel 2016. He expects sales to grow in the next few months during tax season. After that, he would like to begin upgrading some of the equipment and furniture for the employees in his office. He will start with the Reception area, which has the most visibility. If sales reach a certain amount by the end of April, George will purchase a desk, chair, computer, and software upgrade for the receptionist. Otherwise, George will just purchase the desk and chair. How can George determine the best action to take using a Sales Data worksheet?
B
While typing in a cell, you can press the ____________________ key to erase all the characters back to and including the incorrect character you just typed
BACKSPACE
____ ___means that the width of a column will be increased or decreased so the widest entry will fit in the column
Best fit
Leo, owner of Leo's Bread Company, recently installed Excel 2013 and created a new workbook to track sales of different types of bread. He wants to determine which types of bread are the most popular among his customers. He is particularly interested in sales of rye bread, onion rolls, and bagels. Leo has formatted the sales numbers with the Accounting number format. 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?
C
Anita is new to Microsoft Excel 2016. As she uses the application, she is beginning to see that Excel offers many features to help her save time and be more productive. Which of the following features helps Anita be more productive by automatically reducing the number of misspelled or mistyped words?
C. Autocorrect
The ____________________ option on the Auto Fill Options menu fills the destination area with contents using the format of the source area and does not create a series
Copy Cells
You can press the ____________________ key to quit Range Finder.
ESC
The ________ option on the Auto Fill Options menu fills the destination area with a series of months using the format of the source area.
Fill Months
The ____________________ option on the Auto Fill Options menu fills the destination area with the contents but without the formatting of the source area
Fill Without Formatting
The ____________________ option on the Auto Fill Options menu fills the destination area with a series that uses the format of the source area
Fill series
The __useful when you want to assign a value to a cell based on a logical test
IF
_______cells involves creating a single cell by combining two or more selected cells
Merging
You can specify the style and color for the parts of a sparkline chart by selecting a style in the Styles group on the _ _ _ _
SPARKLINE TOOLS DESIGN tab
You can click the ____________________ button arrow (HOME tab | Editing group) to view a list of often-used functions.
Sum
A(n) ____________________ cell reference instructs a paste operation to keep the same cell reference as it copies a formula from one cell to another.
absolute reference
The / arithmetic operator indicates ___________________
division
One of the reasons Excel is such a valuable tool is that you can assign a(n) ____________________ to a cell, and Excel will calculate the result
formula
As you type, Excel displays the entry (and the Cancel box and Enter box) in the ___________________
formula bar
When the Paste Options button is visible, you can use ____________________ to access the paste commands available in the Paste Options gallery
keyboard shortcuts
Like an area chart, a(n) ____________________ chart often is used to illustrate changes in data over time
line
In the order of operations, the last operation Excel performs is
subtraction, addition
A sensitivity analysis is another name for a(n) ____________________ analysis
what-if