NEW
Font size
S
M
L
XL
WorksheetsExcel
Total questions: 30
Worksheet time: 9mins
Name
Class
Date
1.
A formula in the spreadsheet should always start with
a)
An Asterisk
b)
A Bracket
c)
An Equal Sign
d)
A Capital Letter
2.
Which direction do rows run in a spreadsheet?
a)
Diagonal
b)
Horizontal
c)
Vertical
d)
Clockwise
3.
How are rows designated?
a)
Circles
b)
Stars
c)
Numbers
d)
Letters
4.
Which direction do columns run in a spreadsheet?
a)
Vertical
b)
Diagonal
c)
Horizontal
d)
Counter Clockwise
5.
Contains the name of the application and the document name.
a)
Title Bar
b)
Menu bar
c)
Tool Bar
d)
Name Box
6.
What is the name of the area within a worksheet that is current, or ready to receive information?
a)
Office Assistant
b)
Worksheet
c)
Cell
d)
Active Cell
7.
What is the keyboard shortcut key to lock cell references in a formula?
a)
CTRL
b)
ALT
c)
F2
d)
F4
8.
What are the keyboard shortcut keys to edit formula in a cell?
a)
F2
b)
F4
c)
CTRL + 1
d)
CTRL + 1
9.
Which tab of the ribbon should you go to for removing gridlines on a worksheet?
a)
Formulas
b)
View
c)
Review
d)
Developer
10.
What is the default extension of Microsoft Excel 2016 saved file?
a)
.xls
b)
.xlsx
c)
.xlsm
d)
.csv
11.
What term describes explanatory text attached to a cell?
a)
Context
b)
Callout
c)
Comment
d)
Dialog
12.
What alternative key is used as paste function in Excel?
a)
Tab
b)
CTRL
c)
Shift
d)
Enter
13.
A formula and a function are the same thing
a)
true
b)
false
14.
###### means
a)
Entered Number is Wrong
b)
Misspelled
c)
Cell is not wide enough
d)
None of the above
15.
There are three worksheets with every new workbook. You can change that automatic number if you want to
a)
true
b)
false
16.
File Extension .xlsx was introduced in Excel
a)
2003
b)
2007
c)
2010
d)
2013
17.
Excel was designed originally by microsoft to work as part of ______________ PCs
a)
IBM
b)
APPLE
c)
DELL
d)
NOTA
18.
To name a cell or range, you use the
a)
Name Box
b)
Define Name
c)
Paste Name
d)
Format Cells
19.
First electronic spreadsheet was conceived by
a)
Dan Bricklin
b)
Bill Gates
c)
Steve Jobs
d)
IBM
20.
Intial Name of the electronic spreadsheet is
a)
Lotus 123
b)
Visi Calc
c)
Multi plan
d)
E Calculator
21.
Pivot Table feature introduced by
a)
Lotus 123
b)
Multi plan
c)
MS Office
d)
Open Office
22.
Excel sheet can use _________ Fonts
a)
100
b)
256
c)
512
d)
1024
23.
An Excel can contain upto ______ Characters
a)
32767
b)
42568
c)
15869
d)
25604
24.
Lotus 123 was replaced by MS Excel as industry standard spreadsheet in _______
a)
1985
b)
1998
c)
2000
d)
1993
25.
What Programming language is used in Excel
a)
Basic
b)
Fortran
c)
Visual Basic
d)
Python
26.
It is not possible to name the worksheet as
a)
Default
b)
History
c)
Temp
d)
Excel
27.
No. of Columns in Excel 2016
a)
256
b)
16384
c)
65636
d)
16000
28.
No. of Rows in Excel 2016
a)
65636
b)
256
c)
1048576
d)
104856
29.
Last Column name in Excel 2016
a)
XFD
b)
XUV
c)
QHD
d)
XYZ
30.
Father of Excel
a)
Charles Simonyi
b)
Dan Bricklin
c)
Hugo Friedman
d)
Bill Gates
Reset
