# FREE Excel Basic and Advance Questions and Answers

#### What shortcut keys can you use to quickly aggregate rows so you may enlarge or reduce an area of data?

Pressing "ALT + SHIFT + RIGHT ARROW" in Excel will quickly group or outline the selected rows, allowing you to collapse and expand the grouped rows to show or hide the detailed data.

#### What are the AutoSum shortcut keys?

The AutoSum shortcut keys in Excel are:

ALT and =

Pressing "ALT" and "=" (equal sign) keys simultaneously in Excel will quickly insert the AutoSum function, allowing you to sum the numbers in the column directly above the active cell. This shortcut is a convenient way to perform a quick summation of a column of numbers without manually typing the formula.

#### How do you switch Workbook Views to Page Break Preview on the ribbon?

#### What are the shortcut keys on the keyboard for editing a cell's formula?

#### Which one of the aforementioned Excel capabilities enables you to select/highlight every cell that contains a formula?

The "Go To Special" Excel capability enables you to select or highlight every cell that contains a formula.

#### As indicated in column E2, Company A is considering four possible projects and will approve them if the IRR is 10% or above. What is the formula in cell C2 that produces the outcomes displayed below and can be duplicated down to cells C3 through C5?

#### What are the short cuts in an Excel spreadsheet to add a new row?

The correct shortcut in an Excel spreadsheet to add a new row is:

ALT + H + I + R

Pressing the keyboard shortcut "ALT + H + I + R" in Excel will insert a new row above the currently selected row. This is a quick way to add a new row without having to use the mouse and right-clicking on the row number to choose the "Insert" option. The "ALT + H + I + R" shortcut provides a more efficient method to add rows when working with Excel spreadsheets.

#### Which of the following characteristics is not available in the Data ribbon?

#### What key combination on the keyboard locks cell references in a formula?

The key combination "F4" on the keyboard is used to lock cell references in a formula in Excel. When you create a formula with relative cell references (e.g., A1, B2, C3), you can use the "F4" key to toggle between different types of cell references: relative, absolute, and mixed references.

#### How can a dynamic date that displays the final day of each month be created in cell G2?

#### Let's say that cell A1 shows the value "12000.7789". How should this number be rounded to the nearest integer using the following formula?

#### What excel financial modeling technique is recommended?

Using blue font for hard-coded numbers and black font for formulas is not a specific financial modeling technique. Instead, it is a formatting convention that some financial modelers or spreadsheet users follow to make their Excel models easier to read and understand.

#### What are the shortcut keys on the keyboard for inserting a table?

The shortcut keys on the keyboard for inserting a table in Excel are:

ALT + N + T

Pressing "ALT + N + T" keys together will open the "Create Table" dialog box, allowing you to quickly create a table from a selected range of data in Excel.