Font size
WorksheetsMicrosoft Excel
Total questions: 42
Worksheet time: 24mins
Microsoft Excel is what kind of software?
Word Processing Software
Spreadsheet Software
Database Software
Presentation Software
The letters in Excel represent the...
Rows
Columns
Cells
Data
The numbers in Excel represent the...
Rows
Columns
Cells
Data
An Excel file format extension is
doc
xlsx
txt
mp3
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
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.
Row Bars
Column Bars
Scroll Bars
Home Bars
Using the keyboard, you could navigate from one cell to another cell by using the ____ ____.
Enter Keys
Arrow Keys
Piano Keys
Tab Key
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
What icon do you choose to align the text at the top, middle, or bottom of a cell?
What is this icon?
Zoom
Sort and Filter
Symbol
Merge and Center
The cell address of the highlighted cell is
C
4
A4
C4
These are known as
workbooks
worksheets
formula bar
cell
What does the indicated icon do in the red box?
Apply underline
Apply italic
Make text bigger
Apply bold
What does the indicated icon in the red box do?
Change number of active cells
Change font colour
Change font size
Change the number of calculations
Division symbol in spreadsheet.
/
+
=
Multiplication symbol in Microsoft Excel
&
*
^
When you are typing data that is in a series, such as days of the week, you can use this tool to complete the series.
A) AutoSum
B) Custom Fill
C)Fill Handle
D)Ctrl+C
Which of the following is not a term of MS-Excel?
A. Cells
B. Rows
C. Columns
D. Document
The basic unit of a worksheet into which you enter data in Excel is called a
A.cell
B.table
C.box
D.column
The advantage of using a spreadsheet is:
A. calculations can be done automatically.
B. changing data automatically updates calculations
C. more flexibility
D. All of the above
There are three types of data found in a spreadsheet.
A. data, words, numbers
B. equations, data, numbers
C. words, numbers, labels
D. numbers formulas, labels
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
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
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
The ____ performs the arithmetic calculations in a formula.
Calculator
Grid-lines
Status Bar
Operator
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
A combination of numbers and symbols used to express a calculation.
Active Cell
Label
Formula Bar
Formula
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
An Excel file/Google sheet that contains individual worksheets. Also called a spreadsheet file.
Workbook
Drag
File
Headings
A “page” within an Excel workbook that contains columns, rows, and cells.
Workbook
Worksheet
Label
Cell
It is known as the spreadsheet application.
MS Word
MS Excel
MS PowerPoint
MS Publisher
