Which of the following is not a basic step in creating a worksheet?
Save workbook
Modifiy the worksheet
Enter text and data
Copy the worksheet
Correct Answer :
D. Copy the worksheet
Related Questions
What do you mean by a Workspace?
Group of Columns
Group of Worksheets
Group of Rows
Group of Workbooks
Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?
Square
Percentage
Goal Seek
Divide
Comments put in cells are called .....
Smart Tip
Cell Tip
Web Tip
Soft Tip
You can check the conditions against __________ when applying conditional formatting
Cell value
Formula
Both of above
None of above
To create a formula, you can use:
Values but not cell references
Cell references but not values
Values or cell references although not both at the same time
Value and cell references
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
Which symbol must all formula begin with?
=
+
(
@
Which of the following is not a basic step in creating a worksheet?
Save workbook
Modifiy the worksheet
Enter text and data
Copy the worksheet
How do you delete a column?
Select the column heading you want to delete and select the Delete Row button on the standard toolbar
Select the column heading you want to delete and select Insert Delete from the menu
Select the row heading you want to delete and select Edit>Delete from the menu
Right click the column heading you want to delete and select delete from the shortcut menu
Which of following is Not one of Excels what-if function?
Goal seek
Solver
Scenario manager
Auto Outline
The Chart wizard term data categories refers to;
A chart plot area
A horizontal axis
The organization of individual values with a charts data series
The data range that supply chart data
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
Data can be arranged in a worksheet in a easy to understand manner using
auto formatting
applying styles
changing fonts
all 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
To activate the previous cell in a pre-selected range, press
The Alt key
The Tab key
The Enter key
None of the above
A circular reference is
Geometric modeling tool
A cell that points to a drawing object
A formula that either directly or indirectly depends on itself
Always erroneous
An excel workbook is a collection of
Workbooks
Worksheets
Charts
Worksheets and charts
Concatenation of text can be done using
Apostrophe ( )
Exclamation ( ! )
Hash ( # )
Ampersand ( & )
The first cell in EXCEL worksheet is labeled as
AA
A1
Aa
A0
The Name box on to the left of formula bar
shows the name of workbook currently working on
shows the name of worksheet currently working on
shows the name of cell or range currently working on
None of above
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
If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must
From Edit menu choose Clear and then Formats
From Edit menu choose Delete
Click on Remove Formatting tool on Standard Toolbar
Double click the Format Painter and then press Esc key in keyboard
The Delete key of keyboard is assigned to which command in Excel?
Edit >> Clear >> Contents
Edit >> Clear >> All
Edit >> Delete
All of 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
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
You can use the formula pallette to
format cells containing numbers
create and edit formula containing functions
enter assumptions data
copy a range of cells
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
Which function is not available in the Consolidate dialog box?
Pmt
Average
Max
Sum
Which of the following is a correct order of precedence in formula calculation?
Multiplication and division exponentiation positive and negative values
Multiplication and division, positive and negative values, addition and subtraction
Addition and subtraction, positive and negative values, exponentiation
All of above
You can edit a cell by
Clicking the formula button
Double clicking the cell to edit it in-place
Selecting Edit>Edit Cell from the menu
None of above