Excel 2019

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.

Define Formula Bar?

• Area to display table values

• Shows the number of pages from the Excel spreadsheet

• The Excel element that allows you to zoom your values

• An element in Excel that appears below the Ribbon and to the right of the Insert command that shows the contents of the active cell so that you edit the text, value, date, formula, or function.

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.

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

• +

• -

• %

• =

The letters in Excel represent the _______?

• columns

• rows

• data

• functions

The numbers in Excel represent the _____?

• columns

• rows

• data

• functions

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

• A1-C3

• A1-C3=

• =A1-C3

• =C3-A1

What is the name of this cell?

• B10
• 5B
• B5
• A5

Which feature enables you to preview headers and footers, page breaks, and other features that will print?

• Page preview
• Print Layout
• Synchronous Scrolling
• Window View

When you want to total up 2 cells what formula do you use?

• SUM

• AVERAGE

• MIN

• MAX