. Ctrl + A Select all contents of the worksheet. When you link data maintained in an excel workbook to a word document a. Display the style dialog box Display the insert function dialog box Create a new, blank workbook Open Print Preview Answer 12. Files created with Lotus 1-2-3 have an extension a. Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells b. Test your Excel skills with the free 10 Question Multiple Choice Excel Quiz with Answers and Answer Explanations.
All of the above 36. Please visit for question banks, online quiz, downloads, subjective questions and answers. Which of the following methods can not be used to edit the contents of a cell? Shows the location of the previously active cell b. Return a formula result d. The software allows basic calculations, pivot tables, online formulas, boolean logic, functions and more. With the right drag method b.
Press Shift + Home d. Click the save button on the standard toolbar from the menu b. Column letters and row numbers d. Data will be entered in the adjacent cells b. Knowing the correct names for different areas on the screen will assist you in understanding tutorials and Microsoft Office help answers and is well worth investing time in. Which of the following is not information you can specify using the solver? Values or cell references although not both at the same time d.
You can activate a cell by a. Prepare for your assessment with our JobTestPrep Excel practice and get the position you are seeking. So, every time a new value added to the cell, the cell will calculate according to the reference cell formula. There are no pages containingorphan paragraph, so, even if you get any page missing, it won't be a huge loss. Pressing an arrow key b. Click the object command on the insert menu b. Show formula error value 6.
Pressing the Alt key and clicking the format painter button 41. Excel uniquely identifies cells within a worksheet with a cell name a. Format number in comma format. Please visit for question banks, online quiz, downloads, subjective questions and answers. In order to eliminate certain sheets from the changes, hold down the Ctrl key and click on the tab of the worksheet you want excluded from the others.
Employers attribute great importance to software control, and this is a threshold requirement to be hired. When you copy a formula a. Please visit for question banks, online quiz, downloads, subjective questions and answers. In the given screenshot, the letter X is pointing to an area between the first Row header, and the first Column header. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet? Which of the following statements is not true regarding offline cube files in Microsoft Excel 2010? Ctrl + Shift + Format number in time format. With commands on the shortcut menu c.
When you insert an excel file into a word document. The cell marked with A1 must be pasted in cell A1 on the spreadsheet. Please visit for question banks, online quiz, downloads, subjective questions and answers. You want to track the progress of the stock market on a daily basis. Then you can change margins, paper size and layout, page breaks and column widths and print the cell borders and column headings at the top of each page to make it easy to read. Ctrl + Tab Move between two or more open Excel files.
Increase the column width c. C ell references but not values c. What are the benefits of digitally signing an e-mail in Microsoft Excel 2010? It is used to enter and edit worksheet data. Please visit for question banks, online quiz, downloads, subjective questions and answers. To do this, you will need to right click on one of the worksheet tabs and then choose Select All Sheets. Edit the data in a excel source application d. There is no suitable abbreviation of the text d.