4011018
Descripción
Test por Mollie Nichols, actualizado hace más de 1 año
|
Creado por Mollie Nichols
hace alrededor de 9 años
|
|
Pregunta 1
Pregunta
If I wanted to work out the sum/total of the cell range A1:A6 how would I type it into the formula bar?
Respuesta
-
=sum(A1:A6) ENTER
-
=total(A1:A6) ENTER
-
sum(A1:A6) ENTER
-
total(A1:A6) ENTER
Pregunta 2
Pregunta
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.
Respuesta
-
a to z
-
1 to 10
Pregunta 3
Pregunta
To apply a percentage to a number you must use the formula tab.
Respuesta
- True
- False
Pregunta 4
Pregunta
If the question mentions the word FORMAT you must use the format cells command on the home tab.
Respuesta
- True
- False
Pregunta 5
Pregunta
How do you scale the page to fit one page high and two pages wide?
Respuesta
-
Home tab, replace command.
-
Page layout tab, scale to fit group.
-
Page layout tab, size command.
-
File tab, print, custom scaling.
Pregunta 6
Pregunta
If you are asked to add cell B5 and B7, how would you type this in? [blank_start]=B5+B7[blank_end]
Respuesta
-
=B5+B7
Pregunta 7
Pregunta
If you were asked to divide cell B8 by B10, how would you type this in? [blank_start]=B8/B10[blank_end]
Respuesta
-
=B8/B10
Pregunta 8
Pregunta
If you were asked to calculate the smallest value in a cell range which one would you use?
Respuesta
-
=counta
-
=max
-
=min
-
=count
Pregunta 9
Pregunta
If you were asked to calculate the biggest value in a cell range which one would you use?
Respuesta
-
=max
-
=sum
-
=if
-
=min
Pregunta 10
Pregunta
If you were asked to calculate whether a cell is more than or less than another cell which one would you use?
Respuesta
-
=average
-
=sum
-
=if
-
=count
Pregunta 11
Pregunta
How would do you change the username?
Respuesta
-
Page layout, margins
-
File tab, options, username
-
Review tab, spelling and grammar
-
Insert tab, text box
Pregunta 12
Pregunta
To rename worksheets you should double click on the appropriate sheet.
Respuesta
- True
- False
Pregunta 13
Pregunta
Calculate the total of the following cell range B3:B11. How would this be typed in? [blank_start]=sum(B3:B11)[blank_end]
Respuesta
-
=sum(B3:B11)
Pregunta 14
Pregunta
Calculate the average of the cell range B4:C6. How would you type this in? [blank_start]=average(B4:C6)[blank_end]
Respuesta
-
=average(B4:C6)
Pregunta 15
Pregunta
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
Respuesta
- True
- False
Pregunta 16
Pregunta
To insert data labels, which tab needs to be clicked on?
Respuesta
-
Layout tab
-
Design tab
-
Insert tab
-
Home tab
Pregunta 17
Pregunta
Cut and paste is used when something needs to be [blank_start]moved[blank_end]
Respuesta
-
moved
Pregunta 18
Pregunta
When editing a chart the format tab is used for...
Respuesta
-
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
Pregunta 19
Pregunta
To zoom the view tab is used?
Respuesta
- True
- False
Pregunta 20
Pregunta
It is possible to change the chart type even after it has been created?
Respuesta
- True
- False
Pregunta 21
Pregunta
Copy and paste is used when more than [blank_start]one[blank_end] of something is needed.
Respuesta
-
one
Pregunta 22
Pregunta
Pictures and documents that are needed in the exam can be found in the [blank_start]z drive[blank_end]
Respuesta
-
z drive
Pregunta 23
Pregunta
To add a title to a chart which tab do you need to be clicked on?
Respuesta
-
Layout
Pregunta 24
Pregunta
It is possible to keep specific cells visible at all times even when scrolling?
Respuesta
- True
- False
Pregunta 25
Pregunta
New sheets can be added using the format command
Respuesta
- True
- False
¿Quieres crear tus propios Tests gratis con GoConqr? Más información.