1."New Comment" options can be found under _____ tab
2.In maximum, how many sheets can be set as a default while creating new workbook?
3.A typical worksheet has _____ number of columns in Excel 2019.
4.How many characters can be typed in a single cell in Excel?
5.You can activate a cell by
6.Which of the following is not a basic step in creating a worksheet ?
7.Concatenation of text can be done using
8.Data can be arranged in a worksheet in a easy to understand manner using
9.Which of the following is invalid statement?
10.When the formula bar is activated, you can see
11.When you work with large worksheets, you may need to
12.What does the VLOOKUP function do?
13.Which of the following methods can not be used to enter the data in a cell?
14.Which of the following will not cut information?
15.This type of software is similar to an accountant's worksheet
16.Which of the following is the oldest spreadsheet package?
17.Which of the following is a popular DOS based spreadsheet package?
18.A worksheet range is a
19.Which of the following formulas will excel not be able to calculate
20. To copy cell contents using drag and drop press the
21.Each excel file is called a workbook beacuse
22.Which button do you click to add up series of numbers?
23.Which function will you use to enter current time in a worksheet cell?
24.Which of the following is not a valid Zoom percentage in Excel?
25.When you insert an Excel file into a word document, the data are
26.Macros "run" or executed from the ______ menu
27.How are data organized in a spreadsheet
28.In a worksheet you can select
29.Which types of charts can excel produce
30.You want to track the progress of the stock market on daily basis. Which type of chart should you use?
31.Which of the following is not a way to complete a cell entry?
32.You can use the horizontal and vertical scroll bars to
33.Which symbol is used before a number to make it a label?
34.Right clicking something in Excel
35.To delete an embedded object, first
36.When creating a vertical page break
37.To create a formula, you can use
38.Excel probably considers the cell entry January 1, 2000 to be a
39.Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet ?
40. Which of the following methods can not be used to edit the contents of a cell
41.Microsoft Excel is a powerful ______
42.Excel files have a default extension of
43.An excel workbook is a collection of
44.Which of the following is latest version of Excel?
45.Which area in an excel window allows entering values and formulas?
46.Which symbol must all formula begin with?
47.Ms-Excel is based on ______?
48.To save a workbook, you:
49.The first cell in excel worksheet is labeled as
50.Excel displays the current cells address in the
51.The name box
52.What is the shortcut key to hide entire row?
53.A worksheet can have maximum ______ number of rows in Excel 2019?
54.What is the shortcut key to replace a data within sheet
55.To select an entire column in MS-Excel, press ?
56.What is the shortcut key to highlight the entire column ?
57.What do you mean by Workspace ?
58.The software which contains rows and columns is called ______
59.Which of the following syntax is correct regarding SUM function in Excel?
60.What is the symbol for dividing ?
61.What is the symbol of multiplying?
62.What is an example of function?
63.What is an example of formula ?
64.Which key do you press to check spelling?
65.Where a row and column meet, what do you call that?
66.Which of the following is not a term of MS-Excel?
67.Which chart can be created in Excel
68.Ctrl + D shortcut key in Excel will
69.In order to perform a calculation in a spreadsheet, you need to use a:
70.Formatting a cell in Currency, you can specify
71.Which of the following is not an option of spelling dialog box?
72.You can add image to a template by clicking the picture from ______.
73.Which of the following is not an example of a value?
74.Which of the following options is not located in the Page Setup dialog box?
75.Which of the following is not a valid data type in excel
76.Hyperlinks can be
77.You can open the Sort dialog box by choosing Sort from
78.In Excel, by default Numeric Values appears in
79.What will be the result if you type =A1=B1 in cell C1?