Exam review 1

A cell address in a formula that will not change when you copy the formula to another location.

Excel is a ____________ application

What ribbon in layout view contains the commands to inserts/delete new rows n columns in a report?

When you click the Copy command, the border of the selected cell turns yellow?

Symbols used in mathematical operations that include (+, -, *, /).

Where is 'Flash Fill' located?

Mya wants to print her completed music databases and wants to use the report tool. Is she correct?

Which is an actual Excel count function?

A style that displays numbers with a thousand separator (,).

Which is an example of an absolute reference?

To change the BG color of the form so it looks correctly Which option he needs 2 modify theform?

The horizontal and vertical lines on a worksheet are called ______

Which is an actual Excel average function?

Which tab contains the ability to create a pie chart?

To remove a cell's contents or formatting.

What function would you use to look up a value in a column of a table?

Where can you go to delete a Worksheet?

In order to drag and drop a selected group of cells, your mouse must change to ___.

MAX, MIN, AVG and SUM are all _________

Fill color is applied to the __ of a cell.

Where would you go to add a footer or header?

Which ribbon contains the ability to create a column chart?

With a cell active within a range of data, where can you go to format that range as a table?

How could you group worksheets?

The cell that contains the cell pointer. There is a dark outline around this cell.

Which function returns the smallest number in a set of values?

A feature of Microsoft Excel 2013 which you access file and program management control.

On which tab are the number formats located?

On which tab can you find 'Cell Styles'?

Which is an example of a 3D reference?

A feature used to complete an entry based on previous entries made in the column.

A new, empty workbook that contains one worksheet (sheet).

All formulas must start with__.

What function would you use to look up a value in a row of a table?

What function would you use to count a range of cells containing any type of data?

How do you rename a worksheet?

Style vertically aligns with dollar signs ($), thousands of separators (,), and decimal points

Which is an example of a mixed reference?

How do you delete a Worksheet?

What function would you use to count a range of cells containing only numeric data?

The feature that enables Excel to create a series automatically.

Where is 'Flash Fill' located?

If you double click on a heading boundary it will ___ _________ your column or row.

Cole has created a report. Which view could he use to see exactly how the report will look on paper?

Which function returns the largest number in a set of values?

File, Insert, Page Layout, Data, Review and View are all called _________.

Which is an example of a relative reference?

The intersection of a column and a row on a worksheet.

A button in a dialog box that you click to downsize a dialog box to make a selection on a sheet is a Collapse Dialog box

How could you add numeric cell values together?