Which elements of a worksheet can be protected from accidental modification?
Contents
Objects
Scenarios
All of the above
Correct Answer :
D. All of the above
Related Questions
Status indicators are located on the
Vertical scroll bar
Horizontal scroll bar
Formula bar
Standard toolbar
How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
F8
F9
F10
F11
A worksheet can have a maximum of …. Number of rows
256
1024
32000
65535
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
Which of the following formulas is not entered correctly?
=10+50
10+50
=10+50
=B7+14
You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
Pie chart
Row chart
Line chart
Column chart
When a row of data is to be converted into columns
Copy the cells in row, select the same number of cells in row and paste
Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK
Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK
Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK
You can use the drag and drop method to
Copy cell contents
Move cell contents
Add cell contents
a and b
Which of the following you can paste selectively using Paste Special command?
Validation
Formats
Formulas
All of above
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
The auto calculate feature
Can only add values in a range of cells
Provides a quick way to view the result of an arithmetic operation on a range of cells
Automatically creates formulas and adds them to a worksheet
A and c
Excel probably considers the cell entry January 1, 2000 to be a
Label
Value
Formula
Text string
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
Which of the following is not information you can specify using the solver?
Input cells
Constraints
Target cell
Changing cells
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
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
Multiple calculations can be made in a single formula using .......
Standard Formulas
Array Formula
Complex Formulas
Smart Formula
You can merge the main document with data source in Excel. In mail merge operation, Word is usually
server
source
client
none
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
Which area in an Excel window allows entering values and formulas?
Title Bar
Menu Bar
Formula Bar
Standard Tool Bar
Which of the following is not a worksheet design criterion?
Efficiency
Aditibility
Description
Clarity
MS Excel provides the default value for step in Fill Series dialog box
0
1
5
10
What do you call the chart that shows the proportions of how one or more data elements relate to another data element?
XY Chart
Line Chart
Pie Chart
Column Chart
When you link data maintained in an excel workbook to a word document
The word document cannot be edit
The word document contains a reference to the original source application
The word document must contain a hyperlink
The word document contains a copy of the actual data
What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
An absolute cell address is created
Cell address will change when it is copied to another cell
The sheet tab is changed
The status bar does not display the cell address
Excel uniquely identifies cells within a worksheet with a cell name
Cell names
Column numbers and row letters
Column letters and row numbers
Cell locator coordinates
An Excel Workbook is a collection of .......
Workbooks
Worksheets
Charts
Worksheets and Charts
To center worksheet titles across a range of cells, you must
Select the cells containing the title text plus the range over which the title text is to be centered
Widen the columns
Select the cells containing the title text plus the range over which the title text is to be enfettered
Format the cells with the comma style
Tab scrolling button
Allow you to view a different worksheet
Allow you to view additional worksheet rows down
Allow you to view additional worksheet columns to the right
Allow you to view additional sheets tabs
The chart wizard term data series refers to
A chart legend
A collection of chart data markers
A set of values you plot in a chart
A data label