0
What action is used when Excel suggests the wrong range after clicking the SUM button?
Wiki User
∙ 10y ago
Correct the range by dragging the appropriate cells in the worksheet. You could also type in the correct range.
Wiki User
∙ 11y ago
Wiki User
∙ 10y agoYou could type in the correct range, or you could manually select it with the mouse. In either case, have the cursor in the range so that it replaces the wrong one with the correct one.
Add your answer:
Earn +20 pts
Excel remembers the last 100 actions you have completed Thus you can undo up to 100 previous actions by clicking the button arrow to display the Undo list and then clicking the action to?
Undo
How do you quit ms Excel program?
By clicking on the X Button on the top right corner of the Excel Window.
When you click the located in the upper left corner of the window as shown in the accompaying figure excel displays the office button menu?
That is true. Clicking the Office button opens the menu.That is true. Clicking the Office button opens the menu.That is true. Clicking the Office button opens the menu.That is true. Clicking the Office button opens the menu.That is true. Clicking the Office button opens the menu.That is true. Clicking the Office button opens the menu.That is true. Clicking the Office button opens the menu.That is true. Clicking the Office button opens the menu.That is true. Clicking the Office button opens the menu.That is true. Clicking the Office button opens the menu.That is true. Clicking the Office button opens the menu.
What action occurs when clicking the diamond icon located between the row numbers and the column letters in excel?
You select the entire worksheet.
What do you call the sheets in excel?
Normally when you open Excel there are 3 sheets open. They are Sheet1, Sheet2 and Sheet3. Sometimes you will want to give more meaningful names to those sheets. By right clicking on the sheet tab and clicking the Rename option or by double clicking, you can rename a sheet. So you could have many sheets with names on them that are meaningful to what you are doing, which is what we mean by naming sheets.
What is the Fx formula on Excel?
Fx represents functions. It is on the Formula Bar and on the Insert Function Button. Clicking on it starts the process of allowing you to enter a function.
Where is the formula error button in Excel 2007?
There is no formula error button in Excel. However, there is an Error Checking button on the Formulas ribbon in the Formula Auditing section in Excel 2007.
How do you print odd pages and even pages in MS Excel?
MS Excel does not have the ability to selectively print odd or even pages. You need to use the function on your printer for that option. When you print from Excel, instead of just clicking the print button, select print and click on the printer PROPERTIES button. If your printer has the ability to selectively print odd or even pages, you will select that option according to your printer's specifications.
What button opens a menu of basic commands such as save and print in Excel?
Excel 2003 and older: File menu button Excel 2007 and newer: MS Office button (circle at top left of window)
A central location for managing and sharing in Excel?
The Offic Button in Excel.
What are spin buttons in Excel?
They are buttons that can be added to a worksheet and associated with a cell to allow you to quickly change the value in the cell by clicking on the button rather than having to type a new value into a cell.
Which button formats data as a table in Excel?
In Excel 2007, use the "Format as Table" button in the Styles section of the Home tab.
