Q.1
Which would you choose to create a bar diagram?
Q.2
Which setting you must modify to print a worksheet using letterhead?
Q.3
What do you call the chart that shows the proportions of how one or more data elements relate to another data element?
Q.4
The spelling dialog box can be involved by choosing spelling from ________ menu.
Q.5
Which key do you press to check spelling?
Q.6
Excel displays the current cell address in the ________
Q.7
What is the correct way to refer the cell A10 on sheet3 from sheet1?
Q.8
Which language is used to create macros in Excel?
Q.9
Which of the following is not a term of MS-Excel?
Q.10
How many worksheets can a workbook have?
Q.11
How do you display current date only in MS Excel?
Q.12
How do you wrap the text in a cell?
Q.13
What does COUNTA () function do?
Q.14
What is the short cut key to highlight the entire column?
Q.15
In the formula, which symbol specifies the fixed columns or rows?
Q.16
You can use drag-and-drop to embed excel worksheet data in a word document
Q.17
The auto calculate feature
Q.18
Excel uniquely identifies cells within a worksheet with a cell name
Q.19
Getting data from a cell located in a different sheet is called ________
Q.20
Tab scrolling button
Q.21
A numeric value can be treated as a label value if it precedes with
Q.22
Concatenation of text can be done using
Q.23
Data can be arranged in a worksheet in a easy to understand manner using
Q.24
A worksheet can have a maximum of ________ number of rows.
Q.25
Which of the following is not an example of a value?
Q.26
The chart wizard term data series refers to
Q.27
The Chart wizard term data categories refers to;
Q.28
A worksheet range is a
Q.29
Which symbol must all formula begin with?
Q.30
Which of the following formulas is not entered correctly?
0 h : 0 m : 1 s