WorksheetsSDE311 - Test 1 Review
Total questions: 9
Worksheet time: 6mins
Microsoft Excel stores workbooks in worksheets.
True
False
Match terms with their definitions
Workbook
An Excel file
Worksheet
A single 'page' in a workbook
Columns
Run down
Rows
Run across
Most Excel worksheets have a title, column headings, and (a) headings.
No marks: In your own words, tell me what an Excel cell is.
Match the terms with their correct definitions
Formula
What you type in a cell starting with the = sign
Function
Something with a name (like COUNT) that you can include in a formula
SUM
Adds the values in a range
Range
More than one cell
Order of calculations
Multiply and divide come first unless you add parenthesis
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.
Open ended: type your response.
How would you describe Absolute references in cells?
Flash Fill is the same as AutoFill.
True
False
