FREE Excel Basic and Advance Questions and Answers
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.
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.
Which of the following characteristics is not available in the Data ribbon?
How can a dynamic date that displays the final day of each month be created in cell G2?
What distinguishes the keyboard shortcuts for pasting?
Which of the following represents the weighted average score calculation algorithm for cell C8 as shown below?
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.
What are the shortcut keys on the keyboard for editing a cell's formula?
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.
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.
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?
How do you switch Workbook Views to Page Break Preview on the ribbon?
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.
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 equation needs to be typed into cell A3 in order to reflect the outcomes as displayed below?
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.