Show:
Workbook
Worksheet Window
Random
Font Type,Style, Size, and Color
final jeopardy
200
Organized into a rectangular grid of columns and rows within a workbook.
What is a worksheet?
200
It is the default view.
What is normal view?
200

A feature which allows data to to be formatted a certain way if it meets certain user-defined conditions.

What is the Conditional Formatting?

200
This defines the appearance and shape of the letters, numbers, and special characters.
What is Font type?
200

A function that performs a horizontal lookup by searching for a value in the top row of a table and returning the value from the same column.

HLOOKUP

400

What is the intersection of rows and columns on the worksheet?

Cell Address

400
This tab contains groups with the most frequently used commands
What is the Home Tab?
400
This function is used to access the format cells box without clicking in the ribbon.
What is right-click?
400
This defines the color of the characters
What is Font Color?
400

A function that adds all numbers in a range of cells.

What is SUM?

600
A cell referred to by its unique address within a formula.
What is cell reference?
600
This is used to move the worksheet window around to view different parts of the active worksheet?
What is the scroll bar?
600
This is a form of data used to insert titles, such as worksheet titles, column titles, and row titles on the worksheet.
What is Text?
600
These are the 3 options for font style.
What is regular, bold and italics?
600

A function that counts the number of cells in a range.

What is COUNT?

800

What is the infinite number of rectangles in a workbook?

A cell

800
This is the control center in excel
What is the Ribbon?
800

An option that will format a cell to a user-defined format.

What is Cell Style?

800
This includes a specific font for the heading and body of the worksheet.
What is Theme Font?
800

A function that returns the average of all numbers in a range of cells.

What AVERAGE?

1000
This cell is identified by a thick border.
What is the active cell?
1000
This located on the left side of the formula bar
What is Name Box?
1000
This is located at the top of the sceen and contains frequently used commands.
What is the quick access toolbar?
1000
This is the default font.
What is Calibri?
1000

A function that returns a value based on multiple user-specified criteria.

What is IF?