問題一覧
1
How many users can open Excel file at same time
256
2
Excel was introduced in the year
1985
3
Founder of MS Excel
Charles simonyi
4
What is the default height of row
15
5
Maximum height of row
409 points
6
Alphabetical letters
columns
7
Numbers
rows
8
Workbook is a
collection of worksheets and chart
9
Excel files are called
workbook
10
Create a new workbook
ctrl+n
11
Create a new worksheet
shift +f11
12
To check formula and cell range/active formula
f2
13
To know MS Excel version
file>help> check version now
14
To open run dialog box
win+R
15
To copy the value from the cell above the active cell into the cell
ctrl+shift+"
16
Wrap text feature in MS Excel 2019
home
17
Cell address is represented as
A25
18
First cell in excel labeled as
A1
19
Last column of an Excel 2003 worksheet is
IV (256 Columns)
20
Last column of an Excel 2007 worksheet is
XFD(16384 columns)
21
Rows in ms Excel 2003
65536
22
Columns in 2003
256
23
Rows in ms Excel 2007
10,48,576
24
Columns in excel 2007
16,384
25
Shortcut to create names from the row or columns labels for the selected cell
ctrl+shift+ f3
26
Extension of MS Excel file
.xls
27
Keyboard shortcut to navigate between different worksheet
ctrl+page up
28
By default MS Excel display sheet?
3
29
Shortcut to create chart in MS Excel
f11
30
The component the displays the contents of an active cell
formula bar
31
The component of MS Excel displace the address of the active cell
name box
32
To select the entire row of the active cell
shift+space bar
33
To select the entire column
ctrl+space bar
34
Cell boundary that specifies which cell active
cell pointer
35
The graphical and pictorial representation of worksheet data
charts
36
To insert new worksheet
alt+shift +f1
37
Macros are executed from the
view menu
38
Comments put in cells are called
cell tip
39
Concatenation of text can be done using
&
40
Rearrange the data in ascending or descending order
data,sort
41
To enter the current time in a worksheet
ctrl+shift+;
42
Enter the current date in a worksheet
ctrl+;
43
Default view for a worksheet
normal view
44
To move up previous worksheet
ctrl+pg up
45
To access the go to dialogue box
ctrl+G
46
To close the workbook
ctrl+W
47
To close Excel/close the selected workbook window
ctrl+ F4
48
Command from run window to open a new XL file
excel
49
Total number of characters that are cell can contain
32767
50
Not a function in MS Excel
avg
51
Close the window of Excel/close all work books that are open as well as Excel itself
alt+f4
52
Used to describe information in your spreadsheet
label
53
What returns the current date formatted as a date
today()
54
What returns the current time formatted as a time
now()
55
To convert existing Excel worksheet data and charge to HTML documents by using the
internet assistant wizard
56
Maximum zoom percentage in Excel
400
57
Minimum zoom percentage
10
58
Default zoom Percentage
100
59
V look up function used to
find related records
60
To edit the selected cell
f2
61
To create macros in Excel
visual basic
62
Maximum column with in MS Excel
255
63
Default column width in MS Excel
8.43
64
Popular DOS based spredsheet package
lotus 123
65
Files created with Lotus 123 have an extension
.123
66
Oldest spredsheet package
visicalc
67
Greater than sign is an example of
logical operator
68
Ctrl+ D used to
to fill down in the selection
69
Create pivot chart
f1
70
Create chart
f11
71
Expand or collapse formula bar
ctrl+shift+u
72
Insert auto sum formula
alt+=
73
Show or hide all formula
ctrl+~
74
Apply the time format
ctrl+shift+@
75
Display the control menu
alt+space bar
76
To hide selected columns
ctrl+0
77
To hide selected rows
ctrl+9
78
To go to the last cell
ctrl+end
79
To go to the first cell
ctrl+home
80
Left one cell
shift+tab
81
Right one cell
tab
82
Create an absolute
f4
83
Calculate worksheet
f9
84
Go to dialogue box
all
85
Strikethrough
ctrl+s
86
How many tabs are in Excel
9
87
Default tab in MS Excel
home
88
Twin tower New comment in a cell
shift+f2
89
Insert auto sum formula
alt+=
90
Show all hide all formula
ctrl+~
91
To apply the date format
ctrl+shift+#
92
To apply the percentile format without decimal
ctrl+shift+%
93
Start a new line in the same cell
alt+enter
94
Extend the selection of the cell
ctrl+shift+home
95
Create pivtot Chart in the same worksheet
alt+f1
96
To bring up search box
shift+f5
97
While selecting multiple worksheets in excel what key must be used when clicking the sheet tag
ctrl
98
Open workbooks can be switched using
ctrl+tab
99
Excel file cannot be directly exported as
ppt
100
Work space mean
group of workbooks