Quia Home Home FAQ About Log in Subscribe now 30-day free trial
Java Games: Matching, concentration, word search, and flashcards.

BCT 7.04


AB
When keying in spreadsheet, the MOST appropriate time to establish a file name and save the spreadsheet for the first time is:When you create a new spreadsheet.
In a spreadsheet, format means:How values are displayed in your spreadsheet.
To format a range of cells in a spreadsheet to the nearest cent, using currency, set the number of decimal places to:Two
Which of the following functions would be used to add the contents of a range of cells in a spreadsheet?SUM
To add a series of numbers in most spreadsheets, use which function?SUM
To print dollar signs on a spreadsheet, values should be formatted as:Currency
To adjust spreadsheet columns to display the largest entry, change the:Column width
The default alighment for values on a spreadsheet is:Right justified.
The default alignment for labels on a spreadsheet is:Left justified.
The spreadsheet format allows column width to be:Changed.
The format for values in a grade report is:Percentages.
The mathematical operator that represents multiplication:*
The mathematical operator that represents division:/
The mathematical operator that represents addition:+
The mathematical operator that represents subtraction:-
An example of a math function used in a spreadsheet:SUM, AVG
To find the average, most spreadsheet software uses this function:AVG
To format $150,000.00 use the:Currency format
To average a series of values, the function you would use would be:AVG
In the spreadsheet formula +A5+B5*B6/5-3 which math operation will calculate first?Multiplication
In the spreadsheet formula C7*(A9-A1) which math oeration will calculate first?Subtraction
In the spreadsheet formula, D12/C8+E7-E8 which math operation will calculate first?Division
What do you need to enter in a cell just before you enter a formula to show it is not a label?Symbol