Which of the following series type is not valid for Fill Series dialog box?
Linear
Growth
Autofill
Time
Correct Answer :
D. Time
Related Questions
Comments put in cells are called .....
Smart Tip
Cell Tip
Web Tip
Soft Tip
Which area in an Excel window allows entering values and formulas?
Title Bar
Menu Bar
Formula Bar
Standard Tool Bar
Excel displays the current cell address in the ........
Formula bar
Status Bar
Name Box
Title Bar
You can activate a cell by
Pressing the Tab key
Clicking the cell
Pressing an arrow key
All of the above
Which of the following Excel screen components can NOT be turned on or off?
Formula Bar
Status Bar
Tool Bar
None of above
Microsoft Excel is a powerful ...........
Word processing package
Spreadsheet package
Communication S/W Package
DBMS package
Which of the following is not a worksheet design criterion?
Efficiency
Aditibility
Description
Clarity
In the formula, which symbol specifies the fixed columns or rows?
$
*
%
&
Excel worksheet cells work very similarly to what common element of the windows graphical user interface
Option buttons
List boxes
Text boxes
Combo boxes
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
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
What is the short cut key to highlight the entire column?
Ctrl+C
Ctrl+Enter
Ctrl+Page Up
Ctrl+Space Bar
To delete an embedded objects, first
Double click the object
Select the object by clicking it
Press the Shift + Delete keys
Select it and then press the delete key
How do you select an entire column?
Select Edit > Select > Column from the menu
Click the column heading letter
Hold down the shift key as you click anywhere in the column
Hold down the Ctrl key as you click anywhere in the column
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
When you insert an excel file into a word document. The data are
Hyperlinked placed in a word table
Linked
Embedded
Use the word menu bar and toolbars
Status indicators are located on the
Vertical scroll bar
Horizontal scroll bar
Formula bar
Standard toolbar
To activate the previous cell in a pre-selected range, press
The Alt key
The Tab key
The Enter key
None 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
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 do you rearrange the data in ascending or descending order?
Data, Sort
Data, Form
Data, Table
Data Subtotals
In Excel, the Fill Color button on the Formatting toolbar is used for what?
To insert a background
To add borders
To select a distribution of figures
To add shading or color to a cell range
Where can you change automatic or manual calculation mode in Excel?
Double CAL indicator on status bar
Go to Tools >> Options >> Calculation and mark the corresponding radio button
Both of above
None of above
Comments put in cells are called
Smart tip
Cell tip
Web tip
Soft tip
Text formulas:
Replace cell references
Return ASCII values of characters
Concatenate and manipulate text
Show formula error value
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
What is the short cut key to replace a data with another in sheet?
Ctrl + R
Ctrl + Shift + R
Ctrl + H
Ctrl + F
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
When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
Use =if() function to format the required numbers red
Apply Conditional Formatting command on Format menu
Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
All of above
Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
Logical
Math & Trigonometry
Statistical
Financial