Intro to Computing _ Excel
Excel _____ a formula when the cell reference value changes.
Automatically recalculates
If you type 5/6 in a cell, how will Excel automatically convert it?
6 - May
AutoComplete suggests text as you type, using data from the same row.
False
By default, Excel prints the gridlines around the cells or the row and column headings.
False
Formulas are contained and displayed in cells, while the results are displayed in the Formula Bar.
False
To move a chart, click anywhere in it and drag.
False
You can add pictures, shapes, text boxes, and videos to a worksheet.
False
Felix created a chart but doesn't like how it displays his data. What advice would you give him?
He can use the Change Chart Type tool to find a different chart.
Absolute reference
=$A$3
Mixed reference with absolute column
=$A3
If you copy the formula =$C19+$D19 down one cell, the new formula will show as:
=$C20+$D20
June is planning a cruise that costs $8,000 and needs to know how much to save each month over the next year to pay for it. What formula should she create?
=8000/12
Mixed reference with absolute row
=A$3
Relative reference
=A3
How do you restore a deleted worksheet?
A deleted worksheet cannot be restored
Click the red "X" on the Formula Bar.
Cancels the entry
Kelly wants to add cells E3, E4, and E5 and show the answer in cell E6. Which process will NOT produce the correct result?
Click cell E5, click AutoSum, and tap [Tab].
Lisa's boss asks her to create a chart that shows the number of sales made by each salesperson for their top-five products. Which chart type does she create?
Column chart
Column
Compares categorized data on a horizontal axis
Bar
Compares categorized detain a vertical axis
Pie
Compares parts of a whole
Click the green checkmark on the Formula Bar
Completes the entry without moving
Which task would NOT be performed in Excel?
Creating a main document
Which of these is NOT a way to insert a new row or column?
Double-click the row or column header.
Tim wants to reference another worksheet in his formula. How can he do this?
Enter the worksheet name, an exclamation point, and then the cell reference.
Lisa's boss asks her to create a chart showing the number of units sold for each of their top-two items from month to month throughout the year. Which chart type does she create?
Line chart
Tina's spreadsheet contains more than three hundred students' scores for a recent math test. What function can she use to find the highest score?
Max
Tap [Enter].
Moves one cell down
Tap [Tab].
Moves one cell to the right
Philip's worksheet has several complicated formulas. What command can he use to display the formulas (not formula results) in the cells?
Show Formulas
Which name reference is NOT a valid cell name?
Tax Rate
What happens when you change the data in a worksheet associated with a chart?
The chart is automatically updated.
What happens to a cell reference when you tap [F4]?
The selected cell becomes absolute.
Name references are absolute and will NOT change when moved or copied.
True
Use Insert Function to browse formulas and enter arguments and criteria.
True
You can insert one row or column at a time or several at once.
True
You can print a selected portion of your worksheet
True
You cannot resize a chart after it's been moved to its own sheet.
True
Using AutoFill, how do you create a list of numbers 1 through 20?
Type 1 in the first cell, type 2 in the cell below, select both cells, and drag the AutoFill handle down until it reaches 20.
Daniel's column headings are too long to show entirely in each cell. How can he make them appear on multiple lines in the same cell?
Use the Wrap Text command.
How can you focus in on a specific group of cells?
Use the Zoom to Selection Tool
Line
Useful for showing trends in data
Jade wants to add a background to her chart. Which of these is NOT a chart background option?
Video
Which is NOT an Excel navigation method?
[Ctrl]+[P]