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
Correct Answer :
A. Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
Related Questions
Which of the following is not a term of MS-Excel?
Cells
Rows
Columns
Document
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
How can you remove borders applied in cells?ACC
Choose None on Border tab of Format cells
Open the list on Border tool in Formatting toolbar then choose first tool (no border)
Both of above
None of above
Which is used to perform what if analysis?
Solver
Goal seek
Scenario Manager
All of above
An excel workbook is a collection of
Workbooks
Worksheets
Charts
Worksheets and charts
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
Which of the following is not a valid data type in excel
Number
Character
Label
Date/time
Edit >> Delete command
Deletes the content of a cell
Deletes Formats of cell
Deletes the comment of cell
Deletes selected cells
Multiple calculations can be made in a single formula using
standard formulas
array formula
complex formulas
smart formula
To record a sequence of keystrokes and mouse actions to play back later we use:
Media player
Sound Recorder
Calculator
Macro Recorder
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
How can you show or hide the gridlines in Excel Worksheet?
Go to Tools >> Options >> View tab and mark or remove the check box named Gridline
Click Gridline tool on Forms toolbar
Both of above
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
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 of the following you can paste selectively using Paste Special command?
Validation
Formats
Formulas
All of 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 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
The Cancel and Enter buttons appear in the:
Title bar
Formula bar
Menu bar
Sheet tabs
You can use the formula palette to
Format cells containing numbers
Create and edit formulas containing functions
Enter assumptions data
Copy a range of cells
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
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
What do you mean by a Workspace?
Group of Columns
Group of Worksheets
Group of Rows
Group of Workbooks
How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
F8
F9
F10
F11
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
Which menu option can be sued to split windows into two
Format > window
View > window > split
Window > split
View > split
Which area in an Excel window allows entering values and formulas?
Title Bar
Menu Bar
Formula Bar
Standard Tool Bar
You can use the drag and drop method to
Copy cell contents
Move cell contents
Add cell contents
a and b
A numeric value can be treated as label value if ...... precedes it.
Apostrophe ( )
Exclamation ( ! )
Hash ( # )
Tilde ( ~ )
Which Chart can be created in Excel?
Area
Line
Pie
All of the above
Which of the following is not information you can specify using the solver?
Input cells
Constraints
Target cell
Changing cells