NEW
Font size
WorksheetsExcel 2016 Introduction
Total questions: 35
Worksheet time: 37mins
The electronic spreadsheet you work in is contained in a file called a ______________ with the file extension .xlsx.
Binder
Folder
Cabinet
Workbook
This area tells you the name of the project and the name of the program you have open.
Status Bar
Formula Bar
Title Bar
Quick Access Toolbar
The horizontal and vertical lines on the spreadsheet that identify each cell on the spreadsheet are known as the _____.
Cell Blocks
Scroll Bars
Mapping LInes
Grid-lines
A selection of two or more cells is known as a ____.
Cluster
Range
Conglomorate
Big mess
Every Excel formula/equation must begin with _____.
an equal sign
please and thank you
cell reference
a prayer
Define Cell?
The dark bordered box in excel.
A box in Excel that has formulas.
The intersection of a column or row in a worksheet or table.
Fx Bar where you input data.
Define Formula Bar?
I don't know
I don't care
Don't miss this one!
An element in Excel that appears below the Ribbon and to the right of the Insert command that shows the contents of the active cell so that you edit the text, value, date, formula, or function.
What is a sheet in Excel?
A single document that typically contains labels, values, formulas, functions, and graphical representations of data.
A single spreadsheet that typically contains labels, values, formulas, functions, and graphical representations of data.
A single template that typically contains labels, values, formulas, functions, and graphical representations of data.
A single file that typically contains labels, values, formulas, functions, and graphical representations of data.
When you open Excel you are viewing Excel in the ____ View?
Backstage
Frontstage
Spreadsheet
Template
A function in Excel is represented by what letters?
f( )
xF
xf
fx
Where is the zoom function located in Excel?
Bottom right of spreadsheet document
Bottom left of spreadsheet document
Top right of spreadsheet document
Top left of spreadsheet document
Microsoft Excel is what kind of software?
Word Processing Software
Spreadsheet Software
Database Software
Presentation Software
The set of data that runs left to right in a spreadsheet
column
row
cell
active cell
The set of data that runs up and down in a spreadsheet
column
row
cell
active cell
Which of the following suggestions would help Luisa?
___________ lets you access common commands no matter which tab is selected. You can customize the commands depending on your preference.
Cell
Row
Quick Access Toolbar
Worksheet View Options
___________ works like a search bar to help you quickly find tools or commands you want to use.
Cell
Row
Ribbon
Tell Me
___________ is where you can edit data, a formula, or a function that will appear in a specific cell.
Formula Bar
Microsoft Account
Cell
Row
___________ provides three ways to view a worksheet. Simply click a command to select the desired view.
Formula Bar
Scroll Bars
Worksheet View Options
Zoom Control
___________ is a click and drag slider to magnify your Excel screen. The number to the right of the slider reflects the zoom percentage.
Formula Bar
Scroll Bars
Worksheet View Options
Zoom Control
What is 1 on the attached image?
Row
Quick Access Toolbar
Tell Me
Ribbon
What is 3 on the attached image?
Row
Microsoft Account
Tell Me
Formula Bar
What is 5 on the attached image?
Row
Name Box
Tell Me
Formula Bar
What is 6 on the attached image?
Row
Name Box
Tell Me
Formula Bar
What is 7 on the attached image?
Row
Name Box
Column
Cell
What is 8 on the attached image?
Row
Name Box
Column
Cell
What is 10 on the attached image?
Zoom Control
Worksheet View Options
Scroll Bars
Worksheets
What is 11 on the attached image?
Zoom Control
Worksheet View Options
Scroll Bars
Worksheets
What is 12 on the attached image?
Zoom Control
Worksheet View Options
Scroll Bars
Worksheets
What is 13 on the attached image?
Zoom Control
Worksheet View Options
Scroll Bars
Worksheets
The name of the cell is determined by the name of the row and the column intersecting, such as A8.
Formula
Formula Bar
Cell Address
Cell Grid
Tabs you see at the bottom of your workbook file, labeled Sheet 1, Sheet 2, and so on. You can rename the tabs. They represent worksheets within the workbook.
Function
Sheet Tabs
Workbook
Drag
Name the cell range.
A1-D10
A1:D10
A1thruD10
A1&D10
Which command is used to insert a cut or copied selection to a cell or range of cells?
Paste
Document Properties
Copy
Range
