A numeric value can be treated as label value if ...... precedes it.
Apostrophe ( )
Exclamation ( ! )
Hash ( # )
Tilde ( ~ )
Correct Answer :
A. Apostrophe ( )
Related Questions
Which command will you choose to convert a column of data into row?
Cut and Paste
Edit >> Paste Special >> Transpose
Both of above
None of above
It is acceptable to let long text flow into adjacent cells on a worksheet when
data will be entered in the adjecent cells
no data will be entered in the adjacent cells
there is no suitable abbrevition for the text
there is not time to format the text
Which of the following option is not available in Paste Special dialog box?
Add
Subtract
Divide
SQRT
Which of the cell pointer indicates you that you can make selection?
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
Which of the cell pointer indicates that you can fill series?
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
Which of the following is not a way to complete a cell entry?
Pressing enter
Pressing any arrow key on the keyboard
Clicking the Enter button on the Formula bar
Pressing spacebar
How can you print three copies of a workbook?
Select File > Properties form the menu and type 3 in the Copies to print text box
Select File > Print from the menu and type 3 in the Number of copies text box
Click the Print button on the standard toolbar to print the document then take it to Kinkos and have 2 more copies made
Press Ctrl+P+3
You can copy data or formulas
With the copy, paste and cut commands on the edit menu
With commands on the shortcut menu
With buttons on the standard toolbars
All of the above
While Finding and Replacing some data in Excel, which of the following statement is valid?
You can Find and Replace within the sheet or workbook
Excel does not have option to match case for find
Both are valid
None are valid
Rounding errors can occur
When you use multiplication, division, or exponentiation in a formula
When you use addition and subtraction in a formula
Because excel uses hidden decimal places in computation
When you show the results of formulas with different decimal places that the calculated results
Which of the cell pointer indicate that you can move the content to other cell?
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
What symbol is used before a number to make it a label?
( quote )
= ( equal )
_ ( underscore )
( apostrophe )
Excel worksheet cells work very similarly to what common element of the windows graphical user interface
Option buttons
List boxes
Text boxes
Combo boxes
Which of the following is the oldest spreadsheet package?
VisiCalc
Lotus 1-2-3
Excel
StarCalc
When a label is too long to fit within a worksheet cell, you typically must
Shorten the label
Increase the column width
Decrease the column width
Adjust the row height
Where can you change automatic or manual calculation mode in Excel?
Double CAL indicator on status bar
Go to Tools >> Options >> Calculation and mark the corresponding radio button
Both of above
None of above
Which function is not available in the Consolidate dialog box?
Pmt
Average
Max
Sum
Status indicators are located on the
Vertical scroll bar
Horizontal scroll bar
Formula bar
Standard toolbar
Which of the following you can paste selectively using Paste Special command?
Validation
Formats
Formulas
All of above
Hyperlinks can be
Text
Drawing objects
Pictures
All of above
Which Chart can be created in Excel?
Area
Line
Pie
All of the above
Which of the following options is not located in the Page Setup dialog box?
Page Break Preview
Page Orientation
Margins
Headers and Footers
Where can you set the shading color for a range of cells in Excel?
Choose required color form Patterns tab of Format Cells dialog box
Choose required color on Fill Color tool in Formatting toolbar
Choose required color on Fill Color tool in Drawing toolbar
All of above
You can set Page Border in Excel from
From Border tab in Format Cells dialog box
From Border tool in Formatting toolbar
From Line Style tool in Drawing toolbar
You can not set page border in Excel
You can auto fit the width of column by
double clicking on the column name on column header
Double click on the cell pointer in worksheet
Double clicking on column right border on column header
Double clicking on the column left border of column header
You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that?
Custom List
Auto Fill Options
Fill Across Worksheet
Fill Series
You can enter which types of data into worksheet cells?
Labels, values, and formulas
Labels and values but not formulas
Values and formulas but not labels
Formulas only
The command Edit >> Fill Across Worksheet is active only when
One sheet is selected
When many sheets are selected
When no sheet is selected
None of above
How do you insert a row?
Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
Select the row heading where you want to insert the new row and select Edit >Row from the menu
Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
All of the above
Which of the following methods cannot be used to enter data in a cell
Pressing an arrow key
Pressing the Tab key
Pressing the Esc key
Clicking on the formula bar