Click on the cell then hit the Delete key.
The row is inserted at the cell selector position, moving the current row, and all rows below it, down.
1) Make the cell active then F2
2) Double click on the cell
3) Make the cell active then click on the formula bar
The copy command is cancelled, causing the moving border around the selected cell(s) to disappear.
The contents of the selected cell(s) are copied to the range of cells covered by dragging the fill handle.
The number is right aligned.
True.
1) Format menu, Column, Width..., then type in the new column width value
2) Drag and drop the column divider line located to the right of the column letter
3) Format menu, Column, AutoFit Selection
4) Double-click on the column divider line located to the right of the column letter
Allows you to choose a format category for the active cell(s). Once the category is selected, you may choose specific formatting options that pertain to this format category.
1) Currency
2) Percent
3) Comma.
True.
+ addition
- subtraction
/ division
* multiplication
^ exponentiation
Click on a cell, type =, then click on cells to enter the cell reference and type in the arithmetic operators.
Since the formula is being copied from row 2 to row 3 (copied 1 row down) within the same column, the row values for each relative cell reference is increased by one. So, ...
=A2+B2+C2
Since the formula is being copied from column B to column C (copied 1 column to the right) within the same row, the column values for each relative cell reference will be adjusted by one column to the right. So, ...
=B1+C1+D1
Formulas are automatically recalculated whenever a change occurs in a reference cell.
False. It's the reverse.
False. The zoom drop-down is on the standard toolbar.
Creates a formula in the active cell using the sum function. Excel automatically proposes a range based upon the data above or to the left of the active cell.
In ExcepXP, the AutoSum button also contains a drop down list of commonly used Excel functions, and gives the user access to all Excel functions.
ExcelXP no longer has a Paste Function button on the standard toolbar. This feature is now done via the drop down list from the AutoSum button.
Formatting toolbar.
A worksheet (commonly called a spreadsheet) is a rectangular grid of rows and columns used to enter data. A workbook is an Excel file, which contains a collection of worksheets.
Moves the cell selector to the last-used cell in the row.
1) File menu, Page Setup..., Header/Footter tab, then select an item from the Header drop-down list
2) File menu, Print Preview, Setup... button, Header/Footer tab, then select an item from the Header drop-down list
3)click on the Print Preview button on the standard toolbar, Setup... button, Header/Footer tab, then select an item from the Header drop-down list
Select a range of cells in one row (or one column). The first cell in the range usually contains the value that you want to center across the entire range of cells. Then click on the Merge and Center button on the formatting Toolbar.