We can save and protect the workbook by
Write Reservation Password
Protection Password
Read-only Recommended
Any of the above
Correct Answer :
D. Any of the above
Related Questions
How do you wrap the text in a cell?
Format, cells, font
Format, cells, protection
Format, cells, number
Format, cells, alignment
What is represented by the small, black square in the lower-right corner of an active cell or range?
Copy handle
Fill handle
Insert handle
Border
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
By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
Right click on Sheet Tab of third sheet and choose Delete from the context menu
Click on Sheet 3 and from Edit menu choose Delete
Both of above
None of above
How do you display current date only in MS Excel?
date ()
Today ()
now ()
time ()
Which setting you must modify to print a worksheet using letterhead?
Paper
Margin
Layout
Orientation
You can use the format painter multiple times before you turn it off by
You can use the format painter button on ly one time when you click it
Double clicking the format painter button
Pressing the Ctrl key and clicking the format painter button
Pressing the Alt key and clicking the format painter button
In the formula, which symbol specifies the fixed columns or rows?
$
*
%
&
Which of the following is not true regarding Conditional Formatting?
You can add more than one condition to check
You can set condition to look for Bold and apply Italics on them
You can apply Font, border and pattern formats that meets the specified conditions
You can delete any condition from Conditional Formatting dialog box if it is not requried
The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?
None of these
Select Format > Money from the menu
Click the Currency Style button on the formatting toolbar
You have to retype everything and manually add the dollar signs, commas, and decimals
What symbol is used before a number to make it a label?
( quote )
= ( equal )
_ ( underscore )
( apostrophe )
When you copy a formula
Excel erases the original copy of the formula
Excel edits cell references in the newly copied formula
Excel adjusts absolute cell references
Excel doesnt adjust relative cell references
Which of the following formulas will Excel Not be able to calculate?
=SUM(Sales)-A3
=SUM(A1:A5)*.5
=SUM(A1:A5)/(10-10)
=SUM(A1:A5)-10
A typical worksheet has …. Number of columns
128
256
512
1024
Multiple calculations can be made in a single formula using .......
Standard Formulas
Array Formula
Complex Formulas
Smart Formula
Which of the following is not a valid data type in Excel?
Number
Character
Label
Date/Time
Right clicking something in Excel:
Deletes the object
Nothing the right mouse button is there for left handed people
Opens a shortcut menu listing everything you can do to the object
Selects the object
You can move a sheet from one workbook into new book by
From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK
From Edit menu choose Move of Copy then choose (Move to end) and click OK
From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
None of above
Getting data from a cell located in a different sheet is called ......
Accessing
Referencing
Updating
Functioning
We can save and protect the workbook by
Write Reservation Password
Protection Password
Read-only Recommended
Any of the above
Each excel file is called a workbook because
It can contain text and data
It can be modified
It can contain many sheets including worksheets and chart sheets
You have to work hard to create it
A numeric value can be treated as a label value if it precedes with
Apostrophe (&lsquo
Exclamation (!)
Hash (#)
Ampersand (&
Concatenation of text can be done using
Apostrophe (&lsquo
Exclamation (!)
Hash (#)
Ampersand (&
The short cut key Ctrl + R is used in Excel to
Right align the content of cell
Remove the cell contents of selected cells
Fill the selection with active cells to the right
None of above
What is the short cut key to replace a data with another in sheet?
Ctrl + R
Ctrl + Shift + R
Ctrl + H
Ctrl + F
Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?
Square
Percentage
Goal Seek
Divide
Which function is not available in the Consolidate dialog box?
Pmt
Average
Max
Sum
Which of the following is invalid statement?
Sheet tabs can be colored
Some picture can be applied as a background of a sheet
You can set the column width automatically fit the amount of text
The width of a row and be specified manually or fit automatically
Comments can be added to cells using ......
Edit -> Comments
Insert -> Comment
File -> Comments
View > Comments
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