FREE Excel Questions and Answers
A ________ is the point where two rows and columns meet.
Any combination of numbers or words can be entered in the cell
The ________refers to a group of cells.
A cell range can be referred to in a formula as well. In a spreadsheet, a cell range is defined by the reference of the upper left cell (minimum value) of the range and the reference of the lower right cell (maximum value) of the range. Eventually separate cells can be added to this selection, then the range is called an irregular cell range.
What is the location of the filling handle?
In Microsoft Excel, a fill handle is a feature to extend (and fill) a series of numbers, dates, or even text to a desired number of cells. In the active cell of the spreadsheet, the fill handle is a small black box at the bottom right corner
True or False: An Excel file is called a workbook?
Workbook. Also called a spreadsheet, the workbook is a unique file created by Excel XP.
What is the best way to remove of cell boarders?
On the Home tab, in the Front group, click the arrrow next Borders Button, and then
click No Border Button.
OR
Click Home -> the Border arrow -> erase Border, and then select the cells with the border you want to erase.
In Excel, where can you change the shading color for a group of cells?
The formatting and Drawing toolbar is a toolbar in Microsoft Office 2003 and earlier applications that gives the user the ability to change the formatting of selected text or cell.
When all of the numbers in a range between 0 and 100 should be displayed in red, what command would you use?
A condition format changes the appearance oc cell on the basis of conditions that you specofy.If the conditions are true, the cell range is formatted; if the condition are flase, the cell range is not formatted.
In Excel, you may set the page border.
There is no option to set page border in Excel
Which of the following statements about Conditional Formatting is not true?
In Conditional Formatting we cannot set condition to look for Bold and apply Italics on them.
Which of the statements below is false?
The width of a row and specified manually or fit automatically is invalid statement.
The formula palette can be used to
Formula palette is used to create and edit formula.
It is also possible to type a function directly into a cell, however, as there are over 300 functions built into Microsoft Excel, some of which are quite complex, excel provides the Formula Palette to simplify the process.
How do you activate the previous cell when a range is selected?
To go to previous cell we can use Go to function Ctrl + G
Which tool will you use to combine certain cells and position the content in the middle?
In 2003 and earlier versions - From Format Cells dialog box click on Merge Cells check box.
In 2007 and subsequent version - Merge & Center icon on the Home ribbon.
On the Excel screen, there are tab scroll buttons.
On the button left of the Worksheet, we find the Sheet Tab Scroll Buttons to move to the First sheet, Previous sheet, and Last sheet. They are followed by the tabs for the worksheets in our workbook and the Insert Worksheet button or tab, depending on the version of Excel we are using.
On the left of the formula bar, there is a Name box.
Name Box refers to an input box directly to the left of the formula bar. The Name Box normally displays the address of the "active cell" on the worksheet. You can also use the name box to quickly create a name range.
Each Excel file is a workbook with a variety of sheets. Which of the following can't be a workbook sheet?
Data sheet can not be a sheet in workbook.