5th Six Weeks Review

5th Six Weeks Review

Excel Spreadsheets

Excel uses Functions

• predefined formula that performs calculations using specific values in a particular order.

Multiple Choice

Which of the following is a function?

• =Average

• (C4:C10)

• =

• ()

Multiple Choice

Which function gives the lowest number?

• Max

• Min

• Median

• Average

Multiple Choice

Which function counts the cells containing numbers in a range of cells?

• =average

• =max

• =count

• =counta

Multiple Choice

Which function removes extra spaces in a cell?

• Concatenate

• Trim

• Lower

• Right

Range Name

You can assign a name to a group/range of cells.

*Just select range of cells and click in name box to give it a name.

Multiple Choice

An identifying label assigned to a group of cells.

• Name Box

• Range Name

• Function

• Cell

Sort

Sort is simply putting your data in a specific order by columns. See column Severity.

You can sort data in a table in Ascending (A-Z) or Descending (Z-A) order.

Multiple Choice

Sorting is when arrange data in order by column headings.

• True

• False

Show Formulas

You can display your formulas by simply using the command Show Formulas so you check your work.

Multiple Choice

A command that displays the formulas in a worksheet so you can check them.

• Scale

• Show Formulas

• Orientation

• Filter

Filter

You can select what data you want to show up on your table.

You can hide those you don't want to appear.

Multiple Choice

To hide non-matching rows in a table or list of data according to criteria you specify.

• Sort

• Filter

• Scale

• Show Formulas

Total Rows

Total rows are placed at the bottom of the table.

You can modify by using formulas to use sum functions, average, functions, etc.

Multiple Choice

Total rows are placed below the table.

• True

• False

Multiple Choice

The fill handle is used to select cells not to copy.

• True

• False

Merge and Center

Combines several cells into one cell and centers the text.

Multiple Choice

To center a label across several columns, use the Merge & Center command.

• True

• False

Scale

When you want to make the document print and fit onto one page.

Multiple Choice

You CANNOT scale a page to print only on one page.

• True

• False

Multiple Select

Select ALL the ones you need to create a sum formula.

• =

• sum

• (A6:A12)

• +

• add

Multiple Choice

Which formula subtracts two cells?

• =C4=D4

• C4-D4

• =C4-D4

• =C4/D4

Multiple Choice

Which is the operator to multiply?

• +

• =

• *

• /

Multiple Choice

What function do you use to merge information from different cells? (John D Joe)

• Trim

• Concatenate

• Lower

• Left

Worksheet vs. Workbook

Worksheet is one sheet tab in a document.

Workbook is when you have multiple sheets in a document. See picture.

Multiple Choice

What is a document with more than one worksheet called?

• Worksheets

• Workbook

• Spreadsheet

• Workbooks

Autofit a column/row

Autofit is when you want to resize the row/column to the contents inside.

There are two ways to autofit a column or row.

Multiple Choice

There is only one way to autofit a column.

• True

• False

Formulas

All formulas start with =

Then the function

For Example: Sum...Average..Count

Then the range in parenthesis.

NO SPACES are allowed in formulas unless you place in " " quotation marks as part of your criteria. =concatenate(D4," ",E4," ", F4)

Multiple Choice

Spaces are allowed in formulas.

• True

• False

Multiple Choice

What type of document are we working on?

• Word Processing

• Spreadsheet

• Database

• Presentation

Multiple Choice

What program are we using to create a spreadsheet?

• Excel

• PowerPoint

• Word

• Access