Excel Test - Fall 2012
Choose the correct answer and click on it to select. Check your answers then submit to the teacher when you are finished.
- 1.Excel's ___________ function allows you to add all of the numbers in a range of cells.
- A.
MIN
- B.
MAX
- C.
SUM
- D.
ADD
- 2.The ___________ is a central location for managing workbooks with commands like Save, Print, and Open..
- A.
Ribbon
- B.
Office Button
- C.
Screen Tip
- D.
Share toolbar
- 3.When typing formulas or functions into a cell, it is important to:
- A.
Begin the formula with an apostrophe
- B.
Lock the data into the cell by pressing enter when you're done
- C.
Type in lowercase
- D.
Split and Merge
- 4.Excel opens a new workbook with _________ worksheets
- A.
One
- B.
Two
- C.
Three
- D.
Five
- 5.To save a workbook using the shortcut keys, press
- A.
ALT + S
- B.
CTRL + S
- C.
SHIFT + S
- D.
CTRL + F2
- 6.The ______________ is a blinking vertical line that indicates where the next typed character will appear.
- A.
Insertion point
- B.
Alignment tool
- C.
Left-justified
- D.
Right button
- 7.When you create a formula in a cell that meets only specified conditions it is called a ...
- A.
Comma style formatting
- B.
Point mode
- C.
Conditional formula
- D.
Unlimited
- 8.A saved workbook is referred to as a ____________.
- A.
Book
- B.
Workbook
- C.
Project
- D.
File
- 9.The formula _____ multiplies the contents of cell B4 by 18.5
- A.
18.5 ^ B4
- B.
=18.5 * B4
- C.
=B4/18.5
- D.
=B4**18.5
- 10.To alert Excel that you are entering a formula and not text, type a (n) ____________ before the formula
- A.
Ampersand (&)
- B.
Equal sign (=)
- C.
Number sign (#)
- D.
Asterisk (*)
- 11.This is located on the Ribbon and is used to display the borders gallery
- A.
Active cell
- B.
Borders button
- C.
Name box
- D.
Forumula bar
- 12.A user wishes to remove a spreadsheet from a workbook. Which is the correct way to delete the tab?
- A.
Right click on the spreadsheet tab and select DELETE
- B.
Double-click on the spreadsheet tab
- C.
Access the Office Button
- D.
Right click and rename
- 13.Provides easy access to frequently used commands
- A.
Easy Access Toolbar
- B.
Office Button
- C.
Quick Access Toolbar
- D.
Name box
- 14.The numbers on the left side of the Excel grid.
- A.
Row Heading
- B.
Column Heading
- C.
Headers
- D.
Footers
- 15.The one into which you enter data and has a heavy border around it
- A.
Active cell
- B.
Cell name
- C.
Range
- D.
Worksheet
- 16.The basic unit of a worksheet into which you enter data is called a ______________.
- A.
Cell
- B.
Box
- C.
Range
- D.
Gridlines
- 17.Displays the lowest value for a range of cells
- A.
MAX
- B.
MIN
- C.
SUM
- D.
LOW
- 18.The small black square located in the lower-right corner of the heavy border around the active cell
- A.
Name box
- B.
Cell name
- C.
Cell
- D.
Fill handle
- 19.A printed version of a worksheet is called a ______________.
- A.
Hard copy
- B.
Soft copy
- C.
File
- D.
Digital copy
- 20.Displays the highest value for a range of cells
- A.
LOW
- B.
MAX
- C.
MIN
- D.
DIV
- 21.Instructs Excel to display additional spaces for decimals in a cell
- A.
Decrease Decimal Button
- B.
Increase Decimal Button
- C.
Accounting Style
- D.
Comman Style Format
- 22.How are columns designated in Excel?
- A.
Numbers
- B.
Letters
- C.
Triangles
- D.
Circles
- 23.Which direction do rows run in a spreadsheet?
- A.
Counter clockwise
- B.
Horizontal
- C.
Vertical
- D.
Diagonal
- 24.To combine a group of cells together to make one big cell along with center the text in the cell, you would click ____________ button.
- A.
Merge
- B.
Merge and align
- C.
Merge and center
- D.
Format cells
- 25.Type a formula that would divide B3 by E7.
Related Topics
Recent Quizzes
Back to top