Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Year 9 Computer Science Revision 2023 > Spreadsheets > Flashcards

Spreadsheets Flashcards

1
Q

What is conditional formatting in Excel?

A

Conditional formatting makes it easy to highlight certain values or make particular cells easy to identify

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

How was conditional formatting used in the Celebrity Quiz

A
  • Colour changed when you got the question right
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

How was COUNTIF used in the quiz?

A
  • Counts correct answers and adds to the overall score
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Why would you hide formulas in an Excel quiz?

A

Stops the user seeing the answers

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

The Quiz uses Selection - what does this start with?

A

IF

How well did you know this?
1
Not at all
2
3
4
5
Perfectly

Year 9 Computer Science Revision 2023 (5 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions