Excel 1.01-1.02 (Part 1) Question Preview (ID: 40663)


Standards 1.01-1.02. TEACHERS: click here for quick copy question ID numbers.

Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel?
a) Worksheet
b) Workbook
c) Notepad
d) Folder

Jennifer needs to identify the values in column B for a sales report. Which type of entry should she use in the column header?
a) values
b) formulas
c) functions
d) labels

Which of the following software programs is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data?
a) Word
b) Excel
c) Publisher
d) PowerPoint

What command will arrange Microsoft Excel windows so that they appear side by side on the screen?
a) Zoom to Selection
b) New Window
c) Arrange All
d) Freeze Panes

Joyce has updated the data in an existing spreadsheet. Which command would she select to preserve the data for future use?
a) Exit
b) Open
c) Save
d) Save As

What is the process of using the mouse to move or copy cells called?
a) Click and paste
b) Drag and move
c) Dragging
d) Drag and drop

Joan has a table that includes demographic information about her employees. What does all the information about one employee represent?
a) Entry
b) Workbook
c) Row
d) Column

What command do you use to increase or decrease the view of a selected cell or range of cells to fill the Excel Window area for better visibility?
a) Magnify Area
b) Enlarge Selected Area
c) Amplify Range
d) Zoom to Selection

Which of the following notebook- like features organizes the sheets for use in Excel?
a) Workbook
b) Worksheet
c) Notepad
d) Folder

Joan has entered her name in the First Name field in cell B2 of her table. What does her First Name represent in the table?
a) Entry
b) Workbook
c) Row
d) Column

Sharon's spreadsheet contains information about the number of music downloads in F1:F25. F1:F25 represents a:
a) Cell
b) Range
c) Column
d) Row

Sharon's spreadsheet contains information about the number of music downloads in F25. 25 identifies the:
a) Cell
b) Column
c) Range
d) Row

Joyce needs to access a spreadsheet she saved yesterday. Which command would she select?
a) Exit
b) Open
c) Save
d) Save As

Which Microsoft Excel feature automatically inserts data into a cell that begins with the same characters as a previous entry?
a) AutoComplete
b) AutoFill
c) AutoCorrect
d) AutoSpell

What occurs when the cursor is moved over a cell and a user clicks?
a) The row is selected
b) The column is selected
c) The worksheet is selected
d) The cell is selected

John wants to print only the Inventory worksheet that he is currently working on in his workbook. Which option should he choose?
a) Print Selection
b) Print Active Sheet
c) Print Entire Workbook
d) Fit to One Page

In Microsoft Excel, which feature makes an exact replica of the cell data and format while keeping the original cell intact?
a) Paste
b) Move
c) Cute
d) Copy

In an Microsoft Excel worksheet, how do you change the width of a column so that the widest entry will fit?
a) Smart Fit
b) AutoFit
c) Best Fit
d) True Fit

Which area, on the left side of the formula bar, can you look at to determine the cell address of a selected cell?
a) Name box
b) Cell box
c) Address box
d) Formula box

What is the name of the small black square in the lower-right corner of the heavy border of an active cell that repeats a cell's value in adjacent cells?
a) Fill handle
b) Filler
c) Copy handle
d) Copy box

Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 40663 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In
| Sign Up / Register