Show
#
Which of the following commands locks rows or columns in view?On the View tab, select the Freeze Panes command, then choose Freeze Panes from the drop-down menu. The rows will be frozen in place, as indicated by the gray line. You can scroll down the worksheet while continuing to view the frozen rows at the top.
What is the Excel function that adds a group of values and then divides the result by the number of values in the group?Average Function:
an excel function that adds a group of values, and then divides the result by the number of values in the group.
What is a predefined formula that performs calculations by using specific values in a particular order or structure in Excel?A function is a predefined formula that performs calculations using specific values in a particular order. All spreadsheet programs include common functions that can be used for quickly finding the sum, average, count, maximum value, and minimum value for a range of cells.
What is the formatting that changes the appearance of a cell or range when one or more conditions are true?Conditional formatting makes it easy to highlight certain values or make particular cells easy to identify. This changes the appearance of a cell range based on a condition (or criteria). You can use conditional formatting to highlight cells that contain values which meet a certain condition.
|