Font size
WorksheetsSpreadsheet Knowledge
Total questions: 31
Worksheet time: 16mins
If you click this button you would do what function?
(a)
In Excel, this is called a
(a)
This shows the _________ header
column
row
cell
function
This shows the _________ header
column
row
cell
function
This feature in Excel is to ________ the text.
center
underline
bold
change
Active cell is
the cell in your workspace that is selected
a feature that allows you to apply the contents to another cell or selected cells
the cell in where your data is kept
the rectangular shaped area on a worksheet that is created by the intersection of columns and rows
AutoSum
the cell in your workspace that is selected
a feature that allows you to apply the contents to another cell or selected cells
a function that automatically identifies and adds ranges of cells in your worksheet
the rectangular shaped area on a worksheet that is created by the intersection of columns and rows
A cell is
the cell in your workspace that is selected
a feature that allows you to apply the contents to another cell or selected cells
a function that automatically identifies and adds ranges of cells in your worksheet
the rectangular shaped area on a worksheet that is created by the intersection of columns and rows
Autofill is
the cell in your workspace that is selected
a feature that allows you to apply the contents to another cell or selected cells
a function that automatically identifies and adds ranges of cells in your worksheet
the rectangular shaped area on a worksheet that is created by the intersection of columns and rows
The cell address is
The rectangular shaped area on a worksheet that is created by the intersection of columns and rows.
The name of the cell is determined by the name of the row and the column intersecting, such as A8.
The lines in your worksheet that separate the columns and rows.
In a worksheet, the vertical spaces with letter headings.
The cell grid is
The rectangular shaped area on a worksheet that is created by the intersection of columns and rows.
The name of the cell is determined by the name of the row and the column intersecting, such as A8.
The lines in your worksheet that separate the columns and rows.
In a worksheet, the vertical spaces with letter headings.
A combination of numbers and symbols used to express a calculation. Always begins with a = sign.
(a)
Fill down is
When you move information while holding down the mouse button (usually the left) to select a range of cells.
A document that is stored on your computer. In Excel, a file is also known as a workbook.
A feature that allows you to copy information in an active cell to another cell or range of cells you have selected vertically.
A combination of numbers and symbols used to express a calculation. Always begins with a = sign.
A file is
When you move information while holding down the mouse button (usually the left) to select a range of cells.
A document that is stored on your computer. In Excel, a file is also known as a workbook.
A feature that allows you to copy information in an active cell to another cell or range of cells you have selected vertically.
A combination of numbers and symbols used to express a calculation. Always begins with a = sign.
To drag in Excel means
When you move information while holding down the mouse button (usually the left) to select a range of cells.
A document that is stored on your computer. In Excel, a file is also known as a workbook.
A feature that allows you to copy information in an active cell to another cell or range of cells you have selected vertically.
A combination of numbers and symbols used to express a calculation. Always begins with a = sign.
Headings in Excel are
A command line above the worksheet where text, numbers, and formulas are entered into a worksheet.
A drop-down menu item and a button on the standard toolbar that allows you to select a formula that you wish to apply to data in your worksheet.
The identifying letters and numbers for columns and rows. Columns are identified with letters and rows with numbers.
The name that reflects the information contained in a column or row, such as a name or date. Labels are usually letters!
Cell locations in Excel are
A command line above the worksheet where text, numbers, and formulas are entered into a worksheet.
A drop-down menu item and a button on the standard toolbar that allows you to select a formula that you wish to apply to data in your worksheet.
The identifying letters and numbers for columns and rows. Columns are identified with letters and rows with numbers.
The name that reflects the information contained in a column or row, such as a name or date. Labels are usually letters!
Labels in Excel are
A command line above the worksheet where text, numbers, and formulas are entered into a worksheet.
A drop-down menu item and a button on the standard toolbar that allows you to select a formula that you wish to apply to data in your worksheet.
The identifying letters and numbers for columns and rows. Columns are identified with letters and rows with numbers.
The name that reflects the information contained in a column or row, such as a name or date. Labels are usually letters!
The formula bar is
A command line above the worksheet where text, numbers, and formulas are entered into a worksheet.
A drop-down menu item and a button on the standard toolbar that allows you to select a formula that you wish to apply to data in your worksheet.
The identifying letters and numbers for columns and rows. Columns are identified with letters and rows with numbers.
The name that reflects the information contained in a column or row, such as a name or date. Labels are usually letters!
A page within an Excel workbook that contains columns, rows, and cells.
workbook
worksheet
sheet tabs
page layout
c. cell address.
d. grid lines
When we write formulas, which sign do we start with?
Subtraction sign
Equal Sign
Addition sign
Division sign
Which of the following operators (symbols) represent addition in EXCEL spreadsheets?
+
-
*
/
Which of the following symbols represent multiplication in a spreadsheets?
+
-
*
/
Which way does portrait go?
Vertically
Horizontally
Diagonally
90° Angle
Which way does landscape go?
Vertically
Horizontally
Diagonally
90° Angle
What is Portrait and Landscape called in general?
Alignment
Page Orientation
Formatting
Which term refers to the arrangement of text on a page or within a document?
Formatting
Alignment
Font style
Page layout
