Unit 6 Spreadsheets

Which programs are used by accountants to calculate financial spreadsheets?

• Microsoft publisher & Google templates

• Microsoft excel & Google sheets

• Microsoft powerpoint & Google slides

• Microsoft word & Office 365

Imagine you are preparing a presentation for your team about the company's sales performance. You decide to include various types of charts to make the data more understandable. Which of the following is NOT a type of chart you can use?

• pie

• column

• bar

• axis

Imagine you are working on a spreadsheet for your monthly expenses. What does clicking on autosum do?

• subtracts totals

• adds totals

• multiplies totals

• divides totals

Imagine you are organizing a budget in a spreadsheet. What are the letters at the top of the spreadsheet called?

• rows

• alphabets

• numbers

• columns

Which chart would I use to show how Team Teachers beat Team Students in the bowling tournament?

• column

• xy scatter

• pie

• line

If you were analyzing the sales performance of different regions last quarter, which type of chart would you create to compare these groups of data?

• pie

• line

• bar

• column

While traveling abroad, you need to exchange your currency. Which symbol is commonly used to represent currency in many countries?

• *

• &

• $

• @

Before creating a sales performance chart in a spreadsheet, what is the first step you must take?

• click insert charts/graphs

• go to file, print

• highlight the data with your mouse

• bold all the information

If you wanted to visualize the growth of your savings account over the last 5 years, which chart would you use?

• stacked bar chart

• pie chart

• bar chart

• line chart

In a company's annual report, a pie chart is used to do what?

• show trends over time

• represent only one series of data

• show the correlation of two or more sets of data

• show how many pieces you can eat