Scribd
Upload
164 views77 pages

Starting Symbols for Excel Formulas

This document contains 47 multiple choice questions about Excel functions, formulas, and features. It tests knowledge of topics like cell references, formulas, charts, formatting, printing, protecting sheets, and using Excel with other programs. The correct answers are indicated after each question.

Uploaded by

Sachin Maskeen
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
164 views77 pages

Starting Symbols for Excel Formulas

This document contains 47 multiple choice questions about Excel functions, formulas, and features. It tests knowledge of topics like cell references, formulas, charts, formatting, printing, protecting sheets, and using Excel with other programs. The correct answers are indicated after each question.

Uploaded by

Sachin Maskeen
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
  • Basic Excel Questions 1-4
  • Basic Excel Questions 5-7
  • Basic Excel Questions 8-9
  • Excel Chart Questions 10-12
  • Excel Worksheet Functions 13-15
  • Excel Data Manipulation 16-18
  • Excel Calculation Features 19-20
  • Excel Functions 21-22
  • Excel Workbook Management 23-24
  • Excel Cell Selection 25-26
  • Excel Editing Features 27
  • Excel Data Entry 28-29
  • Excel Object Interaction 30-31
  • Excel File Extensions 32-33
  • Excel Cell Comments 34
  • Excel Design Criteria 35-36
  • Excel Versions and Features 37-38
  • Autofill and Window Options 39-40
  • Excel Interface and Security 41-42
  • Circular References and Functionality 43-44
  • Excel File Integration 45-46
  • Formula Usage and Commands 50-52
  • Excel Workbook Features 47-49
  • Formatting and Data Types 53-54
  • Page Setup Features 55-56
  • Excel Navigation and Editing 57-58
  • Data Input and Security 59-61
  • Excel User Interface 62-63
  • Cell Editing and Error Handling 64-65
  • Worksheet Management Steps 66-68

[Link]?

