Questões de Concurso Comentadas para engenheiro

Considere uma planilha do MS Excel com as células B1 até B4 contendo os valores Corolla; Cruze; Focus; e Tucson, respectivamente.
Considere as células C1 até C4 contendo os valores 3; 6; 12 e 24, respectivamente.
Considere, ainda, a seguinte fórmula:
=PROCV(B4;C1:C4;2;0)
Assinale a alternativa que contém uma descrição correta do erro existente na fórmula, de modo a obter o valor 24 usando como valor a procurar a palavra Tucson.

O MS Excel do Office 365 Business permite que o usuário escolha as linhas e colunas que serão repetidas em cada página impressa. Como por exemplo, linhas e colunas com rótulos ou cabeçalhos.
Qual o nome do recurso do MS Excel que permite realizar essa ação?

Ao acionar a guia Arquivo do MS Word do Office 365 Business, encontra-se o item de menu denominado Comentários.
Assinale a alternativa que contém uma afirmação válida sobre esse item de menu do MS Word.

Reportagem divulgada no site jornalístico G1 (http://g1.globo.com) da Rede Globo informou que em 14 das 16 capitais pesquisadas pelo Departamento Intersindical de Estatística e Estudos Sócio-econômicos (Dieese), o preço da cesta básica teve alta no mês de maio. Recife foi a capital onde se registrou a maior alta, com 14,19% de aumento no preço dos produtos da cesta seguida por Natal (8,91%) e Florianópolis (7,61%), enquanto Goiânia e Salvador foram as duas únicas cidades que apresentaram redução nos preços da cesta básica, com queda de 1,19% e 0,35%, respectivamente. São alimentos que fazem parte da cesta básica brasileira, de acordo com o Decreto Lei número 399, EXCETO:

READ THE FOLLOWING TEXT AND CHOOSE THE OPTION WHICH BEST COMPLETES EACH QUESTION ACCORDING TO IT:

Technology has created more jobs than it has destroyed
The battle between men and machines goes back centuries. Are they taking our jobs? Or are they easing our workload? A study by economists at the consultancy Deloitte seeks to shed new light on the relationship between jobs and the rise of technology by searching through census data for England and Wales going back to 1871.   Their conclusion is that, rather than destroying jobs, technology has been a “great job-creating machine”. Findings by Deloitte such as rise in bar staff since the 1950s or a surge in the number of hairdressers this century suggest to the authors that technology has increased spending power, therefore creating new demand and new jobs. Their study argues that the debate has been twisted towards the job-destroying effects of technological change, which are more easily observed than its creative aspects.  Going back over past figures paints a more balanced picture, say authors Ian Stewart and Alex Cole. “The dominant trend is of contracting employment in agriculture and manufacturing being more than balanced by rapid growth in the caring, creative, technology and business services sectors,” they write. “Machines will take on more repetitive and laborious tasks, but they seem no closer to eliminating the need for human labor than at any time in the last 150 years.”  According to the study, hard, dangerous and dull jobs have declined. In some sectors, technology has quite clearly cost jobs, but they question whether they are really jobs we would want to hold on to. Technology directly substitutes human muscle power and, in so doing, raises productivity and shrinks employment. “In the UK the first sector to feel this effect on any scale was agriculture,” says the study.  The study also found out that ‘caring’ jobs have increased. The report cites a “profound shift”, with labor switching from its historic role, as a source of raw power, to the care, education and provision of services to others. Technological progress has cut the prices of essentials, such as food, and the price of bigger household items such as TVs and kitchen appliances, notes Stewart. That leaves more money to spend on leisure, and creates new demand and new jobs, which may explain the big rise in bar staff, he adds. “_______ the decline in the traditional pub, census data shows that the number of people employed in bars rose fourfold between 1951 and 2011,” the report says. The Deloitte economists believe that rising incomes have allowed consumers to spend more on personal services, such as grooming. That in turn has driven employment of hairdressers. So, while in 1871 there was one hairdresser or barber for every 1,793 citizens of England and Wales; today there is one for every 287 people.  (Adapted from: https://goo.gl/7V5vuw. Access: 02/02/2018.)

The use of the modal verb may in “which may explain the big rise in bar staff” (paragraph 6) indicates that