Which of these keys are used in MS Excel to copy formula from above cell?
A. Ctrl+ ”
B. Ctrl+ ;
C. Ctrl+ :
D. Ctrl+ ‘
Which of these keys are used in MS Excel to copy value from above cell?
A. Ctrl + “
B. Ctrl+ E
C. Ctrl+ E
D. Ctrl+ D
Which key is used for help in MS Excel?
A. F1
B. F2
C. F3
D. None of these
Which one is example of spreadsheet software?
A. MS WORD
B. MS EXCEL
C. MS POWERPOINT
D. None of these
With which of the following all formulas in excel starts ?
A. /
B. *
C. $
D. =
Comment put on Excel cell which is displayed by taking the Mouse Pointer there, is called__________?
A. Smart tip
B. Soft Tip
C. Web Tip
D. Cell Tip
In MS Excel to delete duplicate values which menu is used?
A. Data
B. Tools
C. Formatting
D. Layout
How many rows are in one Microsoft Excel sheet?
A. 65,536
B. 16,384
C. 1,048,576
D. None of Above
How many columns are in one Microsoft Excel sheet?
A. 65,536
B. 16,384
C. 1,048,576
D. None of Above
To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called?
A. Pivot Table Report
B. Pivot Table List
C. Pivot Table Field List
D. HTML
Which among following is not associated with spelling dialogue box?
A. Edit
B. Ignore All
C. Ignore
D. Change
Top open an existing workbook, click the open button on the___________toolbar?
A. form
B. standard
C. Drawing
D. Formatting
If you press ___, the cell accepts your typing as its contents ?
A. Tab
B. Ctrl+Enter
C. Enter
D. Alt+Enter
The default style for new data keyed in a new workbook is ___________?
A. Comma
B. Normal
C. Currency
D. Percent
How we can view a cell comment ?
A. position the mouse pointer over the cell
B. click the comment command on the view menu
C. click the edit comment commands on the Insert menu
D. click the Display comment command on the window menu