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