Microsoft Excel Short Cut Keys
MS Excel
1. Ctrl + D
Fill down
2. Ctrl + R
fill right
3. F7 spell
check
4. F8
extended selection
5. F11 new
chart/create chart
6. Alt + F2
save as
7. Alt + F4
quit excel
8. ctrl+ ;
insert the date
9. ctrl+
shift+ : insert the time
10. ctrl+
shift + + insert cell/rows/column
11. ctrl + -
delete cells/rows/column
Microsoft
Excel multiple choice questions
1) Excel
Workbook is a collection of.
a) Workbooks b) Worksheets c) Charts d)
Worksheets and Charts *
2) What do you mean by a Workspace?
a) Group of Columns b) Group of Worksheets c)
Group of Rows d) Group of Workbooks *
3) Excel is
a____.
a) Graphic program b) Database Program c) Spread sheet program *
d) Word program
4) How are data organized in a spreadsheet?
a) Lines and spaces b) Layers and planes c)
Rows and columns * d) Height and width
5) MS-EXCEL is based on?
a) WINDOWS * b) DOS c) UNIX d) OS/2
6) Which of
the following is the oldest spreadsheet package?
a) VisiCalc * b) Lotus 1-2-3 c) Excel d)
StarCalc
7)
Which of the following is a popular DOS based spreadsheet package?
a) Word b) Smart cell c) Excel d) Lotus 1-2-3 *
8) Excel files have a default extension of.
a) .xls * b) Law c) Wk1 d) 123
9) Extension of a Excel file is
a) .xlsx * b) .Xls c) .Doc d) .ptt
10) A
typical worksheet has___ Number of columns.
a) 128 b) 256 * c) 512 d) 1024
11) The first cell in EXCEL worksheet is
labeled as.
a) AA b) A1 * c) AA d) A0
12) Which
one is the last column header in Excel?
a) XFD * b) BCX c) GHF d) XRT
13) Formulas in Excel start with_____.
a) % b) = *
c) + d) –
14) How many
Data Types in Excel?
a) 3 * b) 4 c) 5 d) 6
15) The numeric data entered in the
worksheet is ___ aligned by default.
a) Left b) Right * c) Center d) Top
16) What is
the symbol for multiplying?
a) > b) / c)
! d) * *
17) What is the symbol for dividing?
a) / *
b) % c) & d) #
18) Which of the following is an absolute
cell reference?
a) ! A! 1 b)
$A$1 * c) #a#1 d) A1
19) Default
Worksheets in workbook are?
a) 3 * b) 4
c) 6 d) 255
20) How many worksheets can a workbook have?
a) 3 b) 8
c) 255 d) None of above *
21)
How many worksheets are there in a one workbook?
a) 3 b) 8
c) 255 * d) None of above
22) In
Excel, Columns are labelled as _____.
a) A, B, C, etc. b) 1, 2, 3 etc. c) A1, b1, c1 etc. * d) $A$1, $A$2, etc.
23) In Excel, Rows are labelled as _____.
a) A,
B, C, etc. b) 1, 2, 3 etc. * c) A1,
A2, etc. d) $A$1, $A$2,
24) __ is not a logical function.
a) AND b) Or
c) No d) Sum *
25) NOT, AND, OR and XOR are?
a) Logical Operators * b)
Arithmetic operators c) Relational operators d) None
of the above
26) Excel’s function allows you to add the
numbers in multiple cells___.
a) Min b) Max c) Sum * d) Average
27) Give an
example of a cell address.
a) 25 b) 911
c) 41A d) A21 *
28)
What is the intersection of a column and row on a worksheet called?
a) Column
b) Value c) Address d) Cell *
29) How many
types of sorting?
a) Ascending order b) Descending order c) Pivot sorting d) Both A & B *
30) Comments
put in cells are called?
a) Smart Tip b) Cell Tip * c) Web Tip
d) Soft Tip
31) Which is
not a function in MS excel?
a) Sum b) Max c) Min d) AVG *
32) Which
among following types is of excel data types?
a) Numbers, Formulas, Labels * b) Data, Words, Numbers c) Words, Number, Labels d) Equations, Data,
Numbers
33) Getting
data from a cell located in a different sheet is called?
a) Accessing
b) Referencing * c) Updating d)
Functioning
34)
Which of the following is not a valid data type in Excel?
a) Number
b) Character * c) Label d)
Date/Time
35) Which function will you use to enter current
date and time in a worksheet cell?
A) =today()
B) =now() * C) =time() D) =current Time()
36) To make
a reference absolute, use the ___.
a) Dollar symbol * b) Equal symbol c) Divide symbol d) Any of above
37) What function displays row data in a column
or column data in a row?
a) Hyperlink
b) Index c) Transpose * d) Rows
38) Except for the ___function, a formula with a
logical function shows the word “TRUE”
or “FALSE” as a result.
a) IF * b) AND
c) OR d) Not
39) Which of the following is not an option in
the spelling dialog box?
a) Edit * b) Ignore
c) Ignore all d) Change
40) Which of the following is not a worksheet
design criterion?
a)
Efficiency b) Auditability c) Description * d) Clarity
41) Formatting a cell in Currency, you can
specify.
a) Decimal Places b) Currency Symbol c) Both of above * d) None of above
42)
Formatting a cell in Number format you can’t set.
a) Decimal Places b) Use 1000 separator c) Negative numbers d) Currency Symbol *
43) Which of the following option is not
available in Paste Special dialog box?
a) Add
b) Subtract c) Divide d) SQRT *
44)
How do you display current date and time in MS Excel?
a) Date ()
b) Today () c) Now () * d) Time
()
45)
How do you display current date only in MS Excel?
a) Date ()
b) Today () * c) Now () d) Time ()
46) B7:B9 indicates.
a) Cells B7
and cell B9 only b) Cells B7 through B9 * c) Cell B8 only d) None of the above
47) The Cancel and Enter buttons appear in the.
a) Title bar
b) Formula bar * c) Menu bar d) Sheet tabs
48) A
function inside another function is called ___.
a) Nested function * b)
Round function c) Sum function 49) Which of the following is correct?
a) =AVERAGE
(4, 5, 6, 7) b) =AVERAGE (A1, B1, C1) c) =AVERAGE (A1:A9, B1:B9)
50) Example of built in function.
a) Sum b) average
c) count d) All * d) All
of the above *
51) Which
equation gives the value of six?
a) =6*6 /6 *
b) =6/6-6 c) =6+6*6 d) =6-6/6
52) The name box appears at the?
a) Left of the formula bar * b) Right of the
formula bar c) Below the status bar d)
Below the menu
Comments
Post a Comment