Lesson 02 - Creating a Workbook


1	Which function results can be displayed in AutoCalculate?
	A)	SUM and AVERAGE
	B)	MAX and LOOK
	C)	LABEL and AVERAGE
	D)	MIN and BLANK



2	Which cell alignment is assigned to most values by default?
	A)	Right
	B)	Left
	C)	Center
	D)	Decimal



3	Which function automatically totals a column or row of values?
	A)	TOTAL
	B)	ADD
	C)	SUM
	D)	AVG



4	Which mathematical operator is represented by an asterisk (*)?
	A)	Exponentiation
	B)	Addition
	C)	Subtraction
	D)	Multiplication



5	Which step completes an entry and moves the pointer to the cell to the right?
	A)	Pressing [Enter]
	B)	Pressing [Tab]
	C)	Pressing [Shift]+[Tab]
	D)	Pressing [Shift]+[Enter]



6	Which group on the Formulas tab organizes Excels built-in formulas?
	A)	Calculation
	B)	Function Arguments
	C)	Function Library
	D)	Formula Selection



7	How many blank worksheets are shown when a new workbook is created?
	A)	One
	B)	Two
	C)	Three
	D)	Four



8	What term describes the average width of a numeric character in the standard font?
	A)	Character space
	B)	Label
	C)	Pixel
	D)	Range



9	What two font types are included in a document theme?
	A)	Labels and Values
	B)	Columns and Rows
	C)	Headings and Body
	D)	Header and Footer



10	How are font sizes specified?
	A)	Pixels
	B)	Spaces
	C)	Points
	D)	Picas

Notes		(What is this?)

Add a note
1.	(optional) Enter a note here:
2.	(optional) Select some text on the page (or do this before you open the "Notes" drawer).
3.	Highlighter Color:
4.

Home > Excel > Lesson 02 Quiz