Week 6 - Spreadsheet

Quiz
•
Computers
•
University
•
Medium
Nurul Zinni
Used 11+ times
FREE Resource
7 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 10 pts
Which of the statement of the spreadsheet below is incorrect?
An arrangement of cells in columns and rows used to organize, analyze, calculate and report information usually in numerical form
It is used to create a wide range of different types of files. example Word files (.doc, .docx)
Allows user to create large spreadsheets, reference information and it allows for better storage of information
User can organize and manipulate data create chart and perform calculations
Answer explanation
It is used to create a wide range of different types of files. example Word files (.doc, .docx). This statement is belong to MS words
2.
MULTIPLE CHOICE QUESTION
30 sec • 10 pts
Which Statement is correct? The benefits of using spreadsheet is...
It makes data disorganized and difficult to manipulate
It does not allow for the creation of visual representations of data
Enable dynamic calculations with built-in formulas
Dynamic auto-correct grammar with built-in formulas
Answer explanation
By using Formula Bar.
Enable Dynamic Calculations with built in Formulas
3.
MULTIPLE CHOICE QUESTION
30 sec • 10 pts
Based on the video, what are the different types of spreadsheet being mentioned?
AirTable, Smartsheet, Numbers (iOS), Apache Openoffice Calc and LibreOffice Calc
Zoho Sheet, Apple Numbers, WPS sheet, Quattro Pro and MS Excel
Google Sheets, Free Office Planmaker, LibreOffice, Zoho sheets and WPS Office
Ms Excel, Ms Words, Ms Powerpoint, Ms Project and Ms Forms
Answer explanation
AirTable, Smartsheet, Numbers (iOS), Apache Openoffice Calc, and LibreOffice Calc are also spreadsheet apps.
But Based on the video, the correct answers are Google Sheets, Free Office Planmaker, LibreOffice, Zoho Sheets, and WPS Office.
This is to verify whether you are attentive while watching the video or not.
4.
MULTIPLE CHOICE QUESTION
30 sec • 10 pts
One of the basic functionalities of spreadsheet is "Filtering", What does "Filtering" do?
Adjusting font, color, size, and other features of individual cells or cell groupings
Addition, subtraction, multiplication, and division
Narrowing down data based on specified criteria
Ascending or descending order
Answer explanation
Adjusting font, color, size, and other features of individual cells or cell groupings - Cell Formatting.
Addition, subtraction, multiplication, and division - Basic formulas
Sorting ascending or descending order - Sort
5.
MULTIPLE CHOICE QUESTION
30 sec • 10 pts
How many rows and columns does MS Excel have?
16, 384 Columns
1,0482,576 Rows
16, 384 Rows
1,0482,576 Column
Answer explanation
6.
MULTIPLE CHOICE QUESTION
30 sec • 10 pts
Based on the picture, what is this box called?
Cell
View Option
Name Box
Formula Bar
Answer explanation
7.
MULTIPLE CHOICE QUESTION
30 sec • 10 pts
Which function is used to add up a range of numbers in Excel?
Answer explanation
To add up a range of numbers in Excel. For example =SUM(A1:A98}
Similar Resources on Wayground
12 questions
TES AWAL MODUL 2

Quiz
•
University
8 questions
Microsoft Office Skills

Quiz
•
1st Grade - Professio...
10 questions
Excel&Power Point

Quiz
•
University
10 questions
Quiz Kelompok 4 Mengenai Insert Vidio dan Audio ke PowerPoint

Quiz
•
University
10 questions
ICT Quiz

Quiz
•
University
10 questions
Microsoft Excel Basics

Quiz
•
5th Grade - University
12 questions
PowerPoint Quiz

Quiz
•
7th Grade - University
10 questions
Ice Breaker

Quiz
•
University
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
20 questions
Definite and Indefinite Articles in Spanish (Avancemos)

Quiz
•
8th Grade - University
7 questions
Force and Motion

Interactive video
•
4th Grade - University
36 questions
Unit 5 Key Terms

Quiz
•
11th Grade - University
7 questions
Figurative Language: Idioms, Similes, and Metaphors

Interactive video
•
4th Grade - University
15 questions
Properties of Equality

Quiz
•
8th Grade - University
38 questions
WH - Unit 3 Exam Review*

Quiz
•
10th Grade - University
21 questions
Advise vs. Advice

Quiz
•
6th Grade - University
12 questions
Reading a ruler!

Quiz
•
9th Grade - University