MS EXCEL REVIEW

Multiple Choice

What is in cell A6?

• Monday

• Tuesday

• Wednesday

• Thursday

Multiple Choice

Which of the following cursor allows you to select a range of cells

Multiple Choice

Drag to widen or narrow the width of a column.

Multiple Choice

How would you write a formula for cell A1 subtracted by Cell C3?

• A1-C3

• A1-C3=

• =A1-C3

• =C3-A1

Multiple Choice

Identify the numbered #4 part of MS Excel window

• Column Header

• Row Header

• Name box

• Sheet Tabs

Multiple Choice

Identify the numbered #5 part of MS Excel window

• Column Header

• Row Header

• Name box

• Sheet Tabs

Multiple Choice

Identify the numbered #6 part of MS Excel window

• Formula bar

• Ribbon

• Sheet tabs

• Worksheet Window

Multiple Choice

What does this symbol represent in MS Excel?

• a. Subtract
• b. AutoSum
• c. Formula
• d.    Average

Multiple Choice

If I wanted to know the total amount of bonuses given to the employees I would write the following formula in cell D12:

• =sum(C2:C11)

• =sum(D2,D3,D4,D5,D7,D8,D9,D10,D11)

• =sum(D2:D11)

• $13,442.90

Multiple Choice

What would be a correct formula for SUM in excel?

• =SUM(B3:B9)
• =SUMB3+B9
• SUM(B3:B9)
• =ADD(B3:B9)

Multiple Choice

_____ are vertical. 

• Rows
• Columns

Multiple Choice

________ are horizontal

• Rows
• Columns

Multiple Choice

What is the "Active Cell" in Excel?

• The Bottom cell in a worksheet. It is indicated by a dark border onscreen.

• The current cell in a worksheet. It is indicated by a dark border onscreen.

• The top cell in a worksheet. It is indicated by a dark border onscreen.

• The past cell in a worksheet. It is indicated by a dark border onscreen.

Multiple Choice

What is a spreadsheet?

• An electronic file that contains a grid of columns and rows to organize related data and to display results of calculations.

• An electronic file that contains a grid of negatives and positives to organize related data and to display results of calculations.

• An electronic file that contains a grid of numbers and data to organize related data and to display results of calculations.

• An electronic file that contains a grid of pages and sheets to organize related data and to display results of calculations.

Multiple Choice

What is the Sum formula?

• Sum( )

• Sum( )=

• =Sum( )

• =( )Sum

Multiple Choice

When starting a formula what is the first thing you type in the cell?

• +

• -

• %

• =

Multiple Choice

The letters in Excel represent the _______?

• columns

• rows

• data

• functions

Multiple Choice

The numbers in Excel represent the _____?

• columns

• rows

• data

• functions

Multiple Choice

Where is the zoom function located in Excel?

• Bottom right of spreadsheet document

• Bottom left of spreadsheet document

• Top right of spreadsheet document

• Top left of spreadsheet document

Multiple Choice

Excel is part of?

• Power Point
• Microsoft Office Suite
• Access
• Google

Multiple Choice

What do you call the rectangles on a spreadsheet?

• Cell
• Button
• Sentence

Multiple Choice

What is the Formula sign for multiply? 

• \
• *

Multiple Choice

True or False: Spreadsheets can be used in everyday life by analyzing sports stats, grades, and creating a budget for expenses?

• false
• true

Multiple Choice

How do you make a cell the active cell?

• Click the ACTIVE button
• Click INSERT CELL
• Click on the cell
• Cells are always active

Multiple Choice

What is the name of this cell?

• B10
• 5B
• B5
• A5

Multiple Choice

Excel refers to files as

• Documents
• Workbooks
• data bases

Multiple Choice

Where rows and columns meet are referred to as

• Blocks
• Cells
• Boxes

Multiple Choice

Can you format text with Excel

• Yes
• No

Multiple Choice

In Excel, what symbol do you use for multiplication?

• x

• +

• /

• *

Multiple Choice

In Excel, what symbol do you use for division?

• x

• \

• /

• *

Multiple Choice

In Excel, where would you go to add gridlines?

• Borders

• Charts

• Graphs

• Fill Color

Multiple Choice

In Excel, how do you combine 2 cells and put the words in the middle?

• Merge and Center

• Combine and Center

• You can't do this

• Merge and Middle

Multiple Choice

What cell is red?

• A1

• C1

• C4

• C5