NEW
Font size
WorksheetsExcel Test Questions Lesson 1-3
Total questions: 46
Worksheet time: 46mins
Joan wants to add a new entry at the bottom of her spreadsheet. What is the shortcut that will take her to the last record on her spreadsheet?
Ctrl + Home
Ctrl + End
Ctrl + Up Arrow
Ctrl + 1
Which software program is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data?
Microsoft Word
Microsoft Publisher
Microsoft Excel
Microsoft PowerPoint
Which command among the window control buttons is used to close an open file and completely exit the Microsoft Excel program?
Close
Save As
Exit
Quit
Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel?
Workbook
Worksheet
Notepad
Folder
Sharon’s spreadsheet contains information about the number of music downloads in F25. In this address, ‘25’ identifies the:
Cell
Column
Range
Row
What occurs when the cursor is moved over a cell and a user clicks?
The row is selected
The cell is selected
The column is selected
The worksheet is selected
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?
Entry
Workbook
Row
Column
What command will arrange Microsoft Excel windows so that they appear side-by-side on the screen?
Zoom to Selection
New Window
Arrange All
Freeze Panes
John wants to be able to view multiple areas of his spreadsheet at the same time. What would be his best option?
Freeze Panes
Split
Hide
Unhide
Joyce needs to access a spreadsheet she saved yesterday. Which command would she select?
Exit
Open
Save
Save As
Which group on the View Ribbon enables a user to show or hide the ruler, gridlines, Formula Bar, or headings?
Workbook views
Show
Zoom
Window
Which view is the default view used in Microsoft Excel?
Page Layout
Normal
Web
Which area on the left side of the formula bar indicates the cell address of a selected cell?
Cell box
Address box
Name box
Formula box
Which ribbon option opens a related dialog box?
Ellipse
Drop-Down Arrow
Launcher
Slider
Which Microsoft Office object would you use for quick, convenient, one-click access to frequently used Excel commands?
Quick Access Tool Bar
Title Bar
Status bar
Formula Bar
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?
Entry
Workbook
Row
Column
What feature was created for users who prefer to use the keyboard rather than the mouse, and provides keyboard code icons that may be used in conjunction with the ALT key?
Quick Access Tool Bar
Hot Keys
Mini Toolbar
Key Tips
Which notebook-like feature organizes the sheets for use in Excel?
Workbook
Worksheet
Notepad
Folder
Which tab is used to display the area that contains the print command?
Home
Page Layout
View
File
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?
Magnify Area
Enlarge Selected Area
Amplify Range
Zoom to Selection
Which view enables a user to create or modify a worksheet while seeing how it will look in printed format?
Page Layout
Normal
Web
In a Microsoft Excel worksheet, how do you change the width of a column so that the widest entry will fit?
Smart Fit
AutoFit
Best Fit
True Fit
Alicia needs to move the data in cell B5 to cell E5. Which command would she select?
Clear
Copy
Cut
Format Painter
Which Microsoft Excel feature automatically inserts data into a cell that begins with the same characters as a previous entry?
AutoComplete
AutoFill
Autocorrect
Autospell
Which would be used to help organize and identify Microsoft Excel files by providing details about the files?
File details
Document Properties
File facts
Document options
Which command on the Home ribbon allows data to be moved from one worksheet location to another?
Cut
Move
Copy
Duplicate
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?
Fill handle
Filler
Copy handle
Copy box
Joan is creating a table that will include demographic information about her employees. What is each header in her table considered?
Label
Value
Formula
Function
Which term refers to a group of selected cells that may be formatted, moved, copied or deleted as a group?
Segment
Set
Range
Cluster
Jennifer needs to identify the values in column B for a statistics report. Which type of entry should she use in the column header?
Standard(s)
Value
Formula
Label
Function
John wants to print only the Inventory worksheet that he is currently working on in his workbook. Which option should he choose?
Print Selection
Print Active Sheet
Print Entire Workbook
Fit to One Page
Sharon’s spreadsheet contains information about the number of music downloads in F1:F25. F1:F25 represents a:
cell
column
range
row
Alicia needs to delete the data in cell B5. Which command would she select?
Clear
Copy
Cut
Format Painter
In Microsoft Excel, which feature makes an exact replica of the cell data and format while keeping the original cell intact?
Paste
Move
Cut
Copy
Joyce has updated the data in an existing spreadsheet. Which command would she select to preserve the data for future use?
Exit
Open
Save
Save As
When entering data into a cell, which keyboard key is used to remove characters to the left of the insertion point?
Delete key
Backspace key
Left Arrow key
Enter key
What is the process of using the mouse to move or copy cells called?
Click and Paste
Drag and move
Draggings
Drag and Drop
What is the name of the list of frequently used Excel commands available when a user right-clicks an item in the worksheet?
Mini Toolbar
Quick Access Toolbar
Shortcut Menu
Shortcut Toolbar
Which command on the Fill options dialog box is the default option if a month or day is entered?
Copy Cells
Fill Formatting Only
Fill without Formatting
Fill Series
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?
AutoFill
Filter
Find and Replace
Sort
Jim would like to print only the cell range A1:F20. What page setup option should he change?
Orientation
Page Break
Print Area
Print Titles
Which is a special workbook a user can create and then use as a pattern to create new, similar workbooks or worksheets?
Standard(s)
Form
Boilerplate
Smart Sheet
Template
John's workbook includes 3 worksheets. Which option should he choose to print them?
Print Selection
Print Active Sheet
Print Entire Workbook
Fit to One Page
Steve would like to print only the worksheet he is currently working on. What print option should he choose?
Print Area
Active Sheets
Entire Workbook
Quick Print
What area contains the command used to customize the print options in Microsoft Excel?
Home Ribbon
Page Layout Ribbon
File Tab
Quick Access Toolbar
Which command enables a user to save an existing worksheet with a new name or save the worksheet in a new location?
Close
Save
Save As
Exit
