click below
click below
Normal Size Small Size show me how
7CS Spreadsheet Test
7th Grade Spreadsheet Test
Question | Answer |
---|---|
A mathematical operation that is built into a spreadsheet program to perform shortcut calculations is called what? | Function |
When keying a formula in a spreadsheet, what must you key to inform the program that you are entering a formula instead of entering text? | Equal sign |
What procedure would be used if you had five different columns of data and wanted to add each column without re-keying the formula each time? | Copy |
What application software would allow users to determine the average of a student's work? | Spreadsheet |
What could your school secretary use a spreadsheet to do? | Keep a record of student fees |
What computer program is made up of rows and columns that form cells? | Spreadsheet |
An advantage of a spreadsheet is the speed of accomplishing what? | Calculating numbers |
The intersection of a column and row in a spreadsheet is called what? | Cell |
Numerical data entered into a spreadsheet is called what? | Value |
What is a statement that performs a calculation in a spreadsheet? | Formula |
The cell in which you are currently working is known as what? | Active Cell |
What is the vertical position of a spreadsheet that is identified by a letter? | Column |
What is the horizontal portion of a spreadsheet that is identified by a number? | Row |
Which toolbar has icons that are used frequently for formatting the appearance of a spreadsheet? | Formatting |
In a spreadsheet formula, the asterisk and diagonal stand for what mathematical symbols? | Multiplication and Division |
What should you do in order to save revisions that you have made to an existing spreadsheet? | Save the revised spreadsheet |
Which function would be used to add a range of cells in a spreadsheet? | SUM |
Which function would be used to indicate the largest value in a range of spreadsheet cells? | MAX |
Which function would be used to indicate the smallest value in a range of spreadsheet cells? | MIN |
What key do you press to see the results of a formula? | Enter |
To format font color in a spreadsheet cell what must be done first? | Highlighting the desired cell |
What specific format would change 29.99 to $29.99? | Currency |
Which chart generated from spreadsheet data would compare values that represents parts of a whole? | Pie |
What is alphabetical text entered into a spreadsheet? | Label |
The column letter and row number make up what? | Cell Address |