Intro to Computing _ Excel

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

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]


Set pelajaran terkait

Chapter 14.3 Meiosis and Sexual Reproduction

View Set

Ch. 2 Developing the Problem and Using the Literature Quiz

View Set

Chapter 7: Civil Rights and Fair Housing

View Set

Programming Languages Chapter 7 Review

View Set