Module 4 Review

Question 1

Excel uses order of operations to determine which parts of a formula are calculated before other parts of the formula.

Accepted Answer

True

Question 2

What keyboard shortcut can you use to insert a table?

Accepted Answer

Ctrl + T

Question 3

Which command displays data in an alphabetized or numerical order?

Accepted Answer

Sort

Question 4

Once you name a range, you can change the size of the range using the Name Manager.

Accepted Answer

True

Question 5

A ________ adjusts automatically if you make changes to the worksheet.

Accepted Answer

Relative Cell Reference

Question 6

In order to view the formula in the active cell, what do you do?

Accepted Answer

Double-click the active cell

Question 7

A table name can have up to ------ characters

Accepted Answer

255

Question 8

Which of the following is an acceptable name for a named range?

Accepted Answer

subtotal.wednesday, subtotal_wednesday

Question 9

What allows you to select the arrow in the column header to narrow the data?

Accepted Answer

Filter Button

Question 10

A range can be named in the Name Box.

Accepted Answer

True

Question 11

Which of the following is not a mathematical operator in excel?

Accepted Answer

[

Question 12

A table can be converted to which of the following?

Accepted Answer

Data Range

Question 13

What option is a unique combination of borders and shading to change the appearance of the table?

Accepted Answer

Styles

Question 14

Which of the following options cannot be part of a range name?

Accepted Answer

Space

Question 15

The Name Manager, where named cell ranges can be edited, is on which tab?

Accepted Answer

Formula

Question 16

The formula =6*2/3produces the same result as =6*(2/3).

Accepted Answer

True

Question 17

A filter based on cell color can be applied to a column.

Accepted Answer

True

Question 18

Which of the following fields create a named range? Select all that apply.

Accepted Answer

Define Name, Name Box, Name Manager

Question 19

Special range names may begin with the caret (^) character.

Accepted Answer

False

Question 20

Which of the following options are choices in the Sort Options dialog box?

Accepted Answer

Orientation, Case sensitive

Question 21

You can access a table from which of the following areas? Select all that apply.

Accepted Answer

Name Box, Go To

Question 22

What command is where a named range can be created, edited, and deleted?

Accepted Answer

Name Manager

Question 23

What command is created to sort by any other characteristic that doesn’t sort well alphabetically?

Accepted Answer

Custom List

Question 24

Which table row calculates numeric data by using functions?

Accepted Answer

Total Row

Question 25

What command provides a way to select additional rows and columns to include in an existing table?

Accepted Answer

Resize Table

Question 26

What is the default name for a new table?

Accepted Answer

Table1

Question 27

You can revert back to the original formula by pressing which key?

Accepted Answer

Esc

Question 28

Does Excel recognizes a construct like 3+4= as a legitimate formula?

Accepted Answer

False

Question 29

In order to display all formulas in your worksheet, what do you do?

Accepted Answer

Formulas Tab- Show Formulas

Question 30

Which command provides a way to sort with multiple levels?

Accepted Answer

Custom Sort

Question 31

What are even rows that are formatted differently than odd rows?

Accepted Answer

Banded Rows

Question 32

An absolute cell reference requires which symbol?

Accepted Answer

$

Question 33

You can name a range with a right-click or using the context menu.

Accepted Answer

True

Module 4 Review

Questions 33

Module 4 Review

Questions 33