CPSC 110 01
In this quarter, which month had the highest total cardio sales? -June
By looking only at the sparklines, which type of equipment had an overall downward trend in sales? -elliptical machines
Which Category includes the most types of trees? -Oak
Data bars provide a quick way to distinguish the relationships among values. Which type of tree do the data bars indicate as being highest in stock? -Bradford
According to the IFS function, how many salespeople earned a bonus? -Three
During the week of May 24, which type of rose had the highest number of In-Store total sales? -Patio Roses
Why is it important to use cell references in a formula instead of the data within the cells? -To keep the worksheet accurate because when the data changes, the formula is updated.
During the week of May 24, which type of rose had the highest number of Online total sales? -Tea Roses
For Kodiak West Travel to attract clients, what is the advantage to using Reading View during online meetings? = The presenter can switch to another window without closing the slide show
How can color enhance the text in your presentation? = Provide emphasis and visual cues to the reader
What view enables you to view and edit the text in a presentation rather than thumbnails? = outline view
How does sharing slides help the Kodiak marketing team? = it ensures accuracy across presentations
What table option is used with the filtering command to provide additional data analysis? -Total row
In this project, how is conditional formatting used to address inventory concerns? -The text color and font style indicate which items need to be ordered.
By titling a worksheet Second Quarter Cardio Sales, what information would the reader of the worksheet expect to see? -sales information during the period April through June
What is the most efficient way to enter large amounts of numerical data into an Excel worksheet? -NOT Format the cells before entering the data
What is the most appropriate paper format to give to your audience to facilitate note-taking during your presentation? = NOT notes pages
What is the purpose of a title slide? = It introduces the presentation topic
What is the purpose of a Summary sheet? -To display totals from other worksheets.
What is the purpose of inserting a Section Header in the presentation?= to change the look and flow of the presentation
Why might you change the slide size to 4:3 rather than Widescreen? = to fit an older monitor screen
What is the purpose of using numbered lists in this presentation? = To provide step-by-step procedures for injury prevention
In this project, how is conditional formatting used to address inventory concerns? -NOT The cell style indicates which items need to be ordered.
What table option is used with the filtering command to provide additional data analysis? -NOT Banded Rows
How does live preview help you plan a presentation? = NOT it helps you practice the timing of a live presentation
What type of individuals were the intended audience for the presentation? = Travelers
In how many warehouse locations does Pro Fit Marietta store plyometric products? -NOT one
When calculating percentages, why is it valuable to increase the number of decimal places when analyzing important financial information? -the data is more precise
Why are sparklines valuable when analyzing workbook data? -Sparklines make a pattern more obvious to the eye
When presenting financial information in a worksheet, why is it important to apply a double border to a total in a column? -NOT To convey to the reader that the calculations were performed on the numbers above
What do you think the Director of Operations at Sensation Park Entertainment Group had in mind as the goal of creating this presentation? = To train employees on park safety rules
When should you use a bulleted list? = When the items in the list have no order of priority
The company president, Michelle Barry, requested a column chart showing monthly sales of cardio equipment by category. What valuable business information does this chart convey to Michelle that can be used in decision making? -A pattern of overall monthly sales
Which month had the highest sales of elliptical machines? -April
The data in this worksheet is valid as of what date? -September 30
Which of the following best describes the data in this worksheet? -NOT Quarterly sales report
As of September 30, which product had the highest inventory valuation in terms of Total Retail Value? -Stackable steps
Which of the following calculations would require the use of an absolute cell reference? -Calculating the percentage by which the total retail value of pro jump ropes makes up the total for all products
What type of function is the COUNTIF function? -NOT Logical
Which sales person is closest to achieving the next bonus level? -Morrison
Why does Excel display the #### error when a cell does not display the entire number? - NOT The underlying value is hidden.
Why are there several ways to insert the SUM function? - It is frequently used
Why is it important to use multiple worksheets in a workbook? -To organize data in a logical arrangement.
Why is it important to use cell references in a formula instead of the data within the cells? -To keep the worksheet accurate because when the data changes, the formula is updated.
As of September 30, which plyometric product had the largest quantity in stock? -Pro jump rope
Why is the range finder feature useful to verify Excel formulas? -NOT Formula errors are flagged
How can employees prevent heat stroke? = wear uniform hat or visor
Why might you customize the color and shape of bullets and other objects in presentations for Sensation Park? = NOT to reduce contrast for better visual appeal