CSC Questions and Answers
A worksheet contains columns listing new movie releases, total production costs, week 1 gross revenue, and week 2 gross revenue. Which of the following would least likely form a data series in a column chart?
Movie names
What is an advantage of using the Recommend...
a worksheet contains columns listing new movie rel
what is an advantage of using the recommended char
Written for
CSC - Cyber Secure Coder
CSC - Cyber Secure Coder
Seller
Follow
Pogba119
Reviews received
Content preview
CSC Questions and Answers
A worksheet contains columns listing new movie releases, total production costs, week
1 gross revenue, and week 2 gross revenue. Which of the following would least likely
form a data series in a column chart? - answer Movie names
What is an advantage of using the Recommended Charts command? - answer The
Insert Chart dialog box displays recommended chart types based on the selected data.
What type of chart would display the names of seven city names (such as Jefferson City
and Salt Lake City) on a category axis that is the easiest to read? - answer Bar Chart
You want to create a single chart that shows the proportion of yearly sales for five
divisions for each year for five years. Which type of chart can accommodate your
needs? - answer 100% Stacked column chart
Why would you add Alt Text to a combo chart? - answer To adhere to accessibility
compliance for screen reader capabilities
The value axis currently shows increments such as 50,000 and 100,000. What option
would you select to display the values in increments of 50 and 100? - answer Show
Axis in Thousands
Which chart element should you display to show exact values for a data series in a bar
chart? - answer Data labels
Currently, a column chart shows values on the value axis, years on the category axis,
and state names in the legend. What should you do if you want to organize data with
the states on the category axis and the years shown in the legend? - answer Switch
the rows and columns in the chart.
You have a large dataset that will print on several pages. You want to ensure that
related records print on the same page with column and row labels visible and that
confidential information is not printed. You should apply all of the following page setup
options except which one to accomplish this task? - answer Change the print page
order.
You are working with a large worksheet. Your row headings are in column A. Which
command(s) should be used to see the row headings and the distant information in
columns X, Y, and Z? - answer Freeze Panes command
Which statement is not a recommended guideline for designing and creating an Excel
table? - answer Leave one blank row between records in the table.
Correct Answer
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Pogba119. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £10.55. You're not tied to anything after your purchase.
