1. What are the benefits of using a spreadsheet?

Do calculations to improve efficiency and create charts to visualise data.

10. Which job task would need competency in using Excel?

Data analysis as you work with data and create charts to visualise.

4. What does the Fill Handle in spreadsheet software allow you to do?

Copy formulas or data across cells.

7. After completing a digital project, like creating a spreadsheet for a business, it is important to:

Review your work, by comparing it to the original objectives & improve it.

6. Is this formula =SUM(B5~B10) correct? Why? Why not?

It is incorrect because the ~ should be replaced by a :

9. Which of the following are British values that relate to learning, work and being a citizen?

Democracy, rule of law, individual liberty and respect & tolerance.

8. Time management is a vital life skill, which we need for our studies and work because:

By planning our time, tasks are completed to a high quality & by deadlines.

studbud

L2 Spreadsheets Review 1

10 termsStudBud Administration8 plays

A review of spreadsheets topics.

Flashcards10 cardsFPractice quizPHost liveL

Questions 10

Answers

1
5. Which chart type is best suited to show parts of a whole?
Column chart.
Scatter chart.
Pie chart.
Line chart.
2
1. What are the benefits of using a spreadsheet?
Create documents like reports, so data is presented clearly.
Create slides with text and images which can assist a speaker presenting.
Do calculations to improve efficiency and create charts to visualise data.
Store records that have data & later search for this data using queries.
3
10. Which job task would need competency in using Excel?
Running queries in a database to search for specific information
Creating a bitmap or vector graphic which can be used for posts.
Data analysis as you work with data and create charts to visualise.
Writing code using an IDE or tool like Visual Studio to create programs.
4
4. What does the Fill Handle in spreadsheet software allow you to do?
Save the spreadsheet.
Change font color.
Insert a new sheet.
Copy formulas or data across cells.
5
7. After completing a digital project, like creating a spreadsheet for a business, it is important to:
Approach future projects without referring back to your prior experience.
Complete the project, knowing that you do not need to review it again.
Review your work, by comparing it to the original objectives & improve it.
Quickly start a new project without reflecting on the project just finished
6
6. Is this formula =SUM(B5~B10) correct? Why? Why not?
It is correct because the ~ means approximately.
It is incorrect because the ~ should be replaced by a :
It is incorrect because the ~ should be replaced by a %
It is correct because it has an equal sign.
7
3. Which of the following cell references is an absolute reference?
A1
A$1
$A1
$A$1
8
9. Which of the following are British values that relate to learning, work and being a citizen?
Equality, inclusion, collaboration and diversity.
Diversity, inclusion, collaboration and creativity.
Democracy, rule of law, individual liberty and respect & tolerance.
Democracy, diversity, inclusion and focus.
9
2. What function would you use to calculate the average of a range of cells in a spreadsheet?
=AVERAGE(A1:A5)
=MEAN(A1:A5)
=AVG(A1:A5)
=MID(A1:A5)
10
8. Time management is a vital life skill, which we need for our studies and work because:
By developing digital graphics, the impact is visual on the audience.
It is a communication skill, like writing and speaking.
By planning our time, tasks are completed to a high quality & by deadlines.
It is a technical skill like programming and web development.

L2 Spreadsheets Review 1 Flashcards | StudBud