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