Quiz 3 excel
This presentation is the property of its rightful owner.
Sponsored Links
1 / 11

Quiz #3 – Excel PowerPoint PPT Presentation


  • 138 Views
  • Uploaded on
  • Presentation posted in: General

FMIS 2201. Quiz #3 – Excel. February 2, 2007. #1. Excel is most likely to be used in a:. Structured Decision Support role. Unstructured Decision Support role. #2. Which of the following is a valid cell reference or address in Excel?. A:1 A/1 A=1 A1.

Download Presentation

Quiz #3 – Excel

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Quiz 3 excel

FMIS 2201

Quiz #3 – Excel

February 2, 2007


1 excel is most likely to be used in a

#1. Excel is most likely to be used in a:

  • Structured Decision Support role.

  • Unstructured Decision Support role.


2 which of the following is a valid cell reference or address in excel

#2. Which of the following is a valid cell reference or address in Excel?

  • A:1

  • A/1

  • A=1

  • A1


3 which of the following is an example of an excel formula

#3. Which of the following is an example of an Excel Formula?

  • +C1+C2=C3

  • C1+C2

  • =C1+C2


4 which of the following is a valid cell type

#4. Which of the following is a valid cell type?

  • Text

  • Number

  • Both 1 and 2 are valid cell types

  • Neither of the above are valid cell types


Quiz 3 excel

#5. The =sum function is a more efficient means of summing a column of several numbers than creating a formula specifying each cell to be added

  • True

  • False


6 which of the following symbols designates the division sign in an excel formula

#6. Which of the following symbols designates the division sign in an Excel Formula

  • +

  • -

  • ^

  • /


7 the highest column label is

#7. The highest column label is:

  • Column AB

  • Column IV

  • Column ZZ

  • Column VI


8 the name of the excel spreadsheet file is displayed in the upper left corner of the screen

#8. The name of the Excel Spreadsheet file is displayed in the upper left corner of the screen

  • True

  • False


9 you can edit a formula or cell entry by

#9.You can edit a formula or cell entry by:

  • Double clicking the cell and entering the edit

  • Selecting the cell to be edited and using the formula bar to make the edit

  • Both 1 and 2 are correct.


10 excel spreadsheets are

#10. Excel Spreadsheets are:

  • Single Dimension

  • Two Dimensional

  • Three Dimensional

  • Quad Dimensional


  • Login