Admin Table of Contents
- 1 What option buttons gives options for filling cells following a fill operation?
- 2 What can you use to check which cells are referenced in the formula assigned to the active cell?
- 3 How many types of errors are there in Excel?
- 4 How will you check for and evaluate errors in Excel 2010 Formulas?
- 5 How do you select certain cells in Excel using the keyboard?
Select the cell with the formula and the adjacent cells you want to fill. Click Home > Fill, and choose either Down, Right, Up, or Left. Keyboard shortcut: You can also press Ctrl+D to fill the formula down in a column, or Ctrl+R to fill the formula to the right in a row.
What can you use to check which cells are referenced in the formula assigned to the active cell?
Excel Exam Review
| Question | Answer |
|---|---|
| You can open the Format Cells dialog box by pressing the ____ keys. | Ctrl+1 |
| You can use the ____ to check which cells are referenced in the formula assigned to the active cell. | Range Finder |
What allows you to select cells for use in a formula by using the mouse?
Just as reaching a input point allows the user to select cells with the mouse, it is possible to use the keyboard to select cells. Just use the cursor keys and selection modifiers to create a selection. Using the keyboard to enter data into a formula.
How many types of errors are there in Excel?
Excel’s error values
| Error Value | Meaning |
|---|---|
| #NULL! | You specified an intersection of two cell ranges whose cells don’t actually intersect |
| #NUM! | Problem with a number in the formula |
| #REF! | Invalid cell reference |
| #VALUE! | Wrong type of argument in a function or wrong type of operator |
How will you check for and evaluate errors in Excel 2010 Formulas?
Evaluating formulas Select the cell containing the formula and click the Evaluate Formula button on the Formulas tab of the Ribbon. The Evaluate Formula dialog box appears. Using the Evaluate Formula dialog box to assess a formula. Click the Evaluate button one or more times to evaluate each expression in the formula.
How do you select a cell for a formula?
Use cell references in a formula
- Click the cell in which you want to enter the formula.
- In the formula bar. , type = (equal sign).
- Do one of the following, select the cell that contains the value you want or type its cell reference.
- Press Enter.
How do you select certain cells in Excel using the keyboard?
Select one or more cells
- Click on a cell to select it. Or use the keyboard to navigate to it and select it.
- To select a range, select a cell, then with the left mouse button pressed, drag over the other cells.
- To select non-adjacent cells and cell ranges, hold Ctrl and select the cells.