How do you change column width to fit the contents?
when you work with large worksheets, you may need to
Hyperlinks cannot be
You can use the horizontal and vertical scroll bars to
. What do we call a computer program that organizes data in rows and columns of cells? You might use this type of program to keep a record of the money you earned moving lawns over the summer.
You can add an image to a template by clicking the Insert Picture From File button on the …Toolbar.
What function displays row data in a column or column data in a row?
When you insert an Excel file into a Word document, the data are
Except for the …… function, a formula with a logical function shows the word “TRUE†or “FALSE†as a result
Macros are “run†or executed from the ….menu.
You can open the consolidate dialog box byt choosing Consolidate from the ….menu.
Each excel file is called a workbook because
Which types of charts can excel produce?
How are data organized in a spreadsheet?
What does the VLOOKUP function do?
Gridlines
You can print only an embedded chart by
Which of the following is a correct order of precedence in a formula calculation?
A function inside another function is called a ….function.
How should you print a selected area of a worksheet, if you’ll want to print a different area next time?
Your German supplier still invoices for parts in Deutsche marksHow can you have Excel convert those sums to Euros?
Which function calculates your monthly mortage payment?
. If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracyHow do you activate this feature?
Which of the following methods can not be used to enter data in a cell?
Which of the following will not set text in selected cells to italics?
Which of the following methods cannot be used to edit the content of cell?
Which of the following is not an option in the spelling dialog box?
You can quickly change the appearance of your work by choosing Auto Format from the …Menu
To protect a worksheet, you can choose Protection and the Protect Sheet from the ….menu
You can open the Highlight Changes dialog box by choosing Track Changes from the …Menu.
Which of the following is not a worksheet design criterion?
To copy cell contents using drag and drop, press the
If you press …., the cell accepts your typing as its contents.
The autofill feature
What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?
you can use the formula palette to
What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chas changed
What is an expression that tells how the numbers in a determined set of cells are to be calculated?
“Qtr 1, Qtr 2, Qtr 3†is an example of a
You can edit existing Excel data by pressing the
The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is ….
A user wishes to remove a spreadsheet from a workbookWhich is the correct sequence of events that will do this?
What feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula?
what term describes a background that appears as a grainy, non smooth surface
Excel is a
To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called
Which of the following is not a valid Zoom percentage in Excel?
The spelling tool is placed on ______ toolbar
If you need a text to show vertically in a cellHow will you achieve this?
Can you set 0.5 inch left indentation for a cell in Excel?
You can automatically adjust the size of text in a cell if they do not fit in width by
Formatting a cell in Currency, you can specify
Formatting a cell in Number format you can’t set
What is entered by the function =today()
Which function will you use to enter current time in a woksheet cell?
Special category of Number tab in Format Cells dialog box can be used to apply formats like
Merge cells option can be applied from
Pre-made sheet formats like Simple, Classic, Accounting, Colorful et can be applied from
Which of the following format you can decide to apply or not in AutoFormat dialog box?
How can you remove borders applied in cells?
Where can you set the shedding color for a range of cells in Excel?
You can set Page Border in Excel from
When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
You can check the conditions against __________ when applying conditional formatting
Which of the following is not true regarding Conditional Formatting?
Which of the following is invalid statement?
You can use the formula pallette to
battle of khanwa was fought between
Which tool you will use to join some cells and place the content at the middle of joined cell?
Tab scroll buttons are place on Excel screen
The Name box on to the left of formula bar
Each excel file is a workbook that contains different sheetsWhich of the following can not be a sheet in workbook?
Which of the following is not the correct method of editing the cell content?
You can merge the main document with data source in ExcelIn mail merge operation, Word is usually
How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
. You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so onWhat will you set to effect that?
Where can you change automatic or manual calculation mode in Excel?
How can you show or hide the gridlines in Excel Worksheet?
Which of the following Excel screen components can NOT be turned on or off?
What happens when you press Ctrl + X after selecting some cells in Excel?
Which of the following option is not available in Paste Special dialog box?
Which command will you choose to convert a column of data into row?
It is acceptable to let long text flow into adjacent cells on a worksheet when
Which of the cell pointer indicates you that you can make selection?
Which of the cell pointer indicates that you can fill series?
Which of the cell pointer indicate that you can move the content to other cell?
You can auto fit the width of column by
Long text can be broken down into many lines within a cellYou can do this through
MS Excel provides the default value for step in Fill Series dialog box
When a row of data is to be converted into columns
Ctrl + D shortcut key in Excel will
The short cut key Ctrl + R is used in Excel to
The command Edit >> Fill Across Worksheet is active only when
Which of the following series type is not valid for Fill Series dialog box?
Which of the following you can paste selectively using Paste Special command?
Paste Special allows some operation while you paste to new cellWhich of the following operation is valid?
Edit >> Delete command
To remove the content of selected cells you must issue ______ command
The Delete key of keyboard is assigned to which command in Excel?
If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must
By default Excel provides 3 worksheetsYou need only two of them, how will you delete the third one?
Which of the following action removes a sheet from workbook?
While Finding and Replacing some data in Excel, which of the following statement is valid?
Which of the following is not true about Find and Replace in Excel
You can move a sheet from one workbook into new book by
What is the short cut key to replace a data with another in sheet?
Comments put in cells are called …..
Comments can be added to cells using …..
Which menu option can be used to split windows into two?
Getting data from a cell located in a different sheet is called….
Which of the following is not a valid data type in Excel?
Which elements of a worksheet can be protected from accidental modification?
A numeric value can be treated as label value if …… precedes it.
Concatenation of text can be done using
Which area in an Excel window allows entering values and formulas?
Multiple calculations can be made in a single formula using…..
An Excel Workbook is a collection of …….
What do you mean by a Workspace?
MS-EXCEL is based on ……….?
In EXCEL, you can sum a large range of data by simply selecting a tool button called …..?
To select an entire column in MS-EXCEL, press?
To return the remainder after a number is divided by a divisor in EXCEL we use the function?
Which function is not available in the Consolidate dialog box?
Which is not the function of “Edit, Clear†command?
Microsoft Excel is a powerful………..
How do you rearrange the data in ascending or descending order?
Which Chart can be created in Excel?
What will be the output if you format the cell containing 5436.8 as ‘#,##0.00′?
How do you display current date and time in MS Excel?
How do you display current date only in MS Excel?
How do you wrap the text in a cell?
What does COUNTA () function do?
What is the short cut key to highlight the entire column?
In the formula, which symbol specifies the fixed columns or rows?
Excel displays the current cell address in the ……….
What is the correct way to refer the cell A10 on sheet3 from sheet1?
 Which language is used to create macros in Excel?
