What is the process of bringing data containing text fields separated by commas into Excel called?
Importing Data
100
What type of formula cell reference instructs Microsoft Excel to keep the cell reference constant in the formula as it copies it to the destination area?
Absolute
100
Which View is the default view used in Microsoft Excel?
Normal
100
Where can you find the Insert Function button in Microsoft Excel?
Formula Bar
100
What command will arrange Microsoft Excel windows so that they appear side by side on the screen?
Arrange All
200
What ribbon contains the commands for creating charts in Microsoft Excel?
Insert
200
What is a prewritten formula that is built into Microsoft Excel called?
Function
200
In Microsoft Excel, what do you use to emphasize certain entries and make the worksheet easier to read and understand?
Formatting
200
In an Microsoft Excel worksheet, how do you change the width of a column so that the widest entry will fit?
Auto Fit
200
Which ribbon contains the command to apply a theme to a worksheet in Microsoft Excel?
Page Layout
300
What term refers to an Excel Chart with offset pieces?
Exploded
300
When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?
Relative Reference
300
Which dialogue box in Microsoft Excel do you use to set the rotation of text in a cell to a specific degree?
Format Cells
300
In Microsoft Excel, which feature makes an exact replica of the cell data and format while keeping the original cell intact?
Copy
300
Which command do you use to close an open file and completely exit the Microsoft Excel program?
Exit
400
What ribbon contains the commands used to create a chart in Excel?
Insert Ribbon
400
What feature of Microsoft Excel keeps a portion of a worksheet visible while the other portion scrolls?
Freeze Panes
400
What defines the color of the characters in an Microsoft Excel worksheet?
Font Color
400
What area contains the command used to print a worksheet in Microsoft Excel?
File Tab
400
What is the name of the list of frequently used commands available when a user right-clicks an item in the worksheet?
Shortcut Menu
500
Which of the following are valid Microsoft Excel functions?
AVERAGE, MIN, and MAX
500
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?
Zoom to Selection
500
Which defines the appearance and shape of the letters, numbers, and special characters in Microsoft Excel?
Font
500
To help organize and identify Microsoft Excel files by providing details about the files, which of the following would you use?
Document Properties
500
Which of the following software programs is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data?