Computação e TIC Anos 7–9

MS Excel and The Goal Seek Tool

Compartilhado por Jaymar Sularte há 2 dias 10 P Adotado 0 vezes 2 partidas 2 alunos jogaram

Cadastre-se de graça para adotar este quiz

Prévia das perguntas

Mostrando as 5 primeiras de 10 perguntas — cadastre-se de graça para adotar o quiz inteiro e jogar com a sua turma.

What is the primary purpose of the Goal Seek tool in Microsoft Excel?

A To sort and filter large datasets

B To automatically format cells based on their values

C To create complex charts and graphs from data

D To find the input value needed to achieve a specific target output in a formula

In a spreadsheet, cell B5 contains the formula =B3*B4. If you want B5 to equal 100 by changing B3, which cell would you set as the 'By changing cell' in Goal Seek?

A B3

B B4

C B5

D The entire column B

It is a what-If Analysis tool in Microsoft Excel that finds the input value needed to achieve a specific result.

A Ribbon

B Main Menu

C Goal Seek

D Tab

When using Goal Seek, what must be true about the 'Set cell'?

A It must contain a formula that depends on the 'By changing cell'

B It must be formatted as a percentage

C It must contain only text values

D It must be an empty cell

It is one of the important fields of the Goal Seek that serves as the target result you want to achieve.

A To value

B By changing cell

C Set Value

D Set cell

Quer usar estes quizzes prontos?

Crie uma conta gratuita no SparkMyClass, adote quizzes com um clique e monte os seus próprios jogos de perguntas interativos.

Cadastre-se de graça

Mais quizzes compartilhados

questions

18 P

Technical Quiz

25 P