Which of the following is not a term of MS-Excel?
How many worksheets can a workbook have?
Which would you choose to create a bar diagram?
when you work with large worksheets, you may need to
Hyperlinks cannot be
You can use the horizontal and vertical scroll bars to
. What do we call a computer program that organizes data in rows and columns of cells? You might use this type of program to keep a record of the money you earned moving lawns over the summer.
You can add an image to a template by clicking the Insert Picture From File button on the …Toolbar.
What function displays row data in a column or column data in a row?
When you insert an Excel file into a Word document, the data are
Except for the …… function, a formula with a logical function shows the word “TRUE†or “FALSE†as a result
Macros are “run†or executed from the ….menu.
You can open the consolidate dialog box byt choosing Consolidate from the ….menu.
Each excel file is called a workbook because
Which types of charts can excel produce?
How are data organized in a spreadsheet?
What does the VLOOKUP function do?
Gridlines
You can print only an embedded chart by
Which of the following is a correct order of precedence in a formula calculation?
A function inside another function is called a ….function.
How should you print a selected area of a worksheet, if you’ll want to print a different area next time?
Your German supplier still invoices for parts in Deutsche marksHow can you have Excel convert those sums to Euros?
Which function calculates your monthly mortage payment?
. If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracyHow do you activate this feature?
Which of the following methods can not be used to enter data in a cell?
Which of the following will not set text in selected cells to italics?
Which of the following methods cannot be used to edit the content of cell?
Which of the following is not an option in the spelling dialog box?
You can quickly change the appearance of your work by choosing Auto Format from the …Menu
To protect a worksheet, you can choose Protection and the Protect Sheet from the ….menu
You can open the Highlight Changes dialog box by choosing Track Changes from the …Menu.
Which of the following is not a worksheet design criterion?
To copy cell contents using drag and drop, press the
If you press …., the cell accepts your typing as its contents.
The autofill feature
What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?
you can use the formula palette to
What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chas changed
What is an expression that tells how the numbers in a determined set of cells are to be calculated?
“Qtr 1, Qtr 2, Qtr 3†is an example of a
You can edit existing Excel data by pressing the
The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is ….
A user wishes to remove a spreadsheet from a workbookWhich is the correct sequence of events that will do this?
What feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula?
what term describes a background that appears as a grainy, non smooth surface
Excel is a
To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called
Which of the following is not a valid Zoom percentage in Excel?
The spelling tool is placed on ______ toolbar
If you need a text to show vertically in a cellHow will you achieve this?
Can you set 0.5 inch left indentation for a cell in Excel?
You can automatically adjust the size of text in a cell if they do not fit in width by
Formatting a cell in Currency, you can specify
Formatting a cell in Number format you can’t set
What is entered by the function =today()
Which function will you use to enter current time in a woksheet cell?
Special category of Number tab in Format Cells dialog box can be used to apply formats like
Merge cells option can be applied from
Pre-made sheet formats like Simple, Classic, Accounting, Colorful et can be applied from
Which of the following format you can decide to apply or not in AutoFormat dialog box?
How can you remove borders applied in cells?
Where can you set the shedding color for a range of cells in Excel?
You can set Page Border in Excel from
When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
You can check the conditions against __________ when applying conditional formatting
Which of the following is not true regarding Conditional Formatting?
Which of the following is invalid statement?
You can use the formula pallette to
battle of khanwa was fought between
Which tool you will use to join some cells and place the content at the middle of joined cell?
Tab scroll buttons are place on Excel screen
The Name box on to the left of formula bar
Each excel file is a workbook that contains different sheetsWhich of the following can not be a sheet in workbook?
Which of the following is not the correct method of editing the cell content?
You can merge the main document with data source in ExcelIn mail merge operation, Word is usually
How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
. You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so onWhat will you set to effect that?
Where can you change automatic or manual calculation mode in Excel?
How can you show or hide the gridlines in Excel Worksheet?
Which of the following Excel screen components can NOT be turned on or off?
What happens when you press Ctrl + X after selecting some cells in Excel?
Which of the following option is not available in Paste Special dialog box?
Which command will you choose to convert a column of data into row?
It is acceptable to let long text flow into adjacent cells on a worksheet when
Which of the cell pointer indicates you that you can make selection?
Which of the cell pointer indicates that you can fill series?
Which of the cell pointer indicate that you can move the content to other cell?
You can auto fit the width of column by
Long text can be broken down into many lines within a cellYou can do this through
MS Excel provides the default value for step in Fill Series dialog box
When a row of data is to be converted into columns
Ctrl + D shortcut key in Excel will
The short cut key Ctrl + R is used in Excel to
The command Edit >> Fill Across Worksheet is active only when
Which of the following series type is not valid for Fill Series dialog box?
Which of the following you can paste selectively using Paste Special command?
Paste Special allows some operation while you paste to new cellWhich of the following operation is valid?
Edit >> Delete command
To remove the content of selected cells you must issue ______ command
The Delete key of keyboard is assigned to which command in Excel?
If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must
By default Excel provides 3 worksheetsYou need only two of them, how will you delete the third one?
Which of the following action removes a sheet from workbook?
While Finding and Replacing some data in Excel, which of the following statement is valid?
Which of the following is not true about Find and Replace in Excel
You can move a sheet from one workbook into new book by
What is the short cut key to replace a data with another in sheet?
Comments put in cells are called …..
Comments can be added to cells using …..
Which menu option can be used to split windows into two?
Getting data from a cell located in a different sheet is called….
Which of the following is not a valid data type in Excel?
Which elements of a worksheet can be protected from accidental modification?
A numeric value can be treated as label value if …… precedes it.
Concatenation of text can be done using
Which area in an Excel window allows entering values and formulas?
Multiple calculations can be made in a single formula using…..
An Excel Workbook is a collection of …….
What do you mean by a Workspace?
MS-EXCEL is based on ……….?
In EXCEL, you can sum a large range of data by simply selecting a tool button called …..?
To select an entire column in MS-EXCEL, press?
To return the remainder after a number is divided by a divisor in EXCEL we use the function?
Which function is not available in the Consolidate dialog box?
Which is not the function of “Edit, Clear†command?
Microsoft Excel is a powerful………..
How do you rearrange the data in ascending or descending order?
Which Chart can be created in Excel?
What will be the output if you format the cell containing 5436.8 as ‘#,##0.00′?
How do you display current date and time in MS Excel?
How do you display current date only in MS Excel?
How do you wrap the text in a cell?
What does COUNTA () function do?
What is the short cut key to highlight the entire column?
In the formula, which symbol specifies the fixed columns or rows?
Excel displays the current cell address in the ……….
What is the correct way to refer the cell A10 on sheet3 from sheet1?
 Which language is used to create macros in Excel?
Which of the following is not a term of MS-Excel?
How many worksheets can a workbook have?
Which would you choose to create a bar diagram?
No comments:
Post a Comment