nd
I
I Uni
tSy
ll
abus
Cl
assVI
I
Comput
er
Chapt
er5
Mi
crosof
tExcel2016
BookWor
k
Fi
l
lint
hebl
anks.
[Link]
egi
vest
heser
ial
val
ueoft
hecur
rentdat
e.
[Link]
ect
ingnon-
adj
acentcol
umnspr
essct
rlkey
.
[Link]
asKundl
eri
sthef
atherofExcel
.
[Link]
nter
sect
ionofar
owandcol
umni
sExcel
isknownascel
l
.
5..
xlxsi
sthedef
aul
text
ensi
onf
oranMSExcel
fil
e.
[Link]
mei
srepr
esent
edasdeci
mal
fract
ioni
nExcel
.
Tr
ueorFal
se.
[Link]
canbeusedf
orr
epr
esent
ingdat
aint
hef
orm ofchar
ts.T
[Link]
ksheet
scont
ainmanywor
kbooks.F
[Link]
ear
e256r
owsi
nExcel
.F
[Link]
erepr
esent
edusi
ngl
ett
ers.F
[Link]
vest
henameoft
hewor
ksheet
.F
[Link]
ghtandcol
umnwi
dthcanbeadj
ust
edi
nExcel
.T
Answert
hef
oll
owi
ngquest
ions.
[Link]
saSpr
eadsheet
?
[Link]
eadsheeti
saf
il
ethatexi
stsofcel
l
sinr
owsandcol
umns
andcanhelparr
ange,cal
cul
ateandsor
[Link]
ainaspreadsheet
canbenumericval
ues,aswellast
ext
,for
mulas,r
efer
encesand
funct
ions.
[Link]
sthedi
ff
erencebet
weenawor
kbookandawor
ksheet
?
[Link] ngl
epagespreadsheetorpagei
nExcel
,
whereyoucanwr i
te,
edi tandmanipul
atedata,whereast
he
col
lect
ionofsuchwor ksheetsi
srefer
redasawor kbook.
[Link]
sthedi
ff
erencebet
weenhor
izont
alandv
ert
ical
scr
oll
bar
s?
[Link]
icalscr
oll
barisusedtoscrol
lupanddown,
whi
l
ethe
hori
zont
alscrol
lbarisusedtoscr
ollr
ightandl
eft
.
[Link]
it
ethest
epsf
orsav
inganExcel
fil
e.
[Link]
i
ckt
hef
il
etab.
[Link]
icksav
eify
ouwantt
osavet
heworkbookwit
hanexi
sti
ngname.
orcl
i
cksaveasify
ouwantt
osav
etheworkbookfort
hef
ir
stti
me.
[Link]
ectt
hel
ocat
ionwher
eyouwantt
osav
eyourf
il
e.
[Link]
i
ckont
hesav
ebut
ton,
thef
il
ewi
l
lbesav
ed.
[Link]
inet
hef
oll
owi
ng-
[Link]
ete–Excel
aut
omat
ical
l
ysuggest
swor
dst
hati
tfi
ndsy
ou
enter
edbefor
e.
[Link]
er-Theworksheetissi
nglepagespreadsheetorpagei
n
Excel,
whereyoucanwrit
e,editandmanipul
atedata,whereasthe
coll
ecti
onofsuchworksheetsisref
err
edasawor kbook.
[Link]
rect–Ex cel
automati
cal
l
ycleansuptextf
orlanguage
standar
ds,suchascapital
i
singt
hefi
rstwordofasentence,cor
rect
ing
commonmi sspel
l
ingsetc.
[Link]
il
l–Excel
assumest henumberseri
esyouaretr
yingtoenteri
n
acolumnorrowandf i
l
lsintheemptycel
l
sbasedoni t
sassumpt i
on.
YoucanuseAutofi
ll
tofil
lindat
ali
kenumbersseri
es,months,dayset
c.
[Link]
oFit–Excel
aut
omat
ical
l
yenl
argesorshr
inksacel
ltof
itar
ound
i
tscontent
s.
[Link]
l
lyouaddawor
ksheett
oawor
kbook?
[Link]
ankwor
[Link]
l
lseeadef
aul
twor
ksheet
namedSheet1.
[Link]
socl
i
ckonInsertSheet
sfr
om theCel
lsgr
oupunderthe
[Link]
lli
nsert
edtothel
eftoft
hecurr
entsheet
.
[Link]
it
ethest
epst
oresi
zer
owsi
nMSExcel
.
[Link]
zearowbydraggi
ngthebot
tom edgeofar
owf
urt
herdown
orupwhenthecur
sorchangestoa+sign.
8.
Howwi
l
lyousel
ectnon-
adj
acentr
ows?
Ans-Thiscanbedonebypressi
ngCTRLkeytoget
herwi
tht
herow
headi
ngsofther
owy [Link]
eisnoot
herwayofsel
ect
ingnon-
adj
acentrowsi
nExcel.
[Link]
oumov
edat
ainMSExcel
?
Ans-Tomov edataf
rom onecel
linexcelt
oanother
,cl
ickonthecel
l
andusekeyboar
dshort
cutCTRL+Xandt hencl
ickontheotherl
ocat
ion
andpressCTRL+[Link]
lbemov edtot
henewl ocat
ion.
[Link]
etheadv
ant
agesofspr
eadsheet
s?
[Link]
ti
ng–Af t
ercreati
ngaspreadsheet
,youcanent
erdat
aint
oa
worksheet
,updat
ethevaluesofcel
l
s.
[Link]-
Theabi
li
tytoentermat
hemat
ical
for
mul
asi
skeyt
othe
useful
nessofspr
eadsheets.
[Link]
ons-Spreadsheetprogr
amsprovi
dearangeofpr
eset
funct
ionsthatencapsul
atecommonf ormul
as,al
l
owinguser
stoappl
y
funct
ionswithouthavi
ngt otypethem i
nmanuall
y.
[Link]
calDispl
aysofData-I
nExcel
,thechartssectionprov
idest
he
abi
li
tytopresentadatasetwit
[Link]
owsuser
sto
vi
suali
zeandcommuni cat
ethei
rdatasetswithi
npr esent
ati
ons.
Cl
assVI
I
Comput
er
Chapt
er6-I
ntr
oduct
iont
oDBMS
Bookwor
k-pg93
Ti
ckt
hecor
rectanswer
.
[Link]
umni
nanMSAccesst
abl
ear
eal
socal
l
ed_
___.
[Link]
elds
[Link]
ouopenabl
ankdat
abase,
ther
ear
e__
_tabl
e(s)bydef
aul
t.
[Link]
[Link]
ear
e__
__t
ypesofdat
abases.
[Link]
Tr
ueorFal
se
[Link]
aredundancyi
srel
atedt
odat
adupl
i
cat
ion.T
[Link]
imar
ykeycanhav
edupl
i
cat
eval
ues.F
[Link]
gnv
iewi
susedt
odef
inet
hef
iel
dsofat
abl
e.T
[Link]
ati
onal
dat
abasest
oresdat
aint
hef
orm ofat
abl
e.T
[Link]
ionsorspeci
fi
cat
ioni
nor
dert
opr
esentt
hedat
ainapar
ti
cul
ar
for
mat.T
Answert
hef
oll
owi
ngquest
ions.
[Link]
sadat
abase?
[Link]
roni
csy
stem ofmai
ntai
ningr
ecor
dsi
namannerwhi
chcanbe
easi
lyaccessedandedi
ted.
[Link]
it
eanyt
woobj
ect
ivesofadat
abase.
[Link]
ntai
nanorgani
sedcoll
ecti
onofdat
asuchthati
tcanbeeasi
l
yaccessed,
managed,
updat
edandint
erpr
etedaccor
dingtoanor
gani
sat
ion'
srequi
rement
s.
[Link]
rol
accesst
ofi
l
esy
stemssot
hatal
ldat
aisnotaccessi
blet
oal
luser
s.
[Link]
sDBMS?
[Link] sapr ogram whi
chhelpstheuseri
nmanagi
ngadatabaseandr
etr
iev
ing
i
nformat
ionfrom i
[Link]
sasaninterf
acebetweent
heuserandt
herawdatai
ntheharddi
skof
thecomputer
.
[Link]
ainanyt
woadv
ant
agesofDBMS.
[Link]
easedDataSecuri
ty-I
nDBMSt heaccesst
osensi
ti
vedat
acanbegi
vent
o
aut
horisedusersonl
[Link]
rdat
asecuri
tywit
htheuseofDBMS.
[Link]
ckRet
ri
eval
-DBMShel
psi
nret
ri
evi
ngdat
afr
om l
argedat
abase.
[Link]
ethet
wot
ypesofdat
abase?
[Link]
ear
etwot
ypesofdat
abase-
[Link]
atFi
l
eDat
abase
[Link]
ati
onal
Dat
abase
Q.
[Link]
ethef
ourcomponent
sofadat
abase?
[Link]
es
[Link]
ies
[Link]
ms
[Link]
ts
Q.
[Link]
sMSAccess?
[Link] cr
osoftAccessisav er
ypopularandpowerfulr
elat
ionaldat
abasemanagementsyst
em
thatprovi
desgraphicaluseri
nter
face.I
torgani
sesdataintheform oftabl
esandhel
psi
n
creat
ingar el
ati
onshipbetweentheTablesbyusingthecommonf i
elds.
Q.
[Link]
ethet
wov
iewi
ngopt
ionsf
ort
abl
esi
nMSAccess?
[Link]
ear
etwov
iewi
ngopt
ionsi
nMSAccess-
1.
desi
gnv
iewand
[Link]
asheetv
iew
Q.
[Link]
sthedi
ff
erencebet
weendat
asheetv
iewanddesi
gnv
iew?
[Link]
ew-Thisisusedf
orent
eri
ngt
hedat
ainat
abl
[Link]
eldsar
edi
spl
ayedas
col
umnsi nat abl
eandrecor
dsarerows.
[Link]
gnview-t
hishelpstodeci
dewhichf
iel
dswi l
lbei
ncl
udedandt
hei
rpr
oper
ti
[Link]
al
soinser
tasmalldescri
pti
onofthef
iel
dsforyourownbenef
it
.
Q.
[Link]
l
lyour
enameaf
iel
dindat
asheetv
iew?
[Link]
enameaf
iel
dbyf
oll
owi
ngt
hesest
eps-
[Link]
ecl
i
ckont
hef
iel
[Link]
swi
l
lhi
ghl
i
ghtt
hef
iel
dnamewhi
chy
oucanedi
t.
[Link]
ickonNameandCapti
onbutt
on(
Fiel
dTab-pr
oper
ti
es-NameandCapt
ion)
.Thi
swi
l
l
l
aunchtheFi
ledpr
oper
ti
esdial
ogbox
.
[Link]
veanameofy
ourchoi
ceandanopt
ional
descr
ipt
ionoft
hef
iel
[Link]
i
ckOK.