Spreadsheets - C268 Exam|83 Questions
and Answers|100% Accurate
IN Columns - -AA, BB, CA
- In Rows - -5, 6, 7
- In clip art - -Images
- What is a possible outcome using Boolean logic - -Only the numbers 0 and
1
- What is possible in freeze panes - -Freezing the row above where a person
is working
- Auto sum - -Count, Number, Max
- Logical - -And, Not, OR
- Financial - -Duration, Coupdays, Effect
- Date and Time - -Weeknum, Weekday
- What is true about correlation coefficients when using the Correl function
in Excel? - -They must be a whole number
- Which two options are possible under "Review" on the Excel riboon? - -
Protect sheet and Track Changes
- An administrator wishes to display the number $3.10 in cell A4. How can
this goal be met? - -Select cell A4, select the currency category, then enter
the number 3.1
- A student noted a correlation between hours of studying and test grades.
The student decides to track this correlation coefficient in Excel. How should
this be set up? - -By setting up hours in array A and grades in arrow B, then
using the CORREL function
- A student wants to have text appear in Excel as it would in a business
document, with all of the text starting on the left-hand side. Which group on
the homepage should be used to accomplish this goal? - -Alignment
- A manager has a spreadsheet table with company name, stock prices, and
sales dollars. What should the manager do to sort this table by name and
, then by sales dollars, from largest to smallest? - -Clink anywhere in the table,
click the sort icon, click the name in the sort by dropbox, then click "then by"
and choose "sales dollars largest to smallest"
- The following data is in an Excel Spreadsheet: Company A-Manufacturing-
$22,000,000; Company B - Industrial - $12,000,000; Company C -
Manufacturing - $14,000,000. Which steps will display only the information
for the manufacturing industry? - -Click anywhere in the table, click the filter
button, click the down arrow next to "Industry", and then select
"Manufacturing"
- A doctor wants to know how many patients she has seen this month and
their diagnoses. The doctor's assistant puts together a report showing each
patient's name in column A and diagnosis in column B. Which steps should
the assistant take to obtain a list of patients who have been diagnosed with
strep throat? - -Click in the report, click the filter icon, click the down arrow
for the diagnosis column,
- Cell B3 contains a formula that multiply cells B1 and B2. Which formula is
in cell B3? - -=B1*B2
- The accountant for a company wants to create a spreadsheet to calculate
sales markup. The costs of these items are located in cells C4 through C30,
and the markup percent is located in cell A1. The formula for the markup will
be in the range D4 through D30. What does the formula in cell D4 have to be
in order to copy it into cells D5 through D30? - -=C4+$A1
- (A1) Name (B1) Sales $ (C1) Commission $ (A2) Rep 1 (B2) $12,500 (C2)
(A3) Rep 2 (B3) $15,000 (C3) (A4) Rep 3 (B4) $17,000 (C4) The commission
percent of 2% is located in cell A5. What should the fomula be in cell C2 in
order to calculate commission dollars and enable copying to cells C3 and C4?
- -=A5+$B2
- A local golf course held a charity tournament that was open to all ages.
The following information was gathered about the golfers and presented in a
table: name, age, handicap, and score. Using the score column, which
function will yield the number of scores returned? - -COUNT
- A table included information about 1,000 adults who will be attending a
sporting event. One column indicated the number of children who will be
attending with each adult. If no children will be attending, the column
contains an "N" for none. Which function returns the total number of children
for all adults attending the event? - -SUM
and Answers|100% Accurate
IN Columns - -AA, BB, CA
- In Rows - -5, 6, 7
- In clip art - -Images
- What is a possible outcome using Boolean logic - -Only the numbers 0 and
1
- What is possible in freeze panes - -Freezing the row above where a person
is working
- Auto sum - -Count, Number, Max
- Logical - -And, Not, OR
- Financial - -Duration, Coupdays, Effect
- Date and Time - -Weeknum, Weekday
- What is true about correlation coefficients when using the Correl function
in Excel? - -They must be a whole number
- Which two options are possible under "Review" on the Excel riboon? - -
Protect sheet and Track Changes
- An administrator wishes to display the number $3.10 in cell A4. How can
this goal be met? - -Select cell A4, select the currency category, then enter
the number 3.1
- A student noted a correlation between hours of studying and test grades.
The student decides to track this correlation coefficient in Excel. How should
this be set up? - -By setting up hours in array A and grades in arrow B, then
using the CORREL function
- A student wants to have text appear in Excel as it would in a business
document, with all of the text starting on the left-hand side. Which group on
the homepage should be used to accomplish this goal? - -Alignment
- A manager has a spreadsheet table with company name, stock prices, and
sales dollars. What should the manager do to sort this table by name and
, then by sales dollars, from largest to smallest? - -Clink anywhere in the table,
click the sort icon, click the name in the sort by dropbox, then click "then by"
and choose "sales dollars largest to smallest"
- The following data is in an Excel Spreadsheet: Company A-Manufacturing-
$22,000,000; Company B - Industrial - $12,000,000; Company C -
Manufacturing - $14,000,000. Which steps will display only the information
for the manufacturing industry? - -Click anywhere in the table, click the filter
button, click the down arrow next to "Industry", and then select
"Manufacturing"
- A doctor wants to know how many patients she has seen this month and
their diagnoses. The doctor's assistant puts together a report showing each
patient's name in column A and diagnosis in column B. Which steps should
the assistant take to obtain a list of patients who have been diagnosed with
strep throat? - -Click in the report, click the filter icon, click the down arrow
for the diagnosis column,
- Cell B3 contains a formula that multiply cells B1 and B2. Which formula is
in cell B3? - -=B1*B2
- The accountant for a company wants to create a spreadsheet to calculate
sales markup. The costs of these items are located in cells C4 through C30,
and the markup percent is located in cell A1. The formula for the markup will
be in the range D4 through D30. What does the formula in cell D4 have to be
in order to copy it into cells D5 through D30? - -=C4+$A1
- (A1) Name (B1) Sales $ (C1) Commission $ (A2) Rep 1 (B2) $12,500 (C2)
(A3) Rep 2 (B3) $15,000 (C3) (A4) Rep 3 (B4) $17,000 (C4) The commission
percent of 2% is located in cell A5. What should the fomula be in cell C2 in
order to calculate commission dollars and enable copying to cells C3 and C4?
- -=A5+$B2
- A local golf course held a charity tournament that was open to all ages.
The following information was gathered about the golfers and presented in a
table: name, age, handicap, and score. Using the score column, which
function will yield the number of scores returned? - -COUNT
- A table included information about 1,000 adults who will be attending a
sporting event. One column indicated the number of children who will be
attending with each adult. If no children will be attending, the column
contains an "N" for none. Which function returns the total number of children
for all adults attending the event? - -SUM
