Which of the following statements accurately describes the default selection for AutoSum?Which of the following statements accurately describes the default selection for AutoSum? By default, AutoSum calculates the total from the adjacent cell through the first nonnumeric cell.
Which of the following Excel built in formulas is correct if you want to add numbers?The correct answer is SUM. SUM is used for the addition in MS Excel. The SUM function is located in the Home tab in the ribbon. SUM function adds all numbers in a range of cells and returns the result in MS Excel.
Which function should be used if you want to COUNT the number of nonblank cells in your worksheet?Count nonblank cells in a range by using the COUNTA function
Use the COUNTA function function to count only cells in a range that contain values.
Does Excel automatically save a copy of every 10 minutes?By default the AutoRecover feature is set to automatically save changes to your workbook every 10 minutes. You can shorten or lengthen this interval as you like. Here you can also change Excel AutoRecover file location and specify AutoRecover exceptions.
|