1. Fill in the blanks.
a. The address of the currently active cell is displayed in the
b. A workbook in Excel is saved with the file extension
c. You can enter the pre-defined series of data into a worksheet by using the
feature.
d. The
tab in the Format Cells dialog box provides you the font formatting
options,
e. The Merge cells options is located under the
tab of the Format Cells dialog box
f. All formulae or functions begin with the
sign
g. In a formula
cell reference refers to the same cell or cell range.
h. The
function is used to identify the largest number in a range of cells.
i. You can hold down the
key while selecting non-adjacent cells or range of cells.
symbol is used to designate absolute cell reference in a formula.
j. The symbol is used to designate absolute cell reference in formula
Answers
Explanation:
a. While using the Microsoft Excel, you can easily get the location of currently selected cell in the Name Box which lists on the left of the Formula Bar. But if the cell is named, you can't examine its location based on the displaying on the Name Box.
b. You can save an Excel 2007 or later workbook in the file format of an earlier version of Excel, in a text file format, and in other file formats, such as PDF or XPS. By default, files are saved in the . xlsx file format, but you can change the default file format for saving.
c. The Autofill features of excel allows you to fill a range of cell with series of data without typing all of it.
d. There are six tabs in the Format Cells dialog box: Number, Alignment, Font, Border, Patterns, and Protection. The following sections describe the settings available in each tab.
e. The merge cells options is located under the EXECEL HOME TAB tab of the format cells dialog box.
f. Technically, a formula is any expression that begins with an equals sign (=).
g. A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate. ... Data contained in different areas of a worksheet. Data on other worksheets in the same workbook.
h. The Excel MAX function returns the largest numeric value in a range of values. The MAX function ignores empty cells, the logical values TRUE and FALSE, and text values.
i. Select one or more cells
Select one or more cellsOr use the Shift + arrow keys to select the range. To select non-adjacent cells and cell ranges, hold Ctrl and select the cells.
If you do not want cell references to change when you copy a formula, then make those cell references absolute cell references. Place a "$" before the column letter if you want that to always stay the same. Place a "$" before a row number if you want that to always stay the same.
j. If you do not want cell references to change when you copy a formula, then make those cell references absolute cell references. Place a "$" before the column letter if you want that to always stay the same. Place a "$" before a row number if you want that to always stay the same.