Microsoft Excel 1.02 Question Preview (ID: 45513)


Excel 2016. TEACHERS: click here for quick copy question ID numbers.

In a 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

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

Alicia needs to move the data in cell B5 to cell E5. Which command would she select?
a) Clear
b) Copy
c) Cut
d) Format Painter

Which term refers to a group of selected cells that may be formatted, moved, copied or deleted as a group?
a) Segment
b) Set
c) Range
d) Cluster

Which command on the Home ribbon allows data to be moved from one worksheet location to another?
a) Cut
b) Move
c) Copy
d) Duplicate

Joan is creating a table that will include demographic information about her employees. What is each header in her table considered?
a) Label
b) Value
c) Formula
d) Function

Jennifer needs to identify the values in column B for a statistics report. Which type of entry should she use in the column header?
a) Value
b) Formula
c) Label
d) Function

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

David wants to key the numbers 1 to 1,000 in Column A of his spreadsheet. What command should he use to complete this task?
a) AutoFill
b) Filter
c) Find and Replace
d) Sort

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

Alicia needs to delete the data in cell B5. Which command would she select?
a) Clear
b) Copy
c) Cut
d) Format Painter

What is the name of the list of frequently used Excel commands available when a user right-clicks an item in the worksheet?
a) Mini Toolbar
b) Quick Access Toolbar
c) Shortcut Menu
d) Shortcut Toolbar

Sharon’s spreadsheet contains information about the number of music downloads in F1:F25. F1:F25 represents a:
a) cell
b) column
c) range
d) row

Joan has a table that includes demographic information about her employees. If the demographic information is listed across the top and employee names down the left side of the table, what does all the information about one employee represent?
a) Entry
b) Workbook
c) Row
d) Column

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

When entering data into a cell, which keyboard key is used to remove characters to the left of the insertion point?
a) Delete key
b) Backspace key
c) Left arrow key
d) Enter key

Which would be used to help organize and identify Microsoft Excel files by providing details about the files?
a) File details
b) Document properties
c) File facts
d) Document options

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) Cut
d) Copy

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

Which command on the Fill options dialog box is the default option if a month or day is entered?
a) Copy Cells
b) Fill Formatting Only
c) Fill without Formatting
d) Fill Series

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: 45513 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In | Sign Up / Register

Help / Support / FAQ




Gaming Links