A numeric value can be treated as a label value if it precedes with
Answer: A
Correct answer: Apostrophe (’)
A leading apostrophe forces the entry to be treated as text, so a number keeps its leading zeros and is aligned left. The apostrophe is not displayed or stored as part of the value.
Please log in or register to report this question.
Concatenation of text can be done using
Answer: D
Correct answer: Ampersand (&)
The ampersand joins text: =A1&" "&B1 puts the contents of two cells together with a space between. CONCATENATE does the same thing as a function.
Please log in or register to report this question.
Data can be arranged in a worksheet in a easy to understand manner using
Answer: D
Correct answer: all of above
All three make a sheet easier to read: AutoFormat applies a coordinated set of formats at once, styles apply a named combination consistently, and the choice of font affects legibility directly.
Please log in or register to report this question.
You can use drag-and-drop to embed excel worksheet data in a word document
Answer: A
Correct answer: By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
Dragging alone would move the data; holding Ctrl makes it a copy, and dropping onto the Word button on the taskbar brings that window to the front so the data can be released into the document.
Please log in or register to report this question.
The auto calculate feature
Answer: B
Correct answer: Provides a quick way to view the result of an arithmetic operation on a range of cells
AutoCalculate shows the sum, average, count, maximum or minimum of the selected cells on the status bar. It only displays the result; nothing is written into the sheet.
Please log in or register to report this question.
Excel uniquely identifies cells within a worksheet with a cell name
Answer: C
Correct answer: Column letters and row numbers
A cell is identified by its column letter and row number - A1, B7, IV65536 - in that order.
Please log in or register to report this question.
to view a cell comment
Answer: C
Correct answer: position the mouse pointer over the cell
A comment appears when the pointer rests on the cell carrying the red triangle, and disappears when it moves away. Showing it permanently is a separate option.
Please log in or register to report this question.
When you want to insert a blank imbedded excel object in a word document you can
Answer: A
Correct answer: Click the object command on the insert menu
Insert > Object creates a new embedded object of a chosen type, so a blank Excel worksheet appears in the Word document ready to be filled in.
Please log in or register to report this question.
To save a workbook, you:
Answer: A
Correct answer: Click the save button on the standard toolbar from the menu bar choose File >> Save
Saving is done from the toolbar button, from File > Save, or with Ctrl + S. Ctrl + F5 restores the window and the Windows Start button has no Save command.
Please log in or register to report this question.
You can edit a cell by
Answer: B
Correct answer: Double clicking the cell to edit it in-place
Double-clicking puts the cell into edit mode with the cursor where it was clicked. Pressing F2 or clicking in the formula bar does the same thing.
Please log in or register to report this question.
