Computing Excel Exam

The default file format for Excel 2016:

.xlsx

An Excel function that determines the largest value in a selected range of values.

MAX

An Excel function that determines the smallest value in a selected range of values.

MIN

The function that retrieves and then displays the date and time from your computer is the:

NOW function

A cell reference that refers to a cell by its fixed position in a worksheet is referred to as being:

absolute

The type of cell reference that refers to cells by their fixed position in a worksheet is

absolute

An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column is

autoFit

A workbook sheet that contains only a chart.

chart sheet

A format that changes the appearance of a cell—for example, by adding cell shading or font color—based on a condition; if the condition is true, the cell is formatted based on that condition, and if the condition is false, the cell is not formatted.

conditional formatting

Numbers sorted from highest to lowest are sorted in:

descending order

A cell can only contain a number

false

Sheet tab names can not be changed

false

There is only 1 way to view a date, no formatting allowed

false

The Excel command that recognizes a pattern in your data and then automatically fills in the values when you enter examples of the desired output is:

flash fill

A command that enables you to select one or more rows or columns and lock them into place; the locked rows and columns become separate panes.

freeze panes

One of Excel's What-If Analysis tools that provides a method to find a specific value for a cell by adjusting the value of one other cell—find the right input when you know the result you want.

goal seek

A type of chart that displays trends over time.

line

A chart type that displays trends over time is a:

line chart

The action of placing cell contents that have been copied or moved to the Clipboard into another location is called: ll contents that have been copied or moved to the Clipboard into another location is called:

paste

The abbreviation for number of time periods in various Excel functions

per

The total amount that a series of future payments is worth now.

principal

A box in the upper left corner of the worksheet grid that selects all the cells in a worksheet is the:

select all box

A command that organize data in a particular order.

sort

Tiny charts embedded in a cell that give a visual trend summary alongside your data are:

sparklines

The command that totals several rows of related data together.

subtotal

Data validation is used to control the type of data or the values that are entered into a cell.

true

Excel follows the same math rules, also known as orders of operation

true

A method to find a specific value for a cell by adjusting the value of one other cell. With this, you can work backward from the desired outcome to find the number necessary to achieve your goal.

vlookup

Loans are typically made for a period of:

years