Question

All questions are multi answer (choose two or more options).

6.When formatting cells, which of the following are true about the number category?

	a.	can have up to 5 decimal places
	b.	formats without an asterisk are not affected by operating system settings
	c.	can include general
	d.	can include number
	e.	can have up to 255 decimal places

7.In Excel, which of the following are not true about the IF function?

	a.	It can have two results
	b.	It is in the lookup & reference category
	c.	It needs to wrap text in quotes
	d.	=IF(C2=Yes,1,2) says IF(C2 = Yes, then return a 1, otherwise return a 2)
	e.	It can use mathematical operators

8.In Excel, which of the following are true about the WEEKDAY function?

	a.	it returns the day of the week corresponding to a date
	b.	the serial number is a sequential number that represents the date of the day you are trying to find
	c.	the day is given as an integer
	d.	the syntax is WEEKDAY(serial_number,[return_type])
	e.	dates should be entered by using the DATE function

9.In Excel, which of the following are not correct about the AND function?

	a.	It is a math & trig function
	b.	=AND(A2>1,A2<100) displays TRUE if A2 =50
	c.	=AND(TRUE, ) returns #NAME error
	d.	It determines if all conditions in a test are TRUE
	e.	=AND(TRUE, FALSE) displays FALSE

10.Which of the following are incorrect about a BPMN pool?

	a.	The process should be modelled if it is in a white-box pool
	b.	It has a label
	c.	It can contain multiple processes as long as associated with a message
	d.	It can contain multiple processes
	e.	It contains a complete process

Answer 1

6. When formatting cells, which of the following are true about the number category.

c.	can include general

d.	can include number

7. In Excel, which of the following are not true about the IF function?

b.	It is in the lookup & reference category

8.In Excel, which of the following are true about the WEEKDAY function?

a.	it returns the day of the week corresponding to a date

b.	the serial number is a sequential number that represents the date of the day you are trying to find

c.	the day is given as an integer

d.	the syntax is WEEKDAY(serial_number,[return_type])

e.	dates should be entered by using the DATE function

9.In Excel, which of the following are not correct about the AND function?

a.	It is a math & trig function

c.	=AND(TRUE, ) returns #NAME error

10.Which of the following are incorrect about a BPMN pool?

c.	It can contain multiple processes as long as associated with a message

d.	It can contain multiple processe

If you liked my answer, please give likes/ thumbs up. Thank you!