SDE311 - Test 1 Review

Microsoft Excel stores workbooks in worksheets.

• True

• False

Match terms with their definitions

• Run down

• Worksheet

• A single 'page' in a workbook

• Columns

• An Excel file

• Rows

• Run across

• Workbook

Most Excel worksheets have a title, column headings, and ___ headings.

No marks: In your own words, tell me what an Excel cell is.

Match the terms with their correct definitions

• Adds the values in a range

• Range

• Multiply and divide come first unless you add parenthesis

• Function

• Something with a name (like COUNT) that you can include in a formula

• SUM

• What you type in a cell starting with the = sign

• Formula

• More than one cell

• Order of calculations

More than one answer. You must get all of them right. Which of the following are true or valid?

• =sum(a1,b3,f5)

• =sum(7,9,5)

• sum(a1:a7)

• =sum(a1:a7)

Most excel worksheets are in ​ (a)   ​ mode.​

• Landscape
• Portrait
• A7

Open ended: type your response.

How would you describe Absolute references in cells?

Flash Fill is the same as AutoFill.

• True

• False

Answer explanation

Flash fill looks at existing cell entries to try to figure out what you want typed in another cell, or how you want it to look.