Excel Practice Test
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.
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 worlsheets 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 dispays 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.
Which of the following methods for modifying cell content is incorrect?
A cell can be edited through Press the F2 key or Click the formula bar or Double click the cell.
In Excel, you can integrate the primary document with the data source. Word is commonly used in mail merging operations.
you can merge the main document with the data source in Excel. In mail merge operations, Word is usually client.
If Excel's Auto Calculate option is disabled, how can you update the values of formula cells?
Manual calculation mode means that Excel will only recalculate all open workbooks when we request it by pressing F9. It allows to choose whether we want to update formulas in worksheets or entire workbook.
In Excel, where can you switch between automated and manual calculation modes?
When you press F9 or click Calc Sheet on the Calculation tab on the Tools/Options menu. Calculation also occur every time that you have save the file if you have the checkbox "Recalculate workbook before saving" checked under File> Options > Formulas.
In an Excel worksheet, how do you show or hide the gridline?
In Excel 2016, 2013, 2010, 2007, click View > Show > Gridlines
For Excel 2003 and Earlier: Navigate to Tools > Optiions or Click Gridline tool on Forms toolbar.
Which of the Excel screen components can't be turned on or off?
Show Formula bar option by clciking the File (or Office button) > Options > Advances > Display > Show Formula bar.
In earlier version of Excel, you could hide the status bar if you wanted more space available for your worksheets. However, the capability was removed starting with Excel 2017.
In earlier version of Excel, yoou could hide the tool bar as per requirement. However, that capability was removed starting Excel 2007 and introduced Ribbon.
It is acceptable to let long text stream into adjoining cells on a worksheet when
When there is no data in the adjacent cells, long text flows into adjacent cells on the worksheet. As soon as data is entered into the adjacent cells, text will be visible upto cell length in which data is entered. For full visibility of data either we need o increase the length of cell or wrap text in particular cell.
In Excel, the shortcut key Ctrl + D will
Ctrl + D fills the cell beneath with the contents of the selected cell in column. To fill more than one cell, select the source cell and press Ctrl+Shift+Down to select all cells. Then press Ctrl+D to fill them with the contents of the original cell.
You'll be able to move a sheet from one workbook into a new book by
C) From Edit menu choose Move of Copy the choose (Move to end) and click OK