Excel is an electronic version of a(n) ____.
a. database
b. spreadsheet
c. expression
d. formula
What is b. spreadsheet
100
“AD” is an example of a ____.
a. column heading
b. cell reference
c. row heading
d. Name box
What is a. column heading
100
The active cell has a ____ border.
a. dotted
b. thick
c. red
d. dashed
What is b. thick
100
What happens when you pres "shift + enter"?
a. moves one column to the left
b. moves one column to the right
c. moves up one row
d. moves down one row
What is c. moves up one row
100
Can you drag and drop in Excel? What about cut and paste? Cut and copy?
What is yes, yes and yes!
200
Excel stores its documents as files called ____.
a. worksheets
b. workbooks
c. sheet tabs
d. books
What is b. workbooks
200
Row headings identify each row using a different ____.
a. operator
b. letter
c. number
d. number and letter combination
What is c. number
200
An Excel formula always begins with a(n) ____.
a. parentheses
b. plus sign
c. equals sign
d. colon
What is c. equals sign
200
To accept the AutoComplete text, what do you do?
a. hit enter
b. hit tab
c. press shift + control
d. both a. and b. are correct
What is d. both a. and b. are correct
200
Name two things that Excel has in common with either Word or PowerPoint.
What is - the ribbon, some functions, tabs, text, etc.
300
The contents of an active cell are displayed in the ____.
a. toolbar
b. name box
c. menu bar
d. formula bar
What is d. formula bar
300
The intersection of a row and column is known as a ____.
a. cell
b. reference
c. range
d. border
What is a. cell
300
When a column is truncated, how do you fix it?
a. use the AutoComplete command
b. use the AutoFit command
c. resizes the column width
d. switch to Edit mode
What is b. use the AutoFit command
300
How big is a point?
a. approximately 1/72 of an inch
b. approximately 1/36 of an inch
c. I have no idea
d. I don't really care
What is a. approximately 1/72 of an inch
300
Can you rename a sheet? How?
What is heck yes! The easiest way is to right click it or double click it and type new text.
400
The name given to an Excel workbook before you rename it is ____.
a. Document1
b. Workbook1
c. Book1
d. Untitled1
What is b. Workbook1
400
To go to column A of the current row, click ____.
a. Ctrl + Home
b. Shift + Tab
c. Home
d. Tab + Enter
What is c. Home
400
What type of cell automatically left aligns?
a. dates
b. times
c. numbers
d. text
What is d. text
400
Is Clearing data from a worksheet the same as Deleting data from the worksheet? Explain.
What is No. Clearing data removes the data and leaves the cell blank but Deleting data removes both the data and the cell.
400
Can you add sheets? Delete sheets? What are the new sheets called?
What is yes and yes. The new sheets are called sheet 4, sheet 5, sheet 6, etc.
500
By default, an Excel workbook is made up of ____ worksheets.
a. two
b. four
c. three
d. five
What is c. three
500
To make A1 the active cell, press which of the following keys?
a. Page Up
b. Home
c. Page Down
d. Ctrl+Home
What is d. Ctrl+Home
500
An Excel worksheet can have a maximum of ____ columns in a worksheet.
a. 156
b. 16,385
c. 256
d. 17 million
What is b. 16,385
500
Doing an formula such as =B5*D5 is the same as using the AutoSum function? Explain.
What is no way! Because if you add/delete cells the first formula will still give you the same answer but AutoSum will not.
500
Which is your favorite and why - Excel, PowerPoint or Word? Which will you use the most? Which do you feel is the most "powerful"?