Font size
WorksheetsSpreadsheet for a purpose
Total questions: 97
Worksheet time: 59mins
Excel is a (a) program that allows you to store, organize, and analyze information.
The (a) is where you'll find the commands you need to perform common tasks in Excel.
The Ribbon contains multiple (a) , each with a group of commands.
Excel files are called (a) .
Each workbook holds one or more (a) .
To save time, you can create your document from a __________.
file
image
book
template
On which tab would you find the command to create a new workbook?
File
Home
Insert
View
You can format text in Excel by making it bold, italic, etc.
True
False
Worksheets are made up of rows and columns.
True
False
__________ run from left to right and are identified by numbers.
Rows
Columns
Worksheets
Files
Pre-designed and formatted files called ______ help to create new worksheets quickly.
Documents
Templates
Folders
Cell Reference
The electronic spreadsheet made of cells and organized by rows and columns is known as the _____.
Document
Presentaion
Publicaiton
Worksheet
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
Letters of the alphabet going across the top of the spreadsheet.
Title Bar
Column Labels
Row Labels
Status Bar
Numbers down the left side of the spreadsheet.
Status Bar
Formula Bar
Column Labels
Row Labels
The intersection of a column and a row is called a __________.
Four-way Stop
Formula Bar
Cell
Template
A cell that has a dark border around it.
Jail Cell
Sleepy Cell
Active Cell
Stem Cell
The ________ contains a grid of columns and rows, the formula bar and the ribbon.
Worksheet Window
Document Window
Presentation Window
Publication Window
Every cell has its own unique address or _____ _____, which is identified by the specific coordinates of the intersecting column and row.
PO Box
Cell Reference
Status Bar
Formula Bar
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
These items allow you to move up & down or left & right in a worksheet that is to large to fit on the screen at once.
Scroll Bars
Pry Bar
Scroll Box
Salad Bar
The area is located at the bottom of the Excel window and provides information and options for your worksheet project.
Scroll Bars
Status Bar
Salad Bar
Formula Bar
A selection of two or more cells is known as a ____.
Cluster
Range
Conglomorate
Big mess
A ____ is another name for an equation used in Excel.
Formula
Calculation
Mode Indicator
Template
Every Excel formula/equation must begin with _____.
an equal sign
please and thank you
cell reference
a prayer
The ____ performs the arithmetic calculations in a formula.
Calculator
Grid-lines
Status Bar
Operator
Using the keyboard, you could navigate from one cell to another cell by using the ____ ____.
Enter Keys
Arrow Keys
Piano Keys
Tab Key
Numerical data entered into the spreadsheet cells will appear _____ according to place-value.
Magically
Right Aligned
Left Aligned
Centered
Any data (text or numerical) entered into a cell will appear in the active cell as well as in the ____ ____.
Status Bar
Scroll Bar
Outside Window
Formula Bar
The small dot in the lower-right corner of an active cell. It allows you to copy or duplicate information to other cells.
Scroll Box
Fill Handle
Cell Reference
Ribbon Tab
Entries that identify data in a worksheet and not used in a formula are known as ____. (They are usually aligned-left.)
Tags
Labels
Values
Insignificant
Entries in a spreadsheet used in formulas and functions are known as ____. (They are usually aligned-right.)
Values
Numerical Data
Tags
Labels
The contents of a worksheet will print across the length of the page in ____ ____.
Landscape Orientaion
Portrait Orientation
7th grade Orientation
Total Disorientation
The contents of a worksheet will print across the width of the page in ____ ____.
Landscape Orientaion
Portrait Orientation
7th grade Orientation
Total Disorientation
Which of the following will pull out the lowest number?
SUM
MAX
AVERAGE
MIN
What part of a spreadsheet is vertical?
Formula Bar
Row
Column
Cell
Which part of a spreadsheet is horizontal?
formulas bar
column
row
cell
Which of the following is a function?
John Jones
$5.00
=sum(A1:A5)
=A1+A5
When following the Order of Operations, which of the following would be performed FIRST?
Multiplication
Exponentials
Parenthesis
Division
Values are aligned on which side of a cell?
Left
Right
Which of the following will produce a number that is calculated by adding quantities together and then dividing the total by the number of quantities?
SUM
AVERAGE
MAX
MIN
Labels align on which side of a cell?
Right
Left
Which of the following is a correct cell address?
1
A1
1A
A
What part of cell is represented by letters?
row
forumula bar
columns
cell
Which of the following is used to get the highest number?
AVERAGE
SUM
MAX
MIN
Another name for a spreadsheet file is:
Workbook
Spreadbook
Excel
Worksheet
Where do you look to see what is typed within a cell?
Formula Box
Name box
Name bar
Formula bar
A spreadsheet is what type of software?
Application
Operating
It isn't software
System
Which symbol is used for division?
Asterisk
Forward slash
Back slash
Space bar
A cell that has a dark border around it and is the cell you are currently working in is called:
Row
Label
Column
Active Cell
Which of the following is an example of a label?
John Jones
=A1+A5
$5.00
=sum(A1:A5)
Which of the following symbols is used for multiplication?
Back slash
Plus
Asterisk
Forward slash
Which of the following does a spreadsheet NOT do for a user?
calculate a loan payment schedule
balance a checkbook
write a business letter
create household budget
What symbols MUST be typed first to tell a cell it is going to calculate?
Equals
Asterisk
Dollar
Percentage
The name of the program that we use for spreadsheets in our lab this year is:
Publisher
Access
Excel
Word
Which of the following will give you a total?
MIN
MAX
AVERAGE
SUM
Refers to a group or block of adjacent cells next to each other:
cell group
function
range
formula
Which of the following is a value?
$5.00
=A1+A5
=SUM(A1:A5)
John Jones
Which of the following is a formula?
John Jones
$5.00
=SUM(A1:A5)
=A1+A5
The cell address of the highlighted cell is
C
A4
C4
A pie graph is a visual representation of what?
Values change over time.
comparison of a piece of data to the whole group
a categorical data with rectangular bars with heights or lengths proportional to the values that they represent.
You accidentally erased a record in the sheet. What command can be used to restore it immediately?
A. Insert
B. Copy
C. Undo
D. Replace
What is this icon?
Zoom
Sort and Filter
Symbol
Merge and Center
By default the text data is________ aligned in cell.
Left
Center
Right
Bottom
By default the number data is __________ aligned in cell.
Right
Center
Top
Left
Excel allows you to work with?
Sentences
Paragraphs
data
What type of chart will you use to compare performance of sales of two products ?
Column/ Bar Chart
Line Chart
Pie Chart
It is where you will find the basic commands such as open, save, print, etc
Quick Access Toolbar
Ribbon
File Menu
Tell me
It is designed to help you quickly find the commands that you need to complete a task
Quick Access Toolbar
Ribbon
File Menu
Tell me
To select an entire column in a worksheet, you should press ________.
CTRL+SPACEBAR
SHIFT+SPACEBAR
CTRL+SHIFT+SPACEBAR
SPACEBAR
These are not to be used in calculations which includes numerical information, such as phone numbers and zip codes
Values
Labels
Cell Address
Relative Referencing
These are numerical pieces of information that will be used for calculations.
Labels
Cell Address
Values
Cell Address
A formula starts with an equal sign (=)
True
False
Maybe
Insufficient information
It returns the number of values of the selected cells
SUM
MAX
MIN
COUNT
If you to select non-consecutive cells, then
Press and hold CTRL while clicking column or row headers
Click and drag across column or row headers
Click the first cell in the range. Drag across the cells and release the mouse button
Press and hold CTRL while clicking the celss
If you to select multiple columns, then
Press and hold CTRL while clicking column or row headers
Click and drag across column or row headers
Click the first cell in the range. Drag across the cells and release the mouse button
Press and hold CTRL while clicking the celss
You use this category when you want to enter a text description containing numbers or special characters
Number
General
Text
Accounting
A new Excel file contains _______ worksheets.
1
2
3
4
A collection of worksheets is called a
workbook
file
spreadsheet
column
Which is horizontal (left and right)?
Columns
Rows
Data
Cells
Which is vertical (up and down)?
Cells
Rows
Data
Columns
What do you call the single rectangle that you enter data into?
a box
a cell
a formula bar
a column
What is the top menu in Microsoft Excel called?
The Ribbon
The Arrow
The Menu
The Tab
The file extension of a Microsoft Excel file is
.docx
.pptx
.xlmx
.xlsx
What can be used to add color to a cell?
Cell Borders
Cell Fill
Cell AlignmentT
Text Color
Microsoft Excel was made by Google.
True
False
What company created Excel?
Sony
Microsoft
Apple
Is it possible to create pixel art with a spreadsheet?
True
False
What software could you use to create a spreadsheet?
PowerPoint
Publisher
Word
Excel
What are the boxes on a spreadsheet called?
Squares
Cells
Boxes
Rows
How do you add color to a spreadsheet?
Insert a Picture
Change Column Width
Add a New Tab
Click on the Fill Color button
What program would you use to make a spreadsheet?
PowerPoint
Excel
Publisher
Word
What is a spreadsheet?
An electronic document with rows and columns
A publication
A slideshow
A word processor
What color is the Excel icon?
Blue
Red
Green
Yellow
