😉
What is a prewritten formula that is built into Excel called?
Function
How many tabs does the Excel ribbon have?
9
Which View is the default view used in Excel?
Normal
Which tab can you find the Insert Function button in Excel?
Formula
What command will arrange Excel windows so that they appear side by side on the screen?
Arrange All
Where are the tabs located in excel?
Top of page
What is the process of bringing data from a text file or website into Excel called?
Importing Data
What feature of Excel keeps a portion of a worksheet visible while the other portion scrolls?
Freeze Panes
In Excel, which feature makes an exact replica of the cell data?
Copy
Kathryn needs the title in cell A1 to align horizontally across cells A1 through D1. Which alignment option should she select?
Merge and Center
What defines the color of the characters in an Excel worksheet?
Font color
Which tab contains the command to apply a theme to a worksheet in Microsoft Excel?
Page Layout
In an Excel worksheet, how do you change the width of a column so that the widest entry will fit?
Auto Fit
Which tab contains the command used to print a worksheet in Excel?
File
Which sheet would you use to enter,calculate, manipulate,and analyze data such as numbers and text in Excel?
Worksheet
What tab contains the commands used to create a chart in Excel?
Insert tab
What defines the appearance and shape of the letters in Excel?
Font
Jim would like to print only the cell range A1:F20. What page setup option should he change?
Print Area
Which command do you use to close an open file and completely exit the Excel program?
Exit or esc
David wants to key the numbers 1 to 1000 in Column A of his spreadsheet. What command should he use to complete the task?
AutoFill
Which of the following are valid Excel functions?
AVERAGE, MIN, MAX, SUM, COUNT etc
What is the shortcut to paste content in Excel?
ctrl + V
Lily would like to outline the cell range A1:F20. Which formatting style should she select?
Borders
Which tab can you find the command to apply a fill color to a cell or range of cells in a worksheet?
Home
Which tool is used to organize the data in a particular order?
Sorting