FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 13: Excel: Formulas, Functions, and Formatting

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

True/False

Review LaterAdd Note

Review Later

Excel has more than 400 functions that perform just about every type of calculation you can imagine.

A) True
B) False

Correct Answer

verified

Show Answer

Question 52

True/False

Review LaterAdd Note

Review Later

Point mode allows you to select cells for use in a formula by using your finger or the pointer.

A) True
B) False

Correct Answer

verified

Show Answer

Question 53

Multiple Choice

Review LaterAdd Note

If you do not assign a format to a cell or cells in a column,the column width will remain ____ characters.

Explain what circular references,direct circular references,and indirect circular references are.

____________________ colors jump out of a dark background and are easiest to see.

Moving from left to right,the first calculation in the order of operations is negation (-).

____________________ view shows the worksheet divided into pages.

You can choose from 12 categories of formats in the Format Cells dialog box._________________________

You can click the Format Cells Dialog Box Launcher to open the Format Cells dialog box.

To use ____________________ to verify that a formula contains the intended cell references,double-tap or double-click the cell with the formula you want to check.

Identify the letter of the choice that best matches the phrase or definition. -A formula in a cell that contains a reference back to itself.

Which of the following is the path to the Sum arrow?

To select a number format,you can choose a category in the Number tab in the Format Cells dialog box and then select the number of decimal places,whether or not a dollar sign should be displayed,and how negative numbers should appear.

____ view allows you to create or modify a worksheet while viewing how it will look in printed format.

While holding down the ALT key,you can select nonadjacent ranges and cells._________________________

When you decrease the row height to ____,the row is hidden.

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.

Briefly discuss the order of operations.

Which of the following is the path to the Spelling button?

When Excel recognizes that you entered a date in mm/dd/yy format,it automatically formats the date as ____________________.