Which step completes an entry and moves the pointer to the cell to the right?

Which mathematical operator is represented by an asterisk (*)?

Which function automatically totals a column or row of values?

Which cell alignment is assigned to most values by default?

Which function results can be displayed in AutoCalculate?

Which command allows you to reverse an Undo command?

Which key when pressed displays the access keys?

When navigating in a workbook, which command is used to move to the beginning of the current row?

Which command reverses the last action performed in the worksheet?

Where is the address of the active cell displayed?

As you type a number in a cell, what mode appears in the status bar?

Which view shows margins and the rulers?

Which key combination collapses the ribbon?

The AutoAdd function adds up numbers in a column or row you specify

"CCC" is an example of a ____ in Excel.

_______ quickly highlight(s) important information in a spreadsheet that match your criteria by applying formatting options, data bars, color scales, or icon sets.

The best formula to calculate Profits for January is:

The best formula to calculate the Average for Profits is:

As a general rule, Excel will _____-align numbers.

Cell D4 contains the formula =C1+C2. What formula will see when you paste this into cell E5?

When you copy a formula that contains an absolute reference to a new location, the reference ____.

Which of the following is a logical function?

The image above shows a:

Excel will reference the chart’s data source above as:

The words "Pre-sales" and “Conference Attendance” in the image above are called the chart ______:

____ order arranges content in reverse alphabetical order, from Z to A

Selecting the “Food” button on the slicer on the right will mean that the data table on the left will:

A worksheet ____ is a collection of two or more selected worksheets.

The ______ function returns TRUE if any of its arguments evaluate to TRUE, and returns FALSE if all of its arguments evaluate to FALSE.

To determine the number of sales people by region who have 50 or more orders, we use the:

Removes all spaces from text except for single spaces between words.

An Excel file is called a workbook?

What keystrokes would you press to bring up the “Excel Help” window?

If you press the “Tab” key it moves one cell to the left.

You can format text in a cell in Excel.

Excel automatically adjusts row height to accommodate the size of data in a row.

To add color to a row or column you click the ___.

You can create mixed references by placing a dollar sign in front of only the column letter or only the row number.

You can insert a row by right clicking a column heading.

You can cut and paste data from one cell into another. Instead of using the mouse to do the cut and paste, you can use the keyboard. To cut press _________; to paste, press

“Values” can include numbers, formulas, and functions.

If you look at a worksheet and cannot see certain columns, it is probably because the worksheet has ___ columns.

When editing the “Margins” you can only edit the left and right side of the Worksheet.

Which of the following features allows you to limit down the data in your worksheet?

According to the order of operations, which calculation comes first in the following formula?

=3^2/5+(12-3)

Left-aligned by default

After choosing copy or cut, the range affected is surrounded by a dotted line;

spreadsheets typically leave cut data in place until it is pasted elsewhere