Which of the following action removes a sheet from workbook?
Select the sheet, then choose Edit >> Delete Sheet
Select the sheet then choose Format >> Sheet >> Hide
Both of above
None of above
Correct Answer :
A. Select the sheet, then choose Edit >> Delete Sheet
Related Questions
Which elements of worksheet can be protected from accidental modification
Contents
Objects
Scenarios
All of above
When a range is selected, how can you activate the previous cell?
Press the Alt key
Press Tab
Press Enter
None of above
The autofill feature
extends a sequential series of data
automatically adds range of cell values
applies a boarder around the selected cells
none of the above
To record a sequence of keystrokes and mouse actions to play back later we use:
Media player
Sound Recorder
Calculator
Macro Recorder
Which is not the function of Edit, Clear command?
Delete contents
Delete notes
Delete cells
Delete formats
What is the short cut key to highlight the entire column?
Ctrl+C
Ctrl+Enter
Ctrl+Page Up
Ctrl+Space Bar
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 is a popular DOS based spreadsheet package?
Word
Smart cell
Excel
Lotus 1-2-3
You can use the horizontal and vertical scroll bars to
Split a worksheet into two panes
View different rows and columns edit the contents of a cell
Edit the contents of a cell
view different worksheets
To return the remainder after a number is divided by a divisor in EXCEL we use the function?
ROUND ( )
FACT ( )
MOD ( )
DIV ( )
Comments can be added to cells using ......
Edit -> Comments
Insert -> Comment
File -> Comments
View > Comments
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
Which of the following is an absolute cell reference?
!A!1
$A$1
#a#1
A1
Which of the following format you can decide to apply or not in AutoFormat dialog box?
Number format
Border format
Font format
All of above
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 drag-and-drop to embed excel worksheet data in a word document
By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
By dragging a range of excel data to the word button on the taskbar while pressing Shift key
By dragging a range of excel data to the word button on the taskbar while pressing Alt key
None of above
What are the tabs that appear at the bottom of each workbook called?
Reference tabs
Position tabs
Location tabs
Sheet tabs
Documentation should include
Destination and users of the output data
Source of input data
Information on the purpose of the workbook
All of the above
How can you delete a record?
Delete the column from the worksheet
Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button
Select Data > Delete Record from the menu
Click the Delete button on the Standard toolbar
Which of the following option is not available in Paste Special dialog box?
Add
Subtract
Divide
SQRT
Which of the following is the oldest spreadsheet package?
VisiCalc
Lotus 1-2-3
Excel
StarCalc
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
MS-EXCEL is based on .........?
WINDOWS
DOS
UNIX
OS/2
A worksheet range is a
A command used for data modeling
A range of values such as from 23 to 234
A group of cells
A group of worksheets
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
In Excel, a Data Series is defined as what?
A type of chart
A cell reference
A collection of related data
A division of results
Which key do you press to check spelling?
F3
F5
F7
F9
To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
Unfreeze panes command on the window menu
Freeze panes command on the window menu
Hold titles command on the edit menu
Split command on the window menu
You can select a single range of cells by
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
Pressing the Ctrl key while dragging over the desired cells
Pressing the Shift key and an arrow key
Dragging over the desired cells
To activate the previous cell in a pre-selected range, press
The Alt key
The Tab key
The Enter key
None of the above