Introduction to Excel: PENN FOSTER
Exam Questions and Answers 100%
Solved
On a spreadsheet, what runs vertically and is identified with letters? -
✔✔Columns
Which contextual tab appears when you select an image that has been
added to a worksheet? - ✔✔Picture tools format
You would like the cell reference in a formula to remain the same when you
copy it from cell A9 to cell B9. This is called a/an _______ cell reference. -
✔✔absolute
To quickly create a chart from a selected range of numeric data, you can
select: - ✔✔Quick analysis
What's the default Total Row function? - ✔✔subtotal
Which function would you use to find the average of totals in cells C1
through C5? - ✔✔=AVERAGE(C1:C5)
Misspelled words in excel are: - ✔✔not automatically flagged
Exam Questions and Answers 100%
Solved
On a spreadsheet, what runs vertically and is identified with letters? -
✔✔Columns
Which contextual tab appears when you select an image that has been
added to a worksheet? - ✔✔Picture tools format
You would like the cell reference in a formula to remain the same when you
copy it from cell A9 to cell B9. This is called a/an _______ cell reference. -
✔✔absolute
To quickly create a chart from a selected range of numeric data, you can
select: - ✔✔Quick analysis
What's the default Total Row function? - ✔✔subtotal
Which function would you use to find the average of totals in cells C1
through C5? - ✔✔=AVERAGE(C1:C5)
Misspelled words in excel are: - ✔✔not automatically flagged
