4011018
Descrição
Quiz por Mollie Nichols, atualizado more than 1 year ago
|
Criado por Mollie Nichols
mais de 8 anos atrás
|
|
Questão 1
Questão
If I wanted to work out the sum/total of the cell range A1:A6 how would I type it into the formula bar?
Responda
-
=sum(A1:A6) ENTER
-
=total(A1:A6) ENTER
-
sum(A1:A6) ENTER
-
total(A1:A6) ENTER
Questão 2
Questão
Sorting something into ascending order means you are sorting from [blank_start]a to z[blank_end] or [blank_start]1 to 10[blank_end] for example.
Responda
-
a to z
-
1 to 10
Questão 3
Questão
To apply a percentage to a number you must use the formula tab.
Responda
- True
- False
Questão 4
Questão
If the question mentions the word FORMAT you must use the format cells command on the home tab.
Responda
- True
- False
Questão 5
Questão
How do you scale the page to fit one page high and two pages wide?
Responda
-
Home tab, replace command.
-
Page layout tab, scale to fit group.
-
Page layout tab, size command.
-
File tab, print, custom scaling.
Questão 6
Questão
If you are asked to add cell B5 and B7, how would you type this in? [blank_start]=B5+B7[blank_end]
Responda
-
=B5+B7
Questão 7
Questão
If you were asked to divide cell B8 by B10, how would you type this in? [blank_start]=B8/B10[blank_end]
Responda
-
=B8/B10
Questão 8
Questão
If you were asked to calculate the smallest value in a cell range which one would you use?
Responda
-
=counta
-
=max
-
=min
-
=count
Questão 9
Questão
If you were asked to calculate the biggest value in a cell range which one would you use?
Responda
-
=max
-
=sum
-
=if
-
=min
Questão 10
Questão
If you were asked to calculate whether a cell is more than or less than another cell which one would you use?
Responda
-
=average
-
=sum
-
=if
-
=count
Questão 11
Questão
How would do you change the username?
Responda
-
Page layout, margins
-
File tab, options, username
-
Review tab, spelling and grammar
-
Insert tab, text box
Questão 12
Questão
To rename worksheets you should double click on the appropriate sheet.
Responda
- True
- False
Questão 13
Questão
Calculate the total of the following cell range B3:B11. How would this be typed in? [blank_start]=sum(B3:B11)[blank_end]
Responda
-
=sum(B3:B11)
Questão 14
Questão
Calculate the average of the cell range B4:C6. How would you type this in? [blank_start]=average(B4:C6)[blank_end]
Responda
-
=average(B4:C6)
Questão 15
Questão
When entering formulas into the work sheet, you must use the letter and number of the cell as the reference. e.g C4, B7, B2
Responda
- True
- False
Questão 16
Questão
To insert data labels, which tab needs to be clicked on?
Responda
-
Layout tab
-
Design tab
-
Insert tab
-
Home tab
Questão 17
Questão
Cut and paste is used when something needs to be [blank_start]moved[blank_end]
Responda
-
moved
Questão 18
Questão
When editing a chart the format tab is used for...
Responda
-
Inserting a title and data labels
-
Changing the shading and size of the chart
-
Editing the data on the chart
-
Inserting a different chart type
Questão 19
Questão
To zoom the view tab is used?
Responda
- True
- False
Questão 20
Questão
It is possible to change the chart type even after it has been created?
Responda
- True
- False
Questão 21
Questão
Copy and paste is used when more than [blank_start]one[blank_end] of something is needed.
Responda
-
one
Questão 22
Questão
Pictures and documents that are needed in the exam can be found in the [blank_start]z drive[blank_end]
Responda
-
z drive
Questão 23
Questão
To add a title to a chart which tab do you need to be clicked on?
Responda
-
Layout
Questão 24
Questão
It is possible to keep specific cells visible at all times even when scrolling?
Responda
- True
- False
Questão 25
Questão
New sheets can be added using the format command
Responda
- True
- False
Quer criar seus próprios Quizzes gratuitos com a GoConqr? Saiba mais.