After performing an arithmetic action on two cells containing dates and the result is a number, you shouldformat the cell to show a dateIf the number in a column are arraigned from largest at the top to smallest at the bottom the sort order isdescendingThe countif function is used tocount the number of times a specific condition is met within a defined data rangeA pie chart can contain _____ data ranges.1The fit to option is used tomake the active sheet print on to a single pageThe formula =(4 + 3) * 2 will evaluate as:14The mode function will give you thethe most common occurring value of a range of valuesThe ________ defines what the data islegendWhat is true about adding a new record to an existing table?you add it below the last record and Excel will extend the table to include itIf you wish to keep the titles in column A visible as you page to the right you shouldyou should freeze the first columnTo calculate the Mean of a set of numbers you would use the ________ function.AverageTo include two non-adjacent columns in a pie chart (one title, one data).Highlight the first desired column, press and hold the control key, select the second column, Select Insert, Select witch type of pie you want
Highlight the first desired column, press and hold the control key, select the second column, Select Insert, Select which type of pie you wantA cell address that adjusts both the row and column values to its new location when copied is known as arelative addressIf you wanted to show the change of a value over time such as the price of a stock you would use a ________ chart.lineIf you want to highlight the background of a cell you would use the ________ command.fill
