Excel Questions Lesson one

 True/False

Indicate whether the sentence or statement is true or false.

 

____    1.   The primary purpose of a spreadsheet program like Excel is to solve problems that involve numbers.

 

____    2.   The formula bar appears directly above the toolbar in the worksheet.

 

____    3.   If you want to move the cursor to cell A1, you should press Ctrl+Home on your keyboard.

 

____    4.   Worksheet cells only contain text.

 

____    5.   In order to replace the contents of a cell, you must first select the cell and then key in the new data.

 

____    6.   The Save command will update the latest version of your open file.

 

____    7.   You cannot change the default settings for printing a worksheet.

 

____    8.   You can choose to print all or part of a worksheet.

 

____    9.   Excel provides several template files that can be used to build commonly used spreadsheets.

 

Multiple Choice

Identify the letter of the choice that best completes the statement or answers the question.

 

____   10.   In Excel, a collection of worksheets is referred to as a ____.

a.

spreadsheet

c.

notebook

b.

work area

d.

workbook

 

 

____   11.   The intersection of a worksheet column and row is a ____.

a.

cell

c.

highlight

b.

range

d.

name box

 

 

____   12.   A group of cells that touch each other and form a rectangle is a ____.

a.

cell

c.

highlight

b.

range

d.

name box

 

 

____   13.   Which of the following will clear data from a higlighted cell?

a.

pressing the Delete key

c.

choosing Clear from the Edit menu

b.

pressing the Backspace key

d.

all of the above

 

 

____   14.   A(n) ____ is a cell that is ready for data entry.

a.

active cell

c.

name box

b.

cell reference

d.

bordered cell

 

 

____   15.   The ____ menu contains the Save As command.

a.

File

c.

View

b.

Edit

d.

Window

 

 

____   16.   When Excel starts, a blank worksheet titled ____ appears on the screen.

a.

Excel1

c.

Book1

b.

Worksheet1

d.

Spreadsheet1

 

 

____   17.   To move to the last cell containing data, you should press ____.

a.

Ctrl+Home

c.

Ctrl+Page Up

b.

Ctrl+End

d.

Ctrl+Down Arrow

 

 

____   18.   Press the ____ key to remove data from the selected cell.

a.

Ctrl

c.

Alt

b.

Shift+End

d.

Delete

 

 

____   19.   To edit data in a cell, select the cell and press the ____ key, referred to as the Edit key.

a.

F1

c.

F3

b.

F2

d.

F4

 

 

____   20.   The name box is located on the left side of the ____.

a.

formula bar

c.

Standard toolbar

b.

Formatting toolbar

d.

title bar


 

Welcome to CAOT 85 Excel

 

Top

 Last updated Thursday, March 22, 2007
Copyright © 2005 Amy Sirott  All rights reserved.

Visitor No. Hit Counter