10G - Spreadsheets Revision 1

Quiz
•
Computers
•
10th Grade
•
Medium

Charlotte Hook
Used 1+ times
FREE Resource
9 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
To format a heading to make it expand across more than one cell you need to highlight the cells and then:
Wrap Text
Merge Cells
Align to Middle
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula finds the LARGEST number in an range?
SUM
MIN
MAX
IF
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What type of chart is this?
Line chart
Pie chart
Bar chart
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula adds up the TOTAL of a range of numbers?
VLOOKUP
IF
SUM
AVERAGE
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Correct the following formula:
=IF(C3>=G2,'Enter',"No Entry")
=IF(C3>=G2,'Enter',"No Entry")
=IF(C3>=$G$2,"Enter","No Entry")
=IF(C3>=G2,"Enter","No Entry")
6.
OPEN ENDED QUESTION
3 mins • 1 pt
What do you use an absolute cell reference for?
Evaluate responses using AI:
OFF
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function in Excel helps you to organise data?
Sort & Filter
VLOOKUP
Borders & Shading
Font Size
8.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Is this formula correct?
No
Yes
9.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula finds the arithmetic MEAN?
SUM
MAX
MIN
AVERAGE
Similar Resources on Wayground
10 questions
Les Tableurs ( Microsoft Excel ) 1

Quiz
•
6th - 12th Grade
12 questions
EXCEL

Quiz
•
7th Grade - University
10 questions
Fungsi Penyusutan

Quiz
•
10th Grade
10 questions
Chart

Quiz
•
10th Grade
10 questions
Excel Basic Function

Quiz
•
10th Grade
10 questions
MICROSOFT EXCEL

Quiz
•
9th - 11th Grade
10 questions
Spreadsheet Short

Quiz
•
10th Grade
13 questions
ExcelQuiz

Quiz
•
10th - 12th Grade
Popular Resources on Wayground
11 questions
Hallway & Bathroom Expectations

Quiz
•
6th - 8th Grade
20 questions
PBIS-HGMS

Quiz
•
6th - 8th Grade
10 questions
"LAST STOP ON MARKET STREET" Vocabulary Quiz

Quiz
•
3rd Grade
19 questions
Fractions to Decimals and Decimals to Fractions

Quiz
•
6th Grade
16 questions
Logic and Venn Diagrams

Quiz
•
12th Grade
15 questions
Compare and Order Decimals

Quiz
•
4th - 5th Grade
20 questions
Simplifying Fractions

Quiz
•
6th Grade
20 questions
Multiplication facts 1-12

Quiz
•
2nd - 3rd Grade