
Spreadsheet Data Analysis Quiz

Quiz
•
Computers
•
10th Grade
•
Hard
UNKNOWN USER
FREE Resource
77 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following features is not used for data analysis in spreadsheets?
Consolidating data
Goal Seek
Subtotal
Page layout
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following office tools is known for data analysis?
Writer
Calc
Impress
Draw
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following operations cannot be performed using LibreOffice Calc?
Store and manipulate data
Create graphical representation of data
Analysis of data
Mail merge
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the extension of a spreadsheet file in Calc?
.odb
.odt
.odg
.ods
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The default function while using Consolidate is __.
Average
Sum
Max
Count
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Group by is used in _ tool to apply summary functions on columns.
Consolidate function
Group and Outline
What-if scenario
Subtotal tool
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which tool is used to predict the output while changing the input?
Consolidate function
What-if scenario
Goal seek
Find and Replace
Create a free account and access millions of resources
Similar Resources on Wayground
Popular Resources on Wayground
10 questions
Video Games

Quiz
•
6th - 12th Grade
20 questions
Brand Labels

Quiz
•
5th - 12th Grade
15 questions
Core 4 of Customer Service - Student Edition

Quiz
•
6th - 8th Grade
15 questions
What is Bullying?- Bullying Lesson Series 6-12

Lesson
•
11th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
22 questions
Adding Integers

Quiz
•
6th Grade
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade
Discover more resources for Computers
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade
10 questions
Proper Keyboarding Techniques

Interactive video
•
6th - 10th Grade
10 questions
Understanding Computers: Hardware, Software, and Operating Systems

Interactive video
•
7th - 12th Grade
29 questions
AP CSP Unit 2 Review (Code.org)

Quiz
•
10th - 12th Grade