a.!A!1
b.$A$1
c.#a#1
d.A1
CorrectAnswer:b
[Link]?
a.(quote)
b.=(equal)
c._(underscore)
d.(apostrophe)
CorrectAnswer:b
[Link]?
a.=
b.+
c.(
d.@
CorrectAnswer:a

[Link]?
a.=10+50
b.=B7*B1

c.=B7+14
d.10+50
CorrectAnswer:d

[Link]?
a.=SUM(Sales)A3
b.=SUM(A1:A5)*.5
c.=SUM(A1:A5)/(1010)
d.=SUM(A1:A5)10
CorrectAnswer:a

[Link]
a.128
b.256
c.512
d.1024
CorrectAnswer:b

[Link]?

a.256
b.1024
c.32,000
d.65,535
CorrectAnswer:d

[Link]
a.256
b.1024
c.32,000
d.65,535
CorrectAnswer:d

[Link]?
a.350
b.May10,2001
c.57%
d.SerialNumber50771
CorrectAnswer:d

[Link]
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:b

[Link];
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:b

[Link]
[Link]
b.Arangeofvaluessuchasfrom23to234
[Link]
[Link]

CorrectAnswer:c

[Link]
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:b

[Link]
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:d

[Link]
[Link](&lsquo
[Link](!)

[Link](#)
[Link](&
CorrectAnswer:a

[Link]
[Link](&lsquo
[Link](!)
[Link](#)
[Link](&
CorrectAnswer:d

[Link]
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:d

[Link]

[Link]
[Link]
[Link]
[Link]
CorrectAnswer:a

[Link]
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:b

[Link]
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:c

[Link]

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:c

[Link]

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:a

[Link],you:

[Link]

[Link]+F5

[Link]

[Link]>Save

CorrectAnswer:a

[Link]

[Link]

[Link]

[Link]>EditCellfromthemenu

[Link]

CorrectAnswer:b

[Link]

[Link]
thelowerrightcellinagroupofcells

[Link]

[Link]

[Link]

CorrectAnswer:d

[Link]

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:d

[Link]

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:d

[Link]

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:b

[Link]?

[Link]

[Link]>FormfromthemenutoopentheDataFormdialogbox,findtherecordand
ClicktheDeletebutton

[Link]>DeleteRecordfromthemenu

[Link]

CorrectAnswer:b

[Link]:

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:c

[Link]

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:d

32.FilescreatedwithLotus123haveanextension

[Link]

[Link]

c.123

d.WK1

CorrectAnswer:c

[Link],first

[Link]

[Link]

[Link]+Deletekeys

[Link]

CorrectAnswer:d

[Link]

[Link]>Comments

[Link]>Comments

[Link]>Comments

[Link]>Comments

CorrectAnswer:b

[Link]?

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:c

[Link]

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:d

[Link]

a.Excel2000

b.Excel2002

[Link]

[Link]

CorrectAnswer:d

[Link]

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:b

[Link]

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:d

[Link]

[Link]>window

[Link]>window>split

[Link]>split

[Link]>split

CorrectAnswer:c

[Link]

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:b

[Link]

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:b

[Link]

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:c

[Link]?

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:d

[Link]

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:b

[Link]?

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:a

[Link]

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:c

48.ExcelprobablyconsidersthecellentryJanuary1,2000tobea

Label

Value

Formula

Textstring

CorrectAnswer:b

[Link]?

[Link],values,andformulas

b.Labe3lsandvaluesbutnotformulas

[Link]

[Link]

CorrectAnswer:a

[Link]

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:c

[Link]?

[Link]

[Link],positiveandnegativevalues,additionandsubtraction

[Link],positiveandnegativevalues,exponentiation

[Link]

CorrectAnswer:d

[Link]:

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:d

[Link].Youwantthemtolooklikethis:
$1,[Link]?

[Link]

[Link]>Moneyfromthemenu

[Link]

[Link],commas,anddecimals.

CorrectAnswer:c

[Link]

[Link]

[Link]

[Link]

[Link]/time

CorrectAnswer:b

[Link]
graphicaluserinterface

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:c

[Link]?

[Link].

[Link]

[Link]

[Link]

CorrectAnswer:a

[Link]
shouldyouuse?

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:c

[Link],whatisthefastestwayofgettingtocellA1ina
spreadsheet?

[Link]+Home

[Link]

[Link]+Home

[Link]+Home

CorrectAnswer:a

[Link]?

[Link]

[Link]

c.PressingtheF2key

[Link]

CorrectAnswer:a

[Link]
intoacell,you:

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:b

[Link]

[Link]

[Link]

[Link]

[Link]
CorrectAnswer:c

[Link]?

[Link]+C

[Link]>Cutfromthemenu

[Link]

[Link]+X
CorrectAnswer:a

[Link]?
[Link]

[Link]

[Link]

[Link]
CorrectAnswer:d

[Link]

[Link]

[Link]

[Link]

[Link]
CorrectAnswer:d

[Link]:

[Link]

[Link]

[Link]

[Link]
CorrectAnswer:c

[Link]?

[Link]
shortcutmenu

[Link]>Rowfromthe
menu

[Link]
onthestandardtoolbar

[Link]
CorrectAnswer:a

[Link]?
[Link]

[Link]

[Link]

[Link]
CorrectAnswer:d

[Link]?

[Link]>Select>Columnfromthemenu

[Link]

[Link].

[Link]
CorrectAnswer:b

[Link]?

[Link]>Propertiesformthemenuandtype3intheCopiestoprinttextbox.

[Link]>Printfromthemenuandtype3intheNumberofcopiestextbox.

[Link]
have2morecopiesmade
[Link]+P+3
CorrectAnswer:b

[Link],youfirst:

[Link]

[Link](=)totellExcelthatyoureabouttoenteraformula

[Link]
upyourformula

[Link]
CorrectAnswer:a

[Link],youmust

[Link]
[Link]

[Link]
enfettered

[Link]

CorrectAnswer:a

[Link]?

[Link]
toolbar

[Link]

[Link]>Deletefromthemenu

[Link]
CorrectAnswer:d

[Link]?

[Link]>Finderfromthemenu

[Link]

[Link]>Findfromthemenu

[Link]>FormfromthemenutoopentheDataFormdialogboxandclicktheCriteria
button
CorrectAnswer:d

[Link],wordisusuallythe
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:d

[Link],youtypicallymust

[Link]

[Link]

[Link]

[Link]
CorrectAnswer:b

[Link]

[Link]

[Link]

[Link]

[Link]
CorrectAnswer:b

[Link]
[Link]

[Link]
[Link]
[Link]
CorrectAnswer:b

[Link]?
[Link]
[Link]

[Link]
[Link]
CorrectAnswer:d

[Link]

[Link]

[Link]

[Link]

[Link]
CorrectAnswer:b

[Link]

[Link]
[Link]

[Link]
[Link]
CorrectAnswer:b

[Link]

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:d

[Link],press

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:d

[Link]?

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:a

[Link],youcansee

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:d

[Link]:

[Link]>CopyFormatandEdit>PasteFormatcommandsformthemenu.

[Link],locatedundertheFormat>CopyandApply
menu.

[Link]

[Link]

CorrectAnswer:d

[Link]

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:b

[Link]

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:b

[Link]

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:c

[Link]
clickthe

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:b

[Link]

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:a

[Link],youcanuse:

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:d

[Link]

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:c

[Link]?

[Link]

b.Lotus123

[Link]

[Link]

CorrectAnswer:a

[Link]

[Link],division,orexponentiationinaformula

[Link]

[Link]

[Link]

CorrectAnswer:a

[Link]

[Link],pasteandcutcommandsontheeditmenu

[Link]

[Link]

[Link]

CorrectAnswer:d

[Link]

[Link]

[Link]

[Link]

[Link].

CorrectAnswer:d

[Link]?

[Link]

[Link]

[Link]

d.Lotus123

CorrectAnswer:d

[Link]

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:d

[Link]

[Link]

[Link]

c.Wk1

d.123

CorrectAnswer:a

[Link]

[Link]

[Link]

[Link]

[Link]

CorrectAnswer:b

[Link]?
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:c

[Link],thedataare
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:[Link]

[Link],aformulawithalogicalfunctionshowsthewordTRUE
orFALSEasaresult
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:a

[Link]..menu.

[Link]
[Link]
[Link]
[Link]
CorrectAnswer:c

[Link]..menu.
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:d

[Link]
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:c

[Link]?
[Link]
[Link]
[Link],linegraphsandpiecharts

[Link]
CorrectAnswer:c

[Link]?
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:c

[Link]?
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:c

[Link]
[Link]
[Link]
[Link]
d.a,bandc
CorrectAnswer:d

________________________________________

[Link]
[Link].
[Link]
[Link]
[Link]
CorrectAnswer:d

[Link]?
[Link],exponentialpositiveandnegativevalue
[Link],positiveandnegativevalues,additionandsubtraction
[Link],positiveandnegativevalues,exponentiation
[Link]
CorrectAnswer:d

[Link]..function.
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:a

[Link],ifyoullwanttoprintadifferent
areanexttime?

[Link],pointtoprintarea,andthenclicksetprintarea.
[Link],clickprint,andthenclickselectionunderprintwhat
[Link],clickcustomviews,thenclickadd
[Link]
CorrectAnswer:b

[Link]
ExcelconvertthosesumstoEuros?
[Link],clickSymbolandfromthecurrencysymbolssubset,selecttheEurosign.
[Link],clickAddIns,andselecttheEuroCurrencyToolscheckbox
[Link]
[Link]
CorrectAnswer:b

[Link]?
[Link](payments)
[Link](numberofperiods)
[Link](presentvalue)
[Link]
CorrectAnswer:a

[Link](US),ChineseorJapanese,Excel2002canspeakdataas
youenterit,[Link]?
[Link],andthenclickshowtexttospeechtoolbar.
[Link]

[Link],andthenclickspeechrecognition
[Link]
CorrectAnswer:a

[Link]?
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:c.

[Link]?
[Link]+Ionthekeyboard
[Link]
[Link]
[Link]
CorrectAnswer:b

[Link]?
[Link]
[Link]
c.PressingF2
[Link]
CorrectAnswer:a

[Link]
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:d

[Link]?
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:a

[Link]?
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:b

[Link]?No?[Link]?
[Link]

[Link]
[Link]=inacell
[Link]
CorrectAnswer:b

[Link]?
[Link]
[Link]
[Link]
[Link]+Aonthekeyboard
CorrectAnswer:c

[Link],youcannot
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:a

[Link]
whichofthefollowing?
[Link]
[Link]
[Link]
[Link]

CorrectAnswer:c

[Link]?
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:d

[Link],forinstance1through
20?
[Link],andthendragthefillhandleovertherangeyouwant,forinstance18more
rows
[Link],includebothcells,pointtofillontheEditmenu,andthenclick
down.
[Link],clickinthecellbelowit,onthestandardtoolbarclickthedownarrow
onthePastebutton,andthenclickPasteSpecial
[Link]
CorrectAnswer:a
[Link]
[Link]
[Link]
[Link],FandG
[Link],E,andF.
CorrectAnswer:b

[Link],youmust
[Link]
ofcells
[Link]
[Link]
ofcells
[Link]
CorrectAnswer:a.

[Link],Wordisusuallythe
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:[Link]

[Link]
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:d

[Link]
[Link]

[Link]
[Link]
[Link]
CorrectAnswer:b

[Link]?
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:b

[Link],youmayneedto
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:d

[Link]
[Link]
[Link]
[Link]
[Link]

CorrectAnswer:[Link]

[Link]
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:b

[Link]?
Youmightusethistypeofprogramtokeeparecordofthemoneyyouearnedmovinglawns
overthesummer.
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:A

[Link]
.Toolbar.
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:d

[Link],usethe
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:d

[Link]
a.TheactivecellmustbeA1
[Link]
c.Theactivecellmustbeinrow1
[Link]
CorrectAnswer:c

[Link],press
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:d

[Link],youcansee
[Link]

[Link]
[Link]
[Link]
CorrectAnswer:d

[Link]
[Link]
[Link]
[Link]
d.a,b,andc
CorrectAnswer:d

[Link]
[Link]
[Link]
[Link]
d.a,bandc
CorrectAnswer:d

[Link]
[Link]
[Link]
[Link]
[Link]+enterkey

CorrectAnswer:c

[Link]
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:a

[Link]
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:[Link]

[Link],whatdoesthissignify?
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:b

CollectionofObjectiveQuestionsorMultipleChoiceQuestions(MCQs)distributedthrough
[Link]

________________________________________
[Link]
worksheet,clickthe
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:b

[Link]
thesameworksheet?
[Link],thenclickthepastebuttononthestandardtoolbar
[Link],thenselecttheothertwocells,clickstyleontheFormatmenu,then
clickModify
[Link]
theformattingto
[Link]
CorrectAnswer:c

[Link]
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:[Link]

[Link]
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:c

[Link]..menu.
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:d

[Link]..menu
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:d

[Link],youcan
[Link]
[Link]

[Link]
[Link]
CorrectAnswer:d

[Link]
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:b

[Link]
[Link],divisionorexponentiationinaformula
[Link]
[Link]
[Link]
results
CorrectAnswer:a

[Link]
[Link],pasteandcutcommandsontheeditmenu
[Link]
[Link]
[Link]
CorrectAnswer:d

[Link]
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:d

[Link]
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:[Link]

[Link]
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:c

164.whichfunctionwillcalculatethenumberofworkdaysbetween6/9/2004and8/12/2004?
[Link]

[Link]
[Link]
[Link]
CorrectAnswer:d

[Link],therefore,
[Link]
[Link]
intheworksheet
[Link]
[Link]
CorrectAnswer:b

[Link]
[Link]
[Link]
[Link],formats,andformulasonmultipleworksheetsatonetime
d.b,andc
CorrectAnswer:d

[Link]
[Link]
[Link]
[Link]
[Link]

CorrectAnswer:b

[Link]
[Link]
[Link]
[Link]
[Link]
CorrectAnswer:c

1. Which of the following is an absolute cell reference? a. !A!1 b. $A$1 c. #a#1 d. A1 Correct Answer: b 2. What symbol is us
c. =B7+14 d. 10+50 Correct Answer: d   5. Which of the following formulas will Excel Not be able to calculate? a. =SUM(Sales)
a. 256 b. 1024 c. 32,000 d. 65,535 Correct Answer: d 8. A worksheet can have a maximum of …. Number of rows a. 256 b. 1024 c.
10. The chart wizard term data series refers to a. A chart legend b. A collection of chart data markers c. A set of values yo
Correct Answer: c   13. Getting data from a cell located in a different sheet is called … a. Accessing b. Referencing c. Upda
c. Hash (#) d. Ampersand (&  Correct Answer: a   16. Concatenation of text can be done using a. Apostrophe (&lsquo  b. Exclam
a. By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key b. By dragging a range of 
21. to view a cell comment a. click the edit comment command on the insert menu b. click the display comment command on the w
Correct Answer: a   23. To save a workbook, you: a. Click the save button on the standard toolbar from the menu b. Press Ctrl
c. Selecting Edit>Edit Cell from the menu d. None of above Correct Answer: b   25. You can select a single range of cells by

You might also like