Working with Numbers:
Excel 2007/10/13
Intro
Before you start
Project 1:
 Excel Intro
Project 2:
 Excel Basics
Project 3:
 Format & Arrange
Project 4:
 Groups & Formulas
Project 5:
 Design
Glossary
Appendix
 
Home
Lessons
Archives
About
 
Jan's Illustrated Computer Literacy 101 Logo:Jegsworks Jan's Illustrated Computer Literacy 101
Home > Jan's CompLit 101 > Working with Numbers > Basics > Quiz
Icon: Arrow - Previous pagePrevious    NextIcon: Arrow - Next page

Jan's Working with Numbers

    Excel Basics: Quiz

For each question, click on Radio Button the radio button for your answer. You will be notified immediately whether your choice is correct or not. Double clicking may work better in some browsers.

Choose the BEST answer. 

1.   The currency and the units for measurements that Excel uses are set in _____.

 a. Control Panel: Regional and Language Options (WinXP, Vista) or Region and Language (Win7), Region (Win8, Win8.1, Win10)

 b. Page Setup

 c. File > Options (WinXP) or File > Excel Options (Vista, Win7, Win8, Win8.1, Win10)

 d. File > User Settings

2.  To arrange rows in alphabetical order based on column A, you can select your rows and then select _____.

 a. Sort A-Z on the Formula tab

 b. Sort A-Z on the Data tab

 c. Sort & Filter dialog > select Column A

 d. none of the above

3. To edit existing data in a cell without having to retype it all, you should _____.

 a. double-click the cell

 b. click the Edit button on the Formula bar

 c. hold SHIFT down while clicking the cell

 d. none of the above - you must retype.

4.  If you select a cell with a date in it and drag the fill handle down across several cells, then _____.

 a. the date is copied to each cell

 b. the date is increased by 1 day into each cell

 c. the date is increased by 1 week into each cell

 d.  nothing as AutoFill applies only to numbers

5.  To print just part of a sheet, you would select what you want to print and from Print Preview _____

 a. click the Print button

 b. press the PRINT SCREEN key

 c. select Print selection in the Page Setup dialog on the Sheet tab and then print

 d. select Print selection in the Print dialog (Excel 2007) or in the Print pane (Excel 2010, 2013, and 2016) and then print

6.  To remove the contents of several cells at once, you can _____.

 a. select the cells and press DELETE.

 b. select the cells and right click and choose Clear Contents

 c. select the cells and drag the fill handle back up over them

 d. all of the above 

7.  The formula that will add the value of cell D4 to the value of C2 and then multiply by the value in B2 is _____.

 a. (D4+C2)*B2

 b. D4+C2*B2

 c. =(D4+C2)*B2

 d. =(B2*(D4+C2)

8.   The default orientation for a printed page is _____.

 a. portrait

 b. landscape

 c. whatever was last used

 d. vertical

9.  Cell A4 =2 and A5 = 4. You select both cells and drag the fill handle down to A8. The contents of cells A6, A7, and A8 are _____.

 a. 8, 16, 32

 b. 2, 4, 2

 c. 2, 2, 2

 d. 6, 8 ,10

10.   If a cell shows  ####### , it means that _____.

 a. your formula has a syntax error

 b. the row is too short to show the number at the current font size

 c. the column is too narrow to show all the digits of the number

 d. either b